Jump to content


Photo

MySQL is Bi-Polar?


  • Please log in to reply
5 replies to this topic

#1 sghetti

sghetti
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 31 July 2003 - 09:56 PM

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.
Behold the white horse. And the rider that sat upon him was sghetti. And hell followed with him.

#2 BinaryStar

BinaryStar
  • Staff Alumni
  • Advanced Member
  • 74 posts
  • LocationBethlehem, PA

Posted 31 July 2003 - 10:37 PM

have permissions changed?

BS :D

#3 sghetti

sghetti
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 31 July 2003 - 10:43 PM

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.
Behold the white horse. And the rider that sat upon him was sghetti. And hell followed with him.

#4 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 31 July 2003 - 10:53 PM

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?

#5 sghetti

sghetti
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 01 August 2003 - 03:01 AM

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.
Behold the white horse. And the rider that sat upon him was sghetti. And hell followed with him.

#6 michael yare

michael yare
  • Members
  • PipPip
  • Member
  • 25 posts
  • LocationLondon, UK

Posted 01 August 2003 - 12:28 PM

Is all the data from this script going in to the recently deleted/recreated table?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users