I still think you may have mangled your database

david.houlder's picture
Offline
Joined: 05/29/2010
Juice: 115
I still think you may have mangled your database

Are you saying that both product-price and stock-level imports fail?

I think you may have got your database into a weird state. Have a look at your node, uc_products and uc_product_stock tables. If you look at sites/all/modules/uc_stock_update/uc_stock_update.module you'll see the SQL "where" clauses involved - it's not particularly complicated and you should be able to figure out what's wrong by experimenting with a few SQL selects.

If it all looks OK, try doing an SQL update manually - it's possible that your database was not restored correctly and all updates on those tables are failing.

By the way, reinstalling the uc_stock_update module won't help here.

David Houlder
http://davidhoulder.com

Stock & Price CSV Updater 2 By: david.houlder (80 replies) Sat, 05/29/2010 - 22:48