CODEWITHSUNDEEP
mysqlsyntaxinsert
user3161536
user3161536

Reputation: 3

Mysql INSERT syntax error #1064

I keep getting the following error:

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

when I try to run this query in phpMyAdmin:

INSERT INTO access_log ( 
  idStaff, validSession, attempts, remoteHost, remoteAddress, remoteTime, banned,
  errorNumber,errorMessage,userName ) 
VALUES ( '1','1','1','voidDNS','188.25.3.105','1388877754','','','','pinochio';

My table has these columns and their type in this order is (except an auto-increment column 'entry"):

INT, TINYINT, INT, TEXT, VARCHAR(20), BIGINT( I was afraid of using TIMESTAMP), TINYINT, INT, TEXT, VARCHAR(24).

The query is generated by php automatically, this is why every value has quotes, which I understand shouldn't generate an error.

Can anyone see what's wrong here?

Upvotes: 0

Views: 2277

Answers (1)

Rafael Soufraz
Rafael Soufraz

Reputation: 964

Lack simply closing parentheses at the end of query

Upvotes: 1

Related Questions