Search Form and Social Buttons

HotThemes Logo and Top Menu

To request a forum account, please login here and open support ticket. Only customers with active order(s) can open forum account!

× Discussion about "eCommerce" VirtueMart/Joomla template

Topic-icon Error: Something went wrong when trying to add the

More
6 years 3 days ago - 6 years 3 days ago #9540 by youwantled
youwantled created the topic: 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
Last Edit: 6 years 3 days ago by youwantled.

Please Log in to join the conversation.

More
6 years 2 days ago #9555 by ivan.milic
ivan.milic replied the topic: Re: Error: Something went wrong when trying to add the
Does the table wa89g_vm_shipping_restrictions really exists in your database?
Is the table prefix for other tables wa89g_ also?

Please Log in to join the conversation.

More
6 years 2 days ago #9570 by youwantled
youwantled replied the topic: Re: Error: Something went wrong when trying to add the
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?

Please Log in to join the conversation.

More
6 years 2 days ago #9573 by youwantled
youwantled replied the topic: Re: Error: Something went wrong when trying to add the
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.

Please Log in to join the conversation.

More
6 years 2 days ago #9574 by youwantled
youwantled replied the topic: Re: Error: Something went wrong when trying to add the
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

Please Log in to join the conversation.

Time to create page: 0.134 seconds

Links, Partners and Social Media