1.1.0.2 Questions / Comments / Concerns / Feedback

[burt]

Welcome to v1.1.0.2

- solve some bugs in our Bootstrap 5 implementation
- transfers some pages from language files to the info_pages system
- deprecates redirect.php in favour of actions
- modals updated to the modal component for a unified display
- updates bootstrap to 5.3.5
- updates fontawesome to 6.7.2
- localizes the country list
- allows IPV6 IP addresses
- updates most language files to `const` rather than `define`
- updates a number of modules to use `config_key_base`
- installation procedure "forces" the user to rename the /admin/ directory


Added to Core

Pi Layout Module for "Products URL"
PI Layouts are now fully flexible (XS, SM, MD etc etc)

Thank You's for the help and advice in 1.1.0.2

@raiwa
@frankl
@artfulweb
@heatherbell
@radhavallabh
@bonbec

[burt]

Updated and New Files (structure), in code tags to retain format for easy reading.

Important Note:
1. Language files that have simply changed from `define` to `const` are NOT included in these update instructions.
2. Any language files included here have `more` than a simple change from `define` to `const`, eg new words or constants etc.

Code: Select all

│   README.md
│
├───admin
│   │   index.php
│   │   language_explorer.php
│   │
│   └───includes
│       ├───actions
│       │   ├───advert_manager
│       │   │   └───views
│       │   │           new.php
│       │   │
│       │   ├───outgoing
│       │   │   └───infoboxes
│       │   │           default.php
│       │   │
│       │   ├───outgoing_tpl
│       │   │   └───infoboxes
│       │   │           default.php
│       │   │
│       │   ├───stats_products_purchased
│       │   │   └───views
│       │   │           default.php
│       │   │
│       │   └───stats_products_viewed
│       │       └───views
│       │               default.php
│       │
│       └───languages
│           │   english.php
│           │
│           └───english
│                   index.php
│
├───includes
│   │   version.php
│   │
│   ├───actions
│   │       redirect_manufacturer.php
│   │
│   ├───hooks
│   │   └───admin
│   │       └───siteWide
│   │               bootStrap.php
│   │               fontAwesome.php
│   │               hMenu.php
│   │
│   ├───languages
│   │   │   english.php
│   │   │
│   │   └───english
│   │       │   conditions.php
│   │       │   cookie_usage.php
│   │       │   privacy.php
│   │       │   shipping.php
│   │       │   ssl_check.php
│   │       │
│   │       └───modules
│   │           ├───content
│   │           │   ├───footer_suffix
│   │           │   │       cm_footer_extra_icons.php
│   │           │   │
│   │           │   └───login
│   │           │           cm_login_form.php
│   │           │
│   │           ├───payment
│   │           │       stripe_sca.php
│   │           │
│   │           └───pi
│   │               └───product_info
│   │                       pi_url.php
│   │
│   ├───modules
│   │   ├───content
│   │   │   ├───account
│   │   │   │       cm_account_gdpr.php
│   │   │   │       cm_account_set_password.php
│   │   │   │       cm_account_stripe_sca_cards.php
│   │   │   │
│   │   │   ├───checkout_success
│   │   │   │       cm_cs_downloads.php
│   │   │   │       cm_cs_redirect_old_order.php
│   │   │   │
│   │   │   ├───contact_us
│   │   │   │   │   cm_cu_modular.php
│   │   │   │   │   cm_cu_title.php
│   │   │   │   │
│   │   │   │   └───templates
│   │   │   │           tpl_cm_cu_modular.php
│   │   │   │
│   │   │   ├───footer_suffix
│   │   │   │   └───templates
│   │   │   │           tpl_cm_footer_extra_icons.php
│   │   │   │
│   │   │   ├───index
│   │   │   │   │   cm_i_modular.php
│   │   │   │   │
│   │   │   │   └───templates
│   │   │   │           tpl_cm_i_modular.php
│   │   │   │
│   │   │   ├───info
│   │   │   │   │   cm_info_modular.php
│   │   │   │   │
│   │   │   │   └───templates
│   │   │   │           tpl_cm_info_modular.php
│   │   │   │
│   │   │   ├───login
│   │   │   │   └───templates
│   │   │   │           tpl_cm_login_form.php
│   │   │   │
│   │   │   ├───navigation
│   │   │   │       cm_navbar.php
│   │   │   │
│   │   │   ├───product_info
│   │   │   │   │   cm_pi_modular.php
│   │   │   │   │
│   │   │   │   └───templates
│   │   │   │           tpl_cm_pi_modular.php
│   │   │   │           tpl_cm_pi_reviews.php
│   │   │   │
│   │   │   └───testimonials
│   │   │           cm_t_write.php
│   │   │
│   │   ├───header_tags
│   │   │       ht_canonical.php
│   │   │       ht_category_seo.php
│   │   │       ht_manufacturer_seo.php
│   │   │       ht_outgoing.php
│   │   │       ht_pages_seo.php
│   │   │       ht_product_meta.php
│   │   │       ht_product_opengraph.php
│   │   │       ht_product_schema.php
│   │   │       ht_product_title.php
│   │   │       ht_robot_noindex.php
│   │   │       ht_table_click_jquery.php
│   │   │
│   │   ├───navbar
│   │   │   │   nb_account.php
│   │   │   │   nb_brand.php
│   │   │   │   nb_currencies.php
│   │   │   │   nb_hamburger_button.php
│   │   │   │   nb_home.php
│   │   │   │   nb_languages.php
│   │   │   │   nb_new_products.php
│   │   │   │   nb_search.php
│   │   │   │   nb_shopping_cart.php
│   │   │   │   nb_special_offers.php
│   │   │   │   nb_testimonials.php
│   │   │   │
│   │   │   └───templates
│   │   │           tpl_nb_account.php
│   │   │           tpl_nb_currencies.php
│   │   │           tpl_nb_languages.php
│   │   │
│   │   ├───order_total
│   │   │       ot_shipping.php
│   │   │       ot_subtotal.php
│   │   │       ot_tax.php
│   │   │       ot_total.php
│   │   │
│   │   ├───payment
│   │   │       cod.php
│   │   │       moneyorder.php
│   │   │       pm2checkout.php
│   │   │       stripe_sca.php
│   │   │
│   │   └───pi
│   │       ├───contact_us
│   │       │   │   cu_form.php
│   │       │   │   cu_text.php
│   │       │   │
│   │       │   └───templates
│   │       │           tpl_cu_form.php
│   │       │
│   │       └───product_info
│   │           │   pi_qty_input.php
│   │           │   pi_url.php
│   │           │
│   │           └───templates
│   │                   tpl_pi_url.php
│   │
│   └───system
│       └───versioned
│           ├───1.0.7.6
│           │       info_pages.php
│           │
│           ├───1.01.00.00
│           │       select.php
│           │
│           └───1.01.00.02
│                   modular.php
│                   product_builder.php
│                   request.php
│
├───install
│   │   phoenix.sql
│   │
│   ├───includes
│   │   └───translations
│   │       └───en
│   │               install_3.php
│   │
│   └───templates
│       │   main_page.php
│       │
│       └───pages
│               install_3.php
│               install_4.php
│
└───templates
    └───default
        ├───includes
        │   ├───components
        │   │       modal.php
        │   │
        │   ├───ext
        │   │   └───modules
        │   │       └───content
        │   │           └───account
        │   │                   nuke_account.php
        │   │                   set_password.php
        │   │
        │   ├───hooks
        │   │   └───shop
        │   │       ├───product_info
        │   │       │       gallery.php
        │   │       │
        │   │       └───siteWide
        │   │               bootStrap.php
        │   │               fontAwesome.php
        │   │               styleSheets.php
        │   │
        │   └───pages
        │           account_history.php
        │           advanced_search.php
        │           checkout_payment.php
        │           checkout_shipping.php
        │           cookie_usage.php
        │           ssl_check.php
        │
        └───static
                user.css

[burt]

Updating from 1.1.0.1 to 1.1.0.2 is simple.

PRE STEP. REQUIRED
Make a backup copy of your current Phoenix (as it stands) and current Database (as it stands) so that you can easily rollback if things do not go as planned.

If you are certain you wish to move to 1.1.0.2;

1a. REQUIRED
Run this SQL to update the necessary parts of the 1.1.0.1 Database to 1.1.0.2 Spec

Code: Select all

UPDATE configuration SET set_function = NULL WHERE configuration_key REGEXP '_MODULAR_[ABCDEFGHI]_WIDTH$';
UPDATE configuration SET configuration_value = CONCAT('col-sm-', configuration_value) WHERE configuration_key REGEXP '_MODULAR_[ABCDEFGHI]_WIDTH$';

1b. OPTIONAL
Run this SQL to update Country Names

Code: Select all

UPDATE countries SET countries_name = 'Afghanestan' WHERE countries_iso_code_3 = 'AFG';
UPDATE countries SET countries_name = 'Shqipëria' WHERE countries_iso_code_3 = 'ALB';
UPDATE countries SET countries_name = 'Dzayer' WHERE countries_iso_code_3 = 'DZA';
UPDATE countries SET countries_name = 'Hayastán' WHERE countries_iso_code_3 = 'ARM';
UPDATE countries SET countries_name = 'Österreich' WHERE countries_iso_code_3 = 'AUT';
UPDATE countries SET countries_name = 'Azərbaycan' WHERE countries_iso_code_3 = 'AZE';
UPDATE countries SET countries_name = 'Al-Bahrayn' WHERE countries_iso_code_3 = 'BHR';
UPDATE countries SET countries_name = 'Bielaruś' WHERE countries_iso_code_3 = 'BLR';
UPDATE countries SET countries_name = 'België' WHERE countries_iso_code_3 = 'BEL';
UPDATE countries SET countries_name = 'Bénin' WHERE countries_iso_code_3 = 'BEN';
UPDATE countries SET countries_name = 'Druk Yul' WHERE countries_iso_code_3 = 'BTN';
UPDATE countries SET countries_name = 'Bosnia I Hercegovína' WHERE countries_iso_code_3 = 'BIH';
UPDATE countries SET countries_name = 'Brasil' WHERE countries_iso_code_3 = 'BRA';
UPDATE countries SET countries_name = 'Bulgariya' WHERE countries_iso_code_3 = 'BGR';
UPDATE countries SET countries_name = 'Kampuchea' WHERE countries_iso_code_3 = 'KHM';
UPDATE countries SET countries_name = 'Cabo Verde' WHERE countries_iso_code_3 = 'CPV';
UPDATE countries SET countries_name = 'République Centrafricaine' WHERE countries_iso_code_3 = 'CAF';
UPDATE countries SET countries_name = 'Tchad' WHERE countries_iso_code_3 = 'TCD';
UPDATE countries SET countries_name = 'Zhōngguó' WHERE countries_iso_code_3 = 'CHN';
UPDATE countries SET countries_name = 'République du Congo' WHERE countries_iso_code_3 = 'COG';
UPDATE countries SET countries_name = 'Côte d\'Ivoire' WHERE countries_iso_code_3 = 'CIV';
UPDATE countries SET countries_name = 'Hrvatska' WHERE countries_iso_code_3 = 'HRV';
UPDATE countries SET countries_name = 'Κύπρος' WHERE countries_iso_code_3 = 'CYP';
UPDATE countries SET countries_name = 'Česko' WHERE countries_iso_code_3 = 'CZE';
UPDATE countries SET countries_name = 'Danmark' WHERE countries_iso_code_3 = 'DNK';
UPDATE countries SET countries_name = 'República Dominicana' WHERE countries_iso_code_3 = 'DOM';
UPDATE countries SET countries_name = 'Timor-Lester' WHERE countries_iso_code_3 = 'TLS';
UPDATE countries SET countries_name = 'Misr' WHERE countries_iso_code_3 = 'EGY';
UPDATE countries SET countries_name = 'Guinea Ecuatorial' WHERE countries_iso_code_3 = 'GNQ';
UPDATE countries SET countries_name = 'Iritriya' WHERE countries_iso_code_3 = 'ERI';
UPDATE countries SET countries_name = 'Eesti' WHERE countries_iso_code_3 = 'EST';
UPDATE countries SET countries_name = 'Ityop\'ia' WHERE countries_iso_code_3 = 'ETH';
UPDATE countries SET countries_name = 'Suomi' WHERE countries_iso_code_3 = 'FIN';
UPDATE countries SET countries_name = 'Guyanne française' WHERE countries_iso_code_3 = 'GUF';
UPDATE countries SET countries_name = 'Polynésie française' WHERE countries_iso_code_3 = 'PYF';
UPDATE countries SET countries_name = 'Terres australes et antarctiques françaises' WHERE countries_iso_code_3 = 'ATF';
UPDATE countries SET countries_name = 'République gabonaise' WHERE countries_iso_code_3 = 'GAB';
UPDATE countries SET countries_name = 'Sak\'art\'velo' WHERE countries_iso_code_3 = 'GEO';
UPDATE countries SET countries_name = 'Deutschland' WHERE countries_iso_code_3 = 'DEU';
UPDATE countries SET countries_name = 'Ελλάς' WHERE countries_iso_code_3 = 'GRC';
UPDATE countries SET countries_name = 'Guinée' WHERE countries_iso_code_3 = 'GIN';
UPDATE countries SET countries_name = 'Guiné-Bissau' WHERE countries_iso_code_3 = 'GNB';
UPDATE countries SET countries_name = 'Haïti' WHERE countries_iso_code_3 = 'HTI';
UPDATE countries SET countries_name = 'Magyarország' WHERE countries_iso_code_3 = 'HUN';
UPDATE countries SET countries_name = 'Ísland' WHERE countries_iso_code_3 = 'ISL';
UPDATE countries SET countries_name = 'Īrān (Islamic Republic of)' WHERE countries_iso_code_3 = 'IRN';
UPDATE countries SET countries_name = 'Al-\'Iraq' WHERE countries_iso_code_3 = 'IRQ';
UPDATE countries SET countries_name = 'Éire' WHERE countries_iso_code_3 = 'IRL';
UPDATE countries SET countries_name = 'Yisrā\'el' WHERE countries_iso_code_3 = 'ISR';
UPDATE countries SET countries_name = 'Italia' WHERE countries_iso_code_3 = 'ITA';
UPDATE countries SET countries_name = 'Nippon' WHERE countries_iso_code_3 = 'JPN';
UPDATE countries SET countries_name = 'Al-\'Urdun' WHERE countries_iso_code_3 = 'JOR';
UPDATE countries SET countries_name = 'Qazaqstan Қазақстан' WHERE countries_iso_code_3 = 'KAZ';
UPDATE countries SET countries_name = 'Tungaru' WHERE countries_iso_code_3 = 'KIR';
UPDATE countries SET countries_name = 'Chosŏn' WHERE countries_iso_code_3 = 'PRK';
UPDATE countries SET countries_name = 'Hanguk' WHERE countries_iso_code_3 = 'KOR';
UPDATE countries SET countries_name = 'Dawlat ul-Kuwayt' WHERE countries_iso_code_3 = 'KWT';
UPDATE countries SET countries_name = 'Kyrgyzstan Кыргызстан' WHERE countries_iso_code_3 = 'KGZ';
UPDATE countries SET countries_name = 'Lao' WHERE countries_iso_code_3 = 'LAO';
UPDATE countries SET countries_name = 'Latvija' WHERE countries_iso_code_3 = 'LVA';
UPDATE countries SET countries_name = 'Lubnān' WHERE countries_iso_code_3 = 'LBN';
UPDATE countries SET countries_name = 'Lietuva' WHERE countries_iso_code_3 = 'LTU';
UPDATE countries SET countries_name = 'Dhivehi Raajje' WHERE countries_iso_code_3 = 'MDV';
UPDATE countries SET countries_name = 'Muritan' WHERE countries_iso_code_3 = 'MRT';
UPDATE countries SET countries_name = 'México' WHERE countries_iso_code_3 = 'MEX';
UPDATE countries SET countries_name = 'Monaca' WHERE countries_iso_code_3 = 'MCO';
UPDATE countries SET countries_name = 'Mongol Uls Монгол Улс' WHERE countries_iso_code_3 = 'MNG';
UPDATE countries SET countries_name = 'Al-maɣréb' WHERE countries_iso_code_3 = 'MAR';
UPDATE countries SET countries_name = 'Moçambique' WHERE countries_iso_code_3 = 'MOZ';
UPDATE countries SET countries_name = 'Myanma' WHERE countries_iso_code_3 = 'MMR';
UPDATE countries SET countries_name = 'Naoero' WHERE countries_iso_code_3 = 'NRU';
UPDATE countries SET countries_name = 'Nepāl' WHERE countries_iso_code_3 = 'NPL';
UPDATE countries SET countries_name = 'Nederland' WHERE countries_iso_code_3 = 'NLD';
UPDATE countries SET countries_name = 'Nouvelle-Calédonie' WHERE countries_iso_code_3 = 'NCL';
UPDATE countries SET countries_name = 'Norge' WHERE countries_iso_code_3 = 'NOR';
UPDATE countries SET countries_name = '\'Umān' WHERE countries_iso_code_3 = 'OMN';
UPDATE countries SET countries_name = 'Pākistān' WHERE countries_iso_code_3 = 'PAK';
UPDATE countries SET countries_name = 'Panamá' WHERE countries_iso_code_3 = 'PAN';
UPDATE countries SET countries_name = 'Perú' WHERE countries_iso_code_3 = 'PER';
UPDATE countries SET countries_name = 'Polska' WHERE countries_iso_code_3 = 'POL';
UPDATE countries SET countries_name = 'Qaṭar' WHERE countries_iso_code_3 = 'QAT';
UPDATE countries SET countries_name = 'România' WHERE countries_iso_code_3 = 'ROM';
UPDATE countries SET countries_name = 'Россия' WHERE countries_iso_code_3 = 'RUS';
UPDATE countries SET countries_name = 'São Tomé e Principe' WHERE countries_iso_code_3 = 'STP';
UPDATE countries SET countries_name = 'Al-\'Arabiyyah as Sa\'ūdiyyah' WHERE countries_iso_code_3 = 'SAU';
UPDATE countries SET countries_name = 'Sénégal' WHERE countries_iso_code_3 = 'SEN';
UPDATE countries SET countries_name = 'Slovensko' WHERE countries_iso_code_3 = 'SVK';
UPDATE countries SET countries_name = 'Slovenija' WHERE countries_iso_code_3 = 'SVN';
UPDATE countries SET countries_name = 'Soomaaliya aş-Şūmāl' WHERE countries_iso_code_3 = 'SOM';
UPDATE countries SET countries_name = 'España' WHERE countries_iso_code_3 = 'ESP';
UPDATE countries SET countries_name = 'Sri Lankā' WHERE countries_iso_code_3 = 'LKA';
UPDATE countries SET countries_name = 'As-Sudan' WHERE countries_iso_code_3 = 'SDN';
UPDATE countries SET countries_name = 'Surinam' WHERE countries_iso_code_3 = 'SUR';
UPDATE countries SET countries_name = 'eSwatini' WHERE countries_iso_code_3 = 'SWZ';
UPDATE countries SET countries_name = 'Sverige' WHERE countries_iso_code_3 = 'SWE';
UPDATE countries SET countries_name = 'Suriyah' WHERE countries_iso_code_3 = 'SYR';
UPDATE countries SET countries_name = 'Tojikistan' WHERE countries_iso_code_3 = 'TJK';
UPDATE countries SET countries_name = 'Prathet Thai' WHERE countries_iso_code_3 = 'THA';
UPDATE countries SET countries_name = 'Tunes' WHERE countries_iso_code_3 = 'TUN';
UPDATE countries SET countries_name = 'Türkiye' WHERE countries_iso_code_3 = 'TUR';
UPDATE countries SET countries_name = 'Türkmenistan' WHERE countries_iso_code_3 = 'TKM';
UPDATE countries SET countries_name = 'Ukraїna' WHERE countries_iso_code_3 = 'UKR';
UPDATE countries SET countries_name = 'Al-\'Imārat Al-\'Arabiyyah Al-Muttaḥidah' WHERE countries_iso_code_3 = 'ARE';
UPDATE countries SET countries_name = 'O\'zbekiston' WHERE countries_iso_code_3 = 'UZB';
UPDATE countries SET countries_name = 'Città del Vaticano' WHERE countries_iso_code_3 = 'VAT';
UPDATE countries SET countries_name = 'Việt Nam' WHERE countries_iso_code_3 = 'VNM';
UPDATE countries SET countries_name = 'Al-Yaman' WHERE countries_iso_code_3 = 'YEM';
UPDATE countries SET countries_name = 'Srbija' WHERE countries_iso_code_3 = 'SRB';
UPDATE countries SET countries_name = 'République démocratique du Congo' WHERE countries_iso_code_3 = 'COD';
UPDATE countries SET countries_name = 'Crna Gora' WHERE countries_iso_code_3 = 'MNE';
UPDATE countries SET countries_name = 'Filasṭīn' WHERE countries_iso_code_3 = 'PSE';

2. REQUIRED
Upload these files.
Note that your /admin/ folder is hopefully not called "admin".

1.1.0.2.zip

3. REQUIRED
Visit Info Pages page in Admin and create any that are missing (there will be at least two pages that you need to set up)
Admin > Tools > Info Pages



4. REQUIRED
Visit Security Checks page in Admin and solve any issues
Admin > Tools > Security Checks

[burt]

Development branch is now 1.1.0.3

https://github.com/CE-PhoenixCart/Phoen ... ee/1.1.0.3

[raiwa]

Fontawesome has been updated to 6.7.2, but the link in: includes\languages\english\modules\content\footer_suffix\cm_footer_extra_icons.php
has been updated to version 5:

Code: Select all

Adds FontAwesome Icons to the Footer Area of your site.<div class="alert alert-info">Available Icons are shown here: https://fontawesome.com/v5/search?o=r&ic=free&c=payments-shopping</div>

[BPickle]

Due to a bots issue, I turned off cookies to test something, and ended up with errors on the cookie_usage.php page.

That led to this discovery:

update_1.1.0.1_1.1.0.2/1.1.0.2/1.1.0.1/update/install/phoenix.sql: has this:

Code: Select all

INSERT INTO pages (pages_id, date_added, pages_status, slug, sort_order) VALUES (5, now(), 0, 'cookie_usage', 50);

And so does every update thereafter. But update_1.1.0.1_1.1.0.2/1.1.0.2/1.1.0.1/update.sql has nothing comparable in it.

Did it accidentally get left out? Or is it somewhere else?

[burt]

3. REQUIRED
Visit Info Pages page in Admin and create any that are missing (there will be at least two pages that you need to set up)
Admin > Tools > Info Pages

[BPickle]

3. REQUIRED
Visit Info Pages page in Admin and create any that are missing (there will be at least two pages that you need to set up)
Admin > Tools > Info Pages

Seems like adding the pages in update.sql and then editing them might have been helpful, rather than adding them from scratch.

This also shows the hazards of upgrading to too many versions at one time. It might make it more easy to miss something.

[burt]

I spent hours making this update possible for free.

There is my `might have been helpful`

How on earth did we get to the point where something I do as a helpful favour elicits a not good enough response. Rhetorical, no need to answer.

[BPickle]

This also shows the hazards of upgrading to too many versions at one time. It might make it more easy to miss something.

Just in case you didn't notice, this closing comment blamed me.