coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: scroller on July 05, 2004, 02:58:49 PM

Title: [Solved]: Fatal Error Upgrading from 1.1 to 1.3
Post by: scroller on July 05, 2004, 02:58:49 PM
Just did an upgrade ... that went smoothly with no problem ... but now I can't load the site at all ... it's saying Fatal error : There was an error while processing a database query. Any suggestion how do I start troubleshooting. thanks!
Title: Re: Fatal Error Upgrading from 1.1 to 1.3
Post by: Casper on July 05, 2004, 03:10:48 PM
First, on the off chance, try this.  Type this after your url, '...../index.php?theme=classic'

If that doesn't work, please post here the full database query error.

If what you have posted already is all it shows, you need to turn on debug mode, by using your database tool to turn it on in the config table.  Browse to the row 'debug_row' and change it's value to 1.
Title: Re: Fatal Error Upgrading from 1.1 to 1.3
Post by: conway98 on July 16, 2004, 01:10:48 AM
I recieved the same error. When i turned on debugging mode, here is the error i received:

While executing query "SELECT extension, mime, content FROM cpg11d_filetypes;" on 0

mySQL error: Table 'photos.cpg11d_filetypes' doesn't exist


How do i fix this?

Thanks
Title: Re: Fatal Error Upgrading from 1.1 to 1.3
Post by: conway98 on July 16, 2004, 01:24:15 AM
Ok,
I figured it out. I just ran the database update and it fixed the problem.
Title: Re: [Solved]: Fatal Error Upgrading from 1.1 to 1.3
Post by: scroller on July 21, 2004, 06:01:12 AM
I'm also getting the same error ...

While executing query "SELECT extension, mime, content FROM cpg11d_filetypes;" on 0

mySQL error: Table 'qblaze_YuChing.cpg11d_filetypes' doesn't exist

tried running the update.php a couple of times, still no luck.

i think what probably went wrong was ... I thought I was on 1.0 ... so followed the instructions of upgrading from 1.0 ... but now that I'm look at the DB ... seems like I was on 1.1 all the while???

anyone can help? really lost.
Title: Re: [Solved]: Fatal Error Upgrading from 1.1 to 1.3
Post by: scroller on July 21, 2004, 07:04:58 AM
ah .. did a full install all over again ... and all is well now ...  ;D