'Broken' Uploads/Fatal Error

[keeganmessingonline]

Hi,

I am the webmaster of http://www.keeganmessing.com. Since my new host doesn't allow SQL databases on my plan, I kept my photo gallery at my old host, fan fusion. The photo gallery is located at http://www.keegan-messing.fanfusion.org/coppermine/index.php. A few weeks ago I tried to upload some photos to the gallery and after the upload the thumbnails were broken, it said the upload was successful but when I placed the files, I got a message telling me they were not placed successfully. So naturally I went to the Coppermine website, saw there was an update, and installed it.

Now when I go to my photo gallery, I get fatal error. I enabled debug mode and got this:

While executing query 'SELECT aid FROM cpg14x_albums WHERE moderator_group IN (3)' in include/init.inc.php on line 271

mySQL error: Unknown column 'moderator_group' in 'where clause'

So now I really don't know what's wrong, and I'm pretty frustrated  :'(. I don't know what my previous version was, but according to my cpanel I uploaded the gallery in May 2010.

If anyone could help me fix this, I'd be really grateful.

Thanks.

[phill104]

How did you upgrade? Hopefully using the method outlined in in our docs?

[keeganmessingonline]

How did you upgrade? Hopefully using the method outlined in in our docs?

Yes. I followed your method and uploaded each of the files to my website, then ran your update script.

[Αndré]

mySQL error: Unknown column 'moderator_group' in 'where clause'

Please run update.php again to perform the required database changes.