[SOLVED] Javascript Error - "upgradeModules"

[DJPhill]

Hi everyone,

 

Currently trying to upgrade my store from 1.4.3 - 1.5.5 using 1Clickupgrade module (latest 1.6.1)

Everything seems to go quite fast and then immediately after the database is updated, I get;

 

Javascript error (parseJSON) detected for action "upgradeModules".Starting restoration...

 

Anybody have any idea's what is causing this or how to fix it?

Any questions, please ask.

Any help will be much appreciated!

 

Thanks

Phill

Edited September 20, 2013 by DJPhill (see edit history)

[DJPhill]

Has anyone else come across this problem?

[DJPhill]

Just had another go with the latest 1-Click Upgrade but stil on the same problem....

 

Might try disabling all modules before trying again.

[DJPhill]

Nope! Still the same problem; disabled non native modules - didnt work. disabled all modules...still didnt work.

 

Anybody any ideas?

[DJPhill]

Just checked the error log of the upgrade module and it says;

 

PHP Warning:  mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'MYSQLUsername'@'localhost' (using password: YES) in .../public_html/modules/autoupgrade/db/MySQL.php on line 37

[DJPhill]

Ok, solved on my own.

Found the resolution by doing the manual upgrade (which I think is much better than the 1clickupgrade, as long as you've got your backups and a copy of your database close to hand).

 

Simply turned out to be a MYSQL user issue which I believe may have stemed from my host updating the CPanel and phpMyadmin. All I did was to give the database a new user with a new password, update my settings.ini.php file and everything seemed to work fine.

 

Other things to keep in mind I found were;

- If you copy the database within phpMyadmin, make sure you deselect 'AUTO_INCREMENT' and that the database collation is 'utf8_general_ci' (found out with the error 34 in manual upgrade),

- To cut down on update problems and errors, update to the latest minor release AND THEN the major release,

- Always, always, ALWAYS make sure you have the latest backup of your store and database. In CPanel this is really simple because you can do complete backups. PLUS in File Manager you can compress your files and phpMyAdmin you can copy your database, this way you can keep extracting your files and recopying your database should anything go wrong...alot faster.

 

If I think of any other things I came across, I will let you know.

For now....Peace out!

Edited September 20, 2013 by DJPhill (see edit history)