frankie Posted August 10, 2009 Share Posted August 10, 2009 i am having a very strange issue and i do not know where it is coming from. i am running multiple instances of a very modified oscommerce. i just moved my sites and had to upgrade to php5 and mysql 5. http://pizzainny.com http://forpizzadelivery.com both sites are using the same db and are on the same vps if you do a search for domino you will See that in pizzainny.com i get domino''s and in forpizzadelivery.com i get domino's notice the double '' in the local server i do not have this issue but i am on php4 and mysql4 however it seems that in phpmyadmin i also have the similar repeating of ' in some places. also \ repeats to \\ in phpmyadmin [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
frankie Posted August 10, 2009 Author Share Posted August 10, 2009 i apologize for the wrong file being attached. here is a screen grab of phpmyadmin with the bug [attachment deleted by admin] Quote Link to comment Share on other sites More sharing options...
Andy-H Posted August 10, 2009 Share Posted August 10, 2009 <?php $gpc = array( 'Magic quotes are off', 'Magic quotes are on'); echo $gpc[get_magic_quotes_gpc()] . '<br >'; ?> Run that and post the results back please. Quote Link to comment Share on other sites More sharing options...
frankie Posted August 10, 2009 Author Share Posted August 10, 2009 thanks i get Magic quotes are on Quote Link to comment Share on other sites More sharing options...
frankie Posted August 10, 2009 Author Share Posted August 10, 2009 thanks i figured it out. you remined me of my problems with my previous host. it was because of some code left over in .htaccess file from my previous hosting company. Quote Link to comment Share on other sites More sharing options...
frankie Posted August 10, 2009 Author Share Posted August 10, 2009 actually only the issue with my site is resolved. phpmyadmin still shows double Quote Link to comment Share on other sites More sharing options...
frankie Posted August 10, 2009 Author Share Posted August 10, 2009 i can not edit my posts. i do not know why but anyway actually Magic quotes are off. i had a code in my .htaccess that would allow me to use php4 in my previous host. so now that i nremoved it my problem with double is resolved in my site and magiq quotes show off. but phpmyadmin still shows double. i have not tested everything on my site yet. maybe i should turn magic quotes on. thanks for the help andy Quote Link to comment Share on other sites More sharing options...
Andy-H Posted August 10, 2009 Share Posted August 10, 2009 If the data isn't processed by PHP then it's not magic quotes, and no, leave them off. So you are running that query directly in PHPMyAdmin?? Quote Link to comment Share on other sites More sharing options...
frankie Posted August 10, 2009 Author Share Posted August 10, 2009 i just edited the data in phpmyadmin and noticed it. i do not care about the issue with phpmyadmin so i am going to leave it off unless i see other problems. thank youi again for your help Quote Link to comment Share on other sites More sharing options...
infiniteacuity Posted August 11, 2009 Share Posted August 11, 2009 i just edited the data in phpmyadmin and noticed it. i do not care about the issue with phpmyadmin so i am going to leave it off unless i see other problems. thank youi again for your help Did you app insert that data directly into the DB or did you do that through pma as part of your testing? Quote Link to comment Share on other sites More sharing options...
frankie Posted August 11, 2009 Author Share Posted August 11, 2009 I used PMA you can look at the second image that i uploaded. you can see what i am talking about. Quote Link to comment 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.