That didn't fix the issue. Once I added the color_code column to the table I was able to get the admin login. But once in the actual functions of this extension don't work and cause other 500 errors. On the product_list page if I hit filter with no entries I get a 500. If I try to filter by category, discount, special I get a 500. The only one that works is by manufacturer.
The errors I get are:
Code: Select all
[17-Jun-2022 03:15:12 UTC] PHP Fatal error: Uncaught Exception: Error: Unknown column 'mps.price' in 'where clause'<br />Error No: 1054<br />SELECT * FROM roottesCart_product p LEFT JOIN roottesCart_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND mps.price IS NOT NULL AND (mps.date_end > NOW() OR mps.date_end = '000-00-00') GROUP BY p.product_id ORDER BY p.quantity DESC, p.status DESC, p.date_added DESC, pd.name ASC LIMIT 0,250 in /home/chris815/public_html/TS1/system/library/db/mysqli.php:48
Stack trace:
#0 /home/chris815/te/storage/modification/system/library/db.php(55): DB\MySQLi->query('SELECT * FROM r...')
#1 /home/chris815/te/storage/modification/admin/model/catalog/product.php(546): DB->query('SELECT * FROM r...')
#2 /home/chris815/te/storage/modification/system/engine/loader.php(251): ModelCatalogProduct->getProducts(Array)
#3 /home/chris815/public_html/TS1/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/chris815/te/storage/modification/admin/controller/catalog/product.php(597): Prox in /home/chris815/public_html/TS1/system/library/db/mysqli.php on line 48
OR
[17-Jun-2022 03:15:26 UTC] PHP Fatal error: Uncaught Exception: Error: Unknown column 'mpd.price' in 'where clause'<br />Error No: 1054<br />SELECT * FROM roottesCart_product p LEFT JOIN roottesCart_product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '1' AND mpd.price IS NOT NULL GROUP BY p.product_id ORDER BY p.quantity DESC, p.status DESC, p.date_added DESC, pd.name ASC LIMIT 0,250 in /home/chris815/public_html/TS1/system/library/db/mysqli.php:48
Stack trace:
#0 /home/chris815/te/storage/modification/system/library/db.php(55): DB\MySQLi->query('SELECT * FROM r...')
#1 /home/chris815/te/storage/modification/admin/model/catalog/product.php(546): DB->query('SELECT * FROM r...')
#2 /home/chris815/te/storage/modification/system/engine/loader.php(251): ModelCatalogProduct->getProducts(Array)
#3 /home/chris815/public_html/TS1/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/chris815/te/storage/modification/admin/controller/catalog/product.php(597): Proxy->__call('getProducts', Array)
#5 /home/chris815/te/stor in /home/chris815/public_html/TS1/system/library/db/mysqli.php on line 48
Apparently others have gotten 500 errors on the extension page, but this developer doesn't seem to be active or care to fix or direct how to fix this. I don't understand how this is looking for table columns that don't exist.