aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-10-22 11:03:41 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-10-22 11:03:41 +0000
commitc04b4f17f123ceb078409630c13d57604827e6f5 (patch)
tree3b49826b302d33c2e60bb1b52115f6eb04ff15e8 /engine/schema
parentae2f3b28b11ef6b3b00c4e152851f95b179abf79 (diff)
downloadelgg-c04b4f17f123ceb078409630c13d57604827e6f5.tar.gz
elgg-c04b4f17f123ceb078409630c13d57604827e6f5.tar.bz2
Semi-working session code. Still won't permit logging in, commented out until there is time to fix.
Problem seems to be based around the action_gatekeeper() and the values set for the __elgg_session. Removing this component from the key causes the token to be valid. My feeling is that the session is not being saved or loaded correctly. git-svn-id: https://code.elgg.org/elgg/trunk@2291 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql6
-rw-r--r--engine/schema/upgrades/2008102101.sql6
2 files changed, 6 insertions, 6 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index f82a276d6..b0d86f629 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -275,11 +275,11 @@ CREATE TABLE `prefix_users_sessions` (
`id` int(11) NOT NULL auto_increment,
`session` varchar(255) NOT NULL,
`ts` int(11) unsigned NOT NULL default '0',
- `data` mediumtext,
+ `data` mediumblob,
PRIMARY KEY (`id`),
- KEY `session` (`session`),
- KEY `expires` (`expires`)
+ UNIQUE KEY `session` (`session`),
+ KEY `ts` (`ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- Datalists for things like db version
diff --git a/engine/schema/upgrades/2008102101.sql b/engine/schema/upgrades/2008102101.sql
index 815fa05de..d0c3d4cac 100644
--- a/engine/schema/upgrades/2008102101.sql
+++ b/engine/schema/upgrades/2008102101.sql
@@ -3,9 +3,9 @@ CREATE TABLE IF NOT EXISTS `prefix_users_sessions` (
`id` int(11) NOT NULL auto_increment,
`session` varchar(255) NOT NULL,
`ts` int(11) unsigned NOT NULL default '0',
- `data` mediumtext,
+ `data` mediumblob,
PRIMARY KEY (`id`),
- KEY `session` (`session`),
- KEY `expires` (`expires`)
+ UNIQUE KEY `session` (`session`),
+ KEY `ts` (`ts`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file