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

Recent Discussions

Error log issues for version 3.21
Hi Get this info in error log: 2024-10-08 23:45:32 - PHP Warning: Undefin...
66 Hits
0 Votes
Posted on Tuesday, October 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 ...
296 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...
281 Hits
0 Votes
Posted on Tuesday, August 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...
329 Hits
0 Votes
Posted on Tuesday, August 20 2024, 11:06 AM
the extension incorrectly displays the company nam
For example, VIES correctly displays the company name as MB "Restoranų įran...
355 Hits
0 Votes
Posted on Saturday, August 17 2024, 03:06 PM
  • Resolved