#1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    England, UK
    Posts
    83
    Rep Power
    14
    I am using PHPMyAdmin. I have a table with a column called id, this is INT(11) and is auto_increment.

    It goes up to 153 then when I add another row it seems to want to go up to 6******!

    Does anyone know why?

    How do I sort it?

    ------------------
    Girish Gupta
    MusicGoesOn.com
  2. #2
  3. No Profile Picture
    The Dude Abides
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Feb 2000
    Location
    grass valley,ca
    Posts
    1,062
    Rep Power
    16
    Which version of Phpmyadmin and MySQL?

    Try checking the phpmyadmin changelog for related bugs, as well as the MySQL docs. Don't eliminate your server either. I've seen errors caused by different server configs as well

    chris
  4. #3
  5. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    England, UK
    Posts
    83
    Rep Power
    14
    I'm using MySQL 3.23.21-beta-log and phpMyAdmin 2.0.1

    I can't find anything in the mySQL docs, where would I find the phpMyAdmin changelog?

    Thanks

    ------------------
    Girish Gupta
    MusicGoesOn.com
  6. #4
  7. No Profile Picture
    The Dude Abides
    Devshed Beginner (1000 - 1499 posts)

    Join Date
    Feb 2000
    Location
    grass valley,ca
    Posts
    1,062
    Rep Power
    16
    The change log is on the phpmyadmin site phpwizard.net.

    Are you uploading a text file database or are you creating it using phpmyadmin? Upload errors are very common. I've seen some really wild errors from doing the load data (local?) infile command.

    I would also suggest contacting your hosting provider.

    good luck
    chris

Similar Threads

  1. Best way to denote "" symbol
    By pieux in forum HTML Programming
    Replies: 2
    Last Post: August 31st, 2001, 03:48 PM
  2. auto_increment +153
    By girish_gupta in forum PHP Development
    Replies: 0
    Last Post: October 7th, 2000, 01:38 PM

IMN logo majestic logo threadwatch logo seochat tools logo