[majoreyeswater]

Thanks for your help, I've worked with the hosting service and can now connect to the db, although I have concerns over the timeout value. Also the host has advised they downgraded to MySQL v4 and then recreated the database from the dump file I provided.

However... everything is working EXCEPT when I click on active users I get the error below. This error never occurred under 5.0 but the host is advising that MySql 5.0 is causing them a few problems in their windows environment.

Anyway any advice I'd appreciate it - getting closer and closer to resolution, just a few more steps...

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo,user.skype, user.lppstatus,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1155997352

ORDER BY user.username asc;

MySQL Error : Unknown column 'user.lppstatus' in 'field list'
Error Number : 1054
Date : Saturday, August 19th 2006 @ 03:37:32 PM
Script : http://www.weareleeds.com/online.php
Referrer : http://www.weareleeds.com/index.php
IP Address : **.**.**.**
Username : MajorEyeswater
Classname : vb_database

Thanks.