Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Critical error  (Read 4621 times)

0 Members and 1 Guest are viewing this topic.

Ntalia

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Critical error
« on: January 02, 2014, 09:59:21 am »

Hello

my gallery - http://kanyewest.us/gallery/ showed today an error:
Quote
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:
Quote
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?
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Critical error
« Reply #1 on: January 02, 2014, 03:11:57 pm »

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

Ntalia

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Critical error
« Reply #2 on: January 02, 2014, 04:41:01 pm »

Thank You Greg.

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

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Critical error
« Reply #3 on: January 02, 2014, 05:32:38 pm »

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

Ntalia

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Critical error
« Reply #4 on: January 02, 2014, 05:39:54 pm »

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
Logged

Ntalia

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Critical error
« Reply #5 on: January 02, 2014, 05:46:00 pm »

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

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Critical error
« Reply #6 on: January 02, 2014, 06:18:13 pm »

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

Ntalia

  • Coppermine newbie
  • Offline Offline
  • Posts: 15
Re: Critical error
« Reply #7 on: January 02, 2014, 06:21:38 pm »

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

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Critical error
« Reply #8 on: January 02, 2014, 07:19:02 pm »

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

Page created in 0.02 seconds with 20 queries.