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.

-------------------
Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living.

Omar N. Bradley

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.

-------------------
Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living.

Omar N. Bradley

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);
}

-------------------
Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living.

Omar N. Bradley

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.

-------------------
Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living.

Omar N. Bradley