Error: Something went wrong when trying to add the

Something strange happened a couple of days back when adding products to my site; working on localhost

I tried checking this isue on virtuemart forum, however did not shed any light as to what's happening.

I used DEBUG and it reported the following;

JDatabaseMySQL::query: 1146 - Table '1stop.wa89g_vm_shipping_restrictions' doesn't exist SQL=SELECT count(*) as num_rows FROM wa89g_vm_shipping_restrictions

I found 1 suggestion on the forum, which by the way didn't fix the problem;
go to wa89g_vm_product
product_id please add the auto_increment

Please check if you have the tables in your wa89g_vm_product if not please add the tables

product_packaging` int(11) default NULL,
`child_options` varchar(45) default NULL,
`quantity_options` varchar(45) default NULL,
`child_option_ids` varchar(45) default NULL,
`product_order_levels` varchar(45) default NULL,

was hoping maybe you may have an idea what I should do;

The only additions which were made to the template prior to the error message were;
com_vm_sef_free_v1.5.1
com_xmap-1.2.12
com_flexicontact_5.04
email_protector

all the above were removed in an attemp to get VM/Joomla back to previous state .. but obviously it failed..

Everything seems to be working on frontend with products already entered;

thanks in advance

Does the table wa89g_vm_shipping_restrictions really exists in your database?
Is the table prefix for other tables wa89g_ also?

Hi Ivan,
You're right ... shipping_restrictions is not there

I tried to create a DB of that name, but the number of fields required I don't know.
I googled around trying to find this information out from somewhere, but noo luck..
Can you shed some light as to how many fields I'd require?

Hi again,
Looked into this problem a little deeper now and here’s what I’ve found;
1. Original installation of eCommerce has now go an extra field in Virtuemart -> Admin -> Configuration -> shipping called “Global shipping Options”
2. After installing a fresh Hot ecommerce template, this field is not there
So it looks like this field with all the restriction options is being called when creating a new product. Even though all the options in this field are turned off

There is nowhere in modules, components, plugins or even in Virtuemart configuration where I can see an option to remove this field.

Not sure how this option has appeared, and not even sure if a previously mentioned component added this option.

As I mentioned all the extra components which I did install have been removed, but now this field remains active and I can’t seem to add any products without getting an error.

Hi ..
More information for this problem,
I apologise for the number of posts, but I figure it may help out someone else with the same problem..

Ok , I forgot to mention I downloaded a revised/updated UPS shipping module from forum.virtuemart.net/index.php?topic=47142.0 called vm117-UPSv2.2011.02.11.zip

After installing this module everything turned into a mess, causing errors in creating products due to the missing DB called shipping_restrictions