forums/vb3.php on line 173

[Peter Anthony]

I'm having trouble when going to, for example:

http://www.juventudboricua.com/fotos...0/limit/recent

It says: "Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/jjuventu/public_html/fotos/forums/vb3.php on line 173"

I don't know what to do

[Chuck S]

Run this query in vb sql window and add any necessary prefix as you have removed the vb location field

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

[Peter Anthony]

Originally Posted by Chuck S

Run this query in vb sql window and add any necessary prefix as you have removed the vb location field

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

I'm not sure on how to do that

It says: An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'jjuventu_foro.userfield' doesn't exist

[Chuck S]

Make sure you add your proper mysql table prefix of your vb tables

[Johnny Doomo]

If we're getting this error when we view photos after an upgrade, do we need to run this mysql query on our VB database? Not the Photopost database? I' asking because I was on 5.03 and I never ran this before and if I did why do I have to run it again?

Is running this on my forum database going to mess anything up?

How do I find out if I have a table prefix on my forum database?

[Chuck S]

You probally modified your files but yes you want to run that query on your vb database to add back in the proper field in the right table so we can grab a location.

[yotsume]

I have this same error. Your directions are not clear at all!

In the "Manual Query" window what do I put there?

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

What do I need to change in this to get this to work correctly? Can you be clear please.

Thanks,

[yotsume]

I ran this:

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

It ran but the error still shows in my gallery... How can I fix this mess?

[Chuck S]

Make sure that is the correct query as in table prefix and your issuing that command in the right database

If you are logged in as admin in global options in admin set your debug setting to display errors.

If you view the page you should see your true error here and see if it matches this thread.

[yotsume]

this is the error message i get now:

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 vb_user u LEFT JOIN vb_userfield uf ON uf.userid=u.userid LEFT JOIN vb_session s ON s.userid=u.userid LEFT JOIN vb_usertextfield t ON t.userid=u.userid LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=1 LIMIT 1

Result: Unknown column 'uf.field2' in 'field list'

Database handle: Resource id #26

How do I fix?

[Chuck S]

Correct look at your query its wrong this is the right query

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

That should set you right. You added that field to the wrong vb table user not userfield.

[yotsume]

Aaaa your my gallery code pimp!

All fixed! THANKS!

Question... Why did this happen on a fresh install of latest VB and Photopost?

[yotsume]

Oh Now all I have to do is figure out why in the built in lightbox the buttons aren't showing... URL to the images must be off somewhere...

[Chuck S]

you had to delete that profile field out of vbulletin for this to happen.

As far as lightbox this should help

http://www.photopost.com/forum/showp...22&postcount=9