Post by arbaazdurrani » Sat Dec 29, 2018 12:57 am

Fatal error: Uncaught Exception: Error: Table 'DATABASENAME.oc_zone_to_geo_zone' doesn't exist<br />Error No: 1146<br />SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_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 = '223' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '3656') ORDER BY tr1.priority ASC in /home/WEBROOT/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/WEBROOT/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT tr1.tax_...', Array) #1 /home/WEBROOT/public_html/system/library/cart/tax.php(17): DB->query('SELECT tr1.tax_...') #2 /home/WEBROOT/public_html/catalog/controller/start in /home/WEBROOT/public_html/system/library/db/mysqli.php on line 40

OpenCart Version : 2.3.x
CAN ANYONE HELP PLEASE?
Its too urgent!

Newbie

Posts

Joined
Fri Dec 28, 2018 10:04 pm

Post by OSWorX » Sat Dec 29, 2018 1:00 am

Urgent or not: a bit more infos would be good!

Is it a fresh installation or update?
Any additonal extensions installed?
Was is running before?
Anybody else who has access to the admin and / or database?

Custom Development | Individuelle Entwicklung | Support & Bugfixes

Image Image Image


User avatar
Guru Member

Posts

Joined
Mon Jan 11, 2010 10:52 pm
Location - Austria

Post by arbaazdurrani » Sat Dec 29, 2018 1:08 am

OSWorX wrote:
Sat Dec 29, 2018 1:00 am
Urgent or not: a bit more infos would be good!

Is it a fresh installation or update?
Any additonal extensions installed?
Was is running before?
Anybody else who has access to the admin and / or database?
Its not a fresh installation. I migrated the files and database from one hosting to another.
Yes, there are some other extensions are installed.
Yes, it was running absolutely fine even after migration it was working.
Yes, someone else might have the credentials but for now I am the admin.

Anything else sir!

Newbie

Posts

Joined
Fri Dec 28, 2018 10:04 pm

User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by rahuljain1991 » Sat Dec 29, 2018 3:24 am

You have missing tables or atleast one table in your database, so try restoring the database or just the missing table. Simple :)

Rahul Jain
IT Support - always available to help
My Opencart Extensions
Authentic IT Services - Web design and development
AIS MarketPlace


Newbie

Posts

Joined
Thu Nov 16, 2017 1:39 am


Post by arbaazdurrani » Sat Dec 29, 2018 3:24 pm

rahuljain1991 wrote:
Sat Dec 29, 2018 3:24 am
You have missing tables or atleast one table in your database, so try restoring the database or just the missing table. Simple :)
Thanks I already did that and it is working.
Actually my backup database was corrupted.

Newbie

Posts

Joined
Fri Dec 28, 2018 10:04 pm
Who is online

Users browsing this forum: No registered users and 7 guests