Database errors... unknown?

[sburns1992]

Hey,
For some reason I am getting a few database errors. I get this one when I want to view somebodies profile

Database error in vBulletin 3.8.4:

Invalid SQL:

			SELECT album.*,
				picture.pictureid, picture.extension, picture.idhash, album.moderation,
				picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
				
			FROM album AS album
			LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
			
			WHERE album.userid = 262
				AND album.state IN ('public', 'private', 'profile')
				AND (album.visible > 0 OR album.moderation > 0)
				
			ORDER BY album.lastpicturedate DESC
			LIMIT 2;

MySQL Error   : Unknown column 'album.coverpictureid' in 'on clause'
Error Number  : 1054
Request Date  : Saturday, December 19th 2009 @ 03:46:42 PM
Error Date    : Saturday, December 19th 2009 @ 03:46:42 PM
Script        : http://flamehabbo.com/forum/member.php?u=851
Referrer      : http://flamehabbo.com/forum/memberlist.php
IP Address    : 92.23.1.91
Username      : Burns
Classname     : vB_Database
MySQL Version : 5.0.67-community-nt

Then I get this one when I try to add/edit a usergroup

Database error in vBulletin 3.8.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO usergroup
(`title`, `description`, `usertitle`, `opentag`, `closetag`, `passwordexpires`, `passwordhistory`, `ispublicgroup`, `canoverride`, `awardpermissions`, `arcadepermissions`, `minpoststoplay`, `minreptoplay`, `minreglengthtoplay`, `forumpermissions`, `genericpermissions`, `attachlimit`, `pmquota`, `pmpermissions`, `pmsendmax`, `pmthrottlequantity`, `calendarpermissions`, `wolpermissions`, `adminpermissions`, `genericpermissions2`, `genericoptions`, `profilepicmaxwidth`, `profilepicmaxheight`, `profilepicmaxsize`, `avatarmaxwidth`, `avatarmaxheight`, `avatarmaxsize`, `signaturepermissions`, `sigpicmaxwidth`, `sigpicmaxheight`, `sigpicmaxsize`, `sigmaxrawchars`, `sigmaxchars`, `sigmaxlines`, `sigmaxsizebbcode`, `sigmaximages`, `albumpermissions`, `albumpicmaxwidth`, `albumpicmaxheight`, `albumpicmaxsize`, `albummaxpics`, `albummaxsize`, `usercsspermissions`, `visitormessagepermissions`, `socialgrouppermissions`, `maximumsocialgroups`, `groupiconmaxsize`)
VALUES
('UK Radio DJ test', '', 'UK Radio DJ test', '<b><font color=#33CC33>', '</font></b>', '0', '0', '0', '0', '1', '7', '0', '-1000', '0', '10219775', '1546458827', '0', '50', '1', '5', '0', '1', '0', '0', '1', '62', '210', '210', '65535', '130', '130', '20000', '237567', '500', '100', '10000', '1000', '500', '0', '7', '4', '255', '600', '600', '', '100', '0', '63', '63', '65535', '5', '65535');

MySQL Error   : Unknown column 'albumpicmaxsize' in 'field list'
Error Number  : 1054
Request Date  : Saturday, December 19th 2009 @ 03:39:53 PM
Error Date    : Saturday, December 19th 2009 @ 03:39:53 PM
Script        : http://flamehabbo.com/forum/admincp/usergroup.php?do=update
Referrer      : http://flamehabbo.com/forum/admincp/usergroup.php?do=add
IP Address    : 92.23.1.91
Username      : Burns
Classname     : vB_Database
MySQL Version : 5.0.67-community-nt

and this when I try to edit a notice

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield lots of text went here, too much to add

MySQL Error   : Unknown column 'phrasegroup_ecdownloads' in 'field list'
Error Number  : 1054
Request Date  : Saturday, December 19th 2009 @ 04:20:46 PM
Error Date    : Saturday, December 19th 2009 @ 04:20:46 PM
Script        : http://flamehabbo.com/forum/admincp/notice.php?do=update
Referrer      : http://flamehabbo.com/forum/admincp/notice.php?do=edit&noticeid=18
IP Address    : 92.23.1.91
Username      : Burns
Classname     : vB_Database
MySQL Version : 5.0.67-community-nt

Hope you can help,
Thanks.

[Lynne]

The first one is from a mod - there is no default vb column called coverpictureid in the album table.

Don't know about the second.

The third is also from a mod - there is no default vb column called phrasegroup_ecdownloads in the usergroup table.

[sburns1992]

Managed to sort it
vB4 really sucks, sorry to say.

[ChopSuey]

Talking about vB4 in the vB3 forum?

[sburns1992]

Yeah, basically I upgraded to vB4 and forgot to take a database backup. vB4 then didn't work on our server for some strange reason, so I went back to vB3 and had to insert the whole database manually to make sure nothing from vB4 went in.

I managed it though and the forum is back to normal