Can't edit identities

[brunoqc]

Adding or removing an identity work, but when i try to edit one it say:

"SERVICE CURRENTLY NOT AVAILABLE!

Error No. [0x01F4]"

log:

[02-Apr-2008 11:42:58 -0400] DB Error: _skipDelimitedStrings: [Error message: query with an unterminated text string specified]
[Last executed query: SELECT * FROM users WHERE  user_id='1']
[Native code: 0]
[Native message: not an error]
 in /roundcubemail/program/include/rcube_mdb2.inc on line 265

php5 5.2.5 with php5-sqlite 5.2.5
imap server : dovecot-1.0.13
OS : OpenBSD 4.3
Mozilla Firefox 2.0.0.13
Mozilla Firefox 3 Beta 4
Mozilla Firefox 3 Beta 5

[till]

Oh, wow. I'll investigate the issue. SQLite, right? (You probably would not have mentioned php5-sqlite otherwise.

[brunoqc]

Yes sorry.

SQLite-2.8.17

[tadw]

I confirm, I have the same problem here using Roundcube with Sqlite (occurred in 0.1.0 and 0.1.1).

[Native message: not an error]
 in /var/www/mail/round/program/include/rcube_mdb2.inc on line 265
[06-Apr-2008 12:02:19 +0200] DB Error: _skipDelimitedStrings: [Error message: query with an unterminated text string specified]
[Last executed query: SELECT * FROM users WHERE  user_id='1']

php5: 5.2.0-8+etch10
php5-sqlite: 5.2.0-8+etch10
sqlite: 2.8.17-2
os: debian 4.0 etch
roundcube: 0.1.1

[ajacoutot]

Same error here too with roundcube 0.1.1.
OpenBSD-4.3-current
php5-sqlite-5.2.5

Did aynone came up with a workaround or a fix yet? This is a very frustrating issue.

[brunoqc]

Replying to ajacoutot:

Did aynone came up with a workaround or a fix yet? This is a very frustrating issue.

Not me, sorry. I wish i had the time and skill to even try.

[simonoff]

I confirm, I have the same problem here using Roundcube 0.1.1, but with mysql:

In logs:
[08-May-2008 22:38:17 -0400] DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE MDB2_STATEMENT_mysql_14994162f001b07e7acc347a6ed79813e06ad5b47 FROM 'INSERT INTO messages\n (user_id, del, cache_key, created, idx, uid, subject, from, to, cc, date, size, headers, structure)\n VALUES (?, 0, ?, now(), ?, ?, ?, ?, ?, ?, FROM_UNIXTIME(), ?, ?, ?)']
[Native code: 1064]
[Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), ?, ?, ?)' at line 3]

in /srv/www/htdocs/webmail/program/include/rcube_mdb2.inc on line 265

[simonoff]

Ok! I'm find warkaround!
Disable imap caching:
$rcmail_configenable_caching? = FALSE;

[brunoqc]

Replying to simonoff:

Ok! I'm find warkaround!
Disable imap caching:
$rcmail_configenable_caching? = FALSE;

It don't work for me, I already had:

$rcmail_config['enable_caching'] = FALSE;

in main.inc.php

[tadw]

Ditto, no imap caching enabled here, and still the error. It's obviously an error in the sql statement passed to sqlite.

[koshua]

Similarly, unable to edit a contact here:

[10-May-2008 01:26:39 +0000] DB Error: _skipDelimitedStrings: [Error message: query with an unterminated text string specified]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_e315f893390512f38e71167d51c0dc4a5cb004952] in /var/www/roundcubemail-0.1/program/include/rcube_mdb2.inc on line 246

digging a little deeper, $query was:
UPDATE contacts

SET changed=now(), "name"='example', "email"='test@…', "firstname"=, "surname"=
WHERE contact_id=?
AND user_id=?
AND del<>1

Roundcube 0.1.1, PostgreSQL 8.1.11, PHP 5.2.0-8+etch10, Debian 4.0 (Etch), Apache 2.2.3, Dovecot 1.0.13.

[koshua]

Replying to koshua:
Sorry, that should've been:

UPDATE contacts
         SET    changed=now(), "name"='example', "email"='test@example.com', "firstname"='', "surname"=''
         WHERE  contact_id=?
         AND    user_id=?
         AND    del<>1

[alec]

It was MDB2 package bug. Fixed in [d1403fd7].