Author Topic: Error can't find table 0  (Read 2265 times)

Jhonny

  • Hero Member

  • Offline
  • *****
  • 4183
  • Personal Text
    Peace, enjoy life, last sleep is longer than live!
Error can't find table 0
« on: July 28, 2014, 01:15:11 PM »
When installing the new one rdj 171 I got the error message can't find table 0.


When checking the database with HeidiSQL, i saw that the database was not installed properly.


Backup of the database who is not properly installed.
Code: [Select]
-- MySqlBackup.NET dump 1.5.7 beta
-- Dump time: 2014-07-28 12:51:15
-- ------------------------------------------------------
-- Server version    5.6.16 MySQL Community Server (GPL)


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


--
-- Definition of table `carts`
--

DROP TABLE IF EXISTS `carts`;
CREATE TABLE IF NOT EXISTS `carts` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `carts`
--

/*!40000 ALTER TABLE `carts` DISABLE KEYS */;
INSERT INTO `carts` (`ID`,`name`) VALUES
(1,'Default');
/*!40000 ALTER TABLE `carts` ENABLE KEYS */;


--
-- Definition of table `carts_list`
--

DROP TABLE IF EXISTS `carts_list`;
CREATE TABLE IF NOT EXISTS `carts_list` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `pID` int(11) NOT NULL,
  `swID` int(11) NOT NULL,
  `swButton` int(11) NOT NULL,
  `color` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `carts_list`
--

/*!40000 ALTER TABLE `carts_list` DISABLE KEYS */;

/*!40000 ALTER TABLE `carts_list` ENABLE KEYS */;


--
-- Definition of table `category`
--

DROP TABLE IF EXISTS `category`;
CREATE TABLE IF NOT EXISTS `category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category`
--

/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` (`ID`,`name`) VALUES
(1,'Music'),
(2,'Sound Effects'),
(3,'Sweepers'),
(4,'Station IDs'),
(5,'Jingles'),
(6,'Promos'),
(7,'Commercials'),
(8,'News'),
(9,'Interviews'),
(10,'Radio Shows'),
(11,'Radio Streams');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;


--
-- Definition of table `events`
--

DROP TABLE IF EXISTS `events`;
CREATE TABLE IF NOT EXISTS `events` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `type` tinyint(2) NOT NULL,
  `time` varchar(20) NOT NULL,
  `name` varchar(200) NOT NULL,
  `date` date DEFAULT '2002-01-01',
  `day` varchar(30) DEFAULT '&',
  `hours` varchar(100) DEFAULT '&',
  `data` text,
  `enabled` enum('True','False') DEFAULT 'True',
  `catID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--

/*!40000 ALTER TABLE `events` DISABLE KEYS */;

/*!40000 ALTER TABLE `events` ENABLE KEYS */;


--
-- Definition of table `events_categories`
--

DROP TABLE IF EXISTS `events_categories`;
CREATE TABLE IF NOT EXISTS `events_categories` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events_categories`
--

/*!40000 ALTER TABLE `events_categories` DISABLE KEYS */;
INSERT INTO `events_categories` (`ID`,`name`) VALUES
(1,'Default');
/*!40000 ALTER TABLE `events_categories` ENABLE KEYS */;


--
-- Definition of table `genre`
--

DROP TABLE IF EXISTS `genre`;
CREATE TABLE IF NOT EXISTS `genre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=149 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `genre`
--

/*!40000 ALTER TABLE `genre` DISABLE KEYS */;
INSERT INTO `genre` (`id`,`name`) VALUES
(1,'Acapella'),
(2,'Acid'),
(3,'Acid Jazz'),
(4,'Acid Punk'),
(5,'Acoustic'),
(6,'Alternative'),
(7,'Alternative Rock'),
(8,'Ambient'),
(9,'Anime'),
(10,'Avantgarde'),
(11,'Ballad'),
(12,'Bass'),
(13,'Beat'),
(14,'Bebob'),
(15,'Big Band'),
(16,'Black Metal'),
(17,'Bluegrass'),
(18,'Blues'),
(19,'Booty Bass'),
(20,'BritPop'),
(21,'Cabaret'),
(22,'Celtic'),
(23,'Chamber Music'),
(24,'Chanson'),
(25,'Chorus'),
(26,'Christian Gangsta Rap'),
(27,'Christian Rap'),
(28,'Christian Rock'),
(29,'Classic Rock'),
(30,'Classical'),
(31,'Club'),
(32,'Club - House'),
(33,'Comedy'),
(34,'Contemporary Christian'),
(35,'Country'),
(36,'Crossover'),
(37,'Cult'),
(38,'Dance'),
(39,'Dance Hall'),
(40,'Darkwave'),
(41,'Death Metal'),
(42,'Disco'),
(43,'Dream'),
(44,'Drum & Bass'),
(45,'Drum Solo'),
(46,'Duet'),
(47,'Easy Listening'),
(48,'Electronic'),
(49,'Ethnic'),
(50,'Euro-House'),
(51,'Euro-Techno'),
(52,'Eurodance'),
(53,'Fast Fusion'),
(54,'Folk'),
(55,'Folk-Rock'),
(56,'Folklore'),
(57,'Freestyle'),
(58,'Funk'),
(59,'Fusion'),
(60,'Game'),
(61,'Gangsta'),
(62,'Goa'),
(63,'Gospel'),
(64,'Gothic'),
(65,'Gothic Rock'),
(66,'Grunge'),
(67,'Hard Rock'),
(68,'Hardcore'),
(69,'Heavy Metal'),
(70,'Hip-Hop'),
(71,'House'),
(72,'Humour'),
(73,'Indie'),
(74,'Industrial'),
(75,'Instrumental'),
(76,'Instrumental Pop'),
(77,'Instrumental Rock'),
(78,'JPop'),
(79,'Jazz'),
(80,'Jazz+Funk'),
(81,'Jungle'),
(82,'Latin'),
(83,'Lo-Fi'),
(84,'Meditative'),
(85,'Merengue'),
(86,'Metal'),
(87,'Musical'),
(88,'National Folk'),
(89,'Native US'),
(90,'Negerpunk'),
(91,'New Age'),
(92,'New Wave'),
(93,'Noise'),
(94,'Oldies'),
(95,'Opera'),
(96,'Other'),
(97,'Polka'),
(98,'Polsk Punk'),
(99,'Pop'),
(100,'Pop-Folk'),
(101,'Pop/Funk'),
(102,'Porn Groove'),
(103,'Power Ballad'),
(104,'Pranks'),
(105,'Primus'),
(106,'Progressive Rock'),
(107,'Psychadelic'),
(108,'Psychedelic Rock'),
(109,'Punk'),
(110,'Punk Rock'),
(111,'R&B'),
(112,'Rap'),
(113,'Rave'),
(114,'Reggae'),
(115,'Retro'),
(116,'Revival'),
(117,'Rhythmic Soul'),
(118,'Rock'),
(119,'Rock & Roll'),
(120,'Salsa'),
(121,'Samba'),
(122,'Satire'),
(123,'Showtunes'),
(124,'Ska'),
(125,'Slow Jam'),
(126,'Slow Rock'),
(127,'Sonata'),
(128,'Soul'),
(129,'Sound Clip'),
(130,'Soundtrack'),
(131,'Southern Rock'),
(132,'Space'),
(133,'Speech'),
(134,'Swing'),
(135,'Symphonic Rock'),
(136,'Symphony'),
(137,'Synthpop'),
(138,'Tango'),
(139,'Techno'),
(140,'Techno-Industrial'),
(141,'Terror'),
(142,'Thrash Metal'),
(143,'Top 40'),
(144,'Trailer'),
(145,'Trance'),
(146,'Tribal'),
(147,'Trip-Hop'),
(148,'Vocal');
/*!40000 ALTER TABLE `genre` ENABLE KEYS */;


--
-- Definition of table `history`
--

DROP TABLE IF EXISTS `history`;
CREATE TABLE IF NOT EXISTS `history` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date_played` datetime DEFAULT '2002-01-01 00:00:01',
  `song_type` tinyint(2) NOT NULL,
  `id_subcat` int(11) NOT NULL,
  `id_genre` int(11) NOT NULL,
  `duration` double(11,5) NOT NULL,
  `artist` varchar(255) NOT NULL,
  `original_artist` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `album` varchar(255) NOT NULL,
  `composer` varchar(255) NOT NULL,
  `year` varchar(4) NOT NULL DEFAULT '1900',
  `track_no` smallint(6) NOT NULL DEFAULT '0',
  `disc_no` smallint(6) NOT NULL DEFAULT '0',
  `publisher` varchar(255) NOT NULL,
  `copyright` varchar(255) NOT NULL,
  `isrc` varchar(255) NOT NULL,
  `listeners` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `artist` (`artist`),
  KEY `title` (`title`),
  KEY `date_played` (`date_played`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `history`
--

/*!40000 ALTER TABLE `history` DISABLE KEYS */;

/*!40000 ALTER TABLE `history` ENABLE KEYS */;


--
-- Definition of table `playlists`
--

DROP TABLE IF EXISTS `playlists`;
CREATE TABLE IF NOT EXISTS `playlists` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `playlists`
--

/*!40000 ALTER TABLE `playlists` DISABLE KEYS */;

/*!40000 ALTER TABLE `playlists` ENABLE KEYS */;


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;


I re-installed the database and got the error message no longer.
(Just to note)
Grtz.
R.T.F.M. means to me, Read The Fantastic Messages.
Einstein says: Make things simple, but don't make simple things simpler! (wise) this is just my life lesson you know.

I don't do drugs ( ͡° ͜ʖ ͡°)

Valis

  • Guest
Re: Error can't find table 0
« Reply #1 on: August 13, 2014, 03:42:01 PM »
Okay. Did a re-install. Worked this time.

I'm not certain what I missed out the first couple of times, but it's clear; if you install following the direction exactly, it'll work.

Thanks to all those who responded.