Author |
Topic |
|
vtd
Starting Member
USA
28 Posts |
Posted - 23 April 2002 : 17:46:12
|
Hope this is the right help forum for this MOD :) please help...I have updated this message-icon Mod and then test on editting message. The result is the error below. I have check the installation guide over and over but have not found any missing steps.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/zasp/forum/post_info.asp, line 436 here is the codes I have changed follow by the Installtion guide: ########################################################## Find this code: (at approx line #422)
'## Forum_SQL strSql = "UPDATE " & strActivePrefix & "TOPICS " strSql = strSql & " SET T_MESSAGE = '" & txtMessage & "'" strSql = strSql & ", T_SUBJECT = '" & txtSubject & "'"
Replace it with this:
'## Forum_SQL strSql = "UPDATE " & strActivePrefix & "TOPICS " strSql = strSql & " SET T_MESSAGE = '" & txtMessage & "'" strSql = strSql & ", T_SUBJECT = '" & txtSubject & "'" strSql = strSql & ", T_MSGICON = " & Request.Form("strMessageIcon")
'#################################################### the code below is in my post_info.asp (already changed and post to server)
'## Forum_SQL strSql = "UPDATE " & strActivePrefix & "TOPICS " strSql = strSql & " SET T_MESSAGE = '" & txtMessage & "'" strSql = strSql & ", T_SUBJECT = '" & txtSubject & "'" strSql = strSql & ",T_MSGICON = " & Request.Form("strMessageIcon") if blnTopicMoved then strSql = strSql & ", CAT_ID = " & aryForum(0) strSql = strSql & ", FORUM_ID = " & aryForum(1) if AutoApprove = "Yes" then strSql = strSql & ", T_STATUS = 1 " end if end if strSql = strSql & " WHERE TOPIC_ID = " & Topic_ID '###########'below is the line 436 error (View using Araneae 4.5.2 editor)####### my_Conn.Execute(strSql) if blnTopicMoved then if strEmail = "1" and strMoveNotify = "1" then DoAutoMoveEmail(Topic_ID) strSQL = "SELECT F_SUBSCRIPTION FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & aryForum(1) set rs = my_conn.execute (strSQL) if rs("F_SUBSCRIPTION") < 3 then strSQL = "DELETE FROM " & strTablePrefix & "SUBSCRIPTIONS WHERE TOPIC_ID=" & Topic_ID my_conn.execute(strSQL) end if rs.close end if
Edited by - vtd on 23 April 2002 21:20:50
Edited by - vtd on 23 April 2002 21:23:32 |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 24 April 2002 : 21:52:48
|
You've already run the database update to add the fields to the database? |
|
|
vtd
Starting Member
USA
28 Posts |
Posted - 25 April 2002 : 09:59:39
|
Thanks for your help, I just update the database and the result is below: Please tell me what I should do
Noncritical error: allready existed in the table Critical error: code: 80040E21 in statement [ALTER TABLE FORUM_FORUM ADD F_A_COUNT INT NULL ; ] while trying to add F_A_COUNT to the FORUM table Critical error: code: 80040E21 in statement [ALTER TABLE FORUM_FORUM ADD F_A_TOPICS INT NULL ; ] while trying to add F_A_TOPICS to the FORUM table Critical error: code: 80040E21 in statement [ALTER TABLE FORUM_TOTALS ADD T_A_COUNT INT NULL ; ] while trying to add T_A_COUNT to the TOTALS table Critical error: code: 80040E21 in statement [ALTER TABLE FORUM_TOTALS ADD P_A_COUNT INT NULL ; ] while trying to add P_A_COUNT to the TOTALS table Upgraded: Table A_TOPICS re-created Upgraded: Table A_REPLY re-created Upgraded: Status of archived replies updated Upgraded: Added default values for new fields in CONFIG table
The Upgrade has NOT been completed without errors !
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 25 April 2002 : 13:58:26
|
Not setup.asp, but goto your Admin Options then click on MOD Setup. You should see a dropdown box. Look for the Message Icons entry, choose it and then click on the submit button. |
|
|
vtd
Starting Member
USA
28 Posts |
Posted - 25 April 2002 : 22:26:08
|
Ooh i'm already done that and the icons bar is display on the post form message ok. But i can't edit the message the error message i have already posted above.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 25 April 2002 : 22:55:27
|
can you e-mail your post_info.asp file (I prefer if you put it in a .zip file first) to:
richard_kinser@yahoo.com |
|
|
vtd
Starting Member
USA
28 Posts |
Posted - 26 April 2002 : 02:00:38
|
Thanks um.. I have install several mod so i did not want to edit this file again but now i decided to upload the backup file and edit all over again with other Mod also. so now it is working alrite :) Thanks alot for your help! below is my forum link
http://www10.brinkster.com/zasp/forum/ if you want check it out
Oop can i ask you another question about Additional_Stars v1 Mod sometime i can see my star but other user are not and i have check on star image properties to view the filename and the result is show icon_star_.gif instead of incon_star_color.gif I really appreciate for your time while helping me
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 26 April 2002 : 02:03:09
|
I've never used that MOD, it might be best to start a new topic on it. |
|
|
vtd
Starting Member
USA
28 Posts |
Posted - 26 April 2002 : 02:26:18
|
Thanks anyway I have send the error files post_info.asp and post.asp for you to exam the errors. Please let me know when you fixed cause i really want to have it back incase later on i have found error on other mod
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 26 April 2002 : 03:56:24
|
In your post above it sounded like everything was fixed, but now it's not again? |
|
|
|
Topic |
|