Jump to content

kdenby

Members
  • Content count

    22
  • Joined

  • Last visited

Profile Information

Recent Profile Visitors

2,885 profile views
  1. kdenby

    Country State Selector BS v3.0

    Thanks for getting back to me ... but .. I had already made those selections in the module. The state selector pulldown appears fine in a new account - ie create_account.php but once an account is created then adding a new address or editing the already created one has no pulldown (though the spinner runs on program launch) - see screenshots below. Cheers
  2. kdenby

    Country State Selector BS v3.0

    Hello Milerwan - great little contribution .... almost solved my requirement out of the box .... but ... works fine in create_account.php but when I try to add a new address to an account ie using address_book_process.php the spinner runs but I get no states pull down, only an empty input box. Not sure where to start looking for the problem but I have installed a mint version of address_book_process.php and address_book_details.php from osCommerce 234 Bootstrap Master. Any ideas? Thanks
  3. kdenby

    Auto Update Currencies

    PHP 5.3 and above has introduced a built in function - date_diff. That means trouble for auto_update_currencies.php as it has a function of the same name - so a 'cannot redeclare function date_diff' error results. Just change the name of the function date_diff to something else (eg date_diffnce) and also amend the call on line 58 to use the new name. Cheers KD
  4. kdenby

    Protx Direct v2.22

    Hi Still getting the occasional 'double card debit but only one order' from one of my Protx Direct sites. The most recent was on 3rd Dec and the two debits are 10 minutes apart 11621, 5365, 8161, '8161-82056271503113463288085348463387', 'PAYMENT', '73.0000', '{24FD78BE-7B61-6A40-7E08-A5F7CE91FACD}', 'OK', '0000 : The Authorisation was Successful.', '66073457', '48OPPRCPBZ', 'SECURITY CODE MATCH ONLY', 'NOTMATCHED', 'NOTMATCHED', 'MATCHED', 'NOTCHECKED', '', '2007-12-03 22:52:44' 11620, 5365, 8161, '8161-32439602646219811509671607244862', 'PAYMENT', '73.0000', '{BC0973AF-BAC1-EE4F-602D-FCE8CB003AEC}', 'OK', '0000 : The Authorisation was Successful.', '66072066', '6EQZNV9TDO', 'SECURITY CODE MATCH ONLY', 'NOTMATCHED', 'NOTMATCHED', 'MATCHED', 'NOTCHECKED', '', '2007-12-03 22:42:20' Could there be some sort of timing problem here? .... .These errors are pretty rare and therefore very hard to trap. Any suggestions anyone? Cheers
  5. kdenby

    Protx Direct v2.22

    Here's a weird one. One of the sites that I administer has a customer with surname o'neill and his e-mail address is of the form xxxxxx.o'neill@xxxxxx.com (I've substituted x for security). I had never realised before that an apostrophe can be a valid chr in an e-mail address - potential for :angry: consequences for php & MySQL ! Sure enuff the customer cannot get his card validated when trying to make a purchase - the error says that his e-mail address is invalid - data from the protx_direct table below 11225, 6233, 7812, '7812-07365120167873089746185187973936', 'PAYMENT', '1245.0000', '', 'INVALID', '3078 : The CustomerEMail format is invalid. The value was xxxxxx.o''neill@xxxxxx.com.', '', '', '', '', '', '', '', '', '2007-10-19 11:44:25' 11224, 6233, 7812, '7812-46863717873014966556591201770738', 'PAYMENT', '1245.0000', '', 'INVALID', '3078 : The CustomerEMail format is invalid. The value was xxxxxx.o''neill@xxxxxx.com.', '', '', '', '', '', '', '', '', '2007-10-19 11:39:18' 11223, 6233, 7812, '7812-42306462423997029001851675059116', 'PAYMENT', '1245.0000', '', 'INVALID', '3078 : The CustomerEMail format is invalid. The value was xxxxxx.o''neill@xxxxxx.com.', '', '', '', '', '', '', '', '', '2007-10-19 11:37:32' 11222, 6233, 7812, '7812-89105855799368201733643551103517', 'PAYMENT', '1245.0000', '', 'INVALID', '3078 : The CustomerEMail format is invalid. The value was xxxxxx.o''neill@xxxxxx.com.', '', '', '', '', '', '', '', '', '2007-10-19 11:34:34' As you can see there are two apostrophes - I have checked his entry in the customer address table and the e-mail address recorded there only has one apostrophe. In protx_process.php (Using v4.4) at line 261 customer e-mail address is sent as part of validation ... I guess this may be where the problem lies. Checking for a failed transaction on Protx vspadmin reveals no sign of a failed transaction ... so it looks like the data didn't make it to Protx but was rejected by the bank system. Cheers!
  6. kdenby

    Protx Direct v2.22

    Tom After a week or so of smooth running on 4.3 with 3D Secure turned on for all cards in use I have hit another duplicate payment error - looking at the protx_direct table data shows that in the first instance the transaction returned no data to the table but was authenticated by Protx - then (I guess) the customer received an error message and re-submitted, this time the table has Protx data and Protx debited the card again. Any clues? 10538, 5906, 7276, '7276-84864634186287808377431626802291', 'PAYMENT', '359.9500', '', '', '', '', '', '', '', '', '', '', '', '2007-07-21 03:12:31' 10539, 5906, 7276, '7276-44786262062956179197621581645713', 'PAYMENT', '359.9500', '{01837DD0-5BDD-4E58-9188-C661CCAF209E}', 'OK', '', '51106305', 'yahRD4IVdm', 'ALL MATCH', 'MATCHED', 'MATCHED', 'MATCHED', 'OK', 'AAABAGRRBwAAAABFUFEHAAAAAAA%3D', '2007-07-21 03:15:39'
  7. kdenby

    Protx Direct v2.22

    Tom Thanks for 4.3 - been running it live for 24 hrs and 'so far so good' with no repeat debits and all the data in protx_direct table is coherent ... so I reckon you have done it! Great and thanks a bunch for all the work.
  8. kdenby

    Protx Direct v2.22

    Tom Unfortunately now experiencing some serious problems with 4.2 and 3D Secure turned on. I have applied the javascript multiple transaction fix both to the 'Confirm' button in checkout_confirmation.php and also to the 'Complete order' button in the iframe of protx_process.php. The problems are twofold but I think they stem from the same source - Money is being taken by Protx twice or even three times for the same order OR money is taken two or three times but NO ORDER is created in osCommerce. The protx_direct table shows a confusing set of response data - some lines have much of the info missing - here are some examples 10386 847 7159 7159-36065942542914408269604589773474 PAYMENT 37.67 03/07/07 11:23 10385 847 7159 7159-56691517031330025339430666229258 PAYMENT 37.67 03/07/07 11:19 10388 925 7160 7160-93305677322855588537723040697547 PAYMENT 32.8 03/07/07 13:16 10389 5821 7161 7161-84317109666867137106086033910108 PAYMENT 11 3DAUTH You should now redirect the Customer to their issuing bank for 3D-Authentication OK 03/07/07 14:24 10390 4228 7161 7161-37473177419453332753939524886891 PAYMENT 95 03/07/07 14:25 10391 5821 7162 7162-86997650409209784545302907201282 PAYMENT 11 03/07/07 14:26 10392 5821 7162 7162-16475645938615800267061538947230 PAYMENT 11 {C6CCEF4A-08CA-45D6-B3B6-B6DD5E3A0795} OK 49578513 S5Y63un9Jy ALL MATCH MATCHED MATCHED MATCHED ATTEMPTONLY huxMpAGTXo4nAAEAAAB7KE9Pbu8%3D 03/07/07 14:29 10393 5822 7163 7163-68926275546969073244819595044360 PAYMENT 60.01 {2BB205BF-A0AB-4800-A6BF-769EE27EF5F0} ERROR The given transaction identifier is duplicate. DATA NOT CHECKED OK jOxMpAGTXo4nARACjTGFI3kcUeQ%3D 03/07/07 14:31 For order no 7161 the strange 3D Secure message seems to have caused a delay so that order no 7161 was re-allocated to a successful transaction for another customer, then the original customer has been allocated order no 7162 and Vspadmin shows the money being taken twice with a 2.5min time interval between transactions. The money for order no 7159 (£37.67) was taken twice in Vspadmin ... but in osCommerce order no 7159 is for a different customer altogether and the basket for the original 7159 is still extant. Seems to me that there is a timing issue of some sort here - I do not know if Protx provide detailed debug logs for transaction processing, so my first port of call is here on the forum. I have also had a number of duplicate payments on another site, but that client is so dismayed by the banks' dilatory and sloppy handling of the 3D secure implementation that they have decided to turn off 3D secure and challenge the banks on their poor performance. That site has exactly the same installation of 4.2 protx_direct contribution ... but they are no longer seeing multiple debits or order failures. Sorry about this bad news ... but that's IT folks!
  9. kdenby

    Protx Direct v2.22

    Thanks Tom - I too find that 4.1 now delivers the transaction data to the order in admin ... but also that there is a problem with the Void/Cancel function. I will turn on the appalling 3D Secure tomorrow and test the iframe part ... but thanks a bunch for your dedication and hard work!
  10. kdenby

    Protx Direct v2.22

    Yes ... I too have that problem with 4.0a - the customer id and the value are not being written to protx_direct table if 3DSecure is turned off (and btw what a vile mess the banks have made of 3D Secure!!! - we have had to turn it off because the number of confused/alarmed customer phone calls rocketed) I had a quick look at the code in protx_process.php but cannot see the problem - changes from 3.1a are too great for that to be much use as a comparison. Cheers Keith
  11. kdenby

    Protx Direct v2.22

    Hello I have been tracking a problem with repeat card debits by Protx for the same osCommerce order since moving to the 3D secure version of the Protx direct contrib (using Vn 3.1a). Now I have proof positive - I can see only one order in osCommerce back office. This order shows 3 payments taken from the customer's card - with a time separation of 2 secs. I guess there is a problem with the customer multiple clicking impatiently, but versions of Protx Direct contrib prior to 3D secure implementation were not vulnerable to this error - any timescale for the fix that was offered a short while back? Cheers & thanks for a fine contribution. Keith
  12. kdenby

    QBI Quickbooks Import

    I need a Quickbooks Importer for Quickbooks Regular 2004 for the UK - will I be able to use QB! V2.10 or do I need to wait for Vn 3 ? Cheers Keith Denby
  13. Hmmm ... might have a helpful suggestion - a few posts up I was having trouble with this same line throwing an error and following Coopco's suggestion to look at ot_gv.php in /modules/order_total I checked the code and found no issues ...BUT I had not installed the Voucher part of the contrib, only the Coupon part - so I went into Admin and through to Order Total and ran the Install for Vouchers. That cured the error from line 175 - I realised that 175 was calling a global that hadn't been set . The bad news is that despite all this I still have to enter the coupon redeem code twice for any discount to show up in the shopping cart and product summary. Seem to have been all round the houses and back again.
  14. Coopco - thanks for uploading your vn of checkout_payment.php ... but it's exactly the same as the vn I have and (unsurprisingly) throws the same error - the root of the problem lies elsewhere with the $GLOBAL that is referenced not being set correctly - I will continue to experiment with/search in other places like ot_coupon.php and order_total.php which are referenced by checkout_payment.php..... no need for you to send me any zip, but thanx for the offer. I have a nasty feeling this problem could be related to server setup .... anyway I'll keep posting with the progress (if any!) that I make. K
  15. Hi - thanks for the above info ... and this is what occurred (yes I did originally use 5.16 BlueNoteMKVI) - I downloaded the shanejackson set that you recommended and installed it into the vanilla osc .... checkout_payment.php gave an error (unexpected $ at end of file) - this was due to a couple of instances of <? rather than <?php being used to open php fragements - my server needs <?php - anyway corrected that problem and then got Fatal error: Call to a member function on a non-object in /home/sites/domains/wbstools/catalog/checkout_payment.php on line 174 Line 174 is : $testing= $GLOBALS['ot_gv']->mod_process(); .... and that's the nub of it I think. Looks like this line is trying to get a global value ... and it's not properly defined. You say you had no probs with this install ... wonder what I've missed - but I have checked again that I copied all the files over from 5.12a2 Part 1 + 5.15a2 Part 2. Any ideas out there ...? Thanx Keith
×