View Single Post
  #11  
Old 22nd March 2015, 18:02
vlady100 vlady100 is offline
Senior Member
 
Join Date: Mar 2015
Posts: 18
Default
HTML Code:
Error executing SQL Query -- -------------------------------------------------------- -- -- Table structure for table `torrent_torrents` -- CREATE TABLE `torrent_torrents` ( `id` int(15) unsigned NOT NULL auto_increment, `info_hash` varchar(20) character set latin1 collate latin1_bin default NULL, `md5sum` varchar(32) default NULL, `name` varchar(255) NOT NULL default '', `filename` varchar(255) NOT NULL default '', `save_as` varchar(255) NOT NULL default '', `search_text` text NOT NULL, `descr` text NOT NULL, `plen` bigint(6) unsigned NOT NULL default '0', `size` bigint(20) unsigned NOT NULL default '0', `category` int(10) unsigned NOT NULL default '0', `type` enum('single','multi','link') NOT NULL default 'single', `numfiles` int(10) unsigned NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `exeem` varchar(250) default NULL, `dht` enum('yes','no') NOT NULL default 'no', `backup_tracker` enum('true','false') NOT NULL default 'false', `views` int(10) unsigned NOT NULL default '0', `downloaded` int(10) unsigned NOT NULL default '0', `completed` int(10) unsigned NOT NULL default '0', `banned` enum('yes','no') NOT NULL default 'no', `password` varchar(255) default NULL, `private` enum('true','false') NOT NULL default 'false', `min_ratio` float unsigned NOT NULL default '0', `visible` enum('yes','no') NOT NULL default 'yes', `evidence` tinyint(1) NOT NULL default '0', `owner` int(10) unsigned NOT NULL default '0', `ownertype` tinyint(1) unsigned NOT NULL default '0', `uploader_host` varchar(100) NOT NULL default '', `numratings` int(10) unsigned NOT NULL default '0', `ratingsum` int(10) unsigned NOT NULL default '0', `seeders` int(10) unsigned NOT NULL default '0', `leechers` int(10) unsigned NOT NULL default '0', `tot_peer` int(11) unsigned NOT NULL default '0', `speed` int(10) unsigned NOT NULL default '0', `comments` int(10) unsigned NOT NULL default '0', `complaints` char(3) NOT NULL default '0,0', `tracker` varchar(250) default NULL, `tracker_list` text, `tracker_update` datetime NOT NULL default '0000-00-00 00:00:00', `last_action` datetime NOT NULL default '0000-00-00 00:00:00', `nuked` enum('yes','no','unnuked') NOT NULL default 'no', `ratiobuild` enum('yes','no') NOT NULL default 'no', `nukereason` varchar(225) NOT NULL default '', `thanks` int(10) NOT NULL default '0', `imdb` varchar(225) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `info_hash` (`info_hash`), KEY `owner` (`owner`), KEY `visible` (`visible`), KEY `added` (`added`), KEY `seeders` (`seeders`), KEY `leechers` (`leechers`), KEY `tot_peer` (`tot_peer`), KEY `banned` (`banned`), KEY `password` (`password`), KEY `tracker` (`tracker`), KEY `evidence` (`evidence`), KEY `rating` (`numratings`,`ratingsum`), KEY `numfiles` (`numfiles`), KEY `downloaded` (`downloaded`), KEY `category` (`category`), KEY `type` (`type`), FULLTEXT KEY `ft_search` (`search_text`), FULLTEXT KEY `filename` (`filename`), ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1 ;
Error ID: 1064
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 CHECKSUM=1' at line 73
please give me install-mysql.sql good.
Reply With Quote