Joomla! 3.4.1 and VirtueMart 3.0.7
I have a problem that I need help with. On http://ideasgolive.co/keysandpins3jv/ I'm upgrading a virtuemart but when anyone tries go visit the cart after registering or logging in they get a page with Error: 1064.
If you go to page:
http://ideasgolive.co/keysandpins3jv/index.php/products/shaft-collars/mild-steel-solid/imperial-range_550c5d8957905/5-16-shaft-collar-mild-steel-detail
Add a load of them (needs more than £16) then try to go through the checkout.
When I changed to Breez templage the checkout gave me this error:
#1146 Table 'ideasgol_keys.lr59t_virtuemart_payment_plg_standard' doesn't exist SQL=INSERT INTO `lr59t_virtuemart_payment_plg_standard` (`id`,`virtuemart_order_id`,`order_number`,`virtuemart_paymentmethod_id`,`payment_name`,`payment_order_total`,`payment_currency`,`email_currency`,`cost_per_transaction`,`cost_percent_total`,`tax_id`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','182','68d80160','2','<span class=\"vmpayment_name\">Invoice</span><br />','23.61','GBP','52','','','','2015-04-08 12:20:14','463','2015-04-08 12:20:14','463')
It seems to only happen once you fill in your address details. Any ideas???
VM with Joomla 3.4.1 has a lot issues. You need to wait until VM 3.0.7 stable is released and hope your problem will be fixed.
oh Mad King, The error above has nothing todo with joomla or the vm version. It is just a not correctly installed AIO.
#1146 Table 'ideasgol_keys.lr59t_virtuemart_payment_plg_standard' doesn't exist SQL=INSERT INTO
Means the table of the payment plugin standard does not exist. Which usually happens, when the installation routine does an error. There are soo many people using this plugin with all versions of j2.5.x, j3.3. and j3.4 that it has nothing todo with stable or not.
Quoteoh Mad King, The error above has nothing todo with joomla or the vm version. It is just a not correctly installed AIO.
#1146 Table 'ideasgol_keys.lr59t_virtuemart_payment_plg_standard' doesn't exist SQL=INSERT INTO
Means the table of the payment plugin standard does not exist. Which usually happens, when the installation routine does an error. There are soo many people using this plugin with all versions of j2.5.x, j3.3. and j3.4 that it has nothing todo with stable or not.
How do I fix this? Will just installing VM again sort this?
Thanks,
John
Quote from: Milbo on April 08, 2015, 17:04:41 PM
oh Mad King, The error above has nothing todo with joomla or the vm version. It is just a not correctly installed AIO.
#1146 Table 'ideasgol_keys.lr59t_virtuemart_payment_plg_standard' doesn't exist SQL=INSERT INTO
Means the table of the payment plugin standard does not exist. Which usually happens, when the installation routine does an error. There are soo many people using this plugin with all versions of j2.5.x, j3.3. and j3.4 that it has nothing todo with stable or not.
Sorry about that
try reinstalling just the AIO first
Hi GJC - I tried reinstalling AIO and didn't work. Still no cart access when logged in??? Any ideas anyone???
Hi all - don't know if this helps but when playing around in test copy of the site while loged in and in product I get these system masages:
vmError: $link["view"] is empty
Any help????
Try this.
1. Enable database Update tools in VirtueMart Configuration.
2. Go to Tools >> Tools & Migration. Now click on "Install or if necessary update tables" icon.
This works for the normal tables, Jumbo, but not for the plugin. The plugins are created/checked storing a method (shipment, payment, userfield, custom). Else you can use the "table updater" of the AIO.
Milbo, yes I knew that. But I could not able to open AIO Component or see its Table Updater feature in the recent version of VM 3. So I thought probably you have merged them all together.
Yep in 3 so no AIO available... any ideas???
Simply "install the AIO"!
go here and look for right release : http://dev.virtuemart.net/projects/virtuemart/files
the AIO end with aio.zip
I did install AIO and ideas??? What I was referring to was the AIO component like for VM2.
perhaps on downloading another AIO release ? Can be it's a bug in the package
I tried 3 of them. anyone have a mysql query I could run or something???
Thanks,
are u still on this problem?
Table 'ideasgol_keys.lr59t_virtuemart_payment_plg_standard' doesn't exist
extract the payment std plugin from the AIO - zip it and install -- if all the other ideas don't work
Hi GJC Web Design,
Yep still having a problem. I loaded the payment std plugin by it's self and it installed fine. Sill not able to be logged in and go to the checkout cart? If I go to http://ideasgolive.co/keysandpins3jv/index.php/products/shaft-collars/cart I get - Error: 1064
Quote from: Milbo on April 10, 2015, 12:22:59 PM
The plugins are created/checked storing a method (shipment, payment, userfield, custom). Else you can use the "table updater" of the AIO.
First the thing with the AIO, I dont understand why it works for some people and for others not.
Using the "table updater" of the AIO should have the same effect as going in your shipment method and to store it again.
http://ideasgolive.co/keysandpins3jv/index.php/products/shaft-collars/cart fine here.. is this now fixed?
It's not working if you try to register at checkout or login and try to visit the cart. Were you able to checkout?
Help please.......
Hi,
try to add a menu link to the cart.
If this not working then you have to fix the router file : JOOMLAROOT\components\com_virtuemart\router.php
change
if(!isset($query['Itemid'])){
if ( isset($jmenu['cart']) ) {
$query['Itemid'] = $jmenu['cart'];
} else if ( isset($jmenu['virtuemart']) ) {
$query['Itemid'] = $jmenu['virtuemart'];
}
}
$segments[] = $helper->lang('cart') ;
to
if ( isset($jmenu['cart']) ) $query['Itemid'] = $jmenu['cart'];
else {
$segments[] = $helper->lang('cart') ;
$query['Itemid'] = $jmenu['virtuemart'];
}
To see if this come from router, disable SEF in JOOMLA and try all the steps.
thanks Studio 42, this didn't change anything. I was so hopeful. With sef on or off there was no joy.
http://dev.virtuemart.net/attachments/download/939/com_virtuemart.3.0.7.2_extract_first.zip. Provided fix model user.php seems to solve the part of the problem. Now I can make it to the cart but if I try to confirm the order I get Error: 1146. Any Ideas guys????
Hi, i have joomla 3.3.6 and vm 3.0.4
I set up my frontpage to vm front page, refresh my site and come this:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 SQL=SELECT params FROM ejbce_jarvis_template_styles WHERE style_id =
And if i making order, after the payment come the same.
Please help me, what is wrong!
Thank you!
QuoteSELECT params FROM ejbce_jarvis_template_styles
Shows the error is related to your Joomla template.
The Joomla & VM versions are well out of date. Current is J3.4.3 and VM3.0.9.4
Quote from: jenkinhill on July 21, 2015, 23:42:52 PM
QuoteSELECT params FROM ejbce_jarvis_template_styles
Shows the error is related to your Joomla template.
The Joomla & VM versions are well out of date. Current is J3.4.3 and VM3.0.9.4
OK, Thank You!