News:

Support the VirtueMart project and become a member

Main Menu

Error in the conclusion of the purchase

Started by aeffe68, June 25, 2015, 11:10:40 AM

Previous topic - Next topic

aeffe68

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

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

aeffe68

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

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

aeffe68

#4
Sorry,
which language file should I change? where is it?

jenkinhill

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
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

aeffe68

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 !!!

aeffe68

#7
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"

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

aeffe68

Forgive me, is the translation of google that made me write bad in the first message

jenkinhill

OK, then turn on VM debugging in Configuration/Shop
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum