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_payment_plg_standard' doesn't exist

Started by hendrikdebeer, September 21, 2018, 20:49:05 PM

Previous topic - Next topic

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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

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


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

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

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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

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

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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?