upgrading from 3.5.4 to 3.6.0 problem -- duplicate posts -- :(

[ericgray]

hi all --

-- well, we had a massive problem yesterday when trying to do the upgrade --

--- on the auto-execute steps (1-11), it hung up on step one, timing out the server on IE and Firefox, making things VERY frustrating.

From there, we decided to revert to version 3.5.4, just to get the forum back up, and now it says it's version 3.5.5. --



The problem is, when someone quick-replies in the 3.5.4 (which used to work), they get a "duplicate post" error --

-- and worse yet, when they put a "post reply" in, they get a syntax error, shutting down their attempt.

What can we do? I am not a mySQL full-timer (I'm a lawyer), so this is extremely frustrating --

here is the forum -- www.pbsmiles.com --

I don't mind paying someone money to fix this even -- the whole forum is extremely frustrated --

THANK YOU!

eric

[RS_Jelle]

You have a vBulletin license, so you get free official support

You can ask it on the vBulletin.com forums (vB.org is for vBulletin modding) or you can open a support ticket in the members area

[Freesteyelz]

I would re-upload all of the vB files, disable all plugins then re-run the upgrade to 3.6.0 again.

While there are many who can help here have you tried vB.com's support ticket system?

[ericgray]

thank you for your help thusfar, all -- i have submitted a ticket, too --

-- basically, when i try 3.5.4 and 3.5.5., i get the same duplicate post errors on quick-replying --

-- and this is emailed to me --

here is the error i am getting emailed after i post a quick-reply, which says i am double-posting --

Database error in vBulletin 3.5.5:

Invalid SQL:

SELECT user.*, subscribethread.emailupdate
FROM subscribethread AS subscribethread
INNER JOIN user AS user ON (subscribethread.userid = user.userid)
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid =
user.usergroupid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid =
user.userid)
WHERE subscribethread.threadid = 7488 AND
subscribethread.emailupdate IN (1, 4) AND
subscribethread.canview = 1 AND
CONCAT(' ', IF(usertextfield.ignorelist IS NULL, '',
usertextfield.ignorelist), ' ') NOT LIKE ' 1 ' AND
user.usergroupid <> 3 AND
user.userid <> 1 AND
user.lastactivity >= 1154920702 AND
(usergroup.genericoptions & ) = 0;

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 ') = 0' at line 13
Error Number : 1064
Date : Monday, August 7th 2006 @ 03:24:09 AM
Script : http://spbr.org/pbsmiles/upload/newreply.php
Referrer
:
http://spbr.org/pbsmiles/upload/show...99864post99864
IP
Address : xxx.xxx.xxx.xxx
Username : eric
Classname : vb_database


ANY THOUGHTS?

thank you!

eric

[Sean S]

It appears that something is missing in your database query,

(usergroup.genericoptions & ) = 0;

something is missing after the & but I'm not sure what.

[Paul M]

Your bitfields are broken - I would say you haven't sucessfully uploaded the 3.6 bitfield_vbulletin.xml file to your includes/xml folder. Reupload that file.

You may need to rebuild your bitfields (../admincp/index.php?do=buildbitfields).