I did a standard upgrade from v5.2.5 to v5.2.6 last night and now we are getting SQL INSERT errors whenever a user tries to post, reply or edit posts on our forum. The exact error message is :
Error Invalid SQL: INSERT INTO vbdb( id, title, content, contenttypeid, lastcontentid, parentid, starter, starterparent, starteruser, closure, depth, userid, authorname, setfor, sentto, showpublished, approved, showapproved, viewperms, featured, inlist, protected, votes, lastcontent, created, publishdate, unpublishdate, prefixid, tagid, textcount, eventstartdate, eventenddate ) VALUES ( 63726, '', ' kjsdafjsf', 30, 63726, 51357, 51357, 22, 408, (63726,51357,22,15,2,1), '{"n63726":0,"n51357":1,"n22":2,"n15":3,"n2":4,"n1":5}', 513, 'Mark.MotionRC', 0, (), 1, 1, 1, 2, 0, 1, 0, 0, 1487786181, 1487786181, 1487786181, 0, 0, (), 0, 0, 0 );
"vbdb" is the name of our Vbulletin database.
I've upgraded VB many times using the procedure in the manual and have never had this problem. Our forum is currently down because of this so I hope someone can help me out and let me know how I might fix this.
Thank you,
Mark
www.hobbysquawk.com
Error Invalid SQL: INSERT INTO vbdb( id, title, content, contenttypeid, lastcontentid, parentid, starter, starterparent, starteruser, closure, depth, userid, authorname, setfor, sentto, showpublished, approved, showapproved, viewperms, featured, inlist, protected, votes, lastcontent, created, publishdate, unpublishdate, prefixid, tagid, textcount, eventstartdate, eventenddate ) VALUES ( 63726, '', ' kjsdafjsf', 30, 63726, 51357, 51357, 22, 408, (63726,51357,22,15,2,1), '{"n63726":0,"n51357":1,"n22":2,"n15":3,"n2":4,"n1":5}', 513, 'Mark.MotionRC', 0, (), 1, 1, 1, 2, 0, 1, 0, 0, 1487786181, 1487786181, 1487786181, 0, 0, (), 0, 0, 0 );
"vbdb" is the name of our Vbulletin database.
I've upgraded VB many times using the procedure in the manual and have never had this problem. Our forum is currently down because of this so I hope someone can help me out and let me know how I might fix this.
- vBulletin Version 5.2.6
- PHP Version 7.0.16
- MySQL Version 5.5.52-MariaDB
- Any Addons installed Yes - but I disabled both and the problem still persists
- Does the issue occur in a default style? Yes
- Does the issue occur using the English language provided? Yes
- Error message on the screen' See attachment
- Browser and Browser version used. Chrome Version 56.0.2924.87
- Did you clear the browser cache and did the error continue? Yes
- A list of steps that can be used to recreate the issue. Post a message. Reply to a message. Edit a Message. All of these will show this error. HOWEVER, even though the error message shows the post still gets captured by the database. If you click OK and refresh your browser you will see the post, so this error message is really a false message of sorts??
- DB Search type = Sphinx
Thank you,
Mark
www.hobbysquawk.com
Comment