Ticket #1484954 (closed Bugs: fixed)

Opened 8 months ago

Last modified 7 months ago

Can't edit identities

Reported by: brunoqc Owned by: till
Priority: 5 Milestone: 0.2-alpha
Component: Database Version: svn-trunk
Severity: normal Keywords:
Cc:

Description

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

Change History

  Changed 8 months ago by till

  • owner set to till
  • status changed from new to assigned

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

  Changed 8 months ago by brunoqc

Yes sorry.

SQLite-2.8.17

  Changed 8 months ago by 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

follow-up: ↓ 5   Changed 7 months ago by 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.

in reply to: ↑ 4   Changed 7 months ago by 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.

  Changed 7 months ago by 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

in reply to: ↑ description ; follow-up: ↓ 8   Changed 7 months ago by simonoff

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

in reply to: ↑ 7   Changed 7 months ago by 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

  Changed 7 months ago by tadw

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

follow-up: ↓ 11   Changed 7 months ago by 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.

in reply to: ↑ 10   Changed 7 months ago by 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

  Changed 7 months ago by alec

  • status changed from assigned to closed
  • resolution set to fixed
  • milestone changed from later to 0.1.2

It was MDB2 package bug. Fixed in r1352.

Note: See TracTickets for help on using tickets.