VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: aeffe68 on June 25, 2015, 11:10:40 AM

Title: Error in the conclusion of the purchase
Post by: aeffe68 on June 25, 2015, 11:10:40 AM
Hello everyone,
I'm using version 3.0.4 VirtueMart, I configured the store without problems, but when I try to make a purchase and I ask you to confirm the order, I get out this message:

Message

Entered Invalid date

Someone would know help me?
Thanks in advance
Title: Re: Error in the conclusion of the purchase
Post by: jenkinhill on June 25, 2015, 11:38:31 AM
Start by using a current VirtueMart version (3.0.4 is known to be insecure)  http://forum.virtuemart.net/index.php?topic=118683

And provide a url.
Title: Re: Error in the conclusion of the purchase
Post by: aeffe68 on June 25, 2015, 11:55:47 AM
Thanks for your response, but I unfortunately I find myself with that version of virtuemart as I purchased a template that contained it already.
Now, how can I do to solve this problem without having to delete all?
below place the url of the site in question:
www.vitaminsboost.it
username demoboost
passw boost123
Title: Re: Error in the conclusion of the purchase
Post by: jenkinhill on June 25, 2015, 13:37:06 PM
As it is a commercial template and obviously has specially re-written template files, it is difficult for anyone here to be able to state exactly what the problem is. 

Does one of your delivery methods ask for the customer to select a delivery date?  If so then check that function. Also make sure that the format set in the date language string (usually DATE_FORMAT_LC4="m-d-Y" ) is the same as the date format as you would usually use.   If not then create a language override with the correct format.

Refs:  http://forum.virtuemart.net/index.php?topic=108212.0   http://forum.virtuemart.net/index.php?topic=113895.0

You really should update the VM version, as the one you are using does have known security problems and should never be used for a live store site where customer data could be compromised. OR ask the template supplier for an updated (secure) version.
Title: Re: Error in the conclusion of the purchase
Post by: aeffe68 on June 25, 2015, 15:04:56 PM
Sorry,
which language file should I change? where is it?
Title: Re: Error in the conclusion of the purchase
Post by: jenkinhill on June 25, 2015, 16:51:44 PM
You don't edit the language file, you make an override as described in the links:  http://forum.virtuemart.net/index.php?topic=113895.0
Title: Re: Error in the conclusion of the purchase
Post by: aeffe68 on June 26, 2015, 10:09:06 AM
thanks for your help, but I'm really going crazy ....
Now it turns out this error message when I confirm the order:
1054 - Unknown column 'customer_number' in 'field list' SQL = INSERT INTO `jos_virtuemart_orders` (`virtuemart_order_id`,`virtuemart_user_id`,`virtuemart_vendor_id`,`order_number`,`order_pass`,`customer_number`,`order_total`,`order_salesPrice`,`order_billTaxAmount`,`order_billTax`,`order_billDiscountAmount`,`order_discountAmount`,`order_subtotal`,`order_tax`,`order_shipment`,`order_shipment_tax`,`order_payment`,`order_payment_tax`,`coupon_discount`,`order_discount`,`order_currency`,`order_status`,`user_currency_id`,`user_currency_rate`,`virtuemart_paymentmethod_id`,`virtuemart_shipmentmethod_id`,`ip_address`,`order_language`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('0','0','1','ee5d03','p_3ac88','nonreg_maryguarawebmaster@accalaidesign.it','95','95','0','{\"1\":{\"virtuemart_calc_id\":1,\"calc_name\":\"Tax 20%\",\"calc_value\":\"20.0000\",\"result\":0}}','-5','-5','100','0','0','0','0','0','0','-5','47','P','47','1','5','4','151.45.80.xx','it-IT','2015-06-26 08:06:26 ',' 0 ',' 6/26/2015 08:06:26 ',' 0 ')

I'm not understanding anything !!!
Title: Re: Error in the conclusion of the purchase
Post by: aeffe68 on June 26, 2015, 12:06:11 PM
The database error I resolved, but it continues to persist that the incorrect date.
I plugged in the string override the language but there continues to be!
I do not know how I do... :'( :'( :'(
Are you sure that the error is the date?
I found the string in the language file and it is this:
COM_VIRTUEMART_CART_CHECKOUT_DATA_NOT_VALID = "Invalid data entered"
Title: Re: Error in the conclusion of the purchase
Post by: jenkinhill on June 26, 2015, 12:46:34 PM
Quote from: aeffe68 on June 25, 2015, 11:10:40 AM
Entered Invalid date

That's what you said in your first message. Are you now saying that the error is different?

Turn on VM debugging to see if that helps you to understand the problem.
Title: Re: Error in the conclusion of the purchase
Post by: aeffe68 on June 26, 2015, 13:03:21 PM
Forgive me, is the translation of google that made me write bad in the first message
Title: Re: Error in the conclusion of the purchase
Post by: jenkinhill on June 26, 2015, 15:06:12 PM
OK, then turn on VM debugging in Configuration/Shop