Good day
I have the following error when I click on CONFIRM ORDER in Cart layout. 1146 Table {prefix}#__virtuemart_payment_plg_standard' doesn't exist.
Does someone have the SQL code for this table.
I already tried (fix tables) in Joomla, repair database in CPanel, uploaded the latest AIO file - nothing seems to work. (so far)
Joomla! 3.8.12 PHP 7.1.22 VirtueMart 3.4.0
Hello
You should use the "Install tables and if necessary update tables" in VM /tools/tools&migration.
This works even if You have not switched on tools in configuration.
Jörgen @ Kreativ Fotografi
if it doesn't the table is
'id' => 'int(1) UNSIGNED NOT NULL AUTO_INCREMENT',
'virtuemart_order_id' => 'int(1) UNSIGNED',
'order_number' => 'char(64)',
'virtuemart_paymentmethod_id' => 'mediumint(1) UNSIGNED',
'payment_name' => 'varchar(5000)',
'payment_order_total' => 'decimal(15,5) NOT NULL DEFAULT \'0.00000\'',
'payment_currency' => 'char(3)',
'email_currency' => 'char(3)',
'cost_per_transaction' => 'decimal(10,2)',
'cost_min_transaction' => 'decimal(10,2)',
'cost_percent_total' => 'decimal(10,2)',
'tax_id' => 'smallint(1)'
Thanks @gjcWebDesign
I tried this code in my SQL area of the database. I'm not much of a coding person - and I'm pretty sure I'm missing something somewhere
'b15oq_virtuemart_payment_plg_standard'
(
'id' => 'int(1) UNSIGNED NOT NULL AUTO_INCREMENT',
'virtuemart_order_id' => 'int(1) UNSIGNED',
'order_number' => 'char(64)',
'virtuemart_paymentmethod_id' => 'mediumint(1) UNSIGNED',
'payment_name' => 'varchar(5000)',
'payment_order_total' => 'decimal(15,5) NOT NULL DEFAULT \'0.00000\'',
'payment_currency' => 'char(3)',
'email_currency' => 'char(3)',
'cost_per_transaction' => 'decimal(10,2)',
'cost_min_transaction' => 'decimal(10,2)',
'cost_percent_total' => 'decimal(10,2)',
'tax_id' => 'smallint(1)')
This code doesn't work
SQL error
SQL coding error
of course not.. u have to turn it into a sql statement -- this is just an array
here
CREATE TABLE `6qp_virtuemart_payment_plg_standard` (
`id` int(1) UNSIGNED NOT NULL,
`virtuemart_order_id` int(1) UNSIGNED DEFAULT NULL,
`order_number` char(64) DEFAULT NULL,
`virtuemart_paymentmethod_id` mediumint(1) UNSIGNED DEFAULT NULL,
`payment_name` varchar(5000) DEFAULT NULL,
`payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000',
`payment_currency` char(3) DEFAULT NULL,
`email_currency` char(3) DEFAULT NULL,
`cost_per_transaction` decimal(10,2) DEFAULT NULL,
`cost_min_transaction` decimal(10,2) DEFAULT NULL,
`cost_percent_total` decimal(10,2) DEFAULT NULL,
`tax_id` smallint(1) DEFAULT NULL,
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) NOT NULL DEFAULT '0',
`locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`locked_by` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Payment Standard Table';
change the table prefix
I'm getting the following error message from the database
I hope I'm on the verge of a breakthrough
Thanks again GJC Web Design
I suck at coding!
Error
SQL query:
CREATE TABLE `b15oq_virtuemart_payment_plg_standard` (
`id` int(1) UNSIGNED NOT NULL,
`virtuemart_order_id` int(1) UNSIGNED DEFAULT NULL,
`order_number` char(64) DEFAULT NULL,
`virtuemart_paymentmethod_id` mediumint(1) UNSIGNED DEFAULT NULL,
`payment_name` varchar(5000) DEFAULT NULL,
`payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000',
`payment_currency` char(3) DEFAULT NULL,
`email_currency` char(3) DEFAULT NULL,
`cost_per_transaction` decimal(10,2) DEFAULT NULL,
`cost_min_transaction` decimal(10,2) DEFAULT NULL,
`cost_percent_total` decimal(10,2) DEFAULT NULL,
`tax_id` smallint(1) DEFAULT NULL,
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) NOT NULL DEFAULT '0',
`modified_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) NOT NULL DEFAULT '0',
`locked_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`locked_by` int(11) NOT NULL DEFAULT '0'
) [...]
MySQL said: Documentation
#1046 - No database selected
I do not understand why You should have to do this ???
This should be done by plugin install, activation of plugin or table updater.
Have You tried the "Install tables and if necessary update tables" in VM /tools/tools&migration.
Jörgen @ Kreativ Fotografi
Hi Jörgen @ Kreativ Fotografi
I'm not sure why I have these issues:
1. I have run a scan & repair from my cPanel MySQL Database
2. I have run a table fix from Extensions>Manage>Database>fix
3. I have run Install tables and if necessary update tables" in VM /tools/tools&migration.
4. I have installed the latest version of Joomla, VirtueMart, PHP
I don't know what else to try?
1. Please check that the plugin "VM Payment - Standard" is installed and active.
2. If there is still trouble check the payment options and see if You have a standard payment active and working. If not create one.
If I remember correctly every payment option has an index number. This number is stored in the order. If there isn´t a payment option with the correct ID i think You get unexpected results. If the payment option still doesn´t work please create a new copy of the standard payment option with a new name. Do not delete the old one, just deactivate it. If the new option works. Try to activate the old one and see if everything is OK. If not you may be forced to delete the "old" payment option and create a new one. If You have orders that use the "old" payment option, You can not delete this entry without creating a new one with the same index. This I think can be done by changing the index with PhpMyAdmin. But I hope You do not have to do this.
Jörgen @ Kreativ Fotografi
I received this error when confirming order, 1146 Table 'pjtessal_datbas1.#__virtuemart_payment_plg_standard' doesn't exist.
So then I deleted the standard payment option and created a new payment for PAYPAL. When I saved that option I received this message: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key
Now I'm getting a PAYPAL error 1146 Table 'pjtessal_datbas1.#__virtuemart_payment_plg_paypal' doesn't exist
It is as if the tables are not writing correctly.
I have checked the database - I have all the privileges
Maybe this thread could be connected
http://forum.virtuemart.net/index.php?topic=141082.0 (http://forum.virtuemart.net/index.php?topic=141082.0)
Jörgen @ Kreativ Fotografi
I had Hikashop and sellacious installed before, but I deleted it, but for some reason the database still picks up some elements that is not active. Do you think there might be conflicts?
Rely no good ideas, have You checked that there are not any plugins connected to Hikashop or sellacious ?
Otherwise I think that this more related to the issue I gave the link to.
Jörgen @ Kreativ Fotografi
Max is also on the case, and he doesn't even know what the issue might.
We solved the issue __virtuemart_shipment_plg_weight_countries`, then the next error occurred
__virtuemart_payment_plg_standard' doesn't exist
We ran the SQL Code for Shipment Weight Countries Table, and it seems to work, now I only need the SQL code for virtuemart_payment_plg_standard'
Hopefully that will work!
Have You tried to uncomment the line in the file:administrator/components/com_virtuemart/models/custom.php line 412
// $error = $dispatcher->trigger('plgVmOnStoreInstallPluginTable', array('custom' , $data, $table));
Jörgen @ Kreativ Fotografi
Jörgen, that is not the problem here.
He started with vm3.2.14 and the installer should install the tables, as you said. The trigger was accidently commented for the customfields, but not payment/shipment.
When he runs the table updater within the aio, then the server holds. From my point of view, there is the main problem.
OK, good to know. Hope we can catch this.
Jörgen @ Kreativ Fotografi
Quote from: Jörgen on September 25, 2018, 21:47:43 PM
Have You tried to uncomment the line in the file:administrator/components/com_virtuemart/models/custom.php line 412
// $error = $dispatcher->trigger('plgVmOnStoreInstallPluginTable', array('custom' , $data, $table));
Jörgen @ Kreativ Fotografi
array('custom'
this trigger is only for the 3rd party customplugins interesting.