Error on only some ads...

[Andy R]

On the first page of ads here they all show fine.
http://www.airstreamforums.com/class...wcat.php?cat=6

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.

Script: showproduct

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'

Database handle: Resource id #26

[Chuck S]

Try uploading the new vb3.php file as if your using vb35 you definately need the new file as this line is right in it

$query .= ",avatar.avatarpath, NOT ISNULL(customavatar.". iif( VB35 == "on", "filedata", "avatardata" ) .") AS hascustomavatar,u.avatarrevision";

Note the field in the customavatar table is named differently in vb35 so you need the proper vb3.php file to work right

[Andy R]

I am indeed running v3.5...

Ok, I re-uploaded the vb3.php file from the 9/9 build and I am still getting that error.

[Chuck S]

Interesting I am indeed using vb35 here as well and this is the same code in reviewpost and photopost.

http://www.reeftalk.com/reviews/show...php/product/56

In your customavatar database table in vbulletin what fields do you have?

In 3.5 it should be filedata and in 3.0 series I beleive avatardata

[Andy R]

Here is the list of columns from my Avatar table in vB 3.5

 avatarid 
 title 
 minimumposts 
 avatarpath 
 imagecategoryid 
 displayorder 

[Chuck S]

customavatar table! not avatar

I need to find out why you get this issue and no one else

[Andy R]

Here is my customavatar table columns:

 filedata 
 dateline 
 filename 
 visible 
 filesize 
 width 
 height 

[Andy R]

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.

Once again thanks for your help...