I've given up on OC 4.0, and in order to update jQuery to pass PCI scans, have installed a test instance of 3.0.8 maintenance release. Calling the test install "OC3M" to differentiate it from the live store.
I have a non-maint-rel 3.0.8 store running live and when I export/backup its dbf and attempt to import it into the 3.0.8 "OC3M" store it fails. No extensions installed, PHP 8, default theme. The live store is running with storage in a private folder above /web. I have not yet moved the storage location for OC3M.
The test store runs in demo, connects to it's own separate db and can export and import its own dbf. But OC3M won't import the live store's db from a local backup copy. I initially found that the live OC3 install had table entries not recognized by OC3-Maint. These may have been left over from its days as OC2. Not exporting those tables allowed OC3M to attempt an import but fails. Error is:
Code: Select all
Internal Server Error <b>Warning</b>: mysqli::query(): (42S22/1054): Unknown column 'firstname' in 'field list' in <b>/var/www/clients/client14/web50/web/shop309/system/library/db/mysqli.php</b> on line <b>25</b>