Hi, development versions do not have database upgrade (because this will be in conflict in Joomla! - it is still the same version), so:
DEVELOPMENT VERSIONS ONLY!!!
How to upgrade Phoca Cart - development version (example RC5 -> RC6)
1) Download the next version (if you run RC5, download RC6)
2) Install it in your Joomla! extension manager - all files will be updated, but not all tables and columns in database
3) Open the following file in your text editor: administrator/components/com_phocacart/install/sql/mysql/install.utf8.sql
4) In this file navigate to row:
Code: Select all
-- ---------
-- RC5 -> RC6
-- ---------
and copy everything below this code, stop before next update, e.g.
Code: Select all
-- ---------
-- RC6 -> RC7
-- ---------
5) This copied text paste to new file and with help of FIND and REPLACE function change:
FIND: "--" and REPLACE to "" (find all -- (these are comments) and replace them to nothing - comments will be uncommented
FIND: "#__" and REPLACE to "jos_" (for example - find the prefix and replace it to your database prefix - in your case: "#__" to "j5010t100_" or "j5010t100_jm".
You will find your prefix in your Global Configuration (Joomla! - Administration - System - Global Configuration - Tab Server - Database Settings):
6) Copy this modifed file and paste it to SQL field in e.g. phpMyAdmin which then will update the database
The same you can do for RC6 - RC7.
To make it faster, just copy all the queries listed below your old version (example: you run RC5, then copy everything below RC5 --> RC6), and:
1) Remove the comments above (all - RCx -> RCy) (it is necessary because such comments will be uncommented by step 2 in case you run REPLACE ALL)
Code: Select all
-- ---------
-- RC6 -> RC7
-- ---------
2) Remove all comments "--" at once
3) Change all prefixes "#__" to your prefixes