Fatal error: 1054:Unknown column 'status' in 'field list'
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 :
Quote:
[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?
Re: Express checkout not working possibly countries in database?
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.
Re: Express checkout not working possibly countries in database?
Quote:
Originally Posted by
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.
Its a new install.
Re: Express checkout not working possibly countries in database?
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?
Re: Express checkout not working possibly countries in database?
Quote:
Originally Posted by
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?
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?
Re: Express checkout not working possibly countries in database?
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.
Re: Express checkout not working possibly countries in database?
Quote:
Originally Posted by
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.
Thank you very much, that worked like a dream!
Re: Express checkout not working possibly countries in database?
Yeah! I'm happy you're making progress.
Come on back if you have additional questions and/or issues.
