Install Problem: $result not a valid MySQL resource.

[ArchangelX]

Hi Chuck,

I installed Photopost with no errors...except when I go to submit a product.

After submission I have this appearing in two separate places on the showproduct page, on top of the forum header, and inbetween Navbar and the "Forum/My Products/Watch List" bar.

Content visible to verified customers only.

Also, when submitting a "Post A Review", the review text does not show up...just the above MySQL error message...a duplicate error message is added everytime I add a new review to the product.

I checked out line 186 in VB3.php and it says the following:

Content visible to verified customers only.

Any idea what the problem is? I tried a complete reinstall after dropping all the tables, and still came back to the same error. I double-checked all of my config and integration settings and it all seems appropriate.

Thanks for the help...can't go live till it's fixed, so I appreciate the quick response.

[Chuck S]

forums/vb3.php on line 173

that should explain your issue.

[ArchangelX]

Thanks Chuck, I'll go take a look.

[Chuck S]

Yep its an easy fix.

[ArchangelX]

Wait...um...I'm not sure what to run the query with? Do I run this exactly how it's written within the VBulletin database (not photopost)?

ALTER TABLE userfield ADD field2 VARCHAR(75) DEFAULT NULL;

I'm not really quite sure what is dropped that needs to be back in?

[Chuck S]

Yes you dropped the location field in vb and we pull that

You can run that query in vb sql manager

You need to add in your vb table prefix to the userfield table if you have one.

[ArchangelX]

Chuck,

This is where I'm hung up...I checked my vB MySQL Database for the Userfield Table & field 2...

It's populated and it's full of data:

field2 mediumtext latin1_swedish_ci Yes NULL

For example, if I browse distinct values in that field, I get the following for example:

Rows field2
1682 NULL
287
1 'Ewa Beach, O'ahu
1 -YPO-
1 ..in my EJ1..
1 99-1285 Halawa Valley ST.
1 a designated checkpoint.
5 Aiea
1 Aiea, Hawaii
3 Aiea, HI
1 at my desk
1 auckland,nz
2 Australia
1 Aye Bah Bits
1 Barcelona
etc.

So as you can see, I haven't dropped the location, at least I don't think so. Are you sure this is the correct fix? I'm no coder and I don't meant to question your help, but it doesn't seem like that's the problem.

I don't have a vb table prefix in my main database, either...never set one.

Thanks for the help.

[ArchangelX]

I just double-checked a few profiles as well, and re-entered all information on my Admin account just to see if a certain field was non-existent and was being dropped. All information I entered was there after going back to edit it again, so I coudn't find any fields that were missing from the userfield.

[Chuck S]

In your global options set debug to display errors then go view the page that has an error and you should see the exact specific error although as stated the only field ever missing is that one so thats all we have ever had to post. Let me know what field is messed up in vb we are trying to find and I can assist.

[ArchangelX]

Will do, thanks Chuck for working the midnight hours...

[ArchangelX]

Oooh...I see. Thanks alot Chuck, I get it now...so I should add a new field for sig.pic? That's kinda strange though 'cuz all of my sigs are working for my forum? Weird.

We're sorry, but the system experienced an unrecoverable error. Please try again later.

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 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 sigpic p ON p.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=1 LIMIT 1

Result: Table 'hawaiita_hawaiitalks.sigpic' doesn't exist

Database handle: Resource id #11

Do you know what the exact query I should run is? Thanks ever so much!

[ArchangelX]

Ahh...Chuck. I think I know what the problem is.

I'm running vB3.5.x, and I don't believe the sigpic table even exists in 3.5...it's a new table that was added in vB3.6.

So what do I do, 3.5 doesn't use the sigpic table at all?

[Chuck S]

got ya way too many vb versions

well for one you can upgrade vbulletin to cover up any bugs there are in their code since thats quite old then you dont need to do anything

Or you would replace your function profiledata in vb3.php with this maybe

Content visible to verified customers only.

[ArchangelX]

I'd honestly rather do the latter, as my vB is heavily modified. Jeezmus, the thought scares me right now. Once they go to 4.0, I'm considering it though.

I tried removing the instances of the sigpic, but that didn't work, so I'll definetly give your code a shot. I'm no coder, so I definetly appreciate it.

Thanks for all your help, as always. Can't wait to get started using the product! I'll let you know if it works.

[ArchangelX]

Okay, I made the change, now I get this error. Must be a few things missing from 3.5. Really weird, because both Photopost Pro and Classifieds work fine. Gar.

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

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.useridLEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=1 LIMIT 1

Result: Unknown column 'u.useridLEFT' in 'on clause'

Database handle: Resource id #11

[Chuck S]

probally a spacing thing reapply the block above.

[ArchangelX]

Haha! It works, thank you ever so much Chuck! You're da man! My board and I sincerely appreciate the help! I know you have alotta people asking for support...so I really am grateful for the help! Thanks a bunch.

[Chuck S]

Have a good weekend.