Topic: From Agora Forum to SMF

[!Beevan]

OK....was being very thick.....

I didnt put the full database name in  

ok got past that....

now we have anew error:

Unssucessful :....


Caused the error:

Duplicate entry '62' for key 1

If I recall correctly a friend in a related field was having a similar issue. I will send him an e-mail and see if maybe he knows anything about a fix.

[Tinny77]

Sorry to bump such an old topic, but the problem I got is related to this one...
Tried the converter but I always get duplicated Primary errors.
Tried an insert ignore but 3 messages out of four were missing.
Anyone wnows how to fix this problem?
Tried toset primary to auto increment, tried to edit it tomanother number after it has been inserted... No luck... I wanna move from Agora and I can't

[emanuele]

Don't know if it works in your case, but what I notice is that from time to time reduce the number of "items" converted in one step helps.
For example if you open the agora_to_admf.sql file you can find this line:

Code: [Select]

---* {$to_prefix}messages 200that means that at each rount the converter will take 200 messages and convert all of them and the insert the result into the SMF database, try with a lower number, for example:

Code: [Select]

---* {$to_prefix}messages 50doing this will result into a slower conversion process, but at least should avoid/reduce similar issues...unless I'm completely wrong and in my case it was just a case...