[SQL] Duplicate entry for a key that does not exist?
Hey all, I converted my old catalogue over to the tables that will work with Swift EMU, but upon importing the SQL I seem to get a warning. "Error. DUPLICATE Entry '65535' for key 'PRIMARY'" I looked through the SQL and there is no key known as 65535. I entered it on a blank database and got the same error. new3.sql Download link (items_base). Any reason to why it wont work for Swift DB? I have truncated all tables necessary.
Re: [SQL] Duplicate entry for a key that does not exist?
The max number of smallint(6) is 65535.
So you need to change smallint(6) to int(32) or big int.