| Author |
 Topic  |
|
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 24 August 2012 : 06:21:40
|
In trying to merge a topic just now, I received this error message below.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Column count doesn't match value count at row 1
/tfp/post_info.asp, line 1290
Here are lines 1263 - 1304 below if someone can help; please.
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
end if
'Following query moves the topic to the reply table
strSql = "INSERT INTO " & strTablePrefix & "REPLY "
strSql = strSql & "(TOPIC_ID"
strSql = strSql & ", FORUM_ID"
strSql = strSql & ", CAT_ID"
strSql = strSql & ", R_AUTHOR"
strSql = strSql & ", R_DATE"
strSql = strSql & ", R_IP"
strSql = strSql & ", R_STATUS"
strSql = strSql & ", R_SIG"
strSql = strSql & ", R_MESSAGE"
strSql = strSql & ", R_MSGICON"
strSql = strSql & ") VALUES ("
strSql = strSql & allRec(TopicID, intOlderTopic)
strSql = strSql & ", " & allRec(ForumID, intOlderTopic)
strSql = strSql & ", " & allRec(CatID, intOlderTopic)
strSql = strSql & ", " & allRec(Topic_Author, intOtherTopic)
strSql = strSql & ", '" & allRec(Topic_Date, intOtherTopic) & "'"
strSql = strSql & ", '" & allRec(Topic_IP, intOtherTopic) & "'"
strSql = strSql & ", 1"
strSql = strSql & ", " & allRec(Topic_Sig, intOtherTopic)
strSql = strSql & ", '" & chkString(allRec(Topic_Message, intOtherTopic),"message") & "')"
'Response.Write strSql & "<br>"
'Response.End
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
'Change the replies topic id from the topic we merging to,
'to the current topic, effectively moving them from one topic
'to the other.
strSql = "UPDATE " & strTablePrefix & "REPLY"
strSql = strSql & " SET TOPIC_ID = " & allRec(TopicID, intOlderTopic)
if blnInSameForum = false then
strSql = strSql & ", FORUM_ID = " & allRec(ForumID, intOlderTopic)
strSql = strSql & ", CAT_ID = " & allRec(CatID, intOlderTopic)
end if
strSql = strSql & " WHERE TOPIC_ID = " & allRec(TopicID, intOtherTopic)
'Response.Write strSql & "<br>"
'Response.End
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
Here is a copy of my entire post_info.asp in txt format if someone needs to and has time to look at it; please.
post_info.asp in txt format
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 August 2012 : 20:44:00
|
When you added some Message Icon mod, you left off a bit of code out of this section you posted. (Or whatever mod you last added to this file, removed the code for the Message Icon mod)
You have this bit of code: strSql = strSql & ", R_MSGICON"
But no corresponding value for it.
|
Support Snitz Forums
|
Edited by - Davio on 24 August 2012 20:46:21 |
 |
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 25 August 2012 : 03:23:33
|
Yeah, line 1287 should be changed to say:
strSql = strSql & ", '" & chkString(allRec(Topic_Message, intOtherTopic),"message") & "'"
strSql = strSql & ", " & cLng(Request.Form("strMessageIcon")) & ")"
|
Edited by - Carefree on 27 August 2012 07:36:14 |
|
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 27 August 2012 : 08:04:51
|
Worked PERFECT!!
Thank you for the correct fix, Carefree!!
Davio, I thank you for your reply as well!
You guys sure know how to make a girl's day! :)
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
| |
Topic |
|
|
|
