Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Critical error There was an error while processing a database query  (Read 1915 times)

0 Members and 1 Guest are viewing this topic.

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62

I hope this is the right category. Some time in the last week some of my coppermine galleries have decided to display
Quote
Critical error
There was an error while processing a database query

when going to the gallery and I can't seem to figure out why these couple and not others. Everything is the same host, same version, majority are the same coding for the theme and yet a couple are coming up with that error now.

In the past updating to the latest version has helped fix some issues and I noticed that 1.5.46 is out so I upgraded one [http://brytni-sarpy.com/gallery/] to that version, it has not fixed the issue. Instead now in addition to the processing error which still displays in admin mode I get

Quote
Template error
Failed to find block 'file_line' (#<!-- BEGIN file_line -->(.*?)<!-- END file_line -->#s) in :
                    <div class="{CSS_CLASS}">
                        <h2>{HEADER_TXT}</h2>
                        <span class="cpg_user_message">{MESSAGE}</span>


                        <br /><br />
                    </div>

but only on the homepage of the gallery, if I'm in admin mode from running update.php I see everything fine minus the processing error.

I've run debug mode manually and it is coming up with the following:

Quote
While executing query 'SELECT COUNT(*) FROM cpg15x_pictures WHERE approved = 'NO'' in include/functions.inc.php on line 2507

mySQL error: Table './brytni_gallery/cpg15x_pictures' is marked as crashed and should be repaired
Logged

BabeandJamie4Ever

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 62
Re: Critical error There was an error while processing a database query
« Reply #1 on: April 14, 2018, 08:24:32 pm »

It's solved, my host was able to repair the database on the sites affected and it's running again, the template error seems to be gone as well as a result.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 20 queries.