Hello By combining 2 post gives me this error: Database error in vBulletin 4.2.0: Invalid SQL: DELETE FROM activitystream WHERE typeid = AND contentid IN (SELECT postid FROM post WHERE threadid IN (378692,387548)); MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND contentid IN (SELECT postid FROM post WHERE threadid IN (378692,387548))' at line 4 Error Number : 1064 Request Date : Friday, May 25th 2012 @ 09:29:46 AM Error Date : Friday, May 25th 2012 @ 09:29:46 AM Script : http://www.foroxd.com/inlinemod.php?do=domergethreads&threadids=378692,387548 Referrer : http://www.foroxd.com/inlinemod.php?do=mergethreadcompat&t=378692 IP Address : xxxxxxxxxxx Username : xxxxxxx Classname : vB_Database MySQL Version : 5.5.21-cll As might be fixed? |
BD
Collapse
X
-
Tags: None -
It looks like you were combining two threads, not two posts - was that what you did? I just merged two threads on my test site and it worked just fine. Can you please tell us exactly what you did so we can try to reproduce the error?
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css help -
Thanks,always happenstomerge 2threads.
Works well, letsputwith or withoutredirectionandclick onproceed iswhere it happens.
Thecurious caseis that if thefusesstillgivingthat error
sequence
1 http://img9.imageshack.us/img9/512/image1ivw.png
2 http://img585.imageshack.us/img585/4297/image2fm.png
3 http://img99.imageshack.us/img99/3900/image3ms.pngComment
-
This is a bug - Moving posts results in datatbase error (Forum Only) There is a temporary fix posted (remove the problem code).
Please don't PM or VM me for support - I only help out in the threads.
vBulletin Manual & vBulletin 4.0 Code Documentation (API)
Want help modifying your vbulletin forum? Head on over to vbulletin.org
If I post CSS and you don't know where it goes, throw it into the additional.css template.
W3Schools <- awesome site for html/css helpComment
Related Topics
Collapse
-
by markyGot an error today (everything is verbatim except the bolded part):
Invalid SQL:
/** saveDbCache */ DELETE FROM cacheevent WHERE (cacheid = 'node_10_lvl1data' AND event = 'nodeChg_10')...-
Channel: Support Issues & Questions
-
-
by aelalfeyI started getting this error about 6 days "about 10 emails everyday" ago with no certain reason.Code:
[COLOR=#222222][FONT=arial]Database error in vBulletin 5.1.8:[/FONT][/COLOR] [COLOR=#222222][FONT=arial] Invalid SQL:[/FONT][/COLOR] [COLOR=#222222][FONT=arial]CREATE[/][/]
-
Channel: Support Issues & Questions
-
-
by webtoadvBulletin has sent me 3 emails with database errors. And i was wondering if this is a serious error, or just some bug in vB. Is there something i can do? I have attached the 3 emails below.
...-
Channel: Support Issues & Questions
-
-
by nsglazerI've received hundreds of emails since our upgrade to vBulletin 5.1.3 Patch Level 1 all pretty similar to these. Any idea what's going on?
Database error in vBulletin 5.1.3:
...-
Channel: Support Issues & Questions
-
-
by raymondseowKeep getting this error may i know what causes it?
Database error in vBulletin 5.1.2:
[Showing truncated query, original length: 1320975]
[First 500 char...-
Channel: Support Issues & Questions
-
Comment