Folks, I am moving an old home-made user forum to phpBB. I have adapted my old users table to match the phpBB table, so that I can import all my old users. Unfortunately every time I try, I get the same error:
#1062 - Duplicate entry '3' for key 'PRIMARY'
My primary is the user ID, which I know for certain that is not duplicate. What am I doing wrong? You can see the tables here:
Thank you gbritton for your answer. I'm a total stranger to SQL, so I've taken it one step at a time. I tried so far with phpMyAdmin, exporting the old table to my hard drive, and then selecting the new table, and attempting to import the dump. I haven't tried queries (remember I'm starting from 0, so I would have to read SQL syntax and commands from the beginning).