1. Mitko
  2. EU VAT Compliant
  3. donderdag, februari 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. 73 posts
  2. 17 subcategories
Sales & Billing
  1. 0 posts
  2. 2 subcategories
Welcome
  1. 6 posts
  2. 2 subcategories

Recent Discussions

EU VAT Compliant issue
Hello, we use the EU VAT Compliant plugin. It is working correctly in opencar...
164 Hits
0 Votes
Posted on woensdag, 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...
392 Hits
0 Votes
Posted on dinsdag, oktober 08 2024, 09:53 PM
OWC EU VAT Compliant v3.15 - ocmod bug
When I edit user data and try to save, I get an error: Fatal error: Uncaught ...
547 Hits
0 Votes
Posted on woensdag, augustus 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...
551 Hits
0 Votes
Posted on dinsdag, augustus 27 2024, 12:55 PM
The buyer does not see second address and postal c
The buyer does not see the Administrator's modified second address and postal co...
635 Hits
0 Votes
Posted on dinsdag, augustus 20 2024, 11:06 AM