I have a database with about 15 tables. Up until about 3 days ago I had held steady at about 250 users for the last 15 months. Everyday 2 or would be deleted from table and 2 or 3 would join.
In the last 3 days 400 people have joined. And now, I can't see any of those users in the database by doing a simple "Select table.* etc". BUT if I do a specific search for the user I get a match.
I use phpmyadmin (like most) and if I sort the fields in the table by name and go through the table that way, I don't see the users name. BUT if I do a "query by example" I get a match with all the information.
When the information comes up, if I click on Edit or Delete I get the message "query was empty" or "does not exist". But when I go to re-add them as a test I get the "duplicate key error" as I have made the username a unique key.
So basically I can't edit or delete the users because the db says they don't exist, yet I can't add them manually because the db says they already exist.
Any thoughts?
Oh yeah....if I remove the "unique key" arguement I can manually add them with their original information (exactly the same) with no problems.
Help?
In the last 3 days 400 people have joined. And now, I can't see any of those users in the database by doing a simple "Select table.* etc". BUT if I do a specific search for the user I get a match.
I use phpmyadmin (like most) and if I sort the fields in the table by name and go through the table that way, I don't see the users name. BUT if I do a "query by example" I get a match with all the information.
When the information comes up, if I click on Edit or Delete I get the message "query was empty" or "does not exist". But when I go to re-add them as a test I get the "duplicate key error" as I have made the username a unique key.
So basically I can't edit or delete the users because the db says they don't exist, yet I can't add them manually because the db says they already exist.
Any thoughts?
Oh yeah....if I remove the "unique key" arguement I can manually add them with their original information (exactly the same) with no problems.
Help?