having trouble with entering the tax zone in admin

[corey]

very new to oscdox...please forgive.

I am having trouble entering into the tax zone section in admin. When I try I get the error message:

1146 - Table 'catalog.zones_to_geo_zones' doesn't exist

select count(*) as num_zones from zones_to_geo_zones where geo_zone_id = '1' group by geo_zone_id

Please advise.

Thanks,

Corey

[michael_s]

Looks like you are missing the table zones_to_geo_zones

You will need to add it to your database. Strange....

[corey]

Where can i find info on the oscdox database so I know what fields I need to add?

If you've backed up your database you try and do a restore to see if that works... You will lose any data included after the backup was made though.

[neil]

R U on a remote server?
Chances they will have cpanel & phpmyadmin.
Look in phpmyadmin - it will list all of the tables of your database.

The original sql file is in the install directory or folder of the download of oscmax.

[corey]

Thanks....

learned a little about phpmyadmin and no more database problems. (for now at least)

Corey