| 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 |
|
Topic Locked
