Fatal error: 1054:Unknown column 'status' in 'field list'

[theenglandstore]

Hi

My URL is theenglandstore.com my host is running php 7

The Express Checkout isnt working, when I checked the logs I found this :

[05-Aug-2017 10:24:57 Europe/London] Request URI: /steve/countries.php, IP address: 86.139.0.121
#1 trigger_error() called at [/var/sites/t/theenglandstore.com/public_html/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/var/sites/t/theenglandstore.com/public_html/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/var/sites/t/theenglandstore.com/public_html/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/var/sites/t/theenglandstore.com/public_html/steve/countries.php:141]

[05-Aug-2017 10:24:57 Europe/London] PHP Fatal error: 1054:Unknown column 'status' in 'field list' :: select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id, status from qvwj_countries order by countries_name limit 0, 20 ==> (as called by) /var/sites/t/theenglandstore.com/public_html/steve/countries.php on line 141 <== in /var/sites/t/theenglandstore.com/public_html/includes/classes/db/mysql/query_factory.php on line 167

On looking at countries under the 'locations/taxes' I see the menu is blank.

I am not great with databases, would anyone know if this is the trouble and how can I fix it please?

[lat9]

What is your store's "Zen Cart" history? I ask because the status field was added to the countries database table in Zen Cart 1.5.2.

[theenglandstore]

What is your store's "Zen Cart" history? I ask because the status field was added to the countries database table in Zen Cart 1.5.2.

Its a new install.

[lat9]

Sorry for all the questions, but that doesn't make sense to me. If you performed a new install of ZC 1.5.5 the "countries" table is created with that status field.

How did you perform the installation?

[theenglandstore]

Sorry for all the questions, but that doesn't make sense to me. If you performed a new install of ZC 1.5.5 the "countries" table is created with that status field.

How did you perform the installation?

No worries!

I had trouble uploading with FTP, so my host installed it from the cpanel. I then uploaded 1.55e

If that makes sense?

[lat9]

Any idea what Zen Cart version (a.k.a it) your webhost installed? You might need to upload the zc_install directory via FTP and run that process to get your database properly upgraded.

If you look in your admin's Tools->Server/Version Info, that will let you know what version(s) -- both file and database -- are currently installed.

[theenglandstore]

Any idea what Zen Cart version (a.k.a it) your webhost installed? You might need to upload the zc_install directory via FTP and run that process to get your database properly upgraded.

If you look in your admin's Tools->Server/Version Info, that will let you know what version(s) -- both file and database -- are currently installed.

Thank you very much, that worked like a dream!

[lat9]

Yeah! I'm happy you're making progress.

Come on back if you have additional questions and/or issues.