Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Quick import prolems

Quote Reply
Quick import prolems
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

Subject Author Views Date
Thread Quick import prolems Martin Kjeldsen 4258 May 29, 2000, 11:02 AM
Thread Re: Quick import prolems
pugdog 4162 May 29, 2000, 12:09 PM
Thread Re: Quick import prolems
Martin Kjeldsen 4153 May 29, 2000, 12:19 PM
Thread Re: Quick import prolems
pugdog 4143 May 29, 2000, 1:08 PM
Thread Re: Quick import prolems
el noe 4104 Jun 9, 2000, 8:54 AM
Post Re: Quick import prolems
pugdog 4098 Jun 9, 2000, 11:36 PM
Thread Re: Quick import prolems
el noe 4136 Jun 10, 2000, 5:55 AM
Thread Re: Quick import prolems
pugdog 4121 Jun 11, 2000, 11:02 AM
Post Re: Quick import prolems
el noe 4097 Jun 11, 2000, 11:33 AM