[RESOLVED] MySQL errors

spiritssight

Hello All,

Could someone please help with this issue, what am I doing wrong? I got this when running a SQL under phpMyAdmin. the file is a fixed width

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 @ 70
STR: '
SQL: LOAD DATA LOCAL INFILE /home80c/sub003/sc44514-NPGU/www/uploads/EO.LST'
        INTO TABLE IRS_EOML
        (@var1)

   SET
	col0 = substr(@var1,0,9),
	col1 = substr(@var1,9,70),
	col2 = substr(@var1,79,35),
	col3 = substr(@var1,114,35),
	col4 = substr(@var1,149,22),
	col5 = substr(@var1,171,2),
	col6 = substr(@var1,173,10),
	col7 = substr(@var1,183,4),
	col8 = substr(@var1,187,2),
	col9 = substr(@var1,189,1),
	col10 = substr(@var1,190,4),
	col11 = substr(@var1,194,6),
	col12 = substr(@var1,200,1),
	col13 = substr(@var1,201,2),
	col14 = substr(@var1,203,9),
	col15 = substr(@var1,212,1),
	col16 = substr(@var1,213,2),
	col17 = substr(@var1,215,6),
	col18 = substr(@var1,221,6),
	col19 = substr(@var1,227,1),
	col20 = substr(@var1,228,1),
	col21 = substr(@var1,229,3),
	col22 = substr(@var1,232,3),
	col23 = substr(@var1,235,2),
	col24 = substr(@var1,237,13),
	col25 = substr(@var1,250,13),
	col26 = substr(@var1,263,1),
	col27 = substr(@var1,264,13),
	col28 = substr(@var1,277,1),
	col29 = substr(@var1,278,4),
	col30 = substr(@var1,282,35),
	col31 = substr(@var1,317,1)"


SQL query:

LOAD DATA LOCAL INFILE /home80c/sub003/sc44514-NPGU/www/uploads/EO.LST' INTO TABLE IRS_EOML (@var1) SET col0 = substr(@var1,0,9), col1 = substr(@var1,9,70), col2 = substr(@var1,79,35), col3 = substr(@var1,114,35), col4 = substr(@var1,149,22), col5 = substr(@var1,171,2), col6 = substr(@var1,173,10), col7 = substr(@var1,183,4), col8 = substr(@var1,187,2), col9 = substr(@var1,189,1), col10 = substr(@var1,190,4), col11 = substr(@var1,194,6), col12 = substr(@var1,200,1), col13 = substr(@var1,201,2), col14 = substr(@var1,203,9), col15 = substr(@var1,212,1), col16 = substr(@var1,213,2), col17 = substr(@var1,215,6), col18 = substr(@var1,221,6), col19 = substr(@var1,227,1), col20 = substr(@var1,228,1), col21 = substr(@var1,229,3), col22 = substr(@var1,232,3), col23 = substr(@var1,235,2), col24 = substr(@var1,237,13), col25 = substr(@var1,250,13), col26 = substr(@var1,263,1), col27 = substr(@var1,264,13), col28 = substr(@var1,277,1), col29 = substr(@var1,278,4), col30 = substr(@var1,282,35), col31 = substr(@var1,317,1)"

MySQL said: 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 '/home80c/sub003/sc44514-NPGU/www/uploads/EO.LST'
        INTO TABLE IRS_EOML
' at line 1

Thanks very much!

Sincerely,
Christopher

NogDog

Looks like it's the spurious apostrophe at the end of the file name, perhaps?

spiritssight

Hello there, thanks for the reply,

I fixed the couple errors that I could find, the two ' at near the LOAD DATA LOCAL INFILE area and the one " at the end of the code. But now I get this error and I don't see where its has the issue please help me thanks.

SQL query:

LOAD DATA LOCAL INFILE / home80c / sub003 / sc44514 - NPGU / www / uploads / EO.LST INTO TABLE IRS_EOML(
@var1
) SET col0 = substr( @var1 , 0, 9 ) ,
col1 = substr( @var1 , 9, 70 ) ,
col2 = substr( @var1 , 79, 35 ) ,
col3 = substr( @var1 , 114, 35 ) ,
col4 = substr( @var1 , 149, 22 ) ,
col5 = substr( @var1 , 171, 2 ) ,
col6 = substr( @var1 , 173, 10 ) ,
col7 = substr( @var1 , 183, 4 ) ,
col8 = substr( @var1 , 187, 2 ) ,
col9 = substr( @var1 , 189, 1 ) ,
col10 = substr( @var1 , 190, 4 ) ,
col11 = substr( @var1 , 194, 6 ) ,
col12 = substr( @var1 , 200, 1 ) ,
col13 = substr( @var1 , 201, 2 ) ,
col14 = substr( @var1 , 203, 9 ) ,
col15 = substr( @var1 , 212, 1 ) ,
col16 = substr( @var1 , 213, 2 ) ,
col17 = substr( @var1 , 215, 6 ) ,
col18 = substr( @var1 , 221, 6 ) ,
col19 = substr( @var1 , 227, 1 ) ,
col20 = substr( @var1 , 228, 1 ) ,
col21 = substr( @var1 , 229, 3 ) ,
col22 = substr( @var1 , 232, 3 ) ,
col23 = substr( @var1 , 235, 2 ) ,
col24 = substr( @var1 , 237, 13 ) ,
col25 = substr( @var1 , 250, 13 ) ,
col26 = substr( @var1 , 263, 1 ) ,
col27 = substr( @var1 , 264, 13 ) ,
col28 = substr( @var1 , 277, 1 ) ,
col29 = substr( @var1 , 278, 4 ) ,
col30 = substr( @var1 , 282, 35 ) ,
col31 = substr( @var1 , 317, 1 )

MySQL said: 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 '/home80c/sub003/sc44514-NPGU/www/uploads/EO.LST
        INTO TABLE IRS_EOML
  ' at line 1

bradgrafelman

Your problem is that the file isn't on the DB server - it's on the webserver. Thus, you have to execute the SQL from PHP (residing on the webserver) - not PMA.