Table doesn't exist?

is this a fresh install or an upgrade?

I'm getting a similar problem when adding a product, fresh install of drupal 5.1 and ecommerce:

    * user warning: Table 'zedsaid.ec_shipping_product' doesn't exist query: SELECT service, method FROM ec_shipping_product WHERE vid = 22 in /home/www/globalvoice.org.uk/zedsaid/includes/database.mysql.inc on line 172.
    * user warning: Table 'zedsaid.ec_shipping_product_attribute' doesn't exist query: SELECT field, value FROM ec_shipping_product_attribute WHERE vid = 22 in /home/www/globalvoice.org.uk/zedsaid/includes/database.mysql.inc on line 172.

If anyone can help it would be much appreciated!

Sorry... I just ran update 1 on the shipping module on the update.php page and the error appears to have gone away! Hope that helps...

This is fixed or you had a bad install

I just uninstalled my ecommerce package and installed the .dev tarball and got the same problem. It is a fresh 5.1 install and only ecommerce core modules activated

The only way I could fix this was by deleting the entry for the shipping module in the system table. If you have a bad install, for whatever reason, this is the only way to uninstall the module as this module doesn't use the hook_uninstall (unless you use the dev module to re-install de module which should do the job I guess). I set this to fixed as the shipping module has really installed the tables after all.

Can some one just post the query code to install the table properly? I have phpMyAdmin.

this worked for me:

CREATE TABLE ec_shipping_product (
        vid int(10) unsigned NOT NULL default '0',
        nid int(10) unsigned NOT NULL default '0',
        service varchar(40) NOT NULL default '0',
        method varchar(40) NOT NULL default '0',
        KEY (vid),
        KEY nid (nid),
        KEY (service),
        KEY (method)
      ) TYPE=MyISAM;
      CREATE TABLE ec_shipping_transaction (
        txnid int(10) unsigned NOT NULL DEFAULT '0',
        service varchar(255) NOT NULL DEFAULT '',
        method varchar(255) NOT NULL DEFAULT '',
        cost decimal(10,2) UNSIGNED NOT NULL DEFAULT '0.00',
        PRIMARY KEY  (txnid)
      ) TYPE=MyISAM;
      CREATE TABLE ec_shipping_product_attribute (
        pid int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
        vid int(10) UNSIGNED NOT NULL DEFAULT '0',
        nid int(10) UNSIGNED NOT NULL DEFAULT '0',
        field varchar(255) NOT NULL DEFAULT '',
        value varchar(255) NOT NULL DEFAULT '',
        PRIMARY KEY pid (pid),
        KEY field (field),
        KEY vid (vid),
        KEY nid (nid)
      ) TYPE=MyISAM;
      CREATE TABLE ec_shipping_shipfrom (
        sid int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
        title varchar(255) NOT NULL DEFAULT '',
        code varchar(255) NOT NULL DEFAULT '',
        city varchar(255) NOT NULL DEFAULT '',
        region varchar(255) NOT NULL DEFAULT '',
        country varchar(2) NOT NULL DEFAULT '',
        status int(3) NOT NULL DEFAULT 0,
        PRIMARY KEY sid (sid),
        KEY title (title)
      ) TYPE=MyISAM;