Problems Logging Into ACP?

[Kevin]

This is what I did:

1. I logged out by doing this -> /admin/?page=logout
2. Then I went into phpMyAdmin to check the staff table
3. I saw that my id wasn't 1 (It was 11). I changed it to 1
4. Because I was wondering how it could have been set to 1, i checked the auto_increment and it was set to 12
5. I changed it to 2
6. I then tried logging into the Admin CP and it worked!
   

I found the problem!

install.sql

Code:

--
-- Table structure for table `<PRE>staff`
--

CREATE TABLE IF NOT EXISTS `<PRE>staff` (
  `id` mediumint(9) NOT NULL auto_increment,
  `user` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `password` text NOT NULL,
  `salt` text NOT NULL,
  `perms` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

AUTO_INCREMENT is set at 10. It should be set to 1!