Post by kyrre » Wed Oct 05, 2016 2:54 am

Hi guys

This error comes when a customer tries to create a new account.

Where to start looking :)

OC 1.5.6.4

Code: Select all

Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'company_id' in 'field list'<br />Error No: 1054<br />INSERT INTO oc_address SET customer_id = '655', firstname = 'xxx', lastname = 'xxx', company = '', company_id = '', tax_id = '', address_1 = 'xxx', address_2 = '', city = 'xxx', postcode = 'xxx', country_id = '160', zone_id = '2429'' in /system/database/mysqli.php:41 Stack trace: #0 /vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query('INSERT INTO oc_...') #1 /vqmod/vqcache/vq2-catalog_model_account_customer.php(29): DB->query('INSERT INTO oc_...') #2 /vqmod/vqcache/vq2-catalog_controller_account_register.php(19): ModelAccountCustomer->addCustomer(Array) #3 [internal function]: ControllerAccountRegister->index() #4 /vqmod/vqcache/vq2-system_engine_front.php(42): call_user_func_array(Array, Array) #5 /vqmod/vqcach in /system/database/mysqli.php on line 41
Added info 21:01: The user account is created and works fine when logging in.
Last edited by kyrre on Wed Oct 05, 2016 7:23 am, edited 1 time in total.

Kind regards
Kyrre
http://www.ledstrips.no


New member

Posts

Joined
Mon Jul 16, 2012 10:20 pm

Post by IP_CAM » Wed Oct 05, 2016 6:44 am

Error: Unknown column 'company_id' in 'field list'
means, that you probably use an Extension like this one below:
---
Company ID of the Store - Partita IVA d ... io (VQMOD)
http://www.opencart.com/index.php?route ... n_id=11064
---
but the Extension controller- (or model-) File did NOT add a 'company_id' Field into it's place in the DB,
when the Mod was installed, because you possibly just forgot to activate the Module itself in the Admin USER-Group
TopAdmin Section. That would be the easiest to fix Reason, otherways, you have to tell us first, exactly, what you
use on Theme and Extensions.
--
Just an idea... ;)
Ernie

I don't use the Forum Mailer, to reach me, contact: jti@jacob.ch
-
Demoversions:
OpenCart LIGHT v.1.5.6.5 http://www.bigmax.ch/
OpenCart V-PRO v.1.5.6.5 http://www.ebikes.li/shop/
-
1'700+ FREE OC Extensions - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
-
Image


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by kyrre » Wed Oct 05, 2016 7:22 am

IP_CAM wrote:
Error: Unknown column 'company_id' in 'field list'
means, that you probably use an Extension like this one below:
---
Company ID of the Store - Partita IVA d ... io (VQMOD)
http://www.opencart.com/index.php?route ... n_id=11064
---
but the Extension controller- (or model-) File did NOT add a 'company_id' Field into it's place in the DB,
when the Mod was installed, because you possibly just forgot to activate the Module itself in the Admin USER-Group
TopAdmin Section. That would be the easiest to fix Reason, otherways, you have to tell us first, exactly, what you
use on Theme and Extensions.
--
Just an idea... ;)
Ernie
Hi

Thank you for trying to help :)

I figured out that OC_address was missing company_id and tax_id fields. I added them, and now it works.

I have cleaned up in the modules, so I guess I uninstalled a module removing these two fields at the same time - not knowing they were in use other places.

Kind regards
Kyrre
http://www.ledstrips.no


New member

Posts

Joined
Mon Jul 16, 2012 10:20 pm
Who is online

Users browsing this forum: No registered users and 36 guests