virtuemart_payment_plg_standard' doesn't exist

[hendrikdebeer]

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

[Jörgen]

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

[GJC Web Design]

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)'

[hendrikdebeer]

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

[hendrikdebeer]

SQL error

[hendrikdebeer]

SQL coding error

[GJC Web Design]

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

[hendrikdebeer]

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

[Jörgen]

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

[hendrikdebeer]

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?

[Jörgen]

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

[hendrikdebeer]

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

[hendrikdebeer]

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

[Jörgen]

Maybe this thread could be connected
http://forum.virtuemart.net/index.php?topic=141082.0

Jörgen @ Kreativ Fotografi

[hendrikdebeer]

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?