Joining the "supplied argument is not a valid" party

[shlomot]

Hello,

Let me first express my admiration to your product. I was hesitant about switching from PhotoPlog, mainly because they provide a nice sideshow feature, but no regret after learning more and more about your top-of-the-line product.

And now to the problem: I uploaded videos and photos via FTP. All navigation through the galley is flawless, including thumbnail display. However, when I click on a thumbnail, I'm getting the following message above the header:

Content visible to verified customers only.

Yet, the picture or video are showing just fine.

Also, on each such query I'm getting an administrator email with the following content:

Content visible to verified customers only.

Here's a sample link.

NOTICE: This is an adult site.

Thanks for your assistance.

[Chuck S]

Bug! Shows error after removing profilefield in vbulletin

This might help we code to a default vb which has this field and stores a users location.

[shlomot]

OK. Took the route of adding a tinytext "dummy" field2.

All is fine now. Thanks.

[Chuck S]

Yep does not matter if you use it or not

[yotsume]

PLEASE PLEASE PLEASE I need to know exactly how to add this field ASAP. I need to re-open my site which has this same error.

THANKS!

[Chuck S]

http://www.photopost.com/forum/1187286-post2.html

This will assist you it was in the thread link noted

[yotsume]

In my VB it says: You are not authorized to execute SQL queries

How do I change this?

[Chuck S]

You need to edit your vb config file and under the line for execute queries place your userid

Make note when running that query that you add any table prefix before table userfield if you have one

[yotsume]

Ok I figured out I need to edit my vb config file and add the right. But now I ran the query and got this message in VB:

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

Now what do I need to do? What do I need to change in:

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

Do I need to change userfield to some value?

[yotsume]

Do I need to add vb_ or pp_ befire userfield?

Im not follow your instructions.

[yotsume]

I need to know what exactly to add to this line and where please:

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

Thanks!

[Chuck S]

You need to add your vb table prefix before userfield as I noted in my last reply. If it is vb_ then your query would look like this

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

[yotsume]

FIXED!

You're my GOD!

Thank You in 200 languages!!!

[Chuck S]

have a good evening