View Single Post
  #12  
Old 5th March 2012, 17:06
PAX's Avatar
PAX PAX is offline
Senior Member
 
Join Date: Nov 2010
P2P
Posts: 41
Default
Mysql puked: Column count doesn't match value count at row 1 .
something is missing, that's for sure, but what is missing in the database? I do not know

CREATE TABLE IF NOT EXISTS `torrents` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`info_hash` char(20) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`descr` text NOT NULL,
`category` int(10) unsigned NOT NULL DEFAULT '0',
`size` bigint(20) unsigned NOT NULL DEFAULT '0',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`numfiles` int(10) unsigned NOT NULL DEFAULT '0',
`comments` int(10) unsigned NOT NULL DEFAULT '0',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`times_completed` int(10) unsigned NOT NULL DEFAULT '0',
`leechers` int(10) unsigned NOT NULL DEFAULT '0',
`seeders` int(10) unsigned NOT NULL DEFAULT '0',
`last_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`visible` enum('yes','no') NOT NULL DEFAULT 'yes',
`banned` enum('yes','no') NOT NULL DEFAULT 'no',
`owner` int(10) unsigned NOT NULL DEFAULT '0',
`free` enum('yes','no') DEFAULT 'no',
`anonymous` enum('yes','no') NOT NULL DEFAULT 'no',
`sticky` enum('yes','no') NOT NULL DEFAULT 'no',
`offensive` enum('yes','no') NOT NULL DEFAULT 'no',
`silver` enum('yes','no') NOT NULL DEFAULT 'no',
`t_image` varchar(255) NOT NULL DEFAULT '',
`t_link` text NOT NULL,
`isnuked` enum('yes','no') NOT NULL DEFAULT 'no',
`WhyNuked` varchar(255) NOT NULL DEFAULT 'Bad quality!',
`isrequest` enum('yes','no') NOT NULL DEFAULT 'no',
`ts_external` enum('yes','no') NOT NULL DEFAULT 'no',
`ts_external_url` varchar(128) NOT NULL DEFAULT '',
`ts_external_lastupdate` int(10) unsigned NOT NULL DEFAULT '0',
`allowcomments` enum('yes','no') NOT NULL DEFAULT 'yes',
`doubleupload` enum('yes','no') NOT NULL DEFAULT 'no',
`isScene` int(11) unsigned NOT NULL DEFAULT '0',
`moderated` enum('yes','error','no') NOT NULL DEFAULT 'no',
`moderator` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`error` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`genre` varchar(255) NOT NULL DEFAULT 'genre',
`Torrent név Eng` varchar(80) DEFAULT NULL,
`ido` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`sebesseg` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `info_hash` (`info_hash`),
KEY `category` (`category`),
KEY `times_completed` (`times_completed`,`leechers`,`seeders`),
KEY `visible` (`visible`,`banned`),
KEY `t_image` (`t_image`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=929 ;
Reply With Quote