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. 74 posts
  2. 17 subcategories
Sales & Billing
  1. 0 posts
  2. 2 subcategories
Welcome
  1. 6 posts
  2. 2 subcategories

Recent Discussions

EU VAT Compliant
Hello, we use the EU VAT Compliant plugin. When customer selects Greece it do...
282 Hits
0 Votes
Posted on Monday, February 10 2025, 02:28 PM
EU VAT Compliant issue
Hello, we use the EU VAT Compliant plugin. It is working correctly in opencar...
495 Hits
0 Votes
Posted on Wednesday, December 11 2024, 09:26 AM
Error log issues for version 3.21
Hi Get this info in error log: 2024-10-08 23:45:32 - PHP Warning: Undefin...
711 Hits
0 Votes
Posted on Tuesday, October 08 2024, 09:53 PM
  • Resolved
  • OWC EU VAT Compliant v3.15 - ocmod bug
    When I edit user data and try to save, I get an error: Fatal error: Uncaught ...
    839 Hits
    0 Votes
    Posted on Wednesday, August 28 2024, 09:22 AM
    Very Critical BUG: Swiss VAT IDs are accepted as V
    Hello, the Extensions incorrectly accepts Swiss Tax numbers as valid VAT numb...
    869 Hits
    0 Votes
    Posted on Tuesday, August 27 2024, 12:55 PM
  • Resolved