vlinedesign Posted January 17, 2012 Share Posted January 17, 2012 I found a bug in Prestashop. When a user creates an account and fills out the address field, if they use a city name that starts with "Union", it creates an error and prevents the address from being created. "Uni", "Unio" or "United" works just fine, but if you use "Union", "Union Gap", "UnionGap" or anything that starts with "Union", it brings up an error. Does anyone have a solution to this bug? Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 17, 2012 Share Posted January 17, 2012 Hi vlinedesign, What version of PrestaShop are you running? I just tried this on a fresh installation running 1.4.6.2, and I had no issues registering using an address located in "Union City, CA." -Mike Link to comment Share on other sites More sharing options...
vlinedesign Posted January 17, 2012 Author Share Posted January 17, 2012 Hi Mike, I'm using Prestashop 1.3. Unfortunately, I've made so many modifications to it that upgrading my Prestashop software is just not feasible at this time. It sounds like you've corrected the bug in the newer version of Prestashop. Any idea what that fix might be? Link to comment Share on other sites More sharing options...
vlinedesign Posted January 17, 2012 Author Share Posted January 17, 2012 My apologies, Mike. My copy might be even older than that. I think I'm using the 1.1 version. It was downloaded in January, 2009. Trent Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 17, 2012 Share Posted January 17, 2012 My apologies, Mike. My copy might be even older than that. I think I'm using the 1.1 version. It was downloaded in January, 2009. Trent Wow, that's honestly pretty impressive, and I'm sorry to see you missing out on so many great new features we've added in the last 30+ months since version 1.1. I will try to take a look at this for you, but the differences between version 1.1 and version 1.4.6.2 are really quite large, and just replacing the corresponding files may not work. However, if you would like, I could set you up with a member of our advanced support team who could explain all your upgrading options. But in the meantime, can you please post your URL so that I can test this out on my end? -Mike Link to comment Share on other sites More sharing options...
vlinedesign Posted January 17, 2012 Author Share Posted January 17, 2012 Mike, I'll send you the link via PM. Thanks for you help. Trent Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 17, 2012 Share Posted January 17, 2012 Hi Trent, I took a look at this for you, but unfortunately the entire structure of the software has changed since your version, so there isn't really any sort of quick solution I can offer like I would be able to with newer versions of the software. As I mentioned before though, I would be happy to set you up with a member of our advanced support team, and hopefully they could either provide you some code suggestions or give you information on getting help from our team to upgrade your site. If you're interested, just PM me with your contact information and I will set it up for you. -Mike Link to comment Share on other sites More sharing options...
Mike Kranzler Posted January 18, 2012 Share Posted January 18, 2012 Hi Trent, I just spoke with one of our developers, and it appears that your issue is because "Union" is an SQL keyword that was forbidden in earlier versions of PrestaShop. To fix it, open up your classes/DB.php file, and run a search for the word. It should be in an array with other blacklisted keywords. Just remove 'union' from that list, and that should fix it! Please let me know if this works for you. -Mike Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts