Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Importing Data base from Links 2.0

Quote Reply
Importing Data base from Links 2.0
Hello,

I tried import a big data base from a Links 2.0, but I received this message:

"Importing Links ...


Import error: CRITICAL ERROR OCCURED: Unable to execute query `INSERT INTO search_Users (Username, Email, Name, ReceiveMail, Newsletter, Status) VALUES (?, ?, ?, ?, ?, 'Registered')': Duplicate entry 'admin' for key 1 at /home/encontreiaqui/www/procura/admin/Links/Import/L2S2.pm line 588"

What it means? How I can fix this problem?



Thanks,

Dept
Quote Reply
Re: [dept] Importing Data base from Links 2.0 In reply to
If you view the database, is there already data in the lsql_Links table ?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Importing Data base from Links 2.0 In reply to
>>
is there already data in the lsql_Links table
<<

It's the Users table ;)
Quote Reply
Re: [dept] Importing Data base from Links 2.0 In reply to
It means you already have a user called admin but you are trying to import another user called admin.
Quote Reply
Re: [Paul] Importing Data base from Links 2.0 In reply to
Yes. He may clear the Users table before import.
Or try to delete only the admin user.

Best regards,
Webmaster33


Paid Support
from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...