Critical error

[Ntalia]

Hello

my gallery - http://kanyewest.us/gallery/ showed today an error:

Critical error
There was an error while processing a database query

But support on my webhosting told me there were nor errors accesing the database. Thay said:

I am still not catching an error being reported in the server itself. I am afraid you may need to contact coppermine to see if they can find out what is wrong. If there is any server configurations that need to be made.

Could You help me with this one, please?

[gmc]

More detail is needed to determine the problem..
Read doc at http://documentation.coppermine-gallery.net/en/errors.htm#errors_fatal and follow instructions to manually enable debug mode (since you can't access the admin config menu). You should then get a more detailed error message that will either point you to the problem, or at least provide additional info you can post here for help...

[Ntalia]

Thank You Greg.

I have donw what You said. Could You check it now, please?

[gmc]

OK... the displayed screen now shows the real error:
mySQL error: Table './ntaliaco_copp3/cpg_mod_online' is marked as crashed and should be repaired

cpg_mod_online is not a core CPG table, it is added/used by a plugin onlinestats. It is also likely some external event caused the error - rather than plugin/mod code... but regardless should be able to fix from phpMyAdmin -where you turned on the debug option...

In phpMyAdmin:
Select table cpg_mod_online in the navigation pane on the left - Be sure the correct table name appears in the main frame when the page loads.
Then click the 'Operations' tab in the main frame - on lower left of frame (position may vary based on version of phpMyAdmin), are "Table Maintenance" options - click on Repair Table. You should get a message like 'Your SQL query has been executed successfully' 
Try accessing your gallery again.

If other tables have the same issue - repeat the procedure for them. You successfully accessed a number of other tables before encountering the error per the debug trace. Typically I would expect only one table to be affected.

If all is well - turn off debug mode (at least for everyone) - via Admin Config (or via phpMyAdmin as you turned it on)

Additional information on repairing MySQL tables can be found at:
http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
http://dev.mysql.com/doc/refman/5.0/en/repair-table.html

As for what caused it - you can try providing the MySQL error message to your ISP - they may be able to find an error in the servers logs when the table initially 'crashed'.

Good luck!

[Ntalia]

Thanks again
But I cannot access this cpg_mod_online cause it shows:

#145 - Table './ntaliaco_copp3/cpg_mod_online' is marked as crashed and should be repaired

[Ntalia]

ok, I have accessed it somehow and it doesnt have this fix table option.
Only one option is "Flush the table (FLUSH)"

[gmc]

OK... one more way around... select any other table in the database in the navigation menu.
Then click on the SQL tab in the main window.

Enter (without the quotes):  'REPAIR TABLE cpg_mod_online'  in place of the default 'SELECT * FROM `tablename` WHERE 1' statement and press 'Go'.

You should again see a message like: 'Your SQL query has been executed successfully'
(You may also see an information message like: 'This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.'  This referes to the result set from the REPAIR and can be ignored.

[Ntalia]

Wow, You're the best! it works! thanks a lot again and have a wonderful day

[gmc]

You're welcome... please mark the item as solved.
(Click on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.)