Re: Feedback on 2.0.0-rc1
Not all of the updates have been modified to include the prefix.
Have just run the database update on a 1.5.8 db and have the following in the install log
php 8.3.2
Database Engine: MySQL 8.0.35-0ubuntu0.22.04.1
Code:
---------------
Mar 09 2024 19:56 -- systemChecker::findCurrentDbVersion
1.5.8
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id WHERE c.countries_iso_code_3 = 'CHE'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
UPDATE zen_zones z INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Vorarlberg' WHERE c.countries_iso_code_3 = 'AUT' AND z.zone_code = 'VB'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Valle D\'Aosta' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'AO'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Barletta-Andria-Trani' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'BT'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Forlė-Cesena' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'FC'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'L\'Aquila' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'AQ'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Massa-Carrara' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'MS'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Pesaro E Urbino' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'PU'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id SET z.zone_name = 'Verbano-Cusio-Ossola' WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'VB'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'CI'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'VS'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'OG'; 1146: Table 'lotus_zc1.countries' doesn't exist
---------------
Mar 09 2024 19:57 -- upgradeException
INNER JOIN countries c ON z.zone_country_id = c.countries_id WHERE c.countries_iso_code_3 = 'ITA' AND z.zone_code = 'OT'; 1146: Table 'lotus_zc1.countries' doesn't exist
Mark Brittain
http:\\innerlightcrystals.co.uk\sales\
Bookmarks