I have drupal 6.3 installed. It was installed many months ago and was working perfectly fine until last week. I got this message when clicking through the links:

Warning: Table 'sessions' is marked as crashed and should be repaired query: DELETE FROM sessions WHERE timestamp < 1239610461 in /usr/www/users/depic2/includes/database.mysqli.inc on line 128

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/depic2/includes/database.mysqli.inc:128) in /usr/www/users/depic2/includes/bootstrap.inc on line 582

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/depic2/includes/database.mysqli.inc:128) in /usr/www/users/depic2/includes/bootstrap.inc on line 583

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/depic2/includes/database.mysqli.inc:128) in /usr/www/users/depic2/includes/bootstrap.inc on line 584

Warning: Cannot modify header information - headers already sent by (output started at /usr/www/users/depic2/includes/database.mysqli.inc:128) in /usr/www/users/depic2/includes/bootstrap.inc on line 585

But the messages disappear when I refresh the page. Do I need to update anything?

Thanks,

Ashish

Comments

agsparta’s picture

Please.

agsparta’s picture

This is line 128:

trigger_error(check_plain(mysqli_error($active_db) ."\nquery: ". $query), E_USER_WARNING);

Do you see any errors on the code. I don't see any.

agsparta’s picture

Hi,

Lines from bootstraps that are causing the warnings are:

function drupal_page_header() {
header("Expires: Sun, 19 Nov 1978 05:00:00 GMT");
header("Last-Modified: ". gmdate("D, d M Y H:i:s") ." GMT");
header("Cache-Control: store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", FALSE);
}

VM’s picture

A) you shoud be using Drupal 6.10. You are 7 security and bug fix releases behind.

B) you can try to repair the table using phpmyadmin. The headers issue could be because a core file was altered leaving white space before or after a php tag. Considering you are are using drupal 6.3 it is possible a file or two were altered in some way or that a XSS exploit was used.

I'd try to repair the table using phpmyadmin
I'd check all my files and folders or immediately upgrade my installation.
I'd change all passwords es: database, admin account, FTP and so on.

agsparta’s picture

Thanks! I think we will upgrade drupal to 6.10.