I exported my data from the admin panel, downloaded/unzipped the latest NC file, ran install - all OK. My effects from smeighan.net were there OK. I then tried to import my data but got the following:
Importing data from C:\wamp\www
utcracker\export\31\budude_2012-12-04_0444.xml
DELETE from effects_user_hdr where username='budude'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15307','garlands','budude','MT-GARLAND-BB-1','desc','','','','','','2012-12-01 09:55:52')
Error: (1062) Duplicate entry '15307' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15306','garlands','budude','MT-GARLAND-BG-1','desc','','','','','','2012-11-29 22:41:45')
Error: (1062) Duplicate entry '15306' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15305','garlands','budude','MT-GARLAND-BR-1','desc','','','','','','2012-11-29 22:57:23')
Error: (1062) Duplicate entry '15305' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15308','garlands','budude','MT-GARLAND-BW-1','desc','','','','','','2012-11-29 22:49:40')
Error: (1062) Duplicate entry '15308' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15303','garlands','budude','MT-GARLAND-GB-1','desc','','','','','','2012-11-29 22:33:06')
Error: (1062) Duplicate entry '15303' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15302','garlands','budude','MT-GARLAND-GG-1','desc','','','','','','2012-11-30 00:47:59')
Error: (1062) Duplicate entry '15302' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15301','garlands','budude','MT-GARLAND-GR-1','desc','','','','','','2012-11-29 22:19:28')
Error: (1062) Duplicate entry '15301' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15304','garlands','budude','MT-GARLAND-GW-1','desc','','','','','','2012-11-29 22:34:28')
Error: (1062) Duplicate entry '15304' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15299','garlands','budude','MT-GARLAND-RB-1','desc','','','','','','2012-11-29 22:11:21')
Error: (1062) Duplicate entry '15299' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15297','garlands','budude','MT-GARLAND-RG-1','desc','','','','','','2012-11-29 22:09:36')
Error: (1062) Duplicate entry '15297' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15300','garlands','budude','MT-GARLAND-RR-1','desc','','','','','','2012-11-30 00:49:53')
Error: (1062) Duplicate entry '15300' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15298','garlands','budude','MT-GARLAND-RW-1','desc','','','','','','2012-11-29 22:13:55')
Error: (1062) Duplicate entry '15298' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15323','snowflakes','budude','MT-SNOWFLAKE-BGW-4','desc','','','','','','2012-11-29 23:37:47')
Error: (1062) Duplicate entry '15323' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15318','snowflakes','budude','MT-SNOWFLAKE-BRW-1','desc','','','','','','2012-11-29 23:23:55')
Error: (1062) Duplicate entry '15318' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15319','snowflakes','budude','MT-SNOWFLAKE-BRW-4','desc','','','','','','2012-11-29 23:27:23')
Error: (1062) Duplicate entry '15319' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15324','snowflakes','budude','MT-SNOWFLAKE-GBW-4','desc','','','','','','2012-11-29 23:41:30')
Error: (1062) Duplicate entry '15324' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15320','snowflakes','budude','MT-SNOWFLAKE-GRW-4','desc','','','','','','2012-11-29 23:34:19')
Error: (1062) Duplicate entry '15320' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15322','snowflakes','budude','MT-SNOWFLAKE-RBW-4','desc','','','','','','2012-11-29 23:35:58')
Error: (1062) Duplicate entry '15322' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15321','snowflakes','budude','MT-SNOWFLAKE-RGW-4','desc','','','','','','2012-11-29 23:31:24')
Error: (1062) Duplicate entry '15321' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15316','spirals','budude','MT-SPIRAL-R-4-BW','desc','','','','','','2012-11-30 00:36:46')
Error: (1062) Duplicate entry '15316' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15314','spirals','budude','MT-SPIRAL-R-4-GB','desc','','','','','','2012-11-30 00:39:23')
Error: (1062) Duplicate entry '15314' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15315','spirals','budude','MT-SPIRAL-R-4-GW','desc','','','','','','2012-11-30 00:40:07')
Error: (1062) Duplicate entry '15315' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15313','spirals','budude','MT-SPIRAL-R-4-RB','desc','','','','','','2012-11-30 00:40:44')
Error: (1062) Duplicate entry '15313' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15312','spirals','budude','MT-SPIRAL-R-4-RG','desc','','','','','','2012-11-30 00:41:31')
Error: (1062) Duplicate entry '15312' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into effects_user_hdr (EFFECT_ID,EFFECT_CLASS,USERNAME,EFFECT_NAME,EFFECT_DESC,MUSIC_OBJECT_ID,START_SECS,END_SECS,PHRASE_NAME,CREATED,LAST_UPD) values ('15311','spirals','budude','MT-SPIRAL-R-4-RW','desc','','','','','','2012-11-30 00:42:06')
Error: (1062) Duplicate entry '15311' for key 'PRIMARY'
INSERT 25 records into effects_user_hdr
DELETE from effects_user_dtl where username='budude'
INSERT 374 records into effects_user_dtl
DELETE from project_dtl where project_id in (select project_id from project where username='budude')
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3747','phrase21','191.280533','200.690002','','142','1a5be8dc7a2f82ec2540ed1ca092cfbe','15315')
Error: (1062) Duplicate entry '3747' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3748','phrase20','187.295120','191.280533','','142','8481aa31fa9ce49a8d562bdfc16d8317','15316')
Error: (1062) Duplicate entry '3748' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3749','phrase19','183.445786','187.295120','','142','cbb1bf535a1727429cbc4fb4b849b813','15311')
Error: (1062) Duplicate entry '3749' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3750','phrase18','175.708252','183.445786','','142','','15322')
Error: (1062) Duplicate entry '3750' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3751','phrase17','171.820038','175.708252','','142','52e7f5523571ed45f0a9fabe7b0fd25a','15320')
Error: (1062) Duplicate entry '3751' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3752','phrase16','168.126236','171.820038','','142','','15324')
Error: (1062) Duplicate entry '3752' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3753','phrase15','156.364395','168.126236','','142','6418a54d5a6f2639a59a4643740e31a2','15319')
Error: (1062) Duplicate entry '3753' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3754','phrase14','148.704620','156.364395','','142','6418a54d5a6f2639a59a4643740e31a2','15319')
Error: (1062) Duplicate entry '3754' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3755','phrase13','140.869873','148.704620','','142','','15323')
Error: (1062) Duplicate entry '3755' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3756','phrase12','125.433685','140.869873','','142','21e5d1a1535574ef8c8c2b18bb246a30','15298')
Error: (1062) Duplicate entry '3756' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3757','phrase11','117.773911','125.433685','','142','31e40de18ce47de39aae7dbafbe74a99','15300')
Error: (1062) Duplicate entry '3757' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3758','phrase10','94.639053','117.773911','','142','d240e3f06c10861d2ba7e1ac95b7b12a','15297')
Error: (1062) Duplicate entry '3758' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3759','phrase9','75.392410','94.639053','','142','228931ac7af9d5da9e22aa784ff083a5','15299')
Error: (1062) Duplicate entry '3759' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3760','phrase8','63.650013','75.392410','','142','','15304')
Error: (1062) Duplicate entry '3760' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3761','phrase7','55.990234','63.650013','','142','','15301')
Error: (1062) Duplicate entry '3761' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3762','phrase6','48.213814','55.990234','','142','2b99ad524fbb09c276a2a8120919ca9a','15302')
Error: (1062) Duplicate entry '3762' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3763','phrase5','40.515156','48.213814','','142','e2a2e99ce8d830ad8fc34c3cf28353ef','15303')
Error: (1062) Duplicate entry '3763' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3764','phrase4','32.699852','40.515156','','142','29c40d5bb5e6386c36dc74a2a58666c1','15307')
Error: (1062) Duplicate entry '3764' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3765','phrase3','16.952599','32.699852','','142','13afa28a0bfa405c5c81f7d0cbe7b50a','15305')
Error: (1062) Duplicate entry '3765' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3766','phrase2','6.648841','16.952599','','142','2c3594091952b8679f3cb54fec73817d','15306')
Error: (1062) Duplicate entry '3766' for key 'PRIMARY'
A fatal MySQL error occured.
Query: INSERT into project_dtl (PROJECT_DTL_ID,PHRASE_NAME,START_SECS,END_SECS,EFFECT_NAME,PROJECT_ID,CHECK_SUM,EFFECT_ID) values ('3767','phrase1','0.272175','6.648841','','142','29c40d5bb5e6386c36dc74a2a58666c1','15307')
Error: (1062) Duplicate entry '3767' for key 'PRIMARY'
INSERT 21 records into project_dtl
DELETE from project where username='budude'
A fatal MySQL error occured.
Query: INSERT into project (PROJECT_ID,SONG_ID,USERNAME,FRAME_DELAY,MODEL_NAME,CHECK_SUM,LAST_UPDATE_DATE,LAST_COMPILE_DATE) values ('142','1','budude','50','MTREE-30S-42P','','2012-12-01 10:53:56','2012-12-01 10:54:18')
Error: (1062) Duplicate entry '142' for key 'PRIMARY'
INSERT 1 records into project
DELETE from models_strands where username='budude'
INSERT 15 records into models_strands
DELETE from models_strand_segments where username='budude'
INSERT 9 records into models_strand_segments
DELETE from models where username='budude'
INSERT 4 records into models
Import complete
I looked around using phpadmin but wasn't sure how the keys are set up. Some names are the same in the local/net versions but it appears that the import command deletes all entries for 'budude' first so this shouldn't be a problem... This is the first time I have used the import tool as I never had that much to save until now. My models are there but I ended up with no effects at all. I re-installed the database from the net and it matches up OK. The exported data (XML) "looks" complete from what I can tell.
I've been having this problem for a while now. I believe that some of the records from other users for effects, projects, and models that have been created on the Nutcracker production system are being copied during the local install. This causes a conflict between the records brought over from the production system and the ones we create on our local installations. I've been using a stop gap method to restore my information. I search for all the records in the range show by the errors (i.e. for your example search effects_user_hdr for all EFFECT_ID records "BETWEEN" 15297,15324 and delete them all. Repeat this for each of the other categories, in your case project_dtl (PROJECT_DTL_ID) and project (PROJECT_ID). Once all of these have been deleted - re-import your data, you should get no errors and your information will be back. I'm not sure what problems this may cause in our local installs down the road but I've been pretty desperate not to lose the effects and projects I had completed and I intend to wipe the local install after all my sequences are complete and start from scratch after the Holidays. Good Luck.
Thanks - will give that a shot.
This is a known issue we will fix after xmas. It comes because we are using keys (project_id, effect_id, project_dtl_id) that get duplicated.
on meighan.net 800 people use the system, create new projects, songs .etc. as they do those keys increment and get used.
if you create anything on a localhost those same keys get assigned a new number. unfortunately, they ids can be duplicated.
deleting the records already there is a temp solution and should work.
The architectural issue we have is how to export a database that people are creating anmd using records and put back your exported records without duplicating keys?
The answer is is to use keys without the id's. Project keys will be username,projectname. effects will be username,effect_name.
Now there is no duplication on an export /import.
a more complicated solutuin would be to rename keys and shift everything in your local installs. Kurt and I will work to fix this.
a 3rd solution is that as you change entries in a local install, meighan.net will be updated automatically.
fot this season
something like
if they are not consecutive
delete from effects_user_hdr where effect_id in (15307,15308,15311)
or
if they are consecutive
delete from effects_user_hdr where effect_id >= 15297 and effect_id <= 15323
Another permanent fix:
Re-enter your projects and effects into meighan.net
On the next database refresh you will be back in sync.
i have suggested for a long time that you enter your project and effects into meighan.net after you are satisfied.
otherwise you will get this error on every database refresh.

