URGENT PLEASE "oc_zone_to_geo_zone table not exists"

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!

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?

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!

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

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.