Upgraded now errors

[hashesh]

I upgraded from 2.5 to 3.1 and get the following errors when i click on a review:


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /reviews/forums/vb3.php on line 141

Parse error: parse error, unexpected T_SL in /var/www/html/reviews/templates/vb3enhanced/quickcom.tmpl on line 212


help

[Chuck S]

Well the template issue I already replied on

Template Error(FIXED)

Whats your url to your install and test login

[hashesh]

http://www.pbxtech.info/reviews/show...8&cat=2&page=1

thanks the template is fixed now. you shouldnt need a login.

[Chuck S]

well test logins are always nice to help replicate a problem but nope yours is easy

Your profile query in vb3.php is failing cause one of your profile fields is missing in vbulletin tables

Most likely field2 in the usertextfield is missing since you can delete this.

That is where the location field is help and we code those queries to a default vb3 install so if you change something in vb3 you would need to change our associated query as well

[hashesh]

hmm ok i dont remember deleting it, unless vb did during an upgrade.

but i added the field2 and the error is gone. thanks!

[hashesh]

well i though it was ok..

now im getting two of those errors

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /reviews/forums/vb3.php on line 141

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /reviews/forums/vb3.php on line 141

[Chuck S]

That must be when viewing a photo with comments. Okay well your Vb3 is changed from the normal

We code queries and such based on a non changed vb3 and your profile query is most likely missing the location field

Okay in Vb3 check your usertextfield table and see if you have a field2 entry. This is where a default vb stores the user location