Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2013
    Location
    Bristol
    Posts
    3
    Plugin Contributions
    0

    Default Blank page when looking at product

    I am new to using zencart and have currently having to look after a perviously designed website (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

  2. #2
    Join Date
    Dec 2010
    Location
    UK
    Posts
    1,771
    Plugin Contributions
    3

    Default 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?

  3. #3
    Join Date
    Oct 2013
    Location
    Bristol
    Posts
    3
    Plugin Contributions
    0

    Default 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

  4. #4
    Join Date
    Oct 2013
    Location
    Bristol
    Posts
    3
    Plugin Contributions
    0

    Default Re: Blank page when looking at product

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

  5. #5
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,021
    Plugin Contributions
    3

    Default 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 ?

 

 

Similar Threads

  1. v154 Blank page when updating a product
    By Awalji in forum Basic Configuration
    Replies: 1
    Last Post: 7 Sep 2015, 04:56 PM
  2. Page blank when displaying product page in admin
    By unclemantis in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 18 Jan 2014, 01:20 AM
  3. Getting a blank page when clicking on product
    By doll5272 in forum General Questions
    Replies: 2
    Last Post: 2 Dec 2010, 05:28 PM
  4. Blank Page when product added to category
    By newyorksong in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 10 Sep 2010, 12:46 PM
  5. Page Not Found When Looking Up a Product
    By speeds5 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 30 Sep 2007, 09:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg