Hello,
First I want to thanks and congratulate the team for the great job done in roundcube0.4.
I particularly appreciate the threaded view messages.
So I recently I updated my roundcube from 0.3-stable to 0.4
and I failed sending messages.
I posted here :
http://www.roundcubeforum.net/3-news-announcements/12-general-discussion/7103-cant-send-smtp-error-250-a.html
I can now send email nom not using smtp authentication. I mentioned the thread just in case the dev team didn't read this thread (cause i posted in the wrong section)
Today I go on giving my feedback to participate to improve this lovely tool roundcube.
One of my friend reported me a problem using my installed roundcube 0.4
he can't change his profile (identities signature).
I checked and agree.
May be I misconfigured something but in the 0.3-stable version all is working fine.
Logs tell :
[09-sept.-2010 20:45:32] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_33b125230978f97b6dce9d0eb240ec537306c83b6 FROM 'UPDATE identities SET changed = now(), `name` = ?, `email` = ?, `organization` = ?, `reply-to` = ?, `bcc` = ?, `standard` = ?, `signature` = ?, `html_signature` = ? WHERE identity_id = ? AND user_id = ? AND del <> 1']
[Native code: 1054]
[Native message: Unknown column 'changed' in 'field list']
[09-Sep-2010 20:45:32 +0200]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_33b125230978f97b6dce9d0eb240ec537306c83b6 FROM 'UPDATE identities SET changed = now(), `name` = ?, `email` = ?, `organization` = ?, `reply-to` = ?, `bcc` = ?, `standard` = ?, `signature` = ?, `html_signature` = ? WHERE identity_id = ? AND user_id = ? AND del <> 1']
[Native code: 1054]
[Native message: Unknown column 'changed' in 'field list']
in /var/wws/roundcubemail-0.4/program/include/rcube_mdb2.php on line 262 (POST /mail/?_task=settings&_action=save-identity)
Looks like the update SQL didn't run correctly, try updating manually.
Thank you skaero.
I've already update the identities mysql table manually to correct this point.
I wanted only show this misfunction for the dev team.
That's also why i repeat the smtp authentication bug.
Regards.
OK all is right.
I enabled the sql debug and watch logs.
I forgot to update my database from 0.3-stable to 0.4
Sorry for the noise, I should read the upgrade page carrefully.
May be a new feature in next releases : make an install directory which detect automatically the release and make the SQL upgrade at the first time login