Help !
My websites as crashed and it is a commercial website, this is an emmergency !

I have many errors suddently :

Warning: INSERT command denied to user 'lafeesbase'@'10.0.75.120' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:297:\"UPDATE command denied to user 'lafeesbase'@'10.0.75.120' for table 'sessions'\nquery: UPDATE sessions SET uid = 0, cache = 0, hostname = '89.226.242.250', session = '', timestamp = 1268308874 WHERE sid = '5fa741608c0d3c950f8337a4e3b3f7b4'\";s:5:\"%file\";s:49:\"/homez.323/lafees/www/drupal/includes/session.inc\";s:5:\"%line\";i:68;}', 3, '', 'http://www.la-fee.org/drupal/update.php?op=info', '', '89.226.242.250', 1 in /homez.323/lafees/www/drupal/includes/database.mysql.inc on line 128

user warning: UPDATE command denied to user 'lafeesbase'@'10.0.75.120' for table 'cache_menu' query: UPDATE cache_menu SET data = 'a:2:{s:4:\"tree\";a:14:{i:483;a:2:{s:4:\"link\";a:37:{s:14:\"load_functions\";N;s:16:\"to_arg_functions\";N;s:15:\"access_callback\";N;s:16:\"access_arguments\";N;s:13:\"page_callback\";N;s:14:\"page_arguments\";N;s:5:\"title\";N;s:14:\"title_callback\";N;s:15:\"title_arguments\";N;s:4:\"type\";N;s:11:\"description\";N;s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"483\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:7:\"\

I'm unable to log as user, when i try i hhave this error :

Warning: INSERT command denied to user 'lafeesbase'@'10.0.75.120' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:535:\"INSERT command denied to user 'lafeesbase'@'10.0.75.120' for table 'watchdog'\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'user', 'Session opened for %name.', 'a:1:{s:5:\\"%name\\";s:11:\\"lafee_admin\\";}', 5, '', 'http://www.la-fee.org/drupal/?q=user', 'http://www.la-fee.org/drupal/?q=user', '89.2 in /homez.323/lafees/www/drupal/includes/database.mysql.inc on line 128

Comments

hilrap’s picture

Im no drupal expert, but have you tried repairing your mysql database?

yelvington’s picture

The error is "insert command denied to user 'lafeesbase'@'10.0.75.120'." This is not a Drupal error. It is a MySQL error. Your problem is with your database permissions. If the account you are using for Drupal can't insert or update, Drupal can't do its job.

Loïs’s picture

But i had no probleme before, it appeared suddently. You mean that my SQL account gone wrong and so my SQL database suddently gone wrong ?

hilrap’s picture

Try log on to phpmyadmin and run repair mode over the subsequent tables... If it doesn't help perhaps speak to your provider for further assistance!

Loïs’s picture

Ok, i'll try to contact my provider when possible!
But someone knows what is watchdog, and chache_menu?
Can this error come from an application or something like a parameter?
Thanks a lot!

dallasmayor’s picture

Make sure you back every thing up now even though it's broken. That way you can get back to square one if need be, and it is probably fixable at this point. Notice I didn't make mention of last nights backup? Those errors sound like database errors, but actually they don't mean a thing because data access is far down the chain, so anything preceding can generate misleading errors. Look at your syslog to see if there were any systemwide errors. Look for very simple things that could have recently changed. Something as simple as a locale mismatch can cause apparently catastrophic symptoms of failure. Based on probability there is a simple solution so take a deep breath, and step through it logically.

Loïs’s picture

hi,
How can i backup when i can't acces to my admin in drupal ? I can't even look at my syslog? can i acces my syslog on my ftp servor?

wilgrace’s picture

Hi Lois, did you ever find the cause of this error? I'm getting exactly the same - I'm on Webfusion hosting, I wonder whether they've changed their configuration somehow...

TSE’s picture

- check free space on your webspace
- check if php save mode is set to off

fix this, and wait a while

Greetz TSE

shooo.xz’s picture

you have to clean your data base .. i cleaned up cache cache_form cache_menu .. btw it looks very wierd .. it seems cache is not productive ...