By cmrsf1 on

When logging into my site, I get the following error message:

Warning: Unknown column 's.sid' in 'where clause' query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = '1e6cdu8tpmlgdhiuqsc5i2upa1' in /hsphere/local/home3/cmrsf1/inter-connections.com/drupal/includes/database.mysqli.inc on line 128

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

Anyone have this problem before?

Thanks!

⋅ Categories: Drupal 6.x

Comments

Thomas Sewell’s picture

Thomas Sewell commented

Log into your DB (Using mysql or phpmyadmin) and first check that the sessions table does exist and has the sid column in it.

It may be that your DB has become damaged, or your DB settings are messed up.

I'm assuming you haven't upgraded code just before the issue started.

cmrsf1’s picture

cmrsf1 commented

Thanks, Thomas,
I crashed that install and started over with a 5.7 install so that I could install ubercart as well.

Thomas Sewell’s picture

Thomas Sewell commented

deleted