Adhamh Findlay wrote:
Could you post some more details?
I should first point out that I'm not running the latest one. My index.php says it is version 0.1-20051007.
What version of php are you using? Apache?
I'm using php 4.3.10-16 (debian stable) and php4-sqlite 1.0.2-7 (ditto). I don't use Apache; I'm using lighttpd 1.3.16 and running PHP as CGI. SQLite is 2.8.16 (debian stable).
What is the sqlite information from phpinfo()?
SQLite support => enabled PECL Module version => 1.0 $Id: sqlite.c,v 1.62.2.16 2004/01/17 00:29:37 edink E xp $ SQLite Library => 2.8.16 SQLite Encoding => UTF-8
Directive => Local Value => Master Value sqlite.assoc_case => 0 => 0
Could you post your config files? The db.inc.php
$rcmail_config['db_dsnw'] = 'sqlite://./temp/round.db?mode=0646';
and main.inc.php after
the only changes I made were: $rcmail_config['enable_caching'] = FALSE; $rcmail_config['default_host'] = 'localhost'; $rcmail_config['default_port'] = 143; $rcmail_config['timezone'] = -7;
Someone else asked me:
Did you disable caching because it was causing problems?
Caching was causing problems, yes. But I turned it off because I don't need it; my IMAP server and webmail server are on the same box. FWIW, I don't think caching should be on by default. I would be surprised if there are very many people running a pre-alpha webmail client in a high-volume tiered server setup.
I had to make a change to some file, I forget which now, because turning caching off didn't actually turn it all the way off. Perhaps this has been fixed in current sources, I don't know. It was resulting in an INSERT that sqlite didn't like.
-- Justus