Archive for February, 2012
Feb20How to delete duplicate MySQL records with duplicate field value (as ID)
For some reason i had duplicate entries in my WP database. The ID field in wp_users table was tempered with and was changed to Non Auto-Increment to insert records on the will. I deleted all ID=null records manually and then tried to change it to AUTO INCREMENT but it came up with Duplicate Entry error and then i found that it had duplicated/multiple entries with same IDs as well. Here’s the remedy i had to apply in order to delete those duplicate entries and change ID field to AUTO INCREMENT once again. Click to continue »
Feb04Fix to Windows 7 Error “No such interface supported”
Yesterday i tried to install Internet Explorer 7 standalone version which eventually failed and didn’t work at all. Additionally it caused my Windows 7 Ultimate to produce “No such interface supported” and similar nasty errors when i clicked on main taskbar icons and desktop icons like My Computer. Click to continue »
