Problem after installing Auspost add-on

[ozonlinesales]

Hey, i'm having a problem after i tried to install the auspost (older version). When i tried to install the SQL into the database it producted an error (cant remember exactly what it was) i did not install anything else, i just clicked back. After this i installed the new version of Auspost, this worked ok, it installed and i could set it up. Now when i try and browse products i receive a error. Its says this.

1146 Table 'oos_zen.oos_geo_zones' doesn't exist
in:
[select sum(tax_rate) as tax_rate from (oos_tax_rates tr left join oos_zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join oos_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 = '13') and (za.zone_id is null or za.zone_id = 0 or za.zone_id = '183') and tr.tax_class_id = '0' group by tr.tax_priority]

My site is http://www.ozonlinesales.com if you want to see for your self.

Also, i saved a copy of the admin and includes folder before i installed the addon, i have reverted back to the old folder, but its still in the database.

How can i remove this from the database, i have looked around but can't seem to find it
Thanks

Rhys

[ozonlinesales]

anyone, please help, it seems that when i tried to install the SQL file it remembered the error, now it wants me to fix the error before i can view my products. I just want it removed

[DrByte]

Also, i saved a copy of the admin and includes folder before i installed the addon, i have reverted back to the old folder, but its still in the database.

This is a good reason to also make database backups ...

1146 Table 'oos_zen.oos_geo_zones' doesn't exist

In your configure.php files, what do you have for these settings? Am I correct that you're using these settings? If not, what are they?

  define('DB_PREFIX', 'oos_');
  define('DB_DATABASE', 'oos_zen');

The error message suggests that the above information is what's in your configure.php files.

The error message also suggests that something you've done has deleted the standard geo_zones table (named oos_geo_zones if you're using oos_ as the table-prefix).

If the table is missing, then you most likely deleted it while making the various edits to the .sql file that you mentioned (both here on the forum and in PM).

Recreate the table in phpMyAdmin by:
- login to phpMyAdmin
- choose your "oos_zen" database from the list
- click on the "SQL" tab, and paste this into the query field, and click Go:

CREATE TABLE oos_geo_zones (
  geo_zone_id int(11) NOT NULL auto_increment,
  geo_zone_name varchar(32) NOT NULL default '',
  geo_zone_description varchar(255) NOT NULL default '',
  last_modified datetime default NULL,
  date_added datetime NOT NULL default '0001-01-01 00:00:00',
  PRIMARY KEY  (geo_zone_id)
) TYPE=MyISAM;

[ozonlinesales]

i fixed the problem, i added that table back into the database its good now, thanks for your help, you have been real helpful.

I will be backing up my database from now on.