Problem upgrading 0.7.1

[miky]

I'm having trouble while trying to upgrade Jaws 0.7.1, I have tryed to upgrade to 0.7.2, 0.8.0, 0.8.1.... until 0.8.9, the error message says:

MDB2 Error: not found : _doQuery: [Error message: Could not execute statement] [Last executed query: ALTER TABLE `mm_registry` ADD UNIQUE `mm_reg_key_name_idx` (`key_name`)] [Native code: 1072] [Native message: Key column 'key_name' doesn't exist in table]

Thanks for in advance for any clue that could help me upgrade.

[Gusse500]

It seems to be a DNS problem. Try to use 127.0.0.1 instead of localhost for the hostname.

[miky]

It isn't a DNS problem; it seems that I have different field names. Any ideas?

mysql> describe mm_registry;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(128) | YES | | NULL | |
| value | text | YES | | NULL | |
| updatetime | datetime | YES | | NULL | |
+------------+--------------+------+-----+---------+----------------+

[Gusse500]

I'm not sure witch metod you used to upgrade. I installed Jaws 0.7.0beta1 on my testserver. I upgrade to Jaws 0.8.9 with the following metod without problem.

1. Made a folder named oldinstall and moved every file in 0.7.0beta1 to this folder. The only file I left was config/JawsConfig.php.
2. Uploaded Jaws 0.8.9 complete.
3. In browser pointed to my_domain/upgrade.
4. Followed instructions.
5. In ControlPanel upgraded every old gadget.
6. In ControlPanel installed every new gadget.
7. Deleted oldinstall
8. Finished

Everything worked fine exept Banner. I had to change registry value gadgets -> Banner -> enabled to false and gadgets -> Banner -> version to 0.8.9 and back in ControlPanel install Banner.

If you have tried the upgrade with another procedure I suggest you try this one.

ATTENTION! IF YOU HAVE PICTURES OR FILES UPLOADED GET THEM BACK FROM OLDINSTALL BEFORE YOU DELETE.

[miky]

I was calling mydomain/upgrade.php as the UPGRADING file said without success, now I have tried as you told me (mydomain/upgrade) and it worked.

Thank you very much.

[Gusse500]

Happy that it worked!.