News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VirtueMart 3 - can't checkout

Started by revaboogy, April 08, 2015, 13:59:43 PM

Previous topic - Next topic

revaboogy

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???

MAD King

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.
Joomla! 4.4.5
VirtueMart 4.2.12 11012

Milbo

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

revaboogy

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

MAD King

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
Joomla! 4.4.5
VirtueMart 4.2.12 11012

GJC Web Design

try reinstalling just the AIO first
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

revaboogy

#6
Hi GJC - I tried reinstalling AIO and didn't work. Still no cart access when logged in??? Any ideas anyone???

revaboogy

#7
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????

Jumbo!

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.

Milbo

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Jumbo!

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.

revaboogy

Yep in 3 so no AIO available... any ideas???

Studio 42

Simply "install the AIO"!
go here and look for right release : http://dev.virtuemart.net/projects/virtuemart/files
the AIO end with aio.zip

revaboogy

#13
I did install AIO and ideas??? What I was referring to was the AIO component like for VM2.

Studio 42

perhaps on downloading another AIO release ? Can be it's a bug in the package