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:
the starting j1.5 & jshopping 2.x working installation
a j2.5 new & clean installation. without nothing installed: you need it only to upgrade jshopping
the final j3.1 working installation, with j1.5 data migrated, especially users & groups, but WITHOUT jshopping
upgrade packages from:
old distribution packages from:
** the procedure:
Please pay a LOT OF ATTENTION when you have to drop db tables!!
back up J1.5 installation. (mysql dump, /components/com_jshoppinghopping/files & /components/com_jshoppinghopping/templates directories)
install all upgrade packages from your jshopping version to jshopping 2.9.7
save #__jshopping_* tables from j1.5 database
NOTE: '#_' is the joomla prefix for the db tables (in old joomla it is jos_ )
install jshopping3.2.7 on j2.5
drop #__jshopping_* tables from j2.5 database
import #__jshopping_* previously saved tables from j1.5 database
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)
install upgrade package from 3.14.3 to 4.2.2
save #__jshopping_* tables from j2.5 database, now you can delete j2.5 installation
install jshopping4.2.2 on j3.1
drop #__jshopping_* tables from j3.1 database
import #__jshopping_* previously saved tables from j2.5 database
upgrade from jshopping4.2.2 to last 4.x release
move or copy /components/com_jshoppinghopping/files from j1.5 installation to the j3.1 one.
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,
Last change: 12.10.2013 09:55