Fix for sqlite and session problems
Adhamh Findlay
pmi at adhamh.com
Sun Oct 30 19:03:51 CET 2005
So the session table isn't being created when you use sqlite as the database
type. This patch fixes the problem and allows successful login.
--- sqlite.initial.sql.orig 2005-10-30 09:54:13.000000000 -0800
+++ sqlite.initial.sql 2005-10-30 09:08:17.000000000 -0800
@@ -78,3 +78,19 @@
language varchar(5) NOT NULL default 'en',
preferences text NOT NULL default ''
);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table sessions
+--
+
+
+CREATE TABLE session (
+ sess_id varchar(32) NOT NULL default '',
+ created datetime NOT NULL default '0000-00-00 00:00:00',
+ changed datetime NOT NULL default '0000-00-00 00:00:00',
+ ip VARCHAR(15) NOT NULL default '',
+ vars text NOT NULL,
+ PRIMARY KEY (sess_id)
+)
Adhamh
More information about the Dev
mailing list