I use trunk version (few days age), when i want to create the "Display Name" and "Email Address" then save it, roundcube show the error page like this:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [500]
Please help, and thank you.
List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 15.10.2010 17:14, John Wong wrote:
SERVICE CURRENTLY NOT AVAILABLE!Error No. [500]
what's in logs?????!!!!!!
On Fri, 15 Oct 2010 17:48:44 +0200, A.L.E.C wrote:
On 15.10.2010 17:14, John Wong wrote:
SERVICE CURRENTLY NOT AVAILABLE!Error No. [500]
what's in logs?????!!!!!!
In apache log:
File does not exist: /httpd/roundcube/skins/default/.css _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 15.10.2010 17:54, johnw wrote:
In apache log:
File does not exist: /httpd/roundcube/skins/default/.css
This is interesting, but probably not related, check Roundcube logs.
On Fri, 15 Oct 2010 18:21:18 +0200, A.L.E.C wrote:
On 15.10.2010 17:54, johnw wrote:
In apache log:
File does not exist: /httpd/roundcube/skins/default/.css
This is interesting, but probably not related, check Roundcube logs.
[16-Oct-2010 00:28:57 +0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e4e95283b24f14fd0ebe0875fbd0fff067890fd1] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list'] in /httpd/roundcubemail/program/include/rcube_mdb2.php on line 268 (POST /webmail/?_task=settings&_action=save-identity) _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Fri, 15 Oct 2010 18:21:18 +0200, A.L.E.C wrote:
On 15.10.2010 17:54, johnw wrote:
In apache log:
File does not exist: /httpd/roundcube/skins/default/.css
This is interesting, but probably not related, check Roundcube logs.
[16-Oct-2010 00:28:57] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e4e95283b24f14fd0ebe0875fbd0fff067890fd1] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list']
[16-Oct-2010 00:28:57 +0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e4e95283b24f14fd0ebe0875fbd0fff067890fd1] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list'] in /httpd/roundcubemail/program/include/rcube_mdb2.php on line 268 (POST /webmail/?_task=settings&_action=save-identity) _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 15.10.2010 18:33, johnw wrote:
[16-Oct-2010 00:28:57] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e4e95283b24f14fd0ebe0875fbd0fff067890fd1] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list']
You didn't make properly the upgrade of database structure.
On Fri, 15 Oct 2010 18:35:29 +0200, A.L.E.C wrote:
On 15.10.2010 18:33, johnw wrote:
[16-Oct-2010 00:28:57] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e4e95283b24f14fd0ebe0875fbd0fff067890fd1] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list']
You didn't make properly the upgrade of database structure.
Ok, thank you. but when i run SQL/mysql.upgrade.sql as root, it show the error like this:
root#: mysql roundcubedb < mysql.upgrade.sql ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that column/key exists
What shall i do now?
List info: http://lists.roundcube.net/dev/ BT/aba52c80
Hi,
but when i run SQL/mysql.upgrade.sql as root, it show the error like this:
root#: mysql roundcubedb < mysql.upgrade.sql ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that column/key exists
What shall i do now?
I've ran into the same error just like you. You shouldn't import the whole contents of the mysql.update.sql file, but only the sections which are relevant to you. See the comment statements in the file:
# grep -e "^--" mysql.update.sql -- RoundCube Webmail update script for MySQL databases -- Updates from version 0.1-stable -- Updates from version 0.1.1 -- Updates from version 0.2-alpha -- Updates from version 0.2-beta (InnoDB required) -- Updates from version 0.3-stable -- Updates from version 0.3.1 -- Updates from version 0.4-beta #
Regards, Viktor
On 10/15/2010 06:56 PM, Viktor Balogh wrote:
# grep -e "^--" mysql.update.sql -- RoundCube Webmail update script for MySQL databases -- Updates from version 0.1-stable -- Updates from version 0.1.1 -- Updates from version 0.2-alpha -- Updates from version 0.2-beta (InnoDB required) -- Updates from version 0.3-stable -- Updates from version 0.3.1 -- Updates from version 0.4-beta
and/or use "mysql -f" to continue on errors.
but this could be a little dangerous too ;)
cheers, raoul
On Fri, 15 Oct 2010 17:56:12 +0100, Viktor Balogh wrote:
Hi,
but when i run SQL/mysql.upgrade.sql as root, it show the error like this:
root#: mysql roundcubedb < mysql.upgrade.sql ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that column/key exists
What shall i do now?
I've ran into the same error just like you. You shouldn't import the whole contents of the mysql.update.sql file, but only the sections which are relevant to you. See the comment statements in the file:
# grep -e "^--" mysql.update.sql -- RoundCube Webmail update script for MySQL databases -- Updates from version 0.1-stable -- Updates from version 0.1.1 -- Updates from version 0.2-alpha -- Updates from version 0.2-beta (InnoDB required) -- Updates from version 0.3-stable -- Updates from version 0.3.1 -- Updates from version 0.4-beta #
Regards, Viktor
Yes, i cut down the upgrade script to only have 0.4-beta to below. i can run the mysql.upgrade.sql script now. no any error.
but i still can not save the "Display Name", and the error message still like before.
List info: http://lists.roundcube.net/dev/ BT/aba52c80
Hi,
If you've imported the whole file earlier, it won't help to import the trimmed version on top of the modified database. I would recommend either to start from scratch and re-create the structure, or manually poke with the tables and types to have a working config. I can recommend the phpMyAdmin software for that. And you can look after how a valid structure looks like in the mysql.initial.sql file. And, in advance, take a full dump of your database. (I have chosen the second method and manually repaired the db.)
@to the devs: I don't know how many people suffers from this kind of problem, but I would recommend to keep the sql files for each version separate. This would ensure a flawless 5sec install/upgrade, just as with e.g. the wordpress engine.
Regards, Viktor
On Sat, 16 Oct 2010 01:01:40 +0800, johnw johnw@wonghome.net wrote:
Yes, i cut down the upgrade script to only have 0.4-beta to below. i can run the mysql.upgrade.sql script now. no any error.
but i still can not save the "Display Name", and the error message still like before.
On Fri, 15 Oct 2010 23:14:10 +0800, John Wong wrote:
I use trunk version (few days age), when i want to create the "Display Name" and "Email Address" then save it, roundcube show the error page like this:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [500]
Please help, and thank you.
I use mysqldump -F --opt roundcubemail > roundcubemail.sql to backup the mysql db. then drop all the tables in roundcubemail db. then run mysql < /roundcube/SQL/mysql.initial.sql. then run mysql roundcubemai < roundcubemail.sql.
all command run just fine. but i still can not save the "Display Name" and "Email Address" setting. and the error page still like before.
Is it a bug(s)? no one had this problem? only me? please help and thank you. _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 2010-10-15 22:52 UTC Viktor Balogh wrote:
@to the devs: I don't know how many people suffers from this kind of problem, but I would recommend to keep the sql files for each version separate. This would ensure a flawless 5sec install/upgrade, just as with e.g. the wordpress engine.
+1
The current upgrade process is not user/admin friendly.
On Fri, 15 Oct 2010 23:14:10 +0800, John Wong wrote:
I use trunk version (few days age), when i want to create the "Display Name" and "Email Address" then save it, roundcube show the error page like this:
SERVICE CURRENTLY NOT AVAILABLE!
Error No. [500]
Please help, and thank you.
No one have this problem? only me. Please help and thank you. _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 10/18/2010 01:53 PM, johnw wrote:
No one have this problem? only me. Please help and thank you.
please repost the error message from the logs.
thanks, raoul
On 10/16/2010 12:52 AM, Viktor Balogh wrote:
... the phpMyAdmin software for that. And you can look after how a valid structure looks like in the mysql.initial.sql file. And, in advance, take a full dump of your database. (I have chosen the second method and manually repaired the db.)
please make sure you secure your phpmyadmin install. especially zEmU seems to be a PITA [1][2]
@to the devs: I don't know how many people suffers from this kind of problem, but I would recommend to keep the sql files for each version separate. This would ensure a flawless 5sec install/upgrade, just as with e.g. the wordpress engine.
i recommend someting like "compare db to current layout" or "compare db to xyz.initial.sql". typo3 offers this during the upgrade processes.
cheers, raoul
[1] http://webhostingproblems.net/web-hosting-issues/hosting-security-issues/zme... [2] http://linux.m2osw.com/zmeu-attack
Hello,
please make sure you secure your phpmyadmin install. especially zEmU seems to be a PITA [1][2]
The phpmyadmin files are stored in the apache server root only when I (rarely) must edit the database by hand, for some minutes. Otherwise, all the data is moved to a non-published filesystem. But thanks for the alert. ;)
i recommend someting like "compare db to current layout" or "compare db to xyz.initial.sql". typo3 offers this during the upgrade processes.
it's a good idea.
Regards, Viktor
On Tue, 19 Oct 2010 09:22:56 +0200, Raoul Bhatia [IPAX] wrote:
On 10/18/2010 01:53 PM, johnw wrote:
No one have this problem? only me. Please help and thank you.
please repost the error message from the logs.
thanks, raoul
[19-Oct-2010 22:45:36] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e215a59789b633f24647b313a960c2930a335e8c] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list']
[19-Oct-2010 22:45:36 +0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e215a59789b633f24647b313a960c2930a335e8c] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list'] in /httpd/roundcubemail/program/include/rcube_mdb2.php on line 268 (POST /webmail/?_task=settings&_action=save-identity)
Please help and thank you. _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On 19.10.2010 16:47, johnw wrote:
[19-Oct-2010 22:45:36] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e215a59789b633f24647b313a960c2930a335e8c] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list']
[19-Oct-2010 22:45:36 +0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_mysqli_2e215a59789b633f24647b313a960c2930a335e8c] [Native code: 1054] [Native message: Unknown column 'changed' in 'field list'] in /httpd/roundcubemail/program/include/rcube_mdb2.php on line 268 (POST /webmail/?_task=settings&_action=save-identity)
searching the mysql.update.sql script:
$ grep -i changed mysql.update.sql ADD INDEX
changed_index(changed); ALTER TABLEidentitiesADDchangeddatetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTERuser_id;changeddatetime NOT NULL DEFAULT '1000-01-01 00:00:00',
most probably, you exported your roundcube database *including* "drop table if exists" commands. thus, your dumpfile will recreate the hole database and restore the backup as it was at the time of the export.
please use the "-f" switch and re-apply the mysql.update.sql script (already pointed out a couple of days ago)
please post the output to the list
thanks, raoul _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
On Tue, 19 Oct 2010 22:37:54 +0200, Raoul Bhatia [IPAX] wrote:
please use the "-f" switch and re-apply the mysql.update.sql script (already pointed out a couple of days ago)
please post the output to the list
thanks, raoul
Yeah, it work now (-f), thank you.
root#: mysql -f roundcubedb < SQL/mysql.upgrade.sql _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/aba52c80
-
A.L.E.C -
John Wong -
johnw
-
Patrick Nagel -
Raoul Bhatia [IPAX] -
Viktor Balogh