Actually the problem seems to be with multiple entries with the same owner name -----Original Message----- From: Ken A [mailto:ka@xxxxxxxxxxx] Sent: Monday, December 29, 2008 2:46 PM To: Squirrelmail User Support Mailing List Subject: Re: Problems converting Sqmail .abook flatfiles into MySQL tables. Mike Swearingen wrote: > Hello, > PRIMARY KEY (owner,nickname) is going to give you trouble if all your nicknames are '' Maybe change it to PRIMARY KEY (owner,email) ? Ken > > > I was hoping someone can help with converting the .abook flatfiles into > mysql records. We were able to generate a sql script that should allow us to > import all the .abooks by using the flat2sql.pl file that was supplied from > http://www.squirrelmail.org/docs/admin/admin-5.html#db-backend, but as you > can see below the INSERT command attempts to add multiple enteries in the > same sqmail.address table. This of course generates a sql error. The error > references duplicate entry's for this one record. > > > > As you guess this user has more than one address in their .abook record. > > > > Any Suggestions? > > > > > > INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) > VALUES ('jcmerchant','','','Real Name','email.name@company',''); > > INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) > VALUES ('jcmerchant','','','Real Name','email.name@company',''); > > INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) > VALUES ('jcmerchant','','','Hoksbergen','edsylvia@xxxxxxxxxxxxxxx',''); > > INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) > VALUES ('jcmerchant','','','Nancy King','njking@xxxxxxxxxxx',''); > > INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) > VALUES ('jcmerchant','','','Krish & Bob > Fennessy','nana1950@xxxxxxxxxxx',''); > > INSERT INTO sqmail.address (owner,nickname,firstname,lastname,email,label) > VALUES ('jcmerchant','','','Rita Glasscock','plcrc@xxxxxxx',''); > > > > > > > > Thanks, > > > > Mike Swearingen > > > > > ------------------------------------------------------------------------ > > ---------------------------------------------------------------------------- -- > > > ------------------------------------------------------------------------ > > ----- > squirrelmail-users mailing list > Posting guidelines: http://squirrelmail.org/postingguidelines > List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx > List archives: http://news.gmane.org/gmane.mail.squirrelmail.user > List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users -- Ken Anderson http://www.pacific.net/ ---------------------------------------------------------------------------- -- ----- squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users ------------------------------------------------------------------------------ ----- squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
