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!
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.
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`)
)
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 ;
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*
Better you search for this in the joomla forum, this is a joomla message. You just need to configure your mail correct.
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
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.
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
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.
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
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
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
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`)
)