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