coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: magnum on December 05, 2006, 09:45:33 AM

Title: Error while accessing the database
Post by: magnum on December 05, 2006, 09:45:33 AM
Hi all,

since this morning there is an error in our gallery, when we try to load it.

The SQL-Statement:

While executing query "SELECT * FROM cpg149_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8" on 0

mySQL error:


I've found some solutions in this forum, but we have the problem, that there is no further description after the 'mySQL error'

How can we find out, what happens ?

Thanks
Title: Re: Error while accessing the database
Post by: lamama on December 05, 2006, 10:08:28 AM
If you have access to the server logs, look there. Errors sometimes are surpressed for screen output.
Otherwise I would suggest to ask your webhost.
Title: Re: Error while accessing the database
Post by: magnum on December 05, 2006, 10:13:03 AM
Thanks for your quick answer.

What server logs do you mean ?
Because it is shared web hosting, we only have access to the Web-Logs (of the Apache server). Other logs are not available for customers.

Maybe i have to ask the webhoster....
Title: Re: Error while accessing the database
Post by: magnum on December 05, 2006, 11:49:55 AM
Well, here is another infomation, maybe helpful:

I can't access the main page, but the pictures will be displayed if i select ' newest comments', 'newest uploaded', 'most seen'.

If a picture is selected, the complete album list of the user is accessible, also all other pictures.

It seems to be a problem with display of the main page
Title: Re: Error while accessing the database
Post by: magnum on December 05, 2006, 11:51:40 AM
sorry, something forgotten:

The access to all albums is fine, the only problem is the direct access to any category. Maybe this is helpful.
Title: Re: Error while accessing the database
Post by: magnum on December 05, 2006, 05:06:08 PM
Hi all,

i have tried to repair the database/tables via phpmyadmin. But everything seems to be fine, there are no errors in the database.

Any other idea ?

Greetings Uwe
Title: Re: Error while accessing the database
Post by: Nibbler on December 05, 2006, 05:41:31 PM
Disable the random block in config.
Title: Re: Error while accessing the database
Post by: magnum on December 05, 2006, 06:18:19 PM
Quote from: Nibbler on December 05, 2006, 05:41:31 PM
Disable the random block in config.
Yeah !!!

That works.

Thank you very much.

could you explain me, why the problem occurs, after the gallery runs well for a couple of months ?

greetings Uwe