Aw: update from j1.5.26 & js2.5.3 to j3.1 & js 4.x
a quick guide about how to update from Joomla 1.5 and jshopping 2.x to joomla 3.1 and jshopping 4.x
I have to upgrade a series of old jshopping, so I wrote a procedure, may be it will be usefull...
** you need:
1.
the starting j1.5 & jshopping 2.x working installation
2.
a j2.5 new & clean installation. without nothing installed: you need it only to upgrade jshopping
3.
the final j3.1 working installation, with j1.5 data migrated, especially users & groups, but WITHOUT jshopping
4.
upgrade packages from:
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/updates.html?lang=en
5.
old distribution packages from:
http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/downloads/archive.html?lang=en
** the procedure:
Please pay a LOT OF ATTENTION when you have to drop db tables!!
1.
back up J1.5 installation. (mysql dump, /components/com_jshoppinghopping/files & /components/com_jshoppinghopping/templates directories)
2.
install all upgrade packages from your jshopping version to jshopping 2.9.7
3.
save #__jshopping_* tables from j1.5 database
NOTE: '#_' is the joomla prefix for the db tables (in old joomla it is jos_ )
4.
install jshopping3.2.7 on j2.5
5.
drop #__jshopping_* tables from j2.5 database
6.
import #__jshopping_* previously saved tables from j1.5 database
7.
install all upgrade packages from your jshopping 3.2.7 version to jshopping 3.14.3
(really you have to install only the packages with a sql file, because you need the db, not a working j2.5)
8.
install upgrade package from 3.14.3 to 4.2.2
9.
save #__jshopping_* tables from j2.5 database, now you can delete j2.5 installation
10.
install jshopping4.2.2 on j3.1
11.
drop #__jshopping_* tables from j3.1 database
13.
import #__jshopping_* previously saved tables from j2.5 database
14.
upgrade from jshopping4.2.2 to last 4.x release
15.
move or copy /components/com_jshoppinghopping/files from j1.5 installation to the j3.1 one.
16.
final check: user association.
run this query on both j1.5 and j3.1 databases. the returned recordset must match
SELECT js.`user_id`, js.`u_name` FROM `#__jshopping_users` js
LEFT OUTER JOIN `#__users`jm ON js.`user_id` = jm.`id`
WHERE jm.`id` IS NULL
(better if an empty recordset ;) )
that's all folks!
greetings from Italy,
marco
Last change: 12.10.2013 09:55