MySQL Error when upgraded to 3.5.2

12-19-2005, 08:00 PM

Can you help, please?

Code:

Database error in vBulletin 3.5.2:

Invalid SQL:

	SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	FROM session AS session
	 LEFT JOIN user AS user USING (userid) 
	WHERE session.lastactivity > 1134963476
		
	ORDER BY user.username asc;

MySQL Error  : Unknown column 'user.skype' in 'field list'
Error Number : 1054
Date         : Monday, December 19th 2005 @ 04:52:56 AM
Script       : http://www.MYSITE.com/forums/online.php
Referrer     : http://www.MYSITE.com/forums/
IP Address   : MYIP
Username     : MYNAME
Classname    : vb_database

I did the upgrade process again but nothing still works.

On the vB Official Forums I read: "You have to upgrade your SQL Database since you're running vB 3.5.2 files on a 3.5.0 RC3 database".

What does it mean? How may I upgrade the database?

Thank you for helping, I don't really know what to do...

mineonic добавил 12-19-2005 в 04:55 PM
I forgot to mention that on v 3.5.0 (thus, before upgrading to 3.5.2 and getting this error when clicking on "View Who's Online") I had the skype-addon. So I would like to delete that "user.skype" column, since skype is supported in 3.5.2 natively.

Help please!

mineonic добавил 12-19-2005 в 07:00 PM
Got another one, when a user tries to update is profile:

Code:

Database error in vBulletin 3.5.2:

Invalid SQL:
UPDATE user SET
	parentemail = '',
	icq = '',
	msn = '',
	aim = '',
	yahoo = '',
	skype = '',
	homepage = 'MYPAGE',
	birthday_search = '1985-10-02',
	birthday = '10-02-1985',
	showbirthday = 2,
	usertitle = 'Mangio vermi',
	customtitle = 2
WHERE userid = 37;

MySQL Error  : Unknown column 'skype' in 'field list'
Error Number : 1054
Date         : Monday, December 19th 2005 @ 04:45:52 PM
Script       : http://www.MYSITE.com/forums/profile.php
Referrer     : http://www.MYSITE.com/forums/profile.php?do=editprofile
IP Address   : 85.18.14.39
IP Address   : MYIP
Username     : MYNAME
Classname    : vb_database