Hi,
I've been trying to upgrade from Modx Revo 2.25 to 2.27 and every time I go through the setup process I get the same error messages:
Error updating table for class modTemplateVarResource
Array
(
[0] => 42000
[1] => 1061
[2] => Duplicate key name 'tv_cnt'
)
Error updating table for class modResource
Array
(
[0] => 42000
[1] => 1061
[2] => Duplicate key name 'cache_refresh_idx'
)
The install failed because MODX could not unpack the <<site-path>>/core/packages/core.transport.zip package. Make sure that the <<site-path>>/core/packages/core.transport.zip file exists and is writable, and that you have made the <<site-path>>/core/packages/ directory writable.
It's really strange as I set the Permissions on the relevant folders / files to 777 just to get this working and STILL get the error!
For some reason the tick-box on the previous set up screen (Core Package has been manually unpacked) is untickable. I've managed to upgrade on a Linux shared server ok, but on my main site I can't get it to work at all.
The main site is running on an NGINX server with PHP 5.3.16 & Mysql 5.5.27. Up to REvo 2.25 I've not had an issue and been using this server for quite some time, couldn't upgrade to 2.26 and just thought it was an isolated issue with that version but still can't with 2.27 - any ideas anyone?