[Phalynx]

Originally Posted by jeremyricci

Cool, thanks man. I'll see if I can find out of my provider has SQL4.1 available.

Edit: Well, I checked, and I'm on MySQL Version : 5.0.83. Any other ideas as to why I may be getting these database errors? Here's the full DB Error message:

PHP Code:

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT 
        u.userid,
        u.usergroupid,
        u.membergroupids,
        u.username,
        u.xperience_level,
        u.xperience,
        u.xperience_ppd,
        u.xperience_awards,
        u.reputation,
        s.points_user,
        s.points_thread,
        s.points_post,
        s.points_misc
        FROM xperience_stats AS s
        INNER JOIN user AS u ON u.userid=s.userid
        WHERE 1=1 
        ORDER BY u.xperience desc
        LIMIT 0,30;

MySQL Error   : Unknown column 'u.xperience_awards' in 'field list'
Error Number  : 1054
Request Date  : Monday, October 4th 2010 @ 04:15:47 PM
Error Date    : Monday, October 4th 2010 @ 04:15:48 PM
Script        : http://www.project-abraham.com/forums/xperience.php?go=ranking
Referrer      : http://www.project-abraham.com/forums/xperience.php
IP Address    : 129.130.172.125
Username      : tha_con
Classname     : vB_Database
MySQL Version : 5.0.83-log 


Your files on the server are old. Please copy all files from the ZIP - I mean ALL. After that, re-import that product.xml

Otherwise the database will not be upgraded correctly.