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
