Upgrade error with forum template integration.

[flavoflav]

I upgraded my site from 2.x to 3.x and now I am getting this error when browsing ads

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/www/www.xxxxxxxx.com/classifieds/forums/vb3.php on line 189

[Chuck S]

what version of vbulletin are you using? Is it an old 3.5 series vbulletin?

[flavoflav]

Originally Posted by Chuck S

what version of vbulletin are you using? Is it an old 3.5 series vbulletin?

No its 3.7.3 latetst version.

[Chuck S]

well then that makes no sense. as the table sigpic should definately exist on vb 3.7 series. I am running vb 3.7 series and see no issues nor has anyone else reported any errors

Have you ran all vb upgrades? If you can view your vb database do you see a sigpic table?

[flavoflav]

Originally Posted by Chuck S

well then that makes no sense. as the table sigpic should definately exist on vb 3.7 series. I am running vb 3.7 series and see no issues nor has anyone else reported any errors

Have you ran all vb upgrades? If you can view your vb database do you see a sigpic table?

yes we have run all the upgrades and yes there is a sigpic table

wcbbsigpic 290.5 KB 2.0 KB

[flavoflav]

Ok I canned the old install and made a fresh install of the classifieds so no old data in the databse, but I am still getting this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/local/www/www.westcoastbikers.com/classifieds/forums/vb3.php on line 185

This happens when I click on the profile button or when i look at ads which have been placed.

I checked to make sure that Forum database table prefix is set to what my forums use.

any ideas on fixing this?

[Chuck S]

As admin in global options set debug options to display errors and view the error page and then post here what your error is.

[flavoflav]

Originally Posted by Chuck S

As admin in global options set debug options to display errors and view the error page and then post here what your error is.

Script:

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,u.sigpicrevision,p.filename,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM wcbbuser u LEFT JOIN wcbbuserfield uf ON uf.userid=u.userid LEFT JOIN wcbbsession s ON s.userid=u.userid LEFT JOIN wcbbusertextfield t ON t.userid=u.userid LEFT JOIN wcbbsigpic p ON p.userid=u.userid LEFT JOIN wcbbavatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN wcbbcustomavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=1 LIMIT 1

Result: Table 'wcbb.wcbbsigpic' doesn't exist

Database handle: Resource id #11

I posted that the table does exist in my VB 3.7 install

yes there is a sigpic table wcbbsigpic 290.5 KB 2.0 KB

This is happening in an 100% fresh install.

My VB database prefix is set correctly to wcbb

This is making me crazy

[Chuck S]

Are you sure you are connecting to the vb database as in when you installed your classifieds you put in the correct vb database.

I mean lets look at your error its pretty specific it tells me the table your saying exists does not. Only way that error can be obtained is if the table does not exist in the database your saying it does

[flavoflav]

Originally Posted by Chuck S

Are you sure you are connecting to the vb database as in when you installed your classifieds you put in the correct vb database.

I mean lets look at your error its pretty specific it tells me the table your saying exists does not. Only way that error can be obtained is if the table does not exist in the database your saying it does

Yes the 100% fresh (no upgrade) install went with no errors - the table exists in my vbulletin install.

It definately exists:

cbbsearch 5.7 KB 3.0 KB 2.6 KB Yes
wcbbsetting 74.6 KB 10.0 KB 0 Yes
wcbbsettinggroup 1.8 KB 2.0 KB 0 Yes
wcbbsigparsed 26.9 KB 4.0 KB 0 Yes
wcbbsigpic 290.5 KB 2.0 KB 0 Yes
wcbbsmilie 12.0 KB 2.0 KB 0 Yes
wcbbsocialgroup 120 Bytes 9.0 KB 0 Yes
wcbbsocialgroupmember 56 Bytes 4.0 KB 0

another view:

wcbbsigpic MyISAM 9 Dynamic 50 5950 297508 4294967295 2048 0

[Chuck S]

Feel free to email us through the contact link in the header with ftp info database info url and all logins to support your claim.

I am sure you can see the error and it says the table does not exist so we need to find out why.

[flavoflav]

Originally Posted by Chuck S

Feel free to email us through the contact link in the header with ftp info database info url and all logins to support your claim.

I am sure you can see the error and it says the table does not exist so we need to find out why.

Yes I see the error and what it claims - but when I look at all the tables in my VB install the wcbbsigpic table exists with data in it.

I have emailed all the FTP and Mysql userid's and passwords so you can take a look.

Thanks for your help on this.

John

[Chuck S]

Not a problem will let you know.

[flavoflav]

Originally Posted by Chuck S

Not a problem will let you know.

Chuck - I do not want to be a PITA but do you have an idea of when we may have some answers on this little problem... my users are buggin me about it.

Thank you!

J -

[Chuck S]

Your email has bounced twice to us. We sent you a response asking for a forum admin login and if there is a direct link to phpmyadmin as well and have yet to get a response so there might be an issue with the email your using since I see two bounced messages.

[flavoflav]

Originally Posted by Chuck S

Your email has bounced twice to us. We sent you a response asking for a forum admin login and if there is a direct link to phpmyadmin as well and have yet to get a response so there might be an issue with the email your using since I see two bounced messages.

ergh - okay I updated my email address ...

[Chuck S]

Did you send us an email yet with the requested info? I am not able to view your site or database without these two things.

[flavoflav]

Originally Posted by Chuck S

Did you send us an email yet with the requested info? I am not able to view your site or database without these two things.

email sent

[flavoflav]

Originally Posted by flavoflav

email sent

just as an FYI the forum database is called wcbb

[Chuck S]

I will go check to see what emails we have.