single quote breaking sql query after server move
Posted: Wed May 18, 2011 8:24 am
Hi
I have just transferred a site from one server provider to a new dedicated hosting provider. In short everything has come across fine. The problem I have is that the CMS is now not working corretly. After trouble shooting I have discovered the sql query string is now not working correctly and any single quote in a string of text is now breaking the query. The site has been up and running for several years problem free so the code was working without hitch.
My question is could this be down to a setting in either the new mySql database setup or maybe in the php config set up? I'm transferring several sites and do not want to have to re-code every CMS!
Many thanks in advance.
I have just transferred a site from one server provider to a new dedicated hosting provider. In short everything has come across fine. The problem I have is that the CMS is now not working corretly. After trouble shooting I have discovered the sql query string is now not working correctly and any single quote in a string of text is now breaking the query. The site has been up and running for several years problem free so the code was working without hitch.
My question is could this be down to a setting in either the new mySql database setup or maybe in the php config set up? I'm transferring several sites and do not want to have to re-code every CMS!
Many thanks in advance.