Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can't edit identities #1471

Closed
rcubetrac opened this issue Apr 2, 2008 · 16 comments
Closed

Can't edit identities #1471

rcubetrac opened this issue Apr 2, 2008 · 16 comments
Assignees
Milestone

Comments

@rcubetrac
Copy link

@rcubetrac rcubetrac commented Apr 2, 2008

Reported by brunoqc on 2 Apr 2008 15:56 UTC as Trac ticket #1484954

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

"SERVICE CURRENTLY NOT AVAILABLE!

Error No. [11:42:58 -0400](0x01F4]"

log:

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

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

Migrated-From: http://trac.roundcube.net/ticket/1484954

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented Apr 2, 2008

Comment by @till on 2 Apr 2008 21:40 UTC

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

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented Apr 2, 2008

Status changed by @till on 2 Apr 2008 21:40 UTC

new => assigned

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented Apr 2, 2008

Owner changed by @till on 2 Apr 2008 21:40 UTC

=> till

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented Apr 3, 2008

Comment by brunoqc on 3 Apr 2008 01:21 UTC

Yes sorry.

SQLite-2.8.17

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented Apr 8, 2008

Comment by tadw on 8 Apr 2008 19:24 UTC

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

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

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

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented Apr 30, 2008

Comment by ajacoutot on 30 Apr 2008 12:12 UTC

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.

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 4, 2008

Comment by brunoqc on 4 May 2008 18:08 UTC

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.

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 9, 2008

Comment by simonoff on 9 May 2008 09:25 UTC

Ok! I'm find warkaround!
Disable imap caching:
$rcmail_config['enable_caching'] = FALSE;

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 9, 2008

Comment by brunoqc on 9 May 2008 14:22 UTC

Replying to simonoff:

Ok! I'm find warkaround!
Disable imap caching:
$rcmail_config[= FALSE;

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

$rcmail_config['enable_caching']('enable_caching']) = FALSE;

in main.inc.php

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 9, 2008

Comment by tadw on 9 May 2008 22:09 UTC

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

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 10, 2008

Comment by koshua on 10 May 2008 01:40 UTC

Similarly, unable to edit a contact here:

01:26:39 +0000 DB Error: _skipDelimitedStrings: message: query with an unterminated text string specified
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@example.com', "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.

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 10, 2008

Comment by koshua on 10 May 2008 01:42 UTC

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
@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 10, 2008

Comment by @alecpl on 10 May 2008 20:12 UTC

It was MDB2 package bug. Fixed in d1403fd.

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 10, 2008

Status changed by @alecpl on 10 May 2008 20:12 UTC

assigned => closed

@rcubetrac
Copy link
Author

@rcubetrac rcubetrac commented May 10, 2008

Milestone changed by @alecpl on 10 May 2008 20:12 UTC

later => 0.1.2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants