Critical error Critical error
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Critical error

Started by Ntalia, January 02, 2014, 09:59:21 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Ntalia

Hello

my gallery - http://kanyewest.us/gallery/ showed today an error:
QuoteCritical 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:
QuoteI 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...
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

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!
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

Ntalia

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

Quote#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.
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

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.)
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money