[platal.git] / upgrade / 1.1.2 / README

Check that the following queries return the same results before updating:
SELECT COUNT(*), COUNT(DISTINCT(pid)) FROM profile_name AS pn INNER JOIN profile_name_enum AS pne ON (pn.typeid = pne.id) WHERE pne.type = 'nickname';
SELECT COUNT(*), COUNT(DISTINCT(pid)) FROM profile_name AS pn INNER JOIN profile_name_enum AS pne ON (pn.typeid = pne.id) WHERE pne.type = 'name_other';
SELECT COUNT(*), COUNT(DISTINCT(pid)) FROM profile_name AS pn INNER JOIN profile_name_enum AS pne ON (pn.typeid = pne.id) WHERE pne.type = 'firstname_other';

Once all sql/php scripts have be run, run retrieve_address_tables.sh and finally xx_retrieve_geocoding.sql.
Then "./formatAddresses.php -g -t g -r e" will format the last ungeocoded addresses.

Additions to platal.conf:
[Maps]
api_version = "3.4" (depending on current version when releasing)
language = "fr"
Commit	Line	Data
0e1dfbad SJ	1	Check that the following queries return the same results before updating:
	2	SELECT COUNT(*), COUNT(DISTINCT(pid)) FROM profile_name AS pn INNER JOIN profile_name_enum AS pne ON (pn.typeid = pne.id) WHERE pne.type = 'nickname';
	3	SELECT COUNT(*), COUNT(DISTINCT(pid)) FROM profile_name AS pn INNER JOIN profile_name_enum AS pne ON (pn.typeid = pne.id) WHERE pne.type = 'name_other';
	4	SELECT COUNT(*), COUNT(DISTINCT(pid)) FROM profile_name AS pn INNER JOIN profile_name_enum AS pne ON (pn.typeid = pne.id) WHERE pne.type = 'firstname_other';
304cdf32	5
c7d784c5 SJ	6	Once all sql/php scripts have be run, run retrieve_address_tables.sh and finally xx_retrieve_geocoding.sql.
c7d784c5 SJ	7	Then "./formatAddresses.php -g -t g -r e" will format the last ungeocoded addresses.
559cef11 SJ	8
	9	Additions to platal.conf:
	10	[Maps]
	11	api_version = "3.4" (depending on current version when releasing)
	12	language = "fr"