Hi,
I have a problem with the quick import. When importing
with | as delimiter editer.cgi gives the following error:
Error importing data: [Mon May 29 12:21:13 2000] editor.cgi: DBSQL (11317): Fatal Error: Unable to execute query: [Mon May 29 12:21:13 2000] editor.cgi: LOAD DATA INFILE 'tester.txt' [Mon May 29 12:21:13 2000] editor.cgi: INTO TABLE Links [Mon May 29 12:21:13 2000] editor.cgi: FIELDS TERMINATED BY '|' [Mon May 29 12:21:13 2000] editor.cgi: . Reason: at /kunder/iguidedk/htdocs/login/editor.cgi line 316 .
In line 316 or just before we have: ($delim eq '\t') and ($delim = "\t");
That means tab right? But tabs doesn't work either.
Can somebody please tell what I should use to delimit
my file. I works without quick import, but then no more
than 170 links can be added at the time before the
process cracks and I importing a lot.
Hope somebody can help me.
Martin
I have a problem with the quick import. When importing
with | as delimiter editer.cgi gives the following error:
Error importing data: [Mon May 29 12:21:13 2000] editor.cgi: DBSQL (11317): Fatal Error: Unable to execute query: [Mon May 29 12:21:13 2000] editor.cgi: LOAD DATA INFILE 'tester.txt' [Mon May 29 12:21:13 2000] editor.cgi: INTO TABLE Links [Mon May 29 12:21:13 2000] editor.cgi: FIELDS TERMINATED BY '|' [Mon May 29 12:21:13 2000] editor.cgi: . Reason: at /kunder/iguidedk/htdocs/login/editor.cgi line 316 .
In line 316 or just before we have: ($delim eq '\t') and ($delim = "\t");
That means tab right? But tabs doesn't work either.
Can somebody please tell what I should use to delimit
my file. I works without quick import, but then no more
than 170 links can be added at the time before the
process cracks and I importing a lot.
Hope somebody can help me.
Martin