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 :)