Jim R Posted August 11, 2011 Share Posted August 11, 2011 I was resetting my WordPress database, and while I accomplished what I wanted to accomplish, there were a couple of side effects. One of them was inserting a \ everywhere I have a quote. Considering I deal with the heights of basketball players, 6'1", 6'2", etc., I now have an assortment of \'s showing up all over my site. How do I just get rid of the \'s? I tried to Select the just the cells that had them in a given column, but that didn't work. Quote Link to comment https://forums.phpfreaks.com/topic/244522-database-inserted-s-into-some-of-my-columns-i-need-to-remove-them/ Share on other sites More sharing options...
Jim R Posted August 11, 2011 Author Share Posted August 11, 2011 Good news. I had backed up my database last week before resetting the first time, and the only changes I've made since then are to non-content pages. If someone wants to answer this question still, I'm sure it can help someone else, or likely me in about a year when I screw something up again. : ) Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/244522-database-inserted-s-into-some-of-my-columns-i-need-to-remove-them/#findComment-1255991 Share on other sites More sharing options...
fenway Posted August 11, 2011 Share Posted August 11, 2011 That's single-quote escaping -- but it shouldn't make it into the database. Quote Link to comment https://forums.phpfreaks.com/topic/244522-database-inserted-s-into-some-of-my-columns-i-need-to-remove-them/#findComment-1256134 Share on other sites More sharing options...
Jim R Posted August 12, 2011 Author Share Posted August 12, 2011 True, but it was inserted nonetheless. Hard to explain why. Maybe in upgrading the database "version" (whatever that really means), it escapes all single quotes to avoid any conflicts with PHP. It's the only thing I can think of, but it didn't do it earlier. Quote Link to comment https://forums.phpfreaks.com/topic/244522-database-inserted-s-into-some-of-my-columns-i-need-to-remove-them/#findComment-1256182 Share on other sites More sharing options...
fenway Posted August 12, 2011 Share Posted August 12, 2011 Escaping never makes it out of the string. You're probably escaping it one extra time -- maybe now magic quotes is on, etc.? Quote Link to comment https://forums.phpfreaks.com/topic/244522-database-inserted-s-into-some-of-my-columns-i-need-to-remove-them/#findComment-1256471 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.