Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Import error

Quote Reply
Import error
Alex, I tried import.cgi and got the following error

syntax error at Interface/CGI.pm line 47, near ") for "
BEGIN failed--compilation aborted at /home/sites/site7/web/cgi-bin/lsqldev/admin/import.cgid line 45.


Quote Reply
Re: Import error In reply to
When i try and import from sql1 > sql2

All i keep getting is the script trying to download!!!



Regards

MDJ1
http://www.isee-multimedia.co.uk
Quote Reply
Re: Import error In reply to
Hi, this is an old version of perl problem, we've fixed it up. Thanks!

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Import error In reply to
Can you download it and open it up and see what the message says?

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Import error In reply to
Hi Alex.

Here is a list of the errors from the download file:
Code:
WARNING: Unable to insert admin: Duplicate entry 'admin' for key 3

WARNING: Custom import column `Links.isalt' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.Gwidth' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.LinkExp' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.AltLink' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.isLinked' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.Keywords' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.SalesContact' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.Graphic' has no destination equivelant. It will be ignored

WARNING: Custom import column `Links.Gheight' has no destination equivelant. It will be ignored

WARNING: Custom import column `Validate.Gwidth' has no destination equivelant. It will be ignored

WARNING: Custom import column `Validate.Graphic' has no destination equivelant. It will be ignored

Import has been completed!
It seems that i have to create the extra fields in the tables first!!



Regards

MDJ1
http://www.isee-multimedia.co.uk
Quote Reply
Re: Import error In reply to
Yes, do you think it should create it for you? We can take a look at adding that in.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Import error In reply to
Hi alex,

It would be advantagous if it did import and create the fields for the tables as it's quite a fiddly and time consuming task, I know the first time I did it it took me hours, but that's because i didnt really have a clue.

Plus if you loose your tables it's easier to just re-import the backups, than having to recreate all your field infomation.

It's also a good selling point for the script. Seemless import could maybe purswade users of other software to convert to SQL.

Regards

MDJ1
http://www.isee-multimedia.co.uk