SQL Error With My Site

Hello All,

I am have a minor issue which is below I can't seem to display 'city' in my sql database there appears to be an error.

Support in this matter is greatly appreciated. Thanks

Notice: Error: Unknown column 'city' in 'field list'
Error No: 1054
INSERT INTO address SET customer_id = '4', firstname = 'jjjjjjj', lastname = 'ssssss', company = '', company_id = '', tax_id = '', address_1 = 'PO Box 0000', address_2 = '', city = 'Glory', postcode = '0000', country_id = '13', zone_id = '195' in /home/catalog/public_html/shop/system/database/mysql.php on line 49

This happens when?

What did you changed as this does not happen just like that?

I don't know but I will keep checking for a solution.

You may of had upgraded from an earlier version of OpenCart which the city field from the address table on the database may of had failed on being created during the process and when you either access the admin - > sales - > customers page or from the store-front end during the customer registration form and wish to submit the form, this error comes up.

To fix this, go to your PHPMyAdmin, under your OpenCart database and execute the following SQL statement under the SQL tab:
Note: Replace oc_ with your real table prefix name if it's named differently. Then, try to reproduce the action either from the admin or from the customer registration form.