Customers which have an email-address containing a "-" (dash) are not able to register or order products.
The email-address is rejected as it is not recognized as a proper address.
http://forum.opencart.com/viewtopic.php ... 892#p98892roeligan wrote:A client of mine just called me with the following issue:
Customers which have an email-address containing a "-" (dash) are not able to register or order products.
The email-address is rejected as it is not recognized as a proper address.
Request Reviews v1.0 released.
Error on this line
// RegEx
$define('EMAIL_PATTERN', '/^[A-Z0-9._%\-+]+@[A-Z0-9][A-Z0-9.-]{0,61}[A-Z0-9]\.[A-Z]{2,6}$/i');
Thks
Celestial - Martín Abel Rosales
WhatsApp: 50671482211
Email: martinrosales2012@hotmail.com
Skype: martin.abel.rosales
San José , Costa Rica
r130 - Various bug fixes since 1.4.9.1 - Added email regex defines to the index.php files
I take from here and i think is for 1.4.9.1
Celestial - Martín Abel Rosales
WhatsApp: 50671482211
Email: martinrosales2012@hotmail.com
Skype: martin.abel.rosales
San José , Costa Rica
// RegEx
$define('EMAIL_PATTERN', '/^[A-Z0-9._%\-+]+@[A-Z0-9][A-Z0-9.-]{0,61}[A-Z0-9]\.[A-Z]{2,6}$/i');
Celestial - Martín Abel Rosales
WhatsApp: 50671482211
Email: martinrosales2012@hotmail.com
Skype: martin.abel.rosales
San José , Costa Rica
I enabled and setup PayPal Standard and Flat Rate shipping plus I inserted a new currency for AU Dollars (AUD). I then selected AU Dollars and did a test order. What I found is that all amounts look okay on the final ordering page but post confirmation of the order when I'm redirected to PayPal the Postage and Packing amount is missing.
I then changed the currency to GBP and tried again. This time the Postage and Packing did appear when redirected to PayPal. In fact it seems to work with any of the currencies (Euro, Pounds, US Dollar) that came with OC but not with the AU Dollar which I added.
Can someone please confirm if this is a real issue or have I missed something when inserting the currency?
Change catalog/view/theme/template/default/mail/order_confirm.tpl
Find:
Code: Select all
<th align="left" style="color: #FFFFFF;"><?php echo $column_model; ?></th>
Code: Select all
<th align="left" style="padding: 0.3em; color: #FFFFFF;"><?php echo $column_model; ?></th>
Code: Select all
<td align="left"><?php echo $product['name']; ?>
Code: Select all
<td align="left"><?php echo $product['model']; ?>
Code: Select all
<td align="left"><?php echo $product['model']; ?></td>
Code: Select all
<td align="left"><?php echo $product['name']; ?></td>
For modelcars cars see my OC 3.0.2.0 shop: http://www.gbcars.nl/
For Wooden Toys see my 2.3.0.2 shop: https://www.dehoutentreinenwinkel.nl/
Sorry my bad - for some reason when I had used the clear function in my PayPal shipping calculations section it inserted $0 amounts as the shipping cost hence the effect above.ianm wrote:I've installed a fresh copy of 1.4.9.1 on a local web server and may have come across a bug.
I enabled and setup PayPal Standard and Flat Rate shipping plus I inserted a new currency for AU Dollars (AUD). I then selected AU Dollars and did a test order. What I found is that all amounts look okay on the final ordering page but post confirmation of the order when I'm redirected to PayPal the Postage and Packing amount is missing.
I then changed the currency to GBP and tried again. This time the Postage and Packing did appear when redirected to PayPal. In fact it seems to work with any of the currencies (Euro, Pounds, US Dollar) that came with OC but not with the AU Dollar which I added.
Can someone please confirm if this is a real issue or have I missed something when inserting the currency?
Not quite sure about this one. There is an issue with the model column being wider than the product name column. But you are swapping the model and the product name. I would think leaving them in the same place would be better but with the fixed widths. So I guess the fix would be:Gerrit wrote:In the order_confirm template is an error, or an overlooked thing.
Change catalog/view/theme/template/default/mail/order_confirm.tpl
Find:Change:Code: Select all
<th align="left" style="color: #FFFFFF;"><?php echo $column_model; ?></th>
Find:Code: Select all
<th align="left" style="padding: 0.3em; color: #FFFFFF;"><?php echo $column_model; ?></th>
Change:Code: Select all
<td align="left"><?php echo $product['name']; ?>
Find 2 lines belowCode: Select all
<td align="left"><?php echo $product['model']; ?>
Change:Code: Select all
<td align="left"><?php echo $product['model']; ?></td>
G.Code: Select all
<td align="left"><?php echo $product['name']; ?></td>
EDIT: catalog/view/theme/template/default/mail/order_confirm.tpl
FIND:
Code: Select all
<th align="left" style="width: 15%; padding: 0.3em; color: #FFFFFF;"><?php echo $column_product; ?></th>
<th align="left" style="color: #FFFFFF;"><?php echo $column_model; ?></th>
Code: Select all
<th align="left" style="padding: 0.3em; color: #FFFFFF;"><?php echo $column_product; ?></th>
<th align="left" style="width: 15%; padding: 0.3em; color: #FFFFFF;"><?php echo $column_model; ?></th>
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
I've downloaded the file errored. i am again dowload oc files and upload admin/controller/sale/order.php fixedXsecrets wrote:that's going to be a language pack issue not an opencart bug.
Thanks for the suggestion
1. EDIT: system/library/image.php
2. FIND:
Code: Select all
$extension = $info['extension'];
Code: Select all
$extension = strtolower($info['extension']);
I had a customer place an order yesterday totaling $137.74
$118.00 Item Order Cost
$118.00 Subtotal
$ 8.25 Texas Sales Tax
$ 10.00 Flat Rate Shipping Cost
$137.74 Order Total
For some reason the $ amount that was charged to the customer via PayPal was $138.56 not $137.74 (the OpenCart order total). Should the customer be charged the same $ amount in PayPal that was recorded in OpenCart?
When I log into PayPal to look at the transaction I see that the customer was charged $138.56.
What is going on? Why would PayPal not be charged the same dollar amount $137.74 that was recorded in OpenCart?
The following PayPal information was written to my Error Log
Code: Select all
2010-10-01 20:51:02 - PP_STANDARD :: IPN INIT <-- DEBUG POST VARS::mc_gross=138.56&invoice=168 - Sunny Lucas&protection_eligibility=Partially Eligible - INR Only&address_status=unconfirmed&item_number1=DD T1760 arabian red&payer_id=WRL6CZCTJF7SN&tax=10.56&address_street=604 Canyon Creek&payment_date=13:50:58 Oct 01, 2010 PDT&option_selection1_1=arabian red, Size XL (Size 14 to 16)&payment_status=Completed&charset=windows-1252&address_zip=75904&mc_shipping=10.00&mc_handling=0.00&first_name=Sunny&mc_fee=4.32&address_country_code=US&address_name=Sunny Lucas¬ify_version=3.0&custom=qnmd&payer_status=verified&business=emailus@shopcelebrity.net&address_country=United States&num_cart_items=1&mc_handling1=0.00&address_city=Lufkin&verify_sign=AcyJTfTfbKe4d9xKsP1QPwCRLjzJAJ.1kYafPL4WUT8ooCISZs75EuXT&payer_email=sunnyd557@yahoo.com&mc_shipping1=10.00&option_name1_1=Color, Size&contact_phone=&txn_id=0SX60797JW387564H&payment_type=instant&last_name=Lucas&address_state=TX&item_name1=Bengali Dancer Peasant Top&receiver_email=emailus@shopcelebrity.net&payment_fee=4.32&quantity1=1&receiver_id=KMTWRVHVY6GR2&txn_type=cart&mc_gross_1=128.00&mc_currency=USD&residence_country=US&transaction_subject=qnmd&payment_gross=138.56&
2010-10-01 20:51:03 - PP_STANDARD :: IPN REQ --> cmd=_notify-validate&mc_gross=138.56&invoice=168+-+Sunny+Lucas&protection_eligibility=Partially+Eligible+-+INR+Only&address_status=unconfirmed&item_number1=DD+T1760+arabian+red&payer_id=WRL6CZCTJF7SN&tax=10.56&address_street=604+Canyon+Creek&payment_date=13%3A50%3A58+Oct+01%2C+2010+PDT&option_selection1_1=arabian+red%2C+Size+XL+%28Size+14+to+16%29&payment_status=Completed&charset=windows-1252&address_zip=75904&mc_shipping=10.00&mc_handling=0.00&first_name=Sunny&mc_fee=4.32&address_country_code=US&address_name=Sunny+Lucas¬ify_version=3.0&custom=qnmd&payer_status=verified&business=emailus%40shopcelebrity.net&address_country=United+States&num_cart_items=1&mc_handling1=0.00&address_city=Lufkin&verify_sign=AcyJTfTfbKe4d9xKsP1QPwCRLjzJAJ.1kYafPL4WUT8ooCISZs75EuXT&payer_email=sunnyd557%40yahoo.com&mc_shipping1=10.00&option_name1_1=Color%2C+Size&contact_phone=&txn_id=0SX60797JW387564H&payment_type=instant&last_name=Lucas&address_state=TX&item_name1=Bengali+Dancer+Peasant+Top&receiver_email=emailus%40shopcelebrity.net&payment_fee=4.32&quantity1=1&receiver_id=KMTWRVHVY6GR2&txn_type=cart&mc_gross_1=128.00&mc_currency=USD&residence_country=US&transaction_subject=qnmd&payment_gross=138.56
2010-10-01 20:51:03 - PP_STANDARD :: IPN RESP <-- VERIFIED
2010-10-01 20:51:03 - PP_STANDARD :: VALIDATION FAILED : PP_Standard - Possible Scam: IPN/PDT Price "138.56" does not match OpenCart Total "137.7350". Order needs manual verification.
2010-10-01 20:51:06 - PP_STANDARD :: PDT INIT <-- DEBUG GET VARS::route=payment/pp_standard/pdt&tx=0SX60797JW387564H&st=Completed&amt=138.56&cc=USD&cm=qnmd&item_number=&
2010-10-01 21:03:51 - PP_STANDARD :: IPN INIT <-- DEBUG POST VARS::mc_gross=-138.56&invoice=168 - Sunny Lucas&protection_eligibility=Partially Eligible - INR Only&item_number1=DD T1760 arabian red&payer_id=WRL6CZCTJF7SN&address_street=604 Canyon Creek&payment_date=14:03:37 Oct 01, 2010 PDT&option_selection1_1=arabian red, Size XL (Size 14 to 16)&payment_status=Refunded&charset=windows-1252&address_zip=75904&mc_shipping=10.00&mc_handling=0.00&first_name=Sunny&mc_fee=-4.32&address_country_code=US&address_name=Sunny Lucas¬ify_version=3.0&reason_code=refund&custom=qnmd&business=emailus@shopcelebrity.net&address_country=United States&mc_handling1=0.00&address_city=Lufkin&verify_sign=AQEgFLG-gYJRPNwVRAb4gD.Dx6t9AH5qGyXdtJlOHoQYM.2ZzljIUyDv&payer_email=sunnyd557@yahoo.com&mc_shipping1=10.00&parent_txn_id=0SX60797JW387564H&option_name1_1=Color, Size&contact_phone=&txn_id=6DW70281A02973521&payment_type=instant&last_name=Lucas&address_state=TX&item_name1=Bengali Dancer Peasant Top&receiver_email=emailus@shopcelebrity.net&payment_fee=-4.32&quantity1=1&receiver_id=KMTWRVHVY6GR2&mc_gross_1=128.00&mc_currency=USD&residence_country=US&transaction_subject=qnmd&payment_gross=-138.56&
2010-10-01 21:03:51 - PP_STANDARD :: IPN REQ --> cmd=_notify-validate&mc_gross=-138.56&invoice=168+-+Sunny+Lucas&protection_eligibility=Partially+Eligible+-+INR+Only&item_number1=DD+T1760+arabian+red&payer_id=WRL6CZCTJF7SN&address_street=604+Canyon+Creek&payment_date=14%3A03%3A37+Oct+01%2C+2010+PDT&option_selection1_1=arabian+red%2C+Size+XL+%28Size+14+to+16%29&payment_status=Refunded&charset=windows-1252&address_zip=75904&mc_shipping=10.00&mc_handling=0.00&first_name=Sunny&mc_fee=-4.32&address_country_code=US&address_name=Sunny+Lucas¬ify_version=3.0&reason_code=refund&custom=qnmd&business=emailus%40shopcelebrity.net&address_country=United+States&mc_handling1=0.00&address_city=Lufkin&verify_sign=AQEgFLG-gYJRPNwVRAb4gD.Dx6t9AH5qGyXdtJlOHoQYM.2ZzljIUyDv&payer_email=sunnyd557%40yahoo.com&mc_shipping1=10.00&parent_txn_id=0SX60797JW387564H&option_name1_1=Color%2C+Size&contact_phone=&txn_id=6DW70281A02973521&payment_type=instant&last_name=Lucas&address_state=TX&item_name1=Bengali+Dancer+Peasant+Top&receiver_email=emailus%40shopcelebrity.net&payment_fee=-4.32&quantity1=1&receiver_id=KMTWRVHVY6GR2&mc_gross_1=128.00&mc_currency=USD&residence_country=US&transaction_subject=qnmd&payment_gross=-138.56
2010-10-01 21:03:51 - PP_STANDARD :: IPN RESP <-- VERIFIED
Users browsing this forum: No registered users and 72 guests