Database errors... unknown?
Hey,
For some reason I am getting a few database errors. I get this one when I want to view somebodies profile
Code:
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
Code:
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
Code:
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¬iceid=18
IP Address : 92.23.1.91
Username : Burns
Classname : vB_Database
MySQL Version : 5.0.67-community-nt
Hope you can help,
Thanks.
|
More Information