'Top Posters' now works, thanks for the fix.
Now, about references to 'photopost.cache' which does not exist, do you mean a table named just 'cache' as I have that.
I have just had 2 more debug emails sent by the config-inc.php file:
---------------------------------------------------
1]
An error was encountered during execution of the query:
INSERT INTO users (userid,usergroupid,username,password,email,homepage,icq,aim,yahoo,joindate,birthday,ipaddress,location,interests,occupation,bio,site,, Resource id #7)
values(NULL,'3','V70ARR','9f6db65ced1f9ab32929f857350f29ba','cooke73@hotmail.com','http://','','','','1127922273','1973-3-21','82.41.42.103','Edinburgh, UK','My Car.... R','self employed','','Volvo Owners Club','$, Resource id #7')
The query returned with an errorcode of:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Resource id #7)
values(NULL,'3','V70ARR','9f6db65ced1f9ab32929f857350f2' at line 1
If you need assistence or feel this is a 'bug'; please report it to our support forums at:
http://www.photopost.com/members/forum/f66/index.html
To turn off these emails, set $debug=0 in your config-inc.php file.
2]
An error was encountered during execution of the query:
SELECT id, date, user, userid, SUM(views) AS tviews,COUNT(*) AS pcount, MAX(date) AS maxdate,
SUM(filesize) AS tfilesize FROM photos WHERE approved=1 GROUP BY userid ORDER BY maxlast DESC
The query returned with an errorcode of:
Unknown column 'maxlast' in 'order clause'
If you need assistence or feel this is a 'bug'; please report it to our support forums at:
http://www.photopost.com/members/forum/f66/index.html
To turn off these emails, set $debug=0 in your config-inc.php file.
-------------------------------------------
Can you explain what has caused these please.
Thanks, great support. Keep it up.
Bob