SQL syntax error Solved

Question

Hello,

I have a personal website where I use a database (the one offered by Free).

I received 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 don't know where my problem comes from. Line 1 does not correspond to SQL syntax.

Can someone guide me to tell me where my error originates?
Thank you in advance

Viken

ntui · Accepted Answer

There is a ' or a " or an extra space instead of a char
example:
insert into toto values('integer_type_value')
instead of
insert into toto values(integer_type_value)
check your query carefully and correct it.
if it persists, send me a sample of your query to address removed by moderation and I will provide you with the solution.

oberion · Answer

Hello,Actually, it's MySQL that is responding to you, not PHP.MySQL finds an error on the first line of the query you send it. This thus gives you no clue about the location of the failing query.You need to go through the script of the page, check all the queries, and debug...--Best regards.

edmond · Answer

Hello
Right now I am receiving emails inviting me to click on a link. When I click on these links, I get the same errors!
I am using Internet Explorer 7. Are the errors caused by bugs in IE7? Are they errors on the sender's side?
Thank you for your help

windows xp ie7

Boonichou · Answer

Hello, I have the same type of problem as Viky:

I have a phpbb forum, I am changing my host, and I am at the crucial step of importing the database from my old forum.
However, when I import the file, I get the same error message:

SQL query:
CREATE DATABASE `sidious4` DEFAULT;

MySQL responded:
#1064 - 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

Do you have any idea?

jabri · Answer

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 '12' at line 8
عذراً: 1064
Date: Wednesday 5th of December 2007 04:31:22 PM
---------------Query---------------
in this script
SELECT rafia_news.*,COUNT(rafia_comment.news_id) as numrows
FROM rafia_news LEFT JOIN rafia_comment
ON rafia_news.id = rafia_comment.news_id
WHERE rafia_news.allow = 'yes'
AND rafia_news.inindex = '1'
GROUP BY rafia_news.id
ORDER BY rafia_news.id DESC
LIMIT 12

thank you for helping me to correct this error
to know: I am clueless in programming

nelly · Answer

What are you doing then?

I have the same bug: 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 'WHERE username=''' at line 1

You have an error in your SQL syntax; · Answer

Vous avez une erreur dans votre syntaxe SQL ;

nathan86 · Answer

I encountered the same error. I am currently working on my own machine where I installed WAMP server 2.0
so Apache Version 2.2.11, PHP Version 5.3.0 MySQL Version 5.1.36 and here is my SQL query as I wrote it
$response = mysql_query("SELECT * FROM livredor ORDER BY id DESC LIMIT " . $firstMessageToDisplay . ", " . $numberOfMessagesPerPage) or die(mysql_error());

and I have 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
Can someone help me?

le père · Answer

Hello

Next time, create your own thread instead of doing archaeology in the forum :)

The query you proposed does not contain any obvious errors. I see 3 possible explanations:
. the error is not on that line
. the query is not exactly the one you copied here
. your variable $nombreDeMessagesParPage ends with a )

Personally, I lean towards the 1st hypothesis because the message mentions a closing parenthesis, and there isn't one in your query (the one after $nombreDeMessagesParPage is not part of the query), unless maybe in the variables, but I don't really believe that.

Meri · Answer

Hello, I have the same problem as the first person who posted the message!!!! Please help me Thank you

msi79 · Answer

Here is my error. I'm struggling to find the solution but nothing. I can't move forward anymore. It's even giving me headaches. If someone here could help me. Here is my error:
SQL Error! INSERT INTO enfant VALUES('', 'coulibaly sarha precilia', 'Enfts......3', 'AGE', 'MARITAL STATUS', 'LEVEL OF EDUCATION', 'ivorian.......1', 'ETHNICITY', 'RELIGION', 'SECTOR OF ACTIVITY', 'MAIN OCCUPATION', 'no BCG', 'no DT COQ POLIO +HB', 'no YELLOW FEVER', 'no MEASLES', 'DEPARASITIZATION', 'CHOOSE', '', '')
Cannot add or update a child row: a foreign key constraint fails ('victims'.'child', CONSTRAINT 'child_ibfk_1' FOREIGN KEY ('matri_enf') REFERENCES 'victim' ('registration_number'))

suanik · Answer

In a similar situation, it is also possible that one of the field names is reserved and treated as a structural word.

For example, if I have a field called "read" that I use as a boolean to indicate that a message has been read:
"UPDATE messages SET read=0 WHERE id=1"
This fails.

Indeed, if I enter this query in the "SQL" tab of PHPmyAdmin, I notice that after submitting (and indicating that an error has occurred), PHPmyAdmin displays "read" in uppercase, and in the same color as UPDATE or WHERE. Therefore, I need to choose another name for my field "read."

delvauxo · Answer

Hello everyone,

I had the same error but for a different reason:

I was using a field "table" in my bookings table.

However, the problem was that this field is a reserved word, so it can't be used as a field name.

To solve the problem, I had to add double quotes in my INSERT!

Here is my INSERT from my PHP file:

$requete = "INSERT INTO bookings (email, name, firstname, phone, 'table', bottle, soft, people, date_envoi) "
. "VALUES ('$email', '$name', '$firstname', '$phone', '$amountt', '$amountb', '$amounts', '$amountp', NOW())";

I had to replace table with 'table' and it worked!!!

kirabelle · Answer

Hello,
I have the same message: "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" SELECT *FROM CF_groups_perm WHERE id_group =......
but I don't understand anything about the solutions......... what exactly should I do........ what should I change and where?

selmi · Answer

Hello, we need to remove the spaces and the (é) for the names of the database columns.

debutant-html-php · Answer

 <?php
 mysql_connect("localhost","root","");
 mysql_select_db("tutos");
 if(!empty($_POST)){
 $username = $_POST['username'];
 $email = $_POST['email'];
 $about = $_POST['about'];
 if($username&&$email&&$about){
 extract($_POST);
 $sql="UPDATE users SET username='$username', email='$email', about='{$_POST["about"]}'";
 $req = mysql_query($sql) or die(mysql_error());
 $sql = stripslashes($_POST['about']);
 $success="Votre compte a bien été modifié {$_SESSION["Auth"]["username"]}";
 }else{
 $erreur="Veuillez compléter tous les champs";
 }
 }
 $sql="SELECT * FROM users";
 $req = mysql_query($sql);
 while($d=mysql_fetch_assoc($req)){
 ?>

Minucia · Answer

Hello everyone!
Sorry to dig up this topic but I have the same error, and I can't find out where it's coming from...
I created my database residence_etudiante on PMA and I would like to fill it easily and quickly with foreign keys and everything (which is really giving me trouble).
Here is my SQL query, automatically generated by the AnalysisSI software from my ER diagram:

DROP TABLE IF EXISTS Concierge ;

CREATE TABLE Concierge (id_conc int AUTO_INCREMENT NOT NULL,
nom_conc TEXT, ad_conc TEXT,
tel_conc NUMERIC(10),
id_resi INT NOT NULL,
PRIMARY KEY (id_conc) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Résidence ;

CREATE TABLE Résidence (id_resi int AUTO_INCREMENT NOT NULL,
nom_resi TEXT, ad_resi TEXT,
tel_resi NUMERIC(10),
PRIMARY KEY (id_resi) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Studio ;

CREATE TABLE Studio (id_studio int AUTO_INCREMENT NOT NULL,
charges NUMERIC(50),
loyer NUMERIC(5),
id_resi INT NOT NULL,
id_loc INT NOT NULL,
id_prop INT NOT NULL,
PRIMARY KEY (id_studio) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Locataire ;

CREATE TABLE Locataire (id_loc int AUTO_INCREMENT NOT NULL,
nom_loc TEXT, ad_loc TEXT,
tel_loc NUMERIC(10),
PRIMARY KEY (id_loc) ) ENGINE=InnoDB;

DROP TABLE IF EXISTS Propriétaire ;

CREATE TABLE Propriétaire (id_prop int AUTO_INCREMENT NOT NULL,
nom_prop TEXT, ad_prop TEXT,
tel_prop NUMERIC(10),
PRIMARY KEY (id_prop) ) ENGINE=InnoDB;

ALTER TABLE Concierge
ADD CONSTRAINT FK_Concierge_id_resi
FOREIGN KEY (id_resi)
REFERENCES Résidence (id_resi);

ALTER TABLE Studio
ADD CONSTRAINT FK_Studio_id_resi
FOREIGN KEY (id_resi)
REFERENCES Résidence (id_resi);

ALTER TABLE Studio
ADD CONSTRAINT FK_Studio_id_loc
FOREIGN KEY (id_loc)
REFERENCES Locataire (id_loc);

ALTER TABLE Studio
ADD CONSTRAINT FK_Studio_id_prop
FOREIGN KEY (id_prop)
REFERENCES Propriétaire (id_prop);

and here is the error that shows up:

Error
SQL query:

CREATE TABLE Concierge(

id_conc INT AUTO_INCREMENT NOT NULL ,
nom_conc TEXT,
ad_conc TEXT,
tel_conc NUMERIC( 10 ) ,
id_resi INT NOT NULL ,
PRIMARY KEY ( id_conc )
) ENGINE = INNODB;

MySQL responded: Documentation

#1064 - 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 '(8) NOT NULL,
nom_conc TEXT, ad_conc TEXT,
tel_conc NUMERIC(10),
id_resi INT(8) ' at line 1

Can you help me sort out this little issue?
I should mention that I am a novice in this area and that coding is not my strong suit... thanks in advance!

SQL syntax error

17 answers

My pc boots into bios with windows 11

Orange mail new version

Libreoffice calc: unable to assign a macro to a button

Ciel comptabilité exemplar version 12.1

Excel subtotals

7-zip compression

Disabled overlay features on my telep

Record your game and film yourself at the same time

Starting office 2007 on windows 11 home

Hello i am reading audio files from a usb key but qua