Photo not found in the database!

[MortysTW]

I give up. I've done everything I could think of and looked everywhere I could think of.

I have no idea what I did to my gallery. And to be honest, to the best of my memory, this just happened all on its own. I haven't touched the gallery until I discovered the error.

When I click on any thumb, which strangely appears perfectly and has all the proper comments and ratings, I get "Photo not found in the database!"

Like I said, the thumbs work fine, but when you click to see the actual image after the thumbnail view, I get the PHOTO NOT FOUND IN THE DATABASE! statement printed in the box where the the images and all the other photopost links and stuff should be displaying.

Any clue as to what happened and how I can fix it. I'm all out of ideas.

Here's an example of a page:

http://www.mortystwistedworld.com/ga...php?photo=1345

[Chuck S]

You upgraded and never ran your required upgrade scripts

http://www.mortystwistedworld.com/ga....php?photo=781

Delete upgrade.php off your server

[MortysTW]

Okay. This is weird. I haven't touched my server yet. Haven't even logged into my server to do ANYTHING anywhere else on the site. But for whatever reason I clicked the link to my site you put in your reply and the image loaded on my site. Every single image in my gallery is working again. Its as if it were never broken.

Now I'm just really confused. Any ideas on this miracle occuring?

Going to go verify I deleted that upgrade.php file now. I am so totally confused now.

[Chuck S]

As I stated you upgraded your site and did not run the required upgrade script

[MortysTW]

Gotcha. Was a bit brain dead there Chuck. Thanks. I was looking at it wrong and see the obvious of what you mean now.

Got another zinger though. And this appeared later and I'm not sure what the deal is. When viewing a gallery image page, I get this across the top.

Content visible to verified customers only.

THis only appears on an image page. Not the index of the gallery or on any page listings. Just on the individual picture pages.

And this is what line 173 is in my vb3.php:

Content visible to verified customers only.

Any ideas? Or should I open a new thread?

[Chuck S]

PP trouble finding VB user info? (But classifieds pulling it just fine)

that might help add this field back into your vb table

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

[MortysTW]

THat was it. Changed it to Field 6 instead of 2 and its all good now. Thanks!