VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: sscheidegger on February 28, 2012, 11:29:00 AM

Title: Info/Error on order confirmation
Post by: sscheidegger on February 28, 2012, 11:29:00 AM
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):


        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!
Title: Re: Info/Error on order confirmation
Post by: robboh69 on February 28, 2012, 14:38:07 PM
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)

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.
Title: Re: Info/Error on order confirmation
Post by: Milbo on February 28, 2012, 15:16:07 PM
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`)
)   
Title: Re: Info/Error on order confirmation
Post by: alatak on February 28, 2012, 15:21:57 PM
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 ;
Title: Re: Info/Error on order confirmation
Post by: robboh69 on February 28, 2012, 15:40:18 PM
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*
Title: Re: Info/Error on order confirmation
Post by: Milbo on February 28, 2012, 17:47:04 PM
Better you search for this in the joomla forum, this is a joomla message. You just need to configure your mail correct.
Title: Re: Info/Error on order confirmation
Post by: robboh69 on February 28, 2012, 18:06:59 PM
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* !!!  :D
Title: Re: Info/Error on order confirmation
Post by: cas on February 28, 2012, 23:29:14 PM
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.
Title: Re: Info/Error on order confirmation
Post by: sscheidegger on February 29, 2012, 18:01:23 PM
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
Title: Re: Info/Error on order confirmation
Post by: butchtones on February 29, 2012, 22:02:59 PM
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.
Title: Re: Info/Error on order confirmation
Post by: cas on March 01, 2012, 05:35:13 AM
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
Title: Re: Info/Error on order confirmation
Post by: cas on March 04, 2012, 00:44:41 AM
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
Title: Re: Info/Error on order confirmation
Post by: supermac on March 27, 2012, 11:23:26 AM
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...
:P
Title: Re: Info/Error on order confirmation
Post by: nauck on April 03, 2012, 17:48:39 PM
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)  ;D

Quote from: Milbo on February 28, 2012, 15:16:07 PM
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`)
)