Hi guys
I've been trying to install Opencart v3.0.2.0 a bunch of times without any luck. This is what I get when I try to log in as admin:
"Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'approved' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM oc_customer WHERE approved = '0'' in /customers/b/4/3/XXXXXX/httpd.www/system/library/db/mysqli.php:40 Stack trace: #0 /customers/b/4/3/XXXXXX/httpd.www/system/library/db.php(16): DB\MySQLi->query('SELECT COUNT(*)...', Array) #1 /customers/b/4/3/XXXXXX/httpd.www/admin/model/customer/customer.php(323): DB->query('SELECT COUNT(*)...') #2 [internal function]: ModelCustomerCustomer->getTotalCustomers(Array) #3 /customers/b/4/3/XXXXXX/httpd.www/system/engine/loader.php(178): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array, Array) #5 /customers/b/4/3/XXXXXX/httpd.www/system/engine/proxy.php(25): call_user_func_array(Object(Closure), Array) #6 /customers/b/4/3/XXXXXX/httpd.www/admin/controller/common/header.php(83): Proxy->__call('getTotalCustome...', Array) #7 /customers/b/4/3/24 in /customers/b/4/3/XXXXXX/httpd.www/system/library/db/mysqli.php on line 40"
PHP v5.6 (same problem if I change to PHP v7.0).
Opencart v2.3.0.2 seem to work OK after clean install.
Does anyone know how to fix this... mess?
Best regards
/mr Magoo
PM sent.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The problem is when I'm trying to move the "storage directory". I've been googling and other search engines without luck. There are a bunch of solutions for similar problems but I just can't figure out how to fix my problem but it seem to be a missing column in my database...
Anyone has a clue???
Anyone has a clue???
You are using an earlier version release of the v3.0.2.0 which already has the getTotalCustomers($data = array()) method from your admin/model/customer/customer.php file. In the query, you need to remove the approved field condition in the query.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 104 guests