Post by znyting » Thu Oct 19, 2017 3:36 am

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

Newbie

Posts

Joined
Mon Mar 20, 2017 10:02 pm

Post by straightlight » Thu Oct 19, 2017 5:05 am

PM sent.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by znyting » Wed Dec 13, 2017 6:35 am

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???

Newbie

Posts

Joined
Mon Mar 20, 2017 10:02 pm

Post by straightlight » Wed Dec 13, 2017 7:17 am

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


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 104 guests