Housekeeping panel Admin User Setup Need Help

[Cody3]

the title says it all

[Jackbee]

What do you exactly need help with?

[jdr10027]

what is the problem with the admin user panel setup?

[Cody3]

no i mean the mysql isnt working right it wont create the tables in the db and i cant login to it

[jdr10027]

you have to create it you got a file called sql.txt that has to be imported to your database

[Cody3]

Your SQL query has been executed successfully (Query took 0.0035 sec) SQL query:
-- phpMyAdmin SQL Dump -- version 2.6.4-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 19, 2006 at 05:23 PM -- Server version: 4.1.18 -- PHP Version: 4.3.11 -- -- Database: `` -- -- -------------------------------------------------------- -- -- Table structure for table `adminmsg` -- CREATE TABLE `adminmsg` ( `id` int(11) NOT NULL auto_increment, `username` varchar(225) NOT NULL default '', `comment` text NOT NULL, `IP` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -------------------------------------------------------- -- -- Table structure for table `alert` -- CREATE TABLE `alert` ( `ID` int(11) NOT NULL auto_increment, `message` text NOT NULL, `name` varchar(100) NOT NULL default '', `active` varchar(200) NOT NULL default '', `direct` varchar(100) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=298 ; -- -------------------------------------------------------- -- -- Table structure for table `alerts` -- CREATE TABLE `alerts` ( `id` int(225) NOT NULL auto_increment, `sender` varchar(225) NOT NULL default '', `sip` varchar(225) NOT NULL default '', `msg` varchar(225) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `application` -- CREATE TABLE `application` ( `status` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `banned_songs` -- CREATE TABLE `banned_songs` ( `id` int(11) NOT NULL auto_increment, `Song` text NOT NULL, `From` text NOT NULL, `Long` text NOT NULL, `Reason` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `config` -- CREATE TABLE `config` ( `config_name` varchar(20) NOT NULL default '', `config_value` varchar(20) NOT NULL default '', `config_type_1` varchar(20) NOT NULL default '', `config_value_2` varchar(50) NOT NULL default '', `config_type_2` varchar(20) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `hellos` -- CREATE TABLE `hellos` ( `id` int(11) NOT NULL auto_increment, `message` text NOT NULL, `ip` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ; -- -------------------------------------------------------- -- -- Table structure for table `ipban` -- CREATE TABLE `ipban` ( `ID` int(11) NOT NULL default '0', `IP` varchar(15) NOT NULL default '', `Username` text NOT NULL, `Reason` text NOT NULL, `Banned` text NOT NULL, UNIQUE KEY `ID` (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `maintanance` -- CREATE TABLE `maintanance` ( `status` varchar(200) character set armscii8 collate armscii8_bin NOT NULL default '', `reason` text NOT NULL, `title` text NOT NULL, `image` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `missslot` -- CREATE TABLE `missslot` ( `id` int(11) NOT NULL auto_increment, `Username` varchar(225) NOT NULL default '', `Time` text NOT NULL, `Day` text NOT NULL, `Reason` text NOT NULL, `Cover` text NOT NULL, `ip` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Table structure for table `news` -- CREATE TABLE `news` ( `ID` int(11) NOT NULL auto_increment, `NoticeTitle` text NOT NULL, `NoticeMessage` text NOT NULL, `NoticeDAT` text NOT NULL, `IP` int(11) NOT NULL default '0', `NoticeUsername` text NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -------------------------------------------------------- -- -- Table structure for table `notices` -- CREATE TABLE `notices` ( `ID` int(11) NOT NULL auto_increment, `NoticeTitle` text NOT NULL, `NoticeMessage` text NOT NULL, `NoticeDAT` text NOT NULL, `IP` int(11) NOT NULL default '0', `NoticeUsername` text NOT NULL, UNIQUE KEY `ID` (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Table structure for table `officialdjs` -- CREATE TABLE `officialdjs` ( `ID` int(11) NOT NULL auto_increment, `NoticeMessage` text NOT NULL, `IP` varchar(15) NOT NULL default '', UNIQUE KEY `ID` (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `pm` -- CREATE TABLE `pm` ( `id` varchar(50) NOT NULL default '', `ip` varchar(50) NOT NULL default '', `send_to` varchar(50) NOT NULL default '', `send_from` varchar(50) NOT NULL default '', `message` text NOT NULL, `date` varchar(50) NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `privmsgs` -- CREATE TABLE `privmsgs` ( `msg_id` int(10) NOT NULL auto_increment, `msg_title` varchar(100) NOT NULL default '', `msg_txt` text NOT NULL, `msg_read` int(1) NOT NULL default '0', `msg_date` varchar(12) NOT NULL default '0000-00-00', `msg_time` varchar(100) NOT NULL default '', `msg_ip` varchar(20) NOT NULL default '', `msg_to` varchar(50) NOT NULL default '', `msg_from` varchar(50) NOT NULL default '', PRIMARY KEY (`msg_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `promotion` -- CREATE TABLE `promotion` ( `id` int(11) NOT NULL auto_increment, `yourname` text NOT NULL, `djname` text NOT NULL, `djreason` text NOT NULL, `IP` int(11) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `radioinfo` -- CREATE TABLE `radioinfo` ( `id` int(11) NOT NULL auto_increment, `Radio_IP` text NOT NULL, `Radio_Port` text NOT NULL, `Radio_Password` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -------------------------------------------------------- -- -- Table structure for table `requests` -- CREATE TABLE `requests` ( `id` int(11) NOT NULL auto_increment, `habboname` varchar(225) NOT NULL default '', `type` varchar(225) NOT NULL default '', `dj_name` varchar(225) NOT NULL default '', `message` text NOT NULL, `date` text NOT NULL, `ip` varchar(15) NOT NULL default '', `report` tinyint(1) NOT NULL default '0', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=853 ; -- -------------------------------------------------------- -- -- Table structure for table `requests2` -- CREATE TABLE `requests2` ( `id` int(11) NOT NULL auto_increment, `habboname` varchar(225) NOT NULL default '', `type` varchar(225) NOT NULL default '', `dj_name` varchar(225) NOT NULL default '', `message` text NOT NULL, `date` text NOT NULL, `ip` varchar(15) NOT NULL default '', `report` tinyint(1) NOT NULL default '0', `email` text NOT NULL, `example` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1041 ; -- -------------------------------------------------------- -- -- Table structure for table `rooms` -- CREATE TABLE `rooms` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `message` text NOT NULL, `ip` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=121 ; -- -------------------------------------------------------- -- -- Table structure for table `shoutout` -- CREATE TABLE `shoutout` ( `id` int(11) NOT NULL auto_increment, `username` varchar(225) NOT NULL default '', `comment` text NOT NULL, `IP` varchar(15) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Table structure for table `shows` -- CREATE TABLE `shows` ( `name` text NOT NULL, `dj` text NOT NULL, `day` text NOT NULL, `time` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `sitenews` -- CREATE TABLE `sitenews` ( `ID` int(11) NOT NULL auto_increment, `NoticeTitle` text NOT NULL, `NoticeMessage` text NOT NULL, `NoticeDAT` text NOT NULL, `NoticeTIM` text NOT NULL, `IP` int(11) NOT NULL default '0', `NoticeUsername` text NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=78 ; -- -------------------------------------------------------- -- -- Table structure for table `slotrequest` -- CREATE TABLE `slotrequest` ( `id` int(11) NOT NULL auto_increment, `Username` varchar(225) NOT NULL default '', `Day` text NOT NULL, `Time` text NOT NULL, `ShowName` text NOT NULL, `IP` varchar(15) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `special` -- CREATE TABLE `special` ( `id` varchar(225) NOT NULL default '', `a` varchar(225) NOT NULL default '', `b` varchar(225) NOT NULL default '', `c` varchar(225) NOT NULL default '', `d` varchar(225) NOT NULL default '', `e` varchar(225) NOT NULL default '', `f` varchar(225) NOT NULL default '', `x` varchar(225) NOT NULL default '', `g` varchar(225) NOT NULL default '', `h` varchar(225) NOT NULL default '', `i` varchar(225) NOT NULL default '', `j` varchar(225) NOT NULL default '', `k` varchar(225) NOT NULL default '', `l` varchar(225) NOT NULL default '', `m` varchar(225) NOT NULL default '', `n` varchar(225) NOT NULL default '', `o` varchar(225) NOT NULL default '', `p` varchar(225) NOT NULL default '', `q` varchar(225) NOT NULL default '', `r` varchar(225) NOT NULL default '', `s` varchar(225) NOT NULL default '', `t` varchar(225) NOT NULL default '', `u` varchar(225) NOT NULL default '', `v` varchar(225) NOT NULL default '', `w` varchar(225) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `staff` -- CREATE TABLE `staff` ( `id` int(11) NOT NULL auto_increment, `username` varchar(225) NOT NULL default '', `password` text NOT NULL, `email` text NOT NULL, `level` int(1) NOT NULL default '0', `ban` int(1) NOT NULL default '0', `lastlogin` varchar(225) NOT NULL default 'never', `ip` varchar(15) NOT NULL default '', `avatar` text NOT NULL, UNIQUE KEY `id` (`id`), FULLTEXT KEY `password` (`password`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=218 ; -- -- Mini-Mans help ^_^ -- INSERT INTO `staff` VALUES ('1', 'admin', '4cb9c8a8048fd02294477fcb1a41191a', '[email protected]', '1', '0', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `staff_chat` -- CREATE TABLE `staff_chat` ( `id` int(11) NOT NULL auto_increment, `username` varchar(225) NOT NULL default '', `message` text NOT NULL, `time` time NOT NULL default '00:00:00', `ip` varchar(15) NOT NULL default '', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Table structure for table `staffchat` -- CREATE TABLE `staffchat` ( `id` tinyint(10) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `body` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `status` -- CREATE TABLE `status` ( `id` varchar(225) NOT NULL default '', `a` varchar(225) NOT NULL default '', `b` varchar(225) NOT NULL default '', `c` varchar(225) NOT NULL default '', `d` varchar(225) NOT NULL default '', `e` varchar(225) NOT NULL default '', `f` varchar(225) NOT NULL default '', `x` varchar(225) NOT NULL default '', `g` varchar(225) NOT NULL default '', `h` varchar(225) NOT NULL default '', `i` varchar(225) NOT NULL default '', `j` varchar(225) NOT NULL default '', `k` varchar(225) NOT NULL default '', `l` varchar(225) NOT NULL default '', `m` varchar(225) NOT NULL default '', `n` varchar(225) NOT NULL default '', `o` varchar(225) NOT NULL default '', `p` varchar(225) NOT NULL default '', `q` varchar(225) NOT NULL default '', `r` varchar(225) NOT NULL default '', `s` varchar(225) NOT NULL default '', `t` varchar(225) NOT NULL default '', `u` varchar(225) NOT NULL default '', `v` varchar(225) NOT NULL default '', `w` varchar(225) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `top` -- CREATE TABLE `top` ( `id` int(10) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `artist` varchar(255) NOT NULL default '', `album` varchar(255) NOT NULL default '', `votes` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `topnotices` -- CREATE TABLE `topnotices` ( `ID` int(11) NOT NULL auto_increment, `NoticeMessage` text NOT NULL, `IP` int(11) NOT NULL default '0', UNIQUE KEY `ID` (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Table structure for table `users_online` -- CREATE TABLE `users_online` ( `id` int(11) NOT NULL default '0', `username` varchar(225) NOT NULL default '', `time` text NOT NULL, `url` text NOT NULL, `kick` tinyint(1) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;


but it still has no tables whats with that

[jdr10027]

do you have the right user name, database and password in all index and dbconfig files? there is 1 /2 dbconfig files in the timetable folder too

[Cody3]

nvm i fixed it thank you for your help i had a problem with my file

[phpme]

i've had it for years but neva been able to install any help?

[CJ-real]

make a new thread