Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problems Logging Into ACP?
#1
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! Smile

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


Forum Jump:


Users browsing this thread: 1 Guest(s)