error in installing ms_core [#1553350]

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 commented 2 May 2012 at 15:35

the same issue

Comment #2

Baroch Oren CreditAttribution: Baroch Oren commented 12 September 2012 at 21:33

SPOILER: 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, then connect my_db_name and then:)

ALTER TABLE sessions ADD ssid   varchar(64) NOT NULL DEFAULT '';
ALTER TABLE sessions ADD INDEX ssid (ssid);

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.

patching file includes/bootstrap.inc
patching file includes/session.inc

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 add

    $conf['mixed_session_redirect_rule'] = 0;

to 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,