Problem

[frenckomegl]

Hello, I have a problem with my vbulletin, when I go to see the profile of a user I get this:

How can I fix?

--------------- Added [DATE]1283603619[/DATE] at [TIME]1283603619[/TIME] ---------------

The version I use and 3.8

[BirdOPrey5]

Your Database error is from VB 4.0.6 but you say you use 3.8- did you or someone try an upgrade because something's not right with the version number.

Also we'd need to see the whole error, if you can copy and paste the full text of the error message box.

[frenckomegl]

here:

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height

FROM my_album AS album
LEFT JOIN my_picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)

WHERE album.userid = 1
AND album.state IN ('public', 'private', 'profile')


ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Unknown column 'album.coverpictureid' in 'on clause'
Error Number : 1054
Request Date : Saturday, September 4th 2010 @ 06:50:40 PM
Error Date : Saturday, September 4th 2010 @ 06:50:40 PM
Script : http://habbofrizz.altervista.org/forum/member.php?u=1
Referrer : http://habbofrizz.altervista.org/forum/index.php
IP Address :
Username : ReFrenck
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

[borbole]

Originally Posted by frenckomegl

here:

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT album.*,
picture.pictureid, picture.extension, picture.idhash, album.moderation,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height

FROM my_album AS album
LEFT JOIN my_picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)

WHERE album.userid = 1
AND album.state IN ('public', 'private', 'profile')


ORDER BY album.lastpicturedate DESC
LIMIT 2;

MySQL Error : Unknown column 'album.coverpictureid' in 'on clause'
Error Number : 1054
Request Date : Saturday, September 4th 2010 @ 06:50:40 PM
Error Date : Saturday, September 4th 2010 @ 06:50:40 PM
Script : http://habbofrizz.altervista.org/forum/member.php?u=1
Referrer : http://habbofrizz.altervista.org/forum/index.php
IP Address :
Username : ReFrenck
Classname : vB_Database
MySQL Version : 4.1.22-standard-log

As far as I know there is no coverpictureid in the album table. What was the latest change you did/undid to your board?

[BirdOPrey5]

It looks like someone attempted to upgrade to 4.0.6 but didn't upload all the files... your style is clearly 3.8 but your database is 4.0.6... I don't know what to tell you- you need to figure out what happened- who tried to upgrade and what did they do? Do you have a backup you could revert to? As a last resort option I would maybe try to upgrade, the right way, from the start- first by uploading all the 4.0.6 files over your old ones and then running upgrade.php (again). But I really don't even know where to start with something like this.