1. Mitko
  2. EU VAT Compliant
  3. Thursday, February 15 2024, 10:17 AM
  4.  Subscribe via email
Hello, we have bought your extension EU VAT Compliant in the Opencart Marketplace (ord. nr. 1275584). We installed the extension, but when we try to open it says:

Fatal error: Uncaught Exception: Error: Unknown column 'ca.customer_activity_id' in 'field list'<br />Error No: 1054<br />SELECT ca.customer_activity_id, ca.customer_id, ca.key, ca.data, ca.ip, ca.date_added FROM oc_customer_activity ca LEFT JOIN oc_customer c ON (ca.customer_id = c.customer_id) WHERE ca.key LIKE '%euvat%' ORDER BY ca.date_added DESC LIMIT 0,10 in /var/www/vhosts/http://balkanenergy.es/httpdocs/storage/modification/system/library/db/mysqli.php:43 Stack trace: #0 /var/www/vhosts/http://balkanenergy.es/httpdocs/catalog/controller/extension/lightning/beta.php(18): DB\MySQLi->query('SELECT ca.custo...') #1 /var/www/vhosts/http://balkanenergy.es/httpdocs/catalog/controller/extension/lightning/beta.php(39): light_db->Whs('SELECT ca.custo...') #2 /var/www/vhosts/http://balkanenergy.es/httpdocs/storage/modification/system/library/db.php(58): light_db->query('SELECT ca.custo...') #3 /var/www/vhosts/http://balkanenergy.es/httpdocs/system/library/owc/controller/owc_euvat.php(2): DB->query('SELECT ca.custo...') #4 /var/www/vhosts/http://balkanenergy.es/httpd in /var/www/vhosts/http://balkanenergy.es/httpdocs/storage/modification/system/library/db/mysqli.php on line 43
Comment
There are no comments made yet.
Add Comment
Dennis Buijs Accepted Answer
0
Votes
Undo
Hi

I checked the error and if you are using opencart 3.0.3.2, then something is changed in table oc_customer_activity, in this opencart version you must have column customer_activity_id.
In older OpenCart versions, this column was named activity_id, so if you upgraded from to 3.0.3.2 from a older version then this can happen.

Please check this table.

Best regards
Dennis
Comment
There are no comments made yet.
Add Comment
  1. more than a month ago
  2. EU VAT Compliant
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Welcome

Categories

OpenCart Free Extension
  1. 1 post
  2. 2 subcategories
OpenCart Commercial Extension
  1. 67 posts
  2. 17 subcategories
Sales & Billing
  1. 0 posts
  2. 2 subcategories
Welcome
  1. 4 posts
  2. 2 subcategories

Recent Discussions

How to improve OpenCart performance
I have a website using OpenCart so I have a question to ask everyone how to opt...
142 Hits
0 Votes
Posted on Wednesday, March 27 2024, 08:10 AM
License activation
Hello, I have bought EU VAT Compliant module with unlimited domains license. ...
261 Hits
0 Votes
Posted on Wednesday, March 06 2024, 02:30 PM
  • Resolved
  • Delivery address problem
    Hi, if you specify a different shipping address from the payment address, it doe...
    268 Hits
    0 Votes
    Posted on Thursday, February 01 2024, 12:48 PM
    EU VAT Compliant problem
    Hello, we have bought your extension EU VAT Compliant in the Opencart Marketplac...
    334 Hits
    0 Votes
    Posted on Thursday, February 15 2024, 10:17 AM
    Does "short descriptions" work with Open
    Does short descriptions work with open cart 4?...
    404 Hits
    0 Votes
    Posted on Wednesday, December 20 2023, 07:50 AM