test.ec_cart' doesn't exist query:

I get a similar set of errors when creating a product or clicking on fulfillment centers.

After checking the database (mysql in this case), the shipping tables are just not being installed when the shipping module is installed. Reinstallation of the module does not help.

ec_shipping_product table is not created because low mem limit on your server prevent successfull exec of entire install script raise memory limit or disable some modules

Guys,

its a Drupal problem. When you try to enable many modules at once, Drupal doesnt respect the dependencies and install them on the reverse order.
try to install one at time.

regards,

massa

I have the same problem and I don't think it's the dependencies - they are checked for in the install script (unless there is an error). I disabled all ecommerce modules, deleted them from the server, ran update.php, uploaded them back, and enabled them one by one, following the order of dependencies, ran update.php again (my thinking was that it would definitely re-execute module install script). However, ec_shipping_product along with the other tables in Shipping API module still were not created.

I think low mem limit is more likely explanation; however, even after I disable all modules except the core and those required by the Shipping API, these tables do not get created. I'm on Godaddy shared hosting (I think it's called Deluxe Linux), and I don't think it's possible to raise the mem limit - if it in fact were the reason.

Any ideas? Any way to debug this to see actual error messages?

I've had the same problem. I got exactly the same error message. Then I removed all the tables from the database and enabled the modules one by one. After enabling the cart module again, I got this error message:

user warning: Table 'frisksomenfisk_.ec_cart' doesn't exist query: SELECT c.*, n.title, n.vid FROM node n INNER JOIN ec_cart c ON n.nid = c.nid WHERE c.cookie_id = '1' in /customers/frisksomenfisk.com/frisksomenfisk.com/httpd.www/includes/database.mysql.inc on line 172.

My host is one.com. Does anyone know what to do?

I removed some more unnecessary tables and modules that I didn't use anyway and when I then enabled cart, it worked!

I guess it didn't. New error message:

user warning: Table 'frisksomenfisk_.ec_product' doesn't exist query: SELECT * FROM ec_product WHERE vid = 12 in /customers/frisksomenfisk.com/frisksomenfisk.com/httpd.www/includes/database.mysql.inc on line 172.
user warning: Table 'frisksomenfisk_.ec_product' doesn't exist query: SELECT * FROM ec_product WHERE vid = 18 in /customers/frisksomenfisk.com/frisksomenfisk.com/httpd.www/includes/database.mysql.inc on line 172.
user warning: Table 'frisksomenfisk_.ec_product' doesn't exist query: SELECT * FROM ec_product WHERE vid = 21 in /customers/frisksomenfisk.com/frisksomenfisk.com/httpd.www/includes/database.mysql.inc on line 172.

Which module is supposed to create the ec_product table? Is it product API?

Check this out: http://drupal.org/node/87977

Guys,

yes, its a problem on install process. there are two additional problems regarding eCommerce:
1* Many modules dont have a unistall function, so doesnt matter if you only disable it.
2* Some modules do some additional checks before install, depending if you install many modules togheter, these checks fail and the module doesnt install

uninstall (not only disable) every module and install it again. it doesnt happen on new drupal sites.

regards,

massa