[SOLVED] ERROR: Invalid Identifer @ 726 - MYSQL ERROR

[dsaba]

I am trying to insert this query, I inserted it directly with SQL in phpmyadmin to see what the exact error was

 

I'm running SQL 4

 

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

 

ERROR: Invalid Identifer @ 726

STR: 0.3.

SQL: INSERT INTO mh_info (user_ip, downloadtitle_en, downloadtitle_he, downloadtitle_es, downloadtitle_pt, downloadtitle_pl, hashcode, sentfrom, mirror, combo_status, description_en, description_he, description_es, description_pt, description_pl, mhversion, uploadspeed, nickname, email, livecontact, service, datesubmitted, datetime_modified, title_en, title_he, title_es, title_pt, title, pl, entry_type, datetime_submitted) VALUES ('68.59.238.189', 'title', '', 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'paste the hashcode here', 'gmail.com', 'centrum.cz', 'BAD', 'paste the hashcode here', 'הדבק את ההאשכוד כאן, 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', '0.3.2.0', '10-20 kb/s', 'nickname', 'email address', 'livecontact', 'service', '2007-04-27', '1177667958', 'whatever', 'whatever', 'whatever', 'whatever', 'whatever', 'Combo', '1177667958')

SQL query:

 

INSERT INTO mh_info (user_ip, downloadtitle_en, downloadtitle_he, downloadtitle_es, downloadtitle_pt, downloadtitle_pl, hashcode, sentfrom, mirror, combo_status, description_en, description_he, description_es, description_pt, description_pl, mhversion, uploadspeed, nickname, email, livecontact, service, datesubmitted, datetime_modified, title_en, title_he, title_es, title_pt, title, pl, entry_type, datetime_submitted) VALUES ('68.59.238.189', 'title', '', 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'paste the hashcode here', 'gmail.com', 'centrum.cz', 'BAD', 'paste the hashcode here', 'הדבק את ההאשכוד כאן, 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', '0.3.2.0', '10-20 kb/s', 'nickname', 'email address', 'livecontact', 'service', '2007-04-27', '1177667958', 'whatever', 'whatever', 'whatever', 'whatever', 'whatever', 'Combo', '1177667958')

MySQL said: 

 

#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 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', '0.' at line 1

 

[ Back ] 

 

Do you know how I can fix this error from happening?

-thanks

[dsaba]

this also gave me the same basic error

i changed the value for mhversion from 0.3.20 to whatever

 

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

 

ERROR: Unclosed quote @ 1020

STR: '

SQL: INSERT INTO mh_info (user_ip, downloadtitle_en, downloadtitle_he, downloadtitle_es, downloadtitle_pt, downloadtitle_pl, hashcode, sentfrom, mirror, combo_status, description_en, description_he, description_es, description_pt, description_pl, mhversion, uploadspeed, nickname, email, livecontact, service, datesubmitted, datetime_modified, title_en, title_he, title_es, title_pt, title, pl, entry_type, datetime_submitted) VALUES ('68.59.238.189', 'title', 'הדבק את ההאשכוד כאן', 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'paste the hashcode here', 'gmail.com', 'centrum.cz', 'BAD', 'paste the hashcode here', 'הדבק את ההאשכוד כאן, 'Piega el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'whatever', '10-20 kb/s', 'nickname', 'email', 'livecontact', 'msn', '2007-04-27', '1177668911', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'Combo', '1177668911')

SQL query:

 

INSERT INTO mh_info (user_ip, downloadtitle_en, downloadtitle_he, downloadtitle_es, downloadtitle_pt, downloadtitle_pl, hashcode, sentfrom, mirror, combo_status, description_en, description_he, description_es, description_pt, description_pl, mhversion, uploadspeed, nickname, email, livecontact, service, datesubmitted, datetime_modified, title_en, title_he, title_es, title_pt, title, pl, entry_type, datetime_submitted) VALUES ('68.59.238.189', 'title', 'הדבק את ההאשכוד כאן', 'Pegue el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'paste the hashcode here', 'gmail.com', 'centrum.cz', 'BAD', 'paste the hashcode here', 'הדבק את ההאשכוד כאן, 'Piega el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'whatever', '10-20 kb/s', 'nickname', 'email', 'livecontact', 'msn', '2007-04-27', '1177668911', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'BAD- gmail.com TO centrum.cz', 'Combo', '1177668911')

MySQL said: 

 

#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 'Piega el hashcode aquí', 'cole o hashcode aqui', 'Sklejcie hashcode tutaj', 'wh' at line 1

 

[ Back ] 

[dsaba]

missing a ' single quote, found it

 

solved