sghetti Posted July 31, 2003 Share Posted July 31, 2003 One day everything is great, the next it\'s very sporadic. I have a registration script. Only, the last few days it won\'t work. MySQL won\'t allow me to insert. Is it possible this is MySQL or the script? I don\'t see how it could be the script as it has been working just fine up until a few days ago. Quote Link to comment Share on other sites More sharing options...
BinaryStar Posted July 31, 2003 Share Posted July 31, 2003 have permissions changed? BS Quote Link to comment Share on other sites More sharing options...
sghetti Posted July 31, 2003 Author Share Posted July 31, 2003 Here\'s the deal. I was running it fine and then I couldn\'t get MySQL to start up at all. So I uninstalled and reinstalled it. After the reinstall all of my other scripts run like they should except for this one registration script. I have changed nothing in the script nor did I change any settings in MySQL. I perplexed. Quote Link to comment Share on other sites More sharing options...
gizmola Posted July 31, 2003 Share Posted July 31, 2003 It could be many things. Some suggestions to try: run myisamchk on your table to make sure it\'s not corrupt. Make sure you\'ve not run out of space. Check the mysql log. Execute an insert from the command line. Are you out of keys? Is it trying to insert a duplicate into a column(s) where a unique index exists? What error is returned on the insert? Quote Link to comment Share on other sites More sharing options...
sghetti Posted August 1, 2003 Author Share Posted August 1, 2003 I deleted the old table and set up a new one with full permissions and it still won\'t insert. Just can\'t figure this out. Quote Link to comment Share on other sites More sharing options...
michael yare Posted August 1, 2003 Share Posted August 1, 2003 Is all the data from this script going in to the recently deleted/recreated table? Quote Link to comment Share on other sites More sharing options...
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.