By demon326@drupal.org on

Hello everybody, to start, i love drupal very much! but now where having problems, we have a little band database with cck and view, now my account is getting suspende although i have the band database for monhts without any problem.

this is a part of the crashing query:
"SELECT DISTINCT LEFT( UPPER( node.title ) , 1 ) FROM node node LEFT JOIN content_field_genre node_data_f"

i realy dont know what to do now, i never had any problems untill last friday.., the only things that changed ar core updates and module updates..

⋅ Categories: Drupal 5.x

Comments

cog.rusty’s picture

cog.rusty commented

Sometimes database tables get corrupted and need repair using phpmyadmin. In one case someone needed to drop the cache tables and the locale tables and to create them again.

demon326@drupal.org’s picture

demon326@drupal.org commented

So youre saying that the tables ar corrupt?..

cog.rusty’s picture

cog.rusty commented

How could I know? It is just something that has happened before.

demon326@drupal.org’s picture

demon326@drupal.org commented

dunno, after searching on google it seems that the alpha pager module is the fucked up one :(

minesota’s picture

minesota commented

Did you install or manipulate anything new after last friday ?

Does uninstalling that "alpha pager" module solves the problem ?

Does your webhost or can they install APC ( see http://2bits.com/articles/php-op-code-caches-accelerators-a-must-for-a-l... ) ?

I have a shared hosting account which does fairly well with two drupal installations one of which is active more, while a test drupal site at a VPS ( low end ) shuts down apache with only one admin user doing some admin jobs. Server configs seem to play a great part, even some webhosts make certain changes, non-apparent to us, which can cause performance hits.

demon326@drupal.org’s picture

demon326@drupal.org commented

we did not change anything appart from the core and modules update.., and they dont have that thing and wont install it...