Hi
On upgrading to roundcube 1.0.5 from 0.9.5 using installto.sh I got:
Executing database schema update. PHP Warning: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in Unknown on line 0 Updating database schema (2013042700)... [OK] Updating database schema (2013052500)... [OK] Updating database schema (2013061000)... [FAILED] ERROR: Error in DDL upgrade 2013061000: [7] ERROR: relation "cache_index" does not existAll done.
This is with a postgres database.
How can I fix this please?
Thanks
Roderick Johnstone
The current version 0.9.5 was obtained updating older. if so what? most likely you have not gone past the correct and update db scheme does not meet the standard of 0.9.5. please make sure compliance structures 0.9.5 standard if it differs correct. after can be upgraded. I suspect this file is applicable not correctly 2011092800.sql
On 20.02.2015 22:29, Roderick Johnstone wrote:
Hi
On upgrading to roundcube 1.0.5 from 0.9.5 using installto.sh I got:
Executing database schema update. PHP Warning: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in Unknown on line 0 Updating database schema (2013042700)... [OK] Updating database schema (2013052500)... [OK] Updating database schema (2013061000)... [FAILED] ERROR: Error in DDL upgrade 2013061000: [7] ERROR: relation "cache_index" does not existAll done.
This is with a postgres database.
How can I fix this please?
Thanks
Roderick Johnstone _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
Aleksey
Thanks for you reply.
On 24/02/15 06:04, Gavrilov Aleksey wrote:
The current version 0.9.5 was obtained updating older. if so what?
Yes, we have done several upgrades over the years. I've no recollection of which our first version was and which upgrades were done.
most likely you have not gone past the correct and update db scheme does not meet the standard of 0.9.5. please make sure compliance structures 0.9.5 standard if it differs correct. after can be upgraded.
How would I verify the structures in the database?
I suspect this file is applicable not correctly 2011092800.sql
So, I reran all of the database schema updates in the postgres directory and the 2013061000 and subsequent updates were executed without error, although there were some errors from the earlier updates.
May be this fixed things, or maybe it messed things up badly. How would I check?
Thanks
Roderick
On 20.02.2015 22:29, Roderick Johnstone wrote:
Hi
On upgrading to roundcube 1.0.5 from 0.9.5 using installto.sh I got:
Executing database schema update. PHP Warning: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in Unknown on line 0 Updating database schema (2013042700)... [OK] Updating database schema (2013052500)... [OK] Updating database schema (2013061000)... [FAILED] ERROR: Error in DDL upgrade 2013061000: [7] ERROR: relation "cache_index" does not existAll done.
This is with a postgres database.
How can I fix this please?
Thanks
Roderick Johnstone _______________________________________________ Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
--
Gavrilov Aleksej mailto:gavrilov@info74.ru
Roundcube Users mailing list users@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/users
On 25.02.2015 18:40, Roderick Johnstone wrote:
I recommend the correct structure in version 0.9.5, and then be updated
http://sourceforge.net/projects/roundcubemail/files/roundcubemail/0.9.5/roun... 3. compare the resulting file with a reference from the installer (diff ./scheme_0.9.5.sql ./roundcubemail-0.9.5/SQL/postgres.initial.sql) 4. Make changes the structure of the working copy of the database to check for degradation of the functional 5. Repeat steps 1,3,4 until the structure is not identical 6. try to update to version 1.0.5 or 1.1.0