Changeset 2449 in subversion

Timestamp:

May 2, 2009 4:11:45 PM (4 years ago)

Author:

alec

Message:

• some hints to use sqlite db (#1485821)

Location:

trunk/roundcubemail

Files:

• INSTALL (modified) (1 diff)
• installer/config.php (modified) (1 diff)
• program/include/rcube_mdb2.php (modified) (1 diff)

trunk/roundcubemail/INSTALL

@@ -71 +71 @@
 * SQLite
 --------
-Sqlite requires specifically php5 (sqlite in php4 currently doesn't
-work with roundcube), and you need sqlite 2 (preferably 2.8) to setup
-the sqlite db (sqlite 3.x also doesn't work at the moment). Here is
+You need sqlite 2 (preferably 2.8) to setup the sqlite db 
+(sqlite 3.x also doesn't work at the moment). Here is
 an example how you can setup the sqlite.db for roundcube:
 

trunk/roundcubemail/installer/config.php

@@ -270 +270 @@
 echo '<label for="cfgdbhost">Database server (omit for sqlite)</label><br />';
 echo $input_dbname->show($RCI->is_post ? $_POST['_dbname'] : $dsnw['database']);
-echo '<label for="cfgdbname">Database name</label><br />';
+echo '<label for="cfgdbname">Database name (use a path and filename for sqlite)</label><br />';
 echo $input_dbuser->show($RCI->is_post ? $_POST['_dbuser'] : $dsnw['username']);
 echo '<label for="cfgdbuser">Database user name (needs write permissions)(omit for sqlite)</label><br />';

trunk/roundcubemail/program/include/rcube_mdb2.php

@@ -586 +586 @@
 
     if (strlen($data))
-      sqlite_exec($dbh->connection, $data);
+      if (!sqlite_exec($dbh->connection, $data, $error) || MDB2::isError($dbh)) 
+        raise_error(array('code' => 500, 'type' => 'db',
+            'line' => __LINE__, 'file' => __FILE__, 'message' => $error), TRUE, FALSE); 
     }