When I go to the second pages of ads I get the follow error when trying to view the trailers for sale...
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid)WHERE u.userid=8215 LIMIT 1
Result: Unknown column 'customavatar.filedata' in 'field list'
Omegatron, thanks for the help once again. This was a simple mistake I made. I used mysqlhotcopy to backup databases and the config file was still pointing to old forum database. So I have now change the config to point to the new 3.5 database and that has solved the issue.