Unable to find where is the error

mlosier

Hi guys,

I installed a php script and I get this error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I want to know if there is a way that I can know exactly where in the code is situated that query that is causing the problem...

Thanks guys

NogDog

You'd have find where that message is being generated (probably via mysql_error()), and edit the code to perhaps use [man]user_error/man to output it, which would then also tell you the file and line number where it is happening.

mlosier

Thanks for your answer, but in order to change to user_error(), i have to know which query is generating the error... then i wouldn't have had to post here in the first place...

NogDog

I understand, but there's a limit to the abilities of my ESP. :p

The message you're seeing is apparently being generated by an echo/print, e.g.:

echo mysql_error();

You can simply search your source code for "mysql_error", and where you find it being used in such a manner, change it to something like:

user_error(mysql_error());

I'm afraid that's all I can think of.

mlosier

Ok Thanks, I will try this!! 😃

if i am using

or die(mysql_error())

Would it be like :

or die(user_error(mysql_error()))