12-17-2008, 08:44 PM
This is what I did:
I found the problem!
install.sql
AUTO_INCREMENT is set at 10. It should be set to 1!
- I logged out by doing this -> /admin/?page=logout
- Then I went into phpMyAdmin to check the staff table
- I saw that my id wasn't 1 (It was 11). I changed it to 1
- Because I was wondering how it could have been set to 1, i checked the auto_increment and it was set to 12
- I changed it to 2
- 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!
Kevin Mark - TheHostingTool Lead Developer