Author |
Topic |
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 29 August 2004 : 17:02:56
|
Thank you for the code, OneWayMule!
I am looking forward to opening it up and seeing what you've done!
Thanks again,
Etymon
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 29 August 2004 : 20:57:21
|
You're welcome, OneWayMule! I think I will!
I was talking to my wife about whether or not to add a guestbook to one of our sites. We weren't sure. You just don't see them on the web too much anymore.
Then I thought about it again, and I remembered, that you write some very nice MODs. So, I said to myself, "I think I'll give it a try." Besides, there are still folks out there who don't want to become a member just to say "Hi" or "Thanks". And there others who don't know much about the web, and a forum is intimidating or mind-boggling. I think a guestbook is a good way to go for these surfers!
Thanks again,
Etymon
|
|
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 06 September 2004 : 02:36:55
|
Followed the readme.html, but the guestbook do not work: > >The page cannot be displayed >There is a problem with the page you are trying to reach and it cannot be displayed. > >----------------------------------------------------------------------- >--------- > >Please try the following: > >Click the Refresh button, or try again later. > >Open the www.finsklapphundklubb.org home page, and then look for links >to the information you want. >HTTP 500.100 - Internal Server Error - ASP error >Apache > >----------------------------------------------------------------------- >--------- > >Technical Information (for support personnel) > >Error Type: >ADODB.Recordset.1 (0x80004005) >SQLState: S1000 Native Error Code: 1146 [TCX][MyODBC]Table >'finsklapphundkl.FORUM_GB_OPTIONS' doesn't exist >inc_header.asp, line 560 > >Browser Type: >Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322) > >Page: >GET /Hovedforum/guestbook.asp > >Time: >Friday, September 03, 2004, 3:55:29 PM > >More information: >Sun ONE Active Server Pages Support
|
|
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 06 September 2004 : 02:38:13
|
The problem is that the FORUM_GB_OPTIONS table could not be found in the database. Did you run the MOD Setup (any errors popped up)?
Kind Regards,
OneWayMule
|
|
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 06 September 2004 : 02:39:57
|
Running the MOD-setup:
MOD: Guestbook v3.4
Dropping Table..
Table dropped succesfully --------------------------------------------------------------------------------
Dropping Table.. DROP TABLE FORUM_GB_OPTIONS -2147467259 | SQLState: S1000 Native Error Code: 1051 [TCX][MyODBC]Unknown table 'FORUM_GB_OPTIONS'
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_GUESTBOOK( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_NAME varchar (50) NULL , G_EMAIL varchar (100) NULL , G_WEBSITE varchar (100) NULL , G_ICQ varchar (30) NULL , G_MESSAGE text NOT NULL , G_DATE varchar (50) NOT NULL , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL ,KEY FORUM_GUESTBOOK_G_ID(G_ID)) CREATE TABLE FORUM_GUESTBOOK( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_NAME varchar (50) NULL , G_EMAIL varchar (100) NULL , G_WEBSITE varchar (100) NULL , G_ICQ varchar (30) NULL , G_MESSAGE text NOT NULL , G_DATE varchar (50) NOT NULL , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL ,KEY FORUM_GUESTBOOK_G_ID(G_ID)) 9 | Subscript out of range
--------------------------------------------------------------------------------
Creating table(s)... CREATE TABLE FORUM_GB_OPTIONS( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL , G_V1_SWITCH int NULL , G_V2_SWITCH int NULL , G_V3_SWITCH int NULL , G_MESSAGE text NULL , G_V1_REQ int NOT NULL DEFAULT 0, G_V2_REQ int NOT NULL DEFAULT 0, G_V3_REQ int NOT NULL DEFAULT 0, G_PAGECOUNT int NOT NULL DEFAULT 0, G_T_MAIL int NOT NULL DEFAULT 0, G_W_MAIL int NOT NULL DEFAULT 0, G_T_AUTHOR varchar (150) NOT NULL DEFAULT 0, G_T_REPLYTO varchar (150) NOT NULL DEFAULT 0, G_T_MESSAGE text NOT NULL DEFAULT 0,KEY FORUM_GB_OPTIONS_G_ID(G_ID)) CREATE TABLE FORUM_GB_OPTIONS( G_ID INT (11) DEFAULT '' NOT NULL auto_increment , G_VARFIELD1 varchar (100) NULL , G_VARFIELD2 varchar (100) NULL , G_VARFIELD3 varchar (100) NULL , G_V1_SWITCH int NULL , G_V2_SWITCH int NULL , G_V3_SWITCH int NULL , G_MESSAGE text NULL , G_V1_REQ int NOT NULL DEFAULT 0, G_V2_REQ int NOT NULL DEFAULT 0, G_V3_REQ int NOT NULL DEFAULT 0, G_PAGECOUNT int NOT NULL DEFAULT 0, G_T_MAIL int NOT NULL DEFAULT 0, G_W_MAIL int NOT NULL DEFAULT 0, G_T_AUTHOR varchar (150) NOT NULL DEFAULT 0, G_T_REPLYTO varchar (150) NOT NULL DEFAULT 0, G_T_MESSAGE text NOT NULL DEFAULT 0,KEY FORUM_GB_OPTIONS_G_ID(G_ID)) -2147467259 | SQLState: S1000 Native Error Code: 1101 [TCX][MyODBC]BLOB column 'G_T_MESSAGE' can't have a default value
--------------------------------------------------------------------------------
Adding new records.. INSERT INTO FORUM_GB_OPTIONS (G_VARFIELD1, G_VARFIELD2, G_VARFIELD3, G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_MESSAGE, G_V1_REQ, G_V2_REQ, G_V3_REQ, G_PAGECOUNT, G_T_MAIL, G_W_MAIL, G_T_AUTHOR, G_T_REPLYTO, G_T_MESSAGE) VALUES ('State', 'Country', 'Age', 1, 1, 1, 'Thank you for signing my Guestbook', 0, 0, 0, 10, 0, 0, 'Admin', 'you@yourdomain.com', 'Thank you for signing my Guestbook') INSERT INTO FORUM_GB_OPTIONS (G_VARFIELD1, G_VARFIELD2, G_VARFIELD3, G_V1_SWITCH, G_V2_SWITCH, G_V3_SWITCH, G_MESSAGE, G_V1_REQ, G_V2_REQ, G_V3_REQ, G_PAGECOUNT, G_T_MAIL, G_W_MAIL, G_T_AUTHOR, G_T_REPLYTO, G_T_MESSAGE) VALUES ('State', 'Country', 'Age', 1, 1, 1, 'Thank you for signing my Guestbook', 0, 0, 0, 10, 0, 0, 'Admin', 'you@yourdomain.com', 'Thank you for signing my Guestbook') -2147467259 | SQLState: S1000 Native Error Code: 1146 [TCX][MyODBC]Table 'finsklapphundkl.FORUM_GB_OPTIONS' doesn't exist
--------------------------------------------------------------------------------
If there were errors please post a question in the MOD Implementation Forum at Snitz Forums |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
finsklapphundkl
Starting Member
47 Posts |
Posted - 06 September 2004 : 05:54:32
|
Done that, same errormessage. |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 07 September 2004 : 04:34:29
|
Would it be much work to make this "one user only"-guestbook? Like a blog, that a user can have in the user profile. The user should be the only one able to write, but all users should be able to read. I was thinking of doing this with the "old" guestbook, but your updated seems better =)
|
/Tribaliztic - www.gotlandrace.se -
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
tribaliztic
Senior Member
Sweden
1532 Posts |
Posted - 07 September 2004 : 04:46:26
|
yeah, I thought about that too, but don't it require a forum or a topic to work? If each user could automatically have a topic they could add an answer to each time they want to update the blog it would be pretty easy. BUT, those topic's should only be visible in their profiles and nowhere else...
|
/Tribaliztic - www.gotlandrace.se -
|
|
|
Image
Average Member
Canada
574 Posts |
Posted - 10 September 2004 : 17:08:52
|
In GuestBook
Add Tag </font>
" <td bgcolor=""" & strHeadCellColor & """ align=""left"" colspan=""2"" class=""header""><font face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """ color=""" & strCategoryFontColor & """>" & vbNewLine & _
" <b>Signatures</b>" & vbNewLine & _
" </font>" & vbNewLine & _
" </td>" & vbNewLine & _
" <font color=""" & strCategoryFontColor & """ face=""" & strDefaultFontFace & """ size=""" & strDefaultFontSize & """><b><span class=""spnMessageText"">" & ChkString(strTempName,"display") & "</span></b></font>" & vbNewLine & _
Line 372 replace If strGBField1Req = 1 Then
With If strGBField3Req = 1 Then
In sub DropDownPaging Delete
" <input name=""FORUM_ID"" type=""hidden"" value=""" & Forum_ID & """>" & vbNewLine & _
Replace
If strGBField1Req = 1 and trim(strFormField1) = "" Then
Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
End If
If strGBField2Req = 1 and trim(strFormField2) = "" Then
Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
End If
If strGBField3Req = 1 and trim(strFormField3) = "" Then
Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
End If With
If strGBField1Req = 1 and trim(strFormField1) = "" Then
Err_Msg = Err_Msg & "<li>Please enter your " & strGBField1 & "</li>" & vbNewLine
End If
If strGBField2Req = 1 and trim(strFormField2) = "" Then
Err_Msg = Err_Msg & "<li>Please enter your " & strGBField2 & "</li>" & vbNewLine
End If
If strGBField3Req = 1 and trim(strFormField3) = "" Then
Err_Msg = Err_Msg & "<li>Please enter your " & strGBField3 & "</li>" & vbNewLine
End If
In Admin guestbook
Replace
If strGBField1Req = 1 and trim(strFormField1) = "" Then
Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
End If
If strGBField2Req = 1 and trim(strFormField2) = "" Then
Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
End If
If strGBField3Req = 1 and trim(strFormField3) = "" Then
Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
End If With
If strGBField1Req = 1 and trim(strFormField1) = "" Then
Err_Msg = Err_Msg & "<li>Please enter a " & strGBField1 & "</li>" & vbNewLine
End If
If strGBField2Req = 1 and trim(strFormField2) = "" Then
Err_Msg = Err_Msg & "<li>Please enter a " & strGBField2 & "</li>" & vbNewLine
End If
If strGBField3Req = 1 and trim(strFormField3) = "" Then
Err_Msg = Err_Msg & "<li>Please enter a " & strGBField3 & "</li>" & vbNewLine
End If
And Big Bug With Edit and Delete onclick icon
I dont have these bug on my version
|
|
|
Topic |
|
|
|