Fix Google Drive Primary Key Must Be Unique Error
Huge, huge props to the person that posted this information. What a lifesaver, since our Google Overlords have been merciful and gracious absolutely useless in responding to this problem. What a bunch of drones! Anyhow, here's the fix that worked for me (thanks to Guru).
A sigh of relief. This has been bugging me intermittently for months.
Mad props to Guru.
Obvious caveat: These steps worked for me. They might not work for you. You could seriously screw up your PC. Windows is inherently...susceptible to humans thoroughly damaging it. In fact, if this little disclaimer creates any doubt or anxiety for you, sell your PC and buy an iPad, or whatever you're less likely to foul up and blame someone else for. (I love my iPad Mini, but can't escape PC's thanks to the day job). If you don't already, suck it up and assume full responsibility for your actions, like most of us used to do back in the dark ages. Dammit, I'm starting to sound really old.
- Start Google Drive
- Hold the SHIFT key down and click the Google Drive systray icon, which will show the 'Enable diagnostic mode' special menu.
- Click 'Enable diagnostic mode' menu.
- Wait until Google Drive crashes and shows the "primary key must be unique" error message. Let the application shutdown.
- Go to "c:\Users\%username%\AppData\Local\Google\Drive" folder and open "sync_log.log". (If it opens slowly with Windows Notepad, I recommend using Notepad++ instead)
- Search/find (CTRL + F) for this text: "Detected conflict while trying to download file to".
- After 'to' is the file name associated with the conflict. Rename it. Do this for all conflicted files (if there are more than one).
- Start Google Drive.
A sigh of relief. This has been bugging me intermittently for months.
Mad props to Guru.
Obvious caveat: These steps worked for me. They might not work for you. You could seriously screw up your PC. Windows is inherently...susceptible to humans thoroughly damaging it. In fact, if this little disclaimer creates any doubt or anxiety for you, sell your PC and buy an iPad, or whatever you're less likely to foul up and blame someone else for. (I love my iPad Mini, but can't escape PC's thanks to the day job). If you don't already, suck it up and assume full responsibility for your actions, like most of us used to do back in the dark ages. Dammit, I'm starting to sound really old.