Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
after activation ms_core the session table is not modified and these messages are shown:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT NULL' at line 1 query: ALTER TABLE sessions ADD `ssid` DEFAULT NULL in C:\xampp\htdocs\drupal\includes\database.mysql-common.inc on line 306.
user warning: Key column 'ssid' doesn't exist in table query: ALTER TABLE sessions ADD INDEX ssid (ssid) in C:\xampp\htdocs\drupal\includes\database.mysql-common.inc on line 442.
Comments
Comment #1
mgzrobles CreditAttribution: mgzrobles commentedthe same issue
Comment #2
Baroch Oren CreditAttribution: Baroch Oren commentedSPOILER: I went about 2 hours on this, and it still doesn't work.
Not exactly a patch, more like a workaround. The scheme trick at
mixed_session/modules/ms_core.install
did not do the trick, and so I kind of decoded what the author wanted to do, and wrote it down directly into the mysql client (mysql -u username -p
followed by your password, thenconnect my_db_name
and then:)The
mixed_session_core-6-24.patch
, the latest appearing currently on http://drupalcode.org/project/mixed_session.git/tree/refs/heads/6.x-1.x:..., patched without any errors Drupal core 6.26 which is what I use.BUT! After enabling the mixed_session module, I could never get back to my admin pages. They all claimed to be inaccessible. So I guess something went wrong.
The nice advice on the README.txt, to
drush dis mixed_session
and to addto my
settings.php
, did not fix the fact, that every time after logging in and going to www.example.com/admin, I got "unauthorized" and got kicked out of my session.Luckly I backed up my public_html directory, and so got me back my old bootstrap.inc and session.inc - this got me back to a working condition, without mixed_session, of course.
Hopes this info helps someone, I've wasted about 2 hours on this :-)
Happy New Jewish Year,
Comment #3
solotandem CreditAttribution: solotandem commented@Baroch, are you by chance working on Windows as @ferrum?
Can you provide any feedback on why the database changes failed?