Help - EE quit working

[dohara]

Hello All,

My EE gallery just quit working. To view error:
http://www.northernimagesphotography.com/webgallery/

When I try to go to the EE admin page. I get the following error:

Error in performing query fetchstyle: Unknown column 'ee_exhibition_style_id' in 'field list'

When I try to go to the EE backup page, I get the following error:
You need at least MySQL version 3.23.20 to use this software. You are currently using version 4.0.12

I have used IPowerweb host for six months without any problems and have not made any recent changes. IPowerWeb uses Perl Version 5.006001, Mysql Version 4.0.12, and PHP Version 4.2.3.

I only know enough PHP to be dangerous.

EE is a great program and I would really appreciate help on this major problem, my gallery is critical, and I need it back as soon as possible.

Thank you very much,
Dennis

[Pekka]

dohara wrote:
Hello All,

My EE gallery just quit working. To view error:
http://www.northernimagesphotography.com/webgallery/

When I try to go to the EE admin page. I get the following error:

Error in performing query fetchstyle: Unknown column 'ee_exhibition_style_id' in 'field list'

Sorry to hear that.

Sounds like there is something haywire in SQL tables.

When I try to go to the EE backup page, I get the following error:
You need at least MySQL version 3.23.20 to use this software. You are currently using version 4.0.12

Get EE Backup update for MySQL 4.0 from http://photography-on-the.net/forum/showthread.php?t=9812

If you have made backups install the EE Backup update and do a file restore - let's hope for the best. Table "ee_photo_to_exhibition" is relation table to tell which photo belongs to which exhibition. It is not possible for EE to erase this table (there are no commands programmed for table erase in EE) so reason is in server.

I have used IPowerweb host for six months without any problems and have not made any recent changes. IPowerWeb uses Perl Version 5.006001, Mysql Version 4.0.12, and PHP Version 4.2.3.

I only know enough PHP to be dangerous.

EE is a great program and I would really appreciate help on this major problem, my gallery is critical, and I need it back as soon as possible.

Maybe they updated to MySQL 4.0 and messed something up.

I would also contact your server admin - they should have keps backups of your MySQL tables and they have rights to run MySQL error correction programs like myisamchk which may fix the database (although totally missing table can not be usually retrieved unless it is a disk corruption problem and disk tools can recover the data).

[dohara]

Thanks Pekka, I will give this a try!

Dennis

[dohara]

Hello Pekka,

Question, so all of the zipped files in the MtSQL 4.0 download, go into the backup directory on my host server?

Thanks,
Dennis

[dohara]

Thank You Pekka, I installed the new backup and the restore worked fine. I'm back in business.


Great Job,
Dennis

[Pekka]

Very good to hear it. Well done.

I can not stress this enough for all EE users:

--------------------------------------------
Make sure you make file backups from time to time and DOWNLOAD them from server, too. Keep your EE Backup up-to-date, latest public version is in http://photography-on-the.net/ee/backup/EE_Backup_1_02.zip
--------------------------------------------

That will save your butt when server crashes, hard disk corruption happens or virus or hacker hits the server.