single quote breaking sql query after server move

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
lettie_dude
Forum Commoner
Posts: 65
Joined: Thu Dec 07, 2006 10:10 am

single quote breaking sql query after server move

Post by lettie_dude »

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.
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: single quote breaking sql query after server move

Post by Jade »

Can you post the code that's giving you the error please.
Post Reply