Famous Posted July 12, 2013 Group: Members Topic Count: 145 Topics Per Day: 0.03 Content Count: 455 Reputation: 3 Joined: 06/19/12 Last Seen: February 26, 2018 Share Posted July 12, 2013 Quote Link to comment Share on other sites More sharing options...
Famous Posted August 20, 2013 Group: Members Topic Count: 145 Topics Per Day: 0.03 Content Count: 455 Reputation: 3 Joined: 06/19/12 Last Seen: February 26, 2018 Author Share Posted August 20, 2013 bump! anyone? Quote Link to comment Share on other sites More sharing options...
GmOcean Posted August 20, 2013 Group: Members Topic Count: 31 Topics Per Day: 0.01 Content Count: 666 Reputation: 93 Joined: 04/27/12 Last Seen: August 17, 2015 Share Posted August 20, 2013 As far as I can see, it clearly says Duplicate Entry, which would suggest somewhere in your query You have a duplicate entry. Also, I failed to see why you needed to specify the account ID repeatedly when trying to replace certain values. Quote Link to comment Share on other sites More sharing options...
Patskie Posted August 20, 2013 Group: Members Topic Count: 50 Topics Per Day: 0.01 Content Count: 1702 Reputation: 241 Joined: 09/05/12 Last Seen: 2 hours ago Share Posted August 20, 2013 Primary key should be unique. In your case you are duplicating a data in a column which is considered a primary key Quote Link to comment Share on other sites More sharing options...
Emistry Posted August 20, 2013 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10018 Reputation: 2369 Joined: 10/28/11 Last Seen: Sunday at 05:32 PM Share Posted August 20, 2013 since most of the "ID" inside the table of each SQL table for RO is kinda useless...and meaningless...you can just simply remove all the "ID" column / datafield ...and re-import it ... Quote Link to comment Share on other sites More sharing options...
Question
Famous
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.