Unknown column 'language_id' in 'field list'

Hi,

I am receiving the below error when i try to register a new user on my site. I am using Opencart 1.5.6.4.

Notice: Error: Unknown column 'language_id' in 'field list'
Error No: 1054
INSERT INTO oc_subscribe SET store_id='0',email_id='test@test.com',name='Dave Tester',language_id='1',option1='',option2='',option3='',option4='',option5='',option6='' in /home/mrmr3156/public_html/system/database/mysql.php on line 50

I am assuming this is occuring because this field is not in the database?, i was just wondering what the format would be to enter this field into my database?

Thank you

Hi Derrenp,

that table isn't a default table in OC 1564, so I'm assuming it's from an extension that you've installed.

The "language_id" field is usually specified as int(11), and is also used in Primary Keys and Indexes.

- Mel

Hi,

Thank you for your response, i have added a few extensions so i am not sure which one is the guilty party unfortunately. What would the command syntax look like to add this table, i apologise databases aren't my strong point

Kind Regards
Derren

Hi Derren,

in SQL terms it's this: This assumes the value is always set (hence the NOT NULL).

You can do this change (as well as the index changes) via phpMyAdmin. If you get stuck, PM me and I'll help you out.

- Mel

Hi Mel,

That worked perfectly, thank you very much for your assistance.

Regards
Derren