Sam Dodson
Sam Dodson
Offline
Hello,

My shop is giving errors which seem to be related to taxes and geo zones. Please see the screenshot "topPage_error.png" which shows the error that is shown on every page visited.

To see what might be the problem, in the admin panel, I've gone to Localisation > Geo Zones > UK Shipping and get the following error given at the top of the page, and another error below the "Items" bar. Please see "Geo Zones.png"

There seems to be no error at the Tax Classes or Tax Rates portions.

Screenshots and error log attached. Thanks for your help!
In General
Sunday, September 25 2016, 05:56 PM
Share this post:
Responses (8)
  • Accepted Answer

    Tuesday, September 27 2016, 05:06 PM - #Permalink
    If it's a unstable hosting causing issues like missing tables after install, there probably will be issues also with other systems.

    A normal install of Arastta 1.2.7 would not cause such issues, so something has probably gone bad somewhere along the way. Maybe you installed and tested some bad extensions, maybe you manually has worked in phpMyAdmin, maybe you just installed or migrated using some faulry third party service or whatever. Hard to tell without knowing the full history of your site. But update issues etc. could also be related, and anyway a update would not solve those missing tables.

    Personally I would try to figure out what went wrong, to be able to avoid it in future, but you're surely free to test other systems to. Or maybe the cloud service would fit, and give you less grey here than a fully self managed store: https://arastta.com/
    Like
    1
    The reply is currently minimized Show
  • Accepted Answer

    Sam Dodson
    Sam Dodson
    Offline
    Tuesday, September 27 2016, 02:49 PM - #Permalink
    Rune,

    I was actually thinking that I should probably just start fresh and your advice confirmed my feelings.

    With the lack of ability to update, as well as this table problem, I'm going to use this opportunity to test out other e-commerce options.

    Thanks for your help, guys.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 27 2016, 10:52 AM - #Permalink
    I would consider starting from scratch, with a new fresh install, since there might be more faulty tables etc.
    Something has gone quite bad in your install, if you're missing one or more tables. And then, if you have no clue ...

    Anyhow:
    DB_PREFIX = arsc_ = replace ar_ with arsc_
    The reply is currently minimized Show
  • Accepted Answer

    Sam Dodson
    Sam Dodson
    Offline
    Tuesday, September 27 2016, 02:52 AM - #Permalink
    Hello, Denis,

    Thanks for your help. I'm very, very novice at things like this, so I apologize in advance for my super-simple questions.

    I've tried to follow your instructions as best I could, but I am running into problems.

    I have managed to save the tables.sql you had linked to, and also have taken a look at config.php.

    I don't know what to replace from the config.php to the tables.sql... could you provide an example?

    In phpMyAdmin, I am guessing that I need to create a new table by importing a properly formatted (prefixes replaced correctly) tables.sql? I'm like the golden retriever dog sitting at the computer:

    http://s2.quickmeme.com/img/d6/d6a1143f571184db25f94613edd43b40af6d3a629221aba00d9efdcfef5efd84.jpg

    I've attached a screenshot of my config.php

    Thanks for any further assistance!
    Attachments:
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 27 2016, 01:12 AM - #Permalink
    Sam, you seems to have missing tables, zone_to_geo_zone table exactly. You can create it from phpMyAdmin using the following sample:

    https://github.com/arastta/arastta/blob/master/install/tables.sql#l7332

    Don't forget to replace ar_ table prefix with your ones, available in config.php
    The reply is currently minimized Show
  • Accepted Answer

    Sam Dodson
    Sam Dodson
    Offline
    Sunday, September 25 2016, 06:00 PM - #Permalink
    Copy/paste of error log:

    2016-09-25 10:22:28 - PHP Notice: Error: Table 'upliquid_891.arsc_zone_to_geo_zone' doesn't exist
    Error No: 1146
    SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM arsc_tax_rule tr1 LEFT JOIN arsc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN arsc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN arsc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN arsc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr1.priority ASC in /home/upliquid/public_html/system/library/db/mysqli.php on line 50
    2016-09-25 10:22:28 - PHP Notice: Trying to get property of non-object in /home/upliquid/public_html/system/library/tax.php on line 35
    2016-09-25 10:22:28 - PHP Warning: Invalid argument supplied for foreach() in /home/upliquid/public_html/system/library/tax.php on line 35
    2016-09-25 10:22:28 - PHP Notice: Error: Table 'upliquid_891.arsc_zone_to_geo_zone' doesn't exist
    Error No: 1146
    SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM arsc_tax_rule tr1 LEFT JOIN arsc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN arsc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN arsc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN arsc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '222' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3563') ORDER BY tr1.priority ASC in /home/upliquid/public_html/system/library/db/mysqli.php on line 50
    2016-09-25 10:22:28 - PHP Notice: Trying to get property of non-object in /home/upliquid/public_html/system/library/tax.php on line 63
    2016-09-25 10:22:28 - PHP Warning: Invalid argument supplied for foreach() in /home/upliquid/public_html/system/library/tax.php on line 63
    The reply is currently minimized Show
  • Accepted Answer

    Sam Dodson
    Sam Dodson
    Offline
    Sunday, September 25 2016, 05:58 PM - #Permalink
    Error log here.
    The reply is currently minimized Show
  • Accepted Answer

    Sam Dodson
    Sam Dodson
    Offline
    Sunday, September 25 2016, 05:57 PM - #Permalink
    Hmm, error log could not be attached, which cancelled the uploads for the screenshots, too. I'll try again.

    Edit: error log still cannot be uploaded. I'll paste the error log in a separate reply.
    The reply is currently minimized Show
Your Reply