WARNING: An Error occurred, please refresh the page and try again.

[adb34]

As the title says. I have done a clean install (new website) and have hit an interesting problem. If you visit my Registration page, against Country I have 'WARNING: An Error occurred, please refresh the page and try again.' I thought it may have been the template I installed however it is not. This site only has one plugin installed and that is 'Display logs'.

Log file:

[21-May-2018 14:40:36 Europe/London] Request URI: /index.php?main_page=login, IP address: 10.71.76.142
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/functions/functions_lookups.php:47]
#5 zen_get_countries() called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/functions/html_output.php:541]
#6 zen_get_country_list() called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/templates/template_default/templates/tpl_modules_create_account.php:116]
#7 require(/homepages/20/d503465712/htdocs/shops/idoshop/includes/templates/template_default/templates/tpl_modules_create_account.php) called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/templates/template_default/templates/tpl_login_default.php:92]
#8 require(/homepages/20/d503465712/htdocs/shops/idoshop/includes/templates/template_default/templates/tpl_login_default.php) called at [/homepages/20/d503465712/htdocs/shops/idoshop/includes/templates/responsive_classic/common/tpl_main_page.php:171]
#9 require(/homepages/20/d503465712/htdocs/shops/idoshop/includes/templates/responsive_classic/common/tpl_main_page.php) called at [/homepages/20/d503465712/htdocs/shops/idoshop/index.php:97]

[21-May-2018 14:40:36 Europe/London] PHP Fatal error: 1054:Unknown column 'status' in 'where clause' :: select countries_id, countries_name
from uw15_countries where status != 0 order by countries_name ==> (as called by) /homepages/20/d503465712/htdocs/shops/idoshop/includes/functions/functions_lookups.php on line 47 <== in /homepages/20/d503465712/htdocs/shops/idoshop/includes/classes/db/mysql/query_factory.php on line 171

But now the log file is putting up:

[21-May-2018 16:06:25 Europe/London] PHP Fatal error: 1054:Unknown column 'status' in 'where clause' :: select countries_id, countries_name
from uw15_countries where status != 0 order by countries_name ==> (as called by) /homepages/20/d503465712/htdocs/shops/idoshop/includes/functions/functions_lookups.php on line 47 <== in /homepages/20/d503465712/htdocs/shops/idoshop/includes/classes/db/mysql/query_factory.php on line 171

Any ideas, please? (d503465712 is not my db)

[mprough]

Have you checked your database tables?

~Melanie

[Design75]

What source did you use for your installation. Did you download it from this sit or use some auto-installer?

[adb34]

Have you checked your database tables?

~Melanie

Yes I have, but thanks Melanie

[adb34]

What source did you use for your installation. Did you download it from this sit or use some auto-installer?

Now there is a thing I used the "1 and 1 app centre". I have never had a problem with this before, however, there is always a first time. I will contact them to see what is going on, if it is a problem with their installation process.

[mc12345678]

Now there is a thing I used the "1 and 1 app centre". I have never had a problem with this before, however, there is always a first time. I will contact them to see what is going on, if it is a problem with their installation process.

Not so much their "process" although any auto-installer is not the method developed by the Zen Cart Team, but like most if not all of the auto-installers recently, they skipped at least one database field as part of their install. The status field found in the countries table.... it's been in the standard install for some 3+ years...

[lat9]

Those auto-installers seem to have an issue with the update (made in Zen Cart 1.5.2) that adds a status field to the countries table in the database.

[dbltoe]

And, since most don't include the zc_install folder they never update the database.

[adb34]

So my next question is; how can I fix this?

[Design75]

So my next question is; how can I fix this?

Download the installation package from this site. Unpack and upload it using ftp. Go to your domain and follow the online instructions.