Error while accessing the database

[magnum]

Hi all,

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

The SQL-Statement:

Code Select Expand

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

[lamama]

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.

[magnum]

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....

[magnum]

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

[magnum]

sorry, something forgotten:

The access to all albums is fine, the only problem is the direct access to any category. Maybe this is helpful.

[magnum]

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

[Nibbler]

Disable the random block in config.

[magnum]

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