Author Topic: Info/Error on order confirmation  (Read 8792 times)

sscheidegger

  • Jr. Member
  • **
  • Posts: 88
Info/Error on order confirmation
« 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):

Code: [Select]
        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

  • Beginner
  • *
  • Posts: 19
Re: Info/Error on order confirmation
« Reply #1 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)

Code: [Select]
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9905
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Info/Error on order confirmation
« Reply #2 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`)
)   
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

alatak

  • Contributing Developer
  • Full Member
  • *
  • Posts: 2047
    • alatak.net
Re: Info/Error on order confirmation
« Reply #3 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 ;

robboh69

  • Beginner
  • *
  • Posts: 19
Re: Info/Error on order confirmation
« Reply #4 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*

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9905
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Info/Error on order confirmation
« Reply #5 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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

robboh69

  • Beginner
  • *
  • Posts: 19
Re: Info/Error on order confirmation
« Reply #6 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

cas

  • Jr. Member
  • **
  • Posts: 487
Re: Info/Error on order confirmation
« Reply #7 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.

sscheidegger

  • Jr. Member
  • **
  • Posts: 88
Re: Info/Error on order confirmation
« Reply #8 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

butchtones

  • Beginner
  • *
  • Posts: 27
Re: Info/Error on order confirmation
« Reply #9 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.

cas

  • Jr. Member
  • **
  • Posts: 487
Re: Info/Error on order confirmation
« Reply #10 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

cas

  • Jr. Member
  • **
  • Posts: 487
Re: Info/Error on order confirmation
« Reply #11 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

supermac

  • Jr. Member
  • **
  • Posts: 68
Re: Info/Error on order confirmation
« Reply #12 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

nauck

  • Beginner
  • *
  • Posts: 3
Re: Info/Error on order confirmation
« Reply #13 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

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