Jump to content

James Ellerman

Member
  • Posts

    19
  • Joined

  • Last visited

Everything posted by James Ellerman

  1. For the sake of others reading this thread, we disabled the database cache through the admin web interface and the problem has not occurred since (see settings - store settings - advanced tab, under performance set "enable caching" to disabled.
  2. Sent you a PM with my email details, thanks.
  3. Yes, we are definitely running 6.0.6. Any ideas on how to troubleshoot this further? I can send you database dumps if that helps. I can't see anything immediately obvious with the accounts that have the issue, looking at the underlying database. I have manually reset the password through the admin interface on one account that had the problem, and I can log in as the user. I note that the user has no address book entries, but I'm not sure if this is significant.
  4. I believe I'm running 6.0.6 code, and if I understand correctly, this fix was included in 6.0.6? By the way, how do I check the Cubecart version from the admin console to confirm the version I'm running?
  5. This is still an issue for me. Roughly 1/4 of users who create an account on the site are getting this error. Many of them are having to use an alternate email address to create another account, but some are just not bothering to order, which is costing us hundreds of dollars at a time. I'd really appreciate some advice on where this problem may be coming from. Is this a hosting issue? Perhaps there are some timing problems/delays writing to a database caused by a shared hosting solution? Would upgrading the hosting package to a faster/dedicated server make any difference?
  6. Just tried to reproduce it again with trailing spaces and cannot reproduce the issue now, so I've got no idea what is going on now. I thought I had nailed it down. The problem with intermittent issues is not knowing how to reproduce them. Anyone have any ideas?
  7. No bulk import. All users are created by the users themselves. The users that create themselves with a space at the end of a field end up with corrupt accounts. Even removing the spaces and saving the accounts doesn't seem to fix it. The only fix is to delete the account and recreate it from scratch. Only accounts created with the trailing space seem to have the problem, others that do not have the trailing space are fine.
  8. I think I've reproduced this issue. If I create a user account with a space after the title (eg: "Mrs " with a space at the end of the word Mrs), the account does some strange things. I can create the account just fine as a user, I can set all the user details and save the account, but when I try and log in to the website to place an order, it sends me into an endless loop, and doesn't actually log me in. Rather than giving me an "invalid name or password" error, it just refreshes the same page as if I haven't even logged in, asking for my username and password again, and not logging me in. I haven't tested other combinations of spaces before and after the titles, names, passwords, etc, but it would appear that there needs to be more checking of the field data before it does into the database. EDIT: It may also be happening with addresses too, if there is a space at the end of any field, like a street name.
  9. I'm seeing the same issue on 6.0.6, error 726. Users are reporting strange behaviour, but I can't narrow down exactly what is going on. The symptom is that users cannot change passwords, or create an account they cannot log into, and are unable to reset the password. Surely someone else has seen this? It doesn't seem to happen for everyone who creates an account, but I can't for the life of me work out the common thread here that is causing the issue for some people and not others. Error is something like this (exact details changed to protect the innocent): File: [user.class.php] Line: [726] "INSERT INTO `pok_CubeCart_customer` (`title`,`first_name`,`last_name`,`email`,`phone`,`mobile`,`password`,`salt`,`registered`,`ip_address`) VALUES ('Mr','Firstname','Surname','[email protected]','phone_num','mobile_num','700d01880c3d112d125d728ed98db7cf6ee583a2b599732ab22a1894dd1ff9cd664cc24a14815b69b340e4cf3cafac511982d3f5e2941f5ac07eda0884df0940','0ae0ad80','1439778466','ip_address');" - Duplicate entry '[email protected]' for key 'email'
  10. For the information of those reading this post, my further testing showed that the URLs that are automatically embedded into the emails sent to customers end up all messed up when information is merged into the return URL (they have /modules/gateway/payflow added to them. Fortunately, Payflow Link has the option to ignore the 200 OK return code from Cubecart, but the information above allowed me to correct a problem with the version 1.0.0 of the module to allow the payment module to update the status of the order correctly if the Payflow transaction failed. I did this by having a separate function to process the order, and another to silently update the status using a silent POST within Payflow to update the status. That way, we simply return to the index.php code with either cmd=process or cmd=call used, depending on whether we are updating the order status (silent post) or returning the user to the store site (post). Instructions for use are with the plugin in the plugin marketplace.
  11. I think that's done it. There is some strange behaviour on the Payflow side that makes users get stuck in the Payflow page when a transaction is declined. Rather than presenting them with a button to return back to the store, it only gives them a back button to re-enter their credit card details. As such, their store cart is not cleared, but on the plus side, a silent URL return sets the status on the order to DECLINED, which is good. I'll need to work out if there is a way to fix the Payflow side of things. I will update the Payflow module to 1.0.1, and post it on to the plugins store. Instructions on how to set the Payflow URL will be included in that file. Thanks again
  12. On further testing, it would appear there is some more work that I need to do to complete this module. Currently, for Payflow Link to correctly process a failed transaction, it needs to be able to send the HTTP POST to the Cubecart website, and receive a "200 OK" reply from Cubecart. There appears to be a problem with Payflow Link receiving this OK message back from Cubecart. Presently, the Payflow Link return message is sending a POST to /index.php?_g=rm&type=gateway&cmd=process&module=Payflow along with numerous other fields, including &DESCRIPTION=$cart_order_id, and &RESULT=$result, which I use in the payment gateway module to link the original order. Because Payflow must be configured to do a silent POST message and receive a 200 OK message in return, when it does not receive this, it voids the credit card transaction, but sets the status of the Cubecart order to PROCESSING. Is the missing 200 OK return code something that needs to be added to the payment processing module, or is this something that Cubecart needs to do but does not (or requires a configuration change to be able to do)? How do I get Cubecart to send an OK message in reply to the Payflow POST message?
  13. Don't worry, Al sent me a link to post the module on the CubeCart site. The module is now added to the list for anyone who wants to use it. Thanks again bsmither
  14. FYI, I have successfully created my own plugin for Payflow Link payment gateway. Please feel free to use this, verify the code, and/or post on the site as you see fit. Use at your own risk, etc, but it seems to work fine in my testing.
  15. Sir, you are a legend! Thanks so much for taking the time to post this information, I now have a fully functioning module! It was those little details about the return URL and which modules called which that made all the difference. I would like to share this module in case there is anyone else who may want to use it, since it was created using other modules as templates, along with your advice. There may only be a few people who may need or use it, but as I have struggled to find many e-commerce solutions that offer a Paypal Payflow Link shipping module, it may provide a solution for them. Any idea what the official process is to verify and actually share this code? I have also attached the module to this post (use at your own risk).
  16. I am running CubeCart v6, and have been writing a payment gateway module to interface with Paypal's Payflow Link website. Payflow Link is simply an external web page that takes an HTTP POST with various variables like a transaction value, merchant details, or any other values I choose sent to it from CubeCart, and presents fields to accept the user's credit card details. On completion of processing on the Payflow Link website, Payflow Link can be configured to perform either an HTTP GET or HTTP POST back to a URL on the CubeCart website with an AUTHCODE value (0 = success, >0 means failure). Payflow Link can also be configured to return any of the values that were sent to it by CubeCart for that transaction (eg: CubeCart order ID, or anything else you want to have returned back to you that originally came from CubeCart). Currently, I have managed to get this payment gateway working, up to the point that Payflow Link sends back an HTTP POST to CubeCart with the transaction details, including the original CubeCart order ID, to a separate PHP script I have created that currently just redirects to CubeCart at /index.php?_a=complete&cart_order_id=$cart_order_id". This successfully clears the user's cart, and displays a nice page saying that the order is pending, which is all well and good, as the order is in the system with a PENDING status. The problem I have been stuck on is how to change the order status from PENDING to either PROCESSING or DECLINED, depending on the AUTHCODE variable and CubeCart order ID that is sent back from the Payflow Link website. If this could be done with a simple HTTP POST to index.php, or some other module, that would be nice and simple. At present, the current setup would require the admin to manually check the Payflow reports and reconcile the CubeCart order ID with the Payflow transaction log, and manually change the order status in CubeCart according to whether the credit card transaction is listed as successful or not. Note that I am a novice with PHP and CubeCart, having never programmed in this language before (or any language for the last 20 years for that matter), so I'm pretty pleased to have made it this far! I have tried using pieces of code that I have found in other modules, without luck, as there appears to be classes and functions that are available in calling modules that are not available when a module is run directly from an HTTP POST. I have tried including the order.class.php module and then call the function orderStatus that I believe should be able to modify the status, but I get "Call to member function get() on a non-object in /order.class.php" errors in the error.log file (this is where my understanding of how PHP works begins to break down). If there is not an HTTP POST method to change the order status (when I have the CubeCart order ID as a variable), could someone assist with some code that could allow my PHP module to change the order status when all I have are variable values like order ID? Note that I can pass anything I like to Payflow and get it echoed back to my module through an HTTP POST from Payflow in the return URL. Alternatively, is there a better way of doing this, either with HTTP GET or HTTP POST from Payflow?
  17. Hi Al, Thanks for taking the time to reply. I agree, the payment system has been around for quite a number of years. The client joined when it was Verisign, which was then bought by Paypal, and they have remained with the product since as it still works for them. It is technically possible to change to another Paypal product, but as mentioned it is more expensive, to the tune of around $1000 per year in transaction costs, which will only increase as the number of transactions increases due to the cost structure of the new products. If there is not going to be any development of such a plugin, do you know if there is any similar type of plugin that I could potentially modify with the Payflow Link specific values to suit? I believe the Payflow Link system simply takes values that are POSTed to a customised web page on the Payflow servers, presents the customer with the Payflow hosted processing page where they enter their credit card details, and returns a success/failure to a URL back on the store to complete the transaction. It is not a particularly complex transaction, but my skills are somewhat limited in this area. Surely there must be some other plugins that do a similar thing that I could potentially modify for the task? I have the documentation around what Payflow Link expects to receive, where it has to be sent, etc.
  18. Does anyone have an extension for Payflow Link that works on CC6? Payflow Link is the Paypal (previously Verisign) payment gateway that uses a website hosted by Paypal to collect credit card information (as opposed to Payflow Pro which relies on the store web page to collect the credit card and send them to Paypal for authorisation, which is also different to Paypal Website Payments Pro, for which there is a plugin available, which is also different to Paypal Standard, for which a plugin also exists...I'm sure they don't deliberately want to confuse people, but...) If an extension for Payflow Link is not available, a Payflow Pro plugin would be the next best thing, but Payflow Link is certainly preferred as it is what we use currently. We do not want to use Paypal standard or Website Payments Pro, as the fees involved are greater than using Payflow Link with our bank merchant account, making it uneconomical to swap processing methods just for the sake of a plugin. Thanks in advance.
×
×
  • Create New...