PDA

View Full Version : error upgrading from 3.5.1 to 3.6.1 - problem on 3.5.5 to 3.6.1


Kristijan[cro]
Mon 2nd Oct '06, 7:29pm
vBulletin 3.6 Upgrade System
(Please be patient as some parts may take some time)

Step 11) Upgrade to vBulletin 3.6.0 Beta 1 Complete! (Step 11 of 11)

Step 11) Upgrade to vBulletin 3.6.0 Beta 1 Complete!
Database Error Database error
The Croportal Forum database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the xxxxxxxx (http://www.croportal.net) home page, then try to open another page.
* Click the Back button to try another link.

The xxxxxx forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.5.5:

Invalid SQL:

SELECT atype.extension, atype.thumbnail, atype.newwindow, aperm.usergroupid,
atype.height AS default_height, atype.width AS default_width, atype.size AS default_size,
aperm.height AS custom_height, aperm.width AS custom_width, aperm.size AS custom_size,
aperm.attachmentpermissions AS custom_permissions
FROM attachmenttype AS atype
LEFT JOIN attachmentpermission AS aperm USING (extension)
WHERE enabled = 1
ORDER BY extension;

MySQL Error : Illegal mix of collations (latin1_bin,IMPLICIT) and (cp1250_bin,IMPLICIT) for operation '='
Error Number : 1267
Date : Tuesday, October 3rd 2006 @ 01:21:55 AM
Script : http://www.xxxxxxxx.net/forum/install/upgrade_360b1.php?step=11 (http://www.croportal.net/forum/install/upgrade_360b1.php?step=11)
Referrer : http://xxxxxx.net/forum/install/upgrade_360b1.php?step=10 (http://www.croportal.net/forum/install/upgrade_360b1.php?step=10)
IP Address : xxxxxxx
Username :
Classname : vB_Database


Database error in vBulletin 3.5.5:

Invalid SQL:

SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1159830966;

MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Tuesday, October 3rd 2006 @ 01:21:06 AM
Script : http://www.xxxxx/forum/ (http://www.croportal.net/forum/)
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxxxxxi
Classname : vB_Database

SNN
Mon 2nd Oct '06, 9:56pm
I would try the "./install/upgrade.php" again, seems like it didn't change from 3.5.5

Steve Machol
Mon 2nd Oct '06, 11:20pm
Please see this thread:

http://www.vbulletin.com/forum/showthread.php?t=195137