Info/Error on order confirmation

[sscheidegger]

Hi,

Since I updated to VM2.0.2. and J2.5.1 I get the following message on the order confirmation page (order seems to be successfull nevertheless):

Code Select Expand


        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_payment_plg_standard has not any entry for the order
        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_payment_plg_standard has not any entry for the order
        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_payment_plg_standard has not any entry for the order


I have two payment methods (invoice and paypal) and several shipment methods depending on country and weight.

Any idea what could cause these messages?

Thanks for your help!

[robboh69]

After just having installed 2.0.2 (without errormessages!) on my joomla 1.7.3 I get the same error info: Attention, #__virtuemart_payment_plg_standard has not any entry for the order

This is a message after hitting "confirm order" shown to the customer. (I xxxxx'ed out some "confidential" infos)

Code Select Expand

vmError: VmTableData::store failed - Unknown column 'payment_order_total' in 'field list' SQL=INSERT INTO `xxxx_virtuemart_payment_plg_standard`
(`id`,`virtuemart_order_id`,`order_number`,`virtuemart_paymentmethod_id`,`payment_name`,`payment_order_total`,`payment_currency`,
`cost_per_transaction`,`cost_percent_total`,`tax_id`,`created_on`,`created_by`,`modified_on`,`modified_by`)
VALUES ('0','13','xxxxx','1','xxxxx','380','SEK','0','0','0','2012-02-28 13:24:04','42','2012-02-28 13:24:04','42')

Also I get "could not initiate mailfunction" and I do not recieve any emailconfirmation of the order.

[Milbo]

The message means, that there is no data for the order stored. I think in your case it is just a message, ...
We just enhanced the aio using also the table updater of the core. We are going to provide a new version very soon. There are some small obstacles with the extensions atm. Check the table, it should look like that:
CREATE TABLE `jos_virtuemart_shipment_plg_weight_countries` (
   `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT,
   `virtuemart_order_id` INT(11) UNSIGNED NULL DEFAULT NULL,
   `order_number` CHAR(32) NULL DEFAULT NULL,
   `virtuemart_shipmentmethod_id` MEDIUMINT(1) UNSIGNED NULL DEFAULT NULL,
   `shipment_name` CHAR(255) NOT NULL DEFAULT '',
   `order_weight` DECIMAL(10,4) NULL DEFAULT NULL,
   `shipment_weight_unit` CHAR(3) NULL DEFAULT 'KG',
   `shipment_cost` DECIMAL(10,2) NULL DEFAULT NULL,
   `shipment_package_fee` DECIMAL(10,2) NULL DEFAULT NULL,
   `tax_id` SMALLINT(1) NULL 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',
   PRIMARY KEY (`id`)
)   

[alatak]

Hi,

Yes, and also check for the Standard payment that the table is this one



CREATE TABLE `xxx_virtuemart_payment_plg_standard` (
  `id` int(1) unsigned NOT NULL AUTO_INCREMENT,
  `virtuemart_order_id` int(1) unsigned DEFAULT NULL,
  `order_number` char(32) 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,
  `cost_per_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',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Payment Standard Table' AUTO_INCREMENT=1 ;

[robboh69]

Thanx guys.
While you were answering I actually added the missing column payment_order_total  in the table virtuemart_payment_plg_standard from phpmyadmin.

( `payment_order_total` decimal(15,5) NOT NULL DEFAULT '0.00000' )

Now that error message dissapeared, and things seem to work good. How ever! I still don't get an email confirmation... "..could not initiate mailfunction", but I guess I will have to search the answer to that problem elsewhere in this forum.. *hint hint*

[Milbo]

Better you search for this in the joomla forum, this is a joomla message. You just need to configure your mail correct.

[robboh69]

Thankyou Milbo! That solved the emailing issues for me!

For the first time ever (?) I am up to par with updates/fixes on VM. That certainly has never happend pre 2.0 *Great Job* !!! 

[cas]

I am having a similar error as sscheidegger.   I have Joomla 2.5.1 and VM2.0.2.  Just updated from VM2.0.1.K where it works fine.  Now it goes to PayPal just fine, but then when I cancel the order in PayPal and it returns back to VM, I get this error.  (Note that I changed some info to 'xxx')

Warning

        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order

Notice

        Could not instantiate mail function.
        Could not instantiate mail function.

info

        Info: Message sent to xxxuser, xxx@xxx.com

Could not instantiate mail function. Could not instantiate mail function.

[sscheidegger]

Milbo and alatak

Thanks a lot, this helped! Both tables looked very different for me! Apparently they were not updated correctly from an old RC version of VM (1.9.8 something). I think I'll compare the db structure of my installation with a clean installation to see if there are more differences.

Best,
Stefan

[butchtones]

I had the could not initiate mail function error yesterday.  In joomla - go to GLOBAL CONFIGURATION ->MAIL SETTINGS

I had to change mine from PHP to Sendmail.

Hope that helps.

[cas]

Hi butchtones,

I changed the mail from PHP to Sendmail, but now I get this error:

Warning

        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order
        Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order

Notice

        Could not execute: /var/qmail/bin/sendmail
        Could not execute: /var/qmail/bin/sendmail

info

        Info: Message sent to xxxuser, xxx@xxx.com

Could not execute: /var/qmail/bin/sendmail Could not execute: /var/qmail/bin/sendmail

[cas]

VM team,

Can I get help?  I cannot upgrade to VM2.0.2 until this warning is resolved:  Info: Attention, #__virtuemart_shipment_plg_weight_countries has not any entry for the order

[supermac]

In my VM2.0.2 db tables, ID field's datatype in table #__virtuemart_shipment_plg_weight_countries was tinyint, that's why the error appears: when you reach record n.255 it doesn't store anything more.... if you change it to Int(1) it disappears.
I found the same bug in paypal (xxx_virtuemart_payment_plg_paypal) and standard (xxx_virtuemart_payment_plg_standard) payment table (VM 2.0.2) as Alatak says...

[nauck]

THANKS! THAT did the job for me, now it works again. (While updating, an older version of VM made some problems, now it's fixed) 

Check the table, it should look like that:
CREATE TABLE `jos_virtuemart_shipment_plg_weight_countries` (
   `id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT,
   `virtuemart_order_id` INT(11) UNSIGNED NULL DEFAULT NULL,
   `order_number` CHAR(32) NULL DEFAULT NULL,
   `virtuemart_shipmentmethod_id` MEDIUMINT(1) UNSIGNED NULL DEFAULT NULL,
   `shipment_name` CHAR(255) NOT NULL DEFAULT '',
   `order_weight` DECIMAL(10,4) NULL DEFAULT NULL,
   `shipment_weight_unit` CHAR(3) NULL DEFAULT 'KG',
   `shipment_cost` DECIMAL(10,2) NULL DEFAULT NULL,
   `shipment_package_fee` DECIMAL(10,2) NULL DEFAULT NULL,
   `tax_id` SMALLINT(1) NULL 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',
   PRIMARY KEY (`id`)
)