Forums / General Questions / Blank page when looking at product

Blank page when looking at product

Started by christopher_priest on 9 Jan 2014, 12:17 PM · Views: 1,573

Results 1 to 5 of 5
9 Jan 2014, 12:17 PM
#1
christopher_priest avatar

christopher_priest

New Zenner

Join Date:
Oct 2013
Location:
Bristol
Posts:
3
Plugin Contributions:
0

Blank page when looking at product

I am new to using zencart and have currently having to look after a perviously designed website (https://www.handylabels.co.uk).

When selecting a product it would usually display its details, allow you to add it to your cart etc...

No changes have been made to the site but now it gives a blank page with 'WARNING: An Error occurred, please refresh the page and try again.'

I have checked the logs and there are a lot of this error

[09-Jan-2014 10:56:59] PHP Fatal error: 1146:Table 'web244-zenc_15-1.zen_zones_to_geo_zones' doesn't exist :: select sum(tax_rate) as tax_rate
from (zen_tax_rates tr
left join zen_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id)
left join zen_geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) )
where (za.zone_country_id is null
or za.zone_country_id = 0
or za.zone_country_id = '222')
and (za.zone_id is null
or za.zone_id = 0
or za.zone_id = '0')
and tr.tax_class_id = '1'
group by tr.tax_priority in /home/sites/handylabels.co.uk/public_html/includes/classes/db/mysql/query_factory.php on line 120

zen_zones_to_geo_zones does not exist in my DB.

Any help you can give would be greatly appreciated as the store is currently unusable.

Many thanks

Chris

9 Jan 2014, 12:51 PM
#2
picandnix avatar

picandnix

Totally Zenned

Join Date:
Dec 2010
Location:
UK
Posts:
1,780
Plugin Contributions:
2

Re: Blank page when looking at product

When did this start Chris?
What has changed in your files or admin settings since you didn't have this issue?

9 Jan 2014, 12:57 PM
#3
christopher_priest avatar

christopher_priest

New Zenner

Join Date:
Oct 2013
Location:
Bristol
Posts:
3
Plugin Contributions:
0

Re: Blank page when looking at product

Hi thanks for the quick reply.

The error was first logged at 7:56 today

To my knowledge there have been no changes to any files or settings.

My provider 'heart internet' have recently allowed the upgrade of PHPmyadmin to 4.1.4 (which i haven't done) but that was on the 7/1/2013 and the website has worked up until this morning, could this caused the issue?

Thanks

Chris

9 Jan 2014, 3:01 PM
#4
christopher_priest avatar

christopher_priest

New Zenner

Join Date:
Oct 2013
Location:
Bristol
Posts:
3
Plugin Contributions:
0

Re: Blank page when looking at product

any ideas cause im out of them! Our provider does not know either.

9 Jan 2014, 3:11 PM
#5
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Blank page when looking at product

That table (zones_to_geo_zones) does exist in a stock Zencart 1.5.1 installation. Do you (or does your host) have a database backup available ?