Okay, I have hit a wall.
This is really strange, as reported before,
I just uploaded the latest version of OpenCart and used the current live db on a new "backup" db user/name.
Then, I uploaded our custom template and made a few little changes, everything was fine.
I then tried connecting the updated shop to the live db & we hit errors.
The shop is "busy" 23 orders processed and 11 new customers joined while i was sorting out the update,
But I don't see why or how those orders or customers could break the upgrade?...anyone?
I tried going through the above steps again with the updated live db and hit the same errors.
Front page error:
Code: Select all
Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30Notice: Undefined index: tag in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 23Notice: Undefined index: ean in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 27Notice: Undefined index: jan in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 28Notice: Undefined index: isbn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 29Notice: Undefined index: mpn in /home4/blabla/public_html/testshop/catalog/model/catalog/product.php on line 30
and when I try to login in now to admin I get this:
Code: Select all
Notice: Error: Unknown column 'salt' in 'where clause'
Error No: 1054
SELECT * FROM oc_user WHERE username = 'admin' AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('blabla'))))) OR password = '8989') AND status = '1' in /home4/blabla/public_html/testshop/system/database/mysql.php on line 49
Seems strange only after a few more orders and customers the db is not compatible,
Maybe I need to run the upgrade.sql?
We just want to be secure, seeing as 153.1 has security issues.
Many thanks in advance.
Skills: Ripp, copy, paste.