"Fatal error" after 1.3 upgrade

[pskeggs]

Hi,
After updating my album I get the following error message when trying to run the index.php:
"Fatal error : There was an error while processing a database query."

Debugging says:
"While executing query "SELECT extension, mime, content FROM coppermine_filetypes;" on 0

mySQL error: Table 'skeggs_pix.coppermine_filetypes' doesn't exist"

I have read through the discussions on this topic at http://forum.coppermine-gallery.net/index.php?topic=6781.0, but can't seem to find any solutions. I've run the update.php several times, ensuring I've updated the new files.

When running update.php the report says "already done" on all items, but when checking the actual MySQL database I can see that it hasn't created the coppermine_filtypes table.

Any suggestions on what's causing this?

Thanks,
Paal

[cprice]

I had this exact same error and found that I had not completely copied all of the 1.3.0 files to my 1.2.1 directory.  I re-copied the files and then re-ran update.php.  This time the update worked.

What tipped me off was when I when into Config, it was still label 'Coppermine Photo Gallery 1.2.1'

Hope this helps,

Chris

[Joachim Müller]

@pskeggs: make sure you have CREATE permissions on your mySQL database.

@cprice: if the config page still says cpg1.2.1, you haven't replaced all cpg1.2.1 files (at least, you haven't replaced include/init.inc.php). Make sure to replace the content of the include folder as well.

GauGau