Quote:
Originally Posted by Phalynx
This modification is not compatible with MySQL 4.1
Please upgrade.
|
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