I get these errors when connection V4.0.2.1 to an existing SQLI using V3.x. Can anyone advise exactly what to change?
Warning: Undefined array key "extension" in /var/www/web/Ocart/catalog/model/localisation/language.php on line 44Warning: Undefined array key "extension" in /var/www/web/Ocart/catalog/controller/startup/language.php on line 19Exception: Error: Unknown column 'extension' in 'field list'
Error No: 1054
SELECT DISTINCT `extension` FROM `oc_extension` in /var/www/web/Ocart/system/library/db/mysqli.php on line 64
It sounds like you didn't update your database tables (or at least missed the "extension" table). 4.0 has a new "extension" column that 3.0 did not have. You will need to run a comparison between the two databases, and add that column (as well as any others that are missing).
I'd recommend installing a fresh 4.0 installation on a duplicate site, then analyze what is in the columns you have missing. For the "extension" column specifically, it would need to have a value of "opencart" for the default extensions, and the extension codename if it's a third-party extension. (You will need to re-download and re-install new versions of all extensions you use, because 4.0 handles them much differently than 3.0.)
I'd recommend installing a fresh 4.0 installation on a duplicate site, then analyze what is in the columns you have missing. For the "extension" column specifically, it would need to have a value of "opencart" for the default extensions, and the extension codename if it's a third-party extension. (You will need to re-download and re-install new versions of all extensions you use, because 4.0 handles them much differently than 3.0.)
Did you fixed your issue because I am having same issue and it is very annoying for me. I tried many changes checked my extensions which is fine. Also checked array key extension is properly defined. Need help. Target Pay and BenefitsRov4 wrote: ↑Mon Jun 19, 2023 8:22 pmI get these errors when connection V4.0.2.1 to an existing SQLI using V3.x. Can anyone advise exactly what to change?
Warning: Undefined array key "extension" in /var/www/web/Ocart/catalog/model/localisation/language.php on line 44Warning: Undefined array key "extension" in /var/www/web/Ocart/catalog/controller/startup/language.php on line 19Exception: Error: Unknown column 'extension' in 'field list'
Error No: 1054
SELECT DISTINCT `extension` FROM `oc_extension` in /var/www/web/Ocart/system/library/db/mysqli.php on line 64
Who is online
Users browsing this forum: GPAC and 3 guests
