Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By dirkca on
I get this message. I am unable to log into website too. What would be a slolution
Warning: Can't open file: 'sessions.MYI'. (errno: 145) query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '754c3b09528a7dcc38cce3bb29899605' in /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/database.mysql.inc on line 167
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/database.mysql.inc:167) in /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/bootstrap.inc on line 811
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/database.mysql.inc:167) in /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/bootstrap.inc on line 488
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/database.mysql.inc:167) in /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/bootstrap.inc on line 489
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/database.mysql.inc:167) in /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/bootstrap.inc on line 490
Warning: Cannot modify header information - headers already sent by (output started at /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/database.mysql.inc:167) in /mounted-storage/home50a/sub002/sc34145-KIXI/cmags.org/includes/bootstrap.inc on line 491
Comments
Google might know
http://www.google.com/search?q=mysql+error+145
The first result sounds good.
--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal
I like to truncate the sessions table every couple of weekends
As the sessions table seems to get corrupted sorta frequently I just have taken to truncating it every couple of weekends.
+ Jeremy
solved
Host fixed it for me. Not sure what the problem was. Thanks for replying.
Solution
That error occurs if mysql file that stores table 'sessions' is corrupted (if the server hangs for example).
Solution:
- Delete table 'sessions'
- Restore table from a backup or as empty table from a new Drupal installation