Error while upgrading from 3.7.4 to 3.8

[zomega]

I recieved the follwing error at the last page after the upgrade script ran all the way through. In my admincp it still says that I'm running the old version of vb, and there have been multiple database errors being sent to my email, especially in regards to user registration. Everything worked fine before the upgrade, I'd like to get this issue resolved.

PHP Version: 5.2.6
MySQL Version: 5.0.67-community
Following mods: vbArcade, vbshout, vbadvanced


Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT prefix.*, prefixpermission.usergroupid AS restriction
FROM vb_prefix AS prefix
LEFT JOIN vb_prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
ORDER BY prefix.displayorder;

MySQL Error : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, January 10th 2009 @ 02:57:30 AM
Error Date : Saturday, January 10th 2009 @ 02:57:31 AM
Script : http://zomega.net/forums/install/upgrade_380a2.php?step=5
Referrer : http://zomega.net/forums/install/upgrade_380a2.php?step=4
IP Address : 69.61.191.234
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community

[Carlos 360]

I got the same exact thing, except without that "error" you got there.

Nevermind, my installation works now. It seems like I forgot to point my browser to the upgrade script. Grrr.....I hate when I forget!

[Zachery]

You've got mixed colations, you'll need to change the tables to one or the other. This is caused by your database being set for a default that your tables are not currently set for.

[zomega]

Wait what, I don't quite understand your meaning.

[Hidden_Gamma]

I'm getting an error trying to upgrade from 3.7.4 PL 1 to 3.8.0. When I get to the script, it keeps telling me: "Your vBulletin (3.7.4) does not appear to be running the version that was downloaded (3.8.0).
This generally means your upgrade was not successful. Please ensure that you have uploaded the latest files and click here to try again.
If you are sure you wish to continue with this part of the upgrade, click here."


This is the second upgrade I have done since first getting vBulletin and I've follwowed the instructions closely and uploaded all the files from the upload/ folder minus the install/ twice, so I don't know what the problem could be. I am also getting this message sent to my webmaster email address: Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/redacted/public_html/forum/includes/class_core.php on line 311


MySQL Error :
Error Number :
Request Date : Saturday, January 10th 2009 @ 07:01:27 PM
Error Date : Saturday, January 10th 2009 @ 07:01:27 PM
Script : http://forum.redacted.com/calendar.php?do=add&c=1&day=2001-7-28
Referrer :
IP Address : redacted
Username :
Classname : vB_Database
MySQL Version :


:confused:

[Hidden_Gamma]

Now, also, when I turn the forums back on, if I click on the UserCP, I get a databse error and this gets sent to me:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT COUNT(*) AS count
FROM socialgroup AS socialgroup
INNER JOIN subscribegroup AS subscribegroup ON
(subscribegroup.userid = 1 AND subscribegroup.groupid = socialgroup.groupid)
LEFT JOIN socialgroupmember AS socialgroupmember ON
(socialgroupmember.userid = 1 AND socialgroupmember.groupid = socialgroup.groupid)
WHERE 1=1;

MySQL Error : Table 'redactedforum.subscribegroup' doesn't exist
Error Number : 1146
Request Date : Saturday, January 10th 2009 @ 07:24:47 PM
Error Date : Saturday, January 10th 2009 @ 07:24:47 PM
Script : http://forum.redacted.com/usercp.php
Referrer : http://forum.redacted.com/search.php?searchid=447
IP Address : redacted
Username : redacted
Classname : vB_Database
MySQL Version : 5.0.67-community-log

[Hidden_Gamma]

Never mind, I figured out what went wrong. Dope that I am, I never uploaded the rest of the files from the install folder. :rolleyes: :o

[n.a.a]

I have the same problem as Hidden Gamma. I just upgraded to the 3.8.1. but my control panel still says that I have the 3.7.3. on. I got no error massage regarding this matter but what I do have is the invalid SQL error whenever I enter the UserCP:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM socialgroup AS socialgroup
INNER JOIN subscribegroup AS subscribegroup ON
(subscribegroup.userid = 5967 AND subscribegroup.groupid = socialgroup.groupid)
LEFT JOIN socialgroupmember AS socialgroupmember ON
(socialgroupmember.userid = 5967 AND socialgroupmember.groupid = socialgroup.groupid)
WHERE 1=1;

MySQL Error : Table 'goldman.subscribegroup' doesn't exist
Error Number : 1146
Request Date : Wednesday, February 4th 2009 @ 04:13:02 AM
Error Date : Wednesday, February 4th 2009 @ 04:13:03 AM
Script : http://shabab-alamal.com/vb/usercp.php
Referrer : http://shabab-alamal.com/vb/index.php
IP Address : 41.234.0.231
Username : Nadia. A.
Classname : vB_Database
MySQL Version : 4.1.21-log

I tried reuploading the upgrade directories to my server, 3 times!! But still, I have the same problem! Can someone help, please?!

[beishe8]

Poster found the answer