siric Posted February 5, 2009 Share Posted February 5, 2009 Hi,My users are unable to add new addresses to their profile. They keep getting an error which states There is 1 error :an error occurred while updating your address (screen shot attached).Does anyone know how to fix this?Thanks Link to comment Share on other sites More sharing options...
rocky Posted February 5, 2009 Share Posted February 5, 2009 I think the problem is the "11 Union Road". The word "Union" is blacklisted in classes/Db.php on line 49. This is frequently reported as a problem, but it is a security feature to prevent SQL attacks. Link to comment Share on other sites More sharing options...
siric Posted February 5, 2009 Author Share Posted February 5, 2009 Yes, I realised that it is the word Union. How would you get around this as it is part of a valid address? Union Road, Union Square, etc. Link to comment Share on other sites More sharing options...
rocky Posted February 8, 2009 Share Posted February 8, 2009 Unfortunately, there is no permanent solution that I'm aware of. You can remove the word UNION from the blacklist, but it may make your website vulnerable. You would have to insert these entries with the word UNION directly into the database. I suppose you could have a message asking customers to enter something like UNI*N instead of UNION, and you can manually change them in the database. I don't have any neat and easy solution. Link to comment Share on other sites More sharing options...
Recommended Posts