hi coRpSE

i am having problems with uploading the SQL FILE , I  have done a fresh install deleted the old download module and dropped the tables in php myadmin,
downloaded your advanced Downloads V1.2.1 patched and uploaded all the files ect ,

when i go to upload the '' Full-Install.sql '' file i get the following Error ,

could you advise me what to do as i dont have a clue


Error

SQL query:

--
-- Dumping data for table `nuke_downloads_categories`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_downloads_config`
--
CREATE TABLE IF NOT EXISTS `nuke_downloads_config` (
`config_name` varchar( 255 ) NOT NULL DEFAULT '',
`config_value` text NOT NULL ,
PRIMARY KEY ( `config_name` )
) ENGINE = MYISAM ;

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes

huh, I just tested this and it working on my site. Here, delete any Downloads table there is and try this.



Run that SQL and let me know.

— coRpSE @ Wed Jun 12, 2013 12:52 pm wrote

huh, I just tested this and it working on my site. Here, delete any Downloads table there is and try this.

Code: [ Select all ]

--
-- Table structure for table `nuke_downloads_accesses`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_accesses` (
  `username` varchar(60) NOT NULL DEFAULT '',
  `downloads` int(11) NOT NULL DEFAULT '0',
  `uploads` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`username`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_accesses`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_categories`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_categories` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `usecatcolor` tinyint(2) NOT NULL DEFAULT '0',
  `catcolor` varchar(50) NOT NULL,
  `catimage` varchar(255) NOT NULL DEFAULT './modules/Downloads/images/cat_icons/dir.png',
  `cdescription` text NOT NULL,
  `parentid` int(11) NOT NULL DEFAULT '0',
  `whoadd` tinyint(2) NOT NULL DEFAULT '0',
  `uploaddir` varchar(255) NOT NULL DEFAULT '',
  `canupload` tinyint(2) NOT NULL DEFAULT '0',
  `active` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`cid`),
  KEY `title` (`title`),
  FULLTEXT KEY `catimage` (`catimage`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_categories`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_config`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_config` (
  `config_name` varchar(255) NOT NULL DEFAULT '',
  `config_value` text NOT NULL,
  PRIMARY KEY (`config_name`(100))
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_config`
--

INSERT INTO `nuke_downloads_config` (`config_name`, `config_value`) VALUES
('admperpage', '50'),
('blockunregmodify', '1'),
('dateformat', ''),
('mostpopular', '10'),
('mostpopulartrig', '0'),
('perpage', '15'),
('popular', '100'),
('results', '30'),
('show_download', '1'),
('show_links_num', '1'),
('usegfxcheck', '1'),
('dlfpath', './modules/Downloads/files'),
('show_overview', '1'),
('overview', '10'),
('ddisplay', '2'),
('thumbh', '110'),
('thumbw', '110'),
('dlposton_off', '1'),
('dlpostmin', '2'),
('dlpostmin_message', '<center><H3><font>Sorry, You don''t meet our minimum requirement to download these files. We do not accept spam in our forums to be a way<br>
to get your post count up. If you do spam or make a worthless post just to get your post count up, we will BAN you permanently<br>
and your access to download anything from use will be halted indefinitely.</font></H3></center>'),
('dlamount', '3'),
('dlweek', '15'),
('dlday', '3'),
('dlbypass', '999'),
('dltabber', '0'),
('dltabselectedcolor', 'C9C9C9'),
('dltabunselcolor', '666666'),
('dltabfontcolor', 'FFFFFF'),
('dltabselfontcolor', '000000'),
('show_featured', '0'),
('usefbcomments', '1'),
('usefbadmin', 'admin1,admin.2'),
('usefbpostcount', '5'),
('usefbtheme', '0'),
('usefbwidth', '600');

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_downloads`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_downloads` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `featured` tinyint(2) NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `external_mirror2` varchar(255) NOT NULL DEFAULT '',
  `external_mirror1` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `fixes` text NOT NULL,
  `features` text NOT NULL,
  `screenshot1` varchar(255) NOT NULL,
  `screenshot2` varchar(255) NOT NULL,
  `screenshot3` varchar(255) NOT NULL,
  `screenshot4` varchar(255) NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `hits` int(11) NOT NULL DEFAULT '0',
  `submitter` varchar(60) NOT NULL DEFAULT '',
  `sub_ip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
  `filesize` bigint(20) NOT NULL DEFAULT '0',
  `version` varchar(20) NOT NULL DEFAULT '',
  `homepage` varchar(255) NOT NULL DEFAULT '',
  `active` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`),
  KEY `hits` (`hits`),
  KEY `active` (`active`),
  FULLTEXT KEY `fixes` (`fixes`,`features`,`screenshot1`,`screenshot2`,`screenshot3`,`screenshot4`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_downloads`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_extensions`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_extensions` (
  `eid` int(11) NOT NULL AUTO_INCREMENT,
  `ext` varchar(6) NOT NULL DEFAULT '',
  `file` tinyint(1) NOT NULL DEFAULT '0',
  `image` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`eid`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_extensions`
--

INSERT INTO `nuke_downloads_extensions` (`eid`, `ext`, `file`, `image`) VALUES
(1, '.ace', 1, 0),
(2, '.arj', 1, 0),
(3, '.bz', 1, 0),
(4, '.bz2', 1, 0),
(5, '.cab', 1, 0),
(7, '.gif', 0, 1),
(8, '.gz', 1, 0),
(9, '.iso', 1, 0),
(10, '.jpeg', 0, 1),
(11, '.jpg', 0, 1),
(12, '.lha', 1, 0),
(13, '.lzh', 1, 0),
(14, '.png', 0, 1),
(15, '.rar', 1, 0),
(16, '.tar', 1, 0),
(17, '.tgz', 1, 0),
(18, '.uue', 1, 0),
(19, '.zip', 1, 0),
(20, '.zoo', 1, 0),
(21, '.exe', 1, 0),
(22, 'exe', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_mods`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_mods` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `lid` int(11) NOT NULL DEFAULT '0',
  `cid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `modifier` varchar(60) NOT NULL DEFAULT '',
  `sub_ip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
  `brokendownload` int(3) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `filesize` bigint(20) NOT NULL DEFAULT '0',
  `version` varchar(20) NOT NULL DEFAULT '',
  `homepage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`rid`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_mods`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_new`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_new` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(100) NOT NULL DEFAULT '',
  `url` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `submitter` varchar(60) NOT NULL DEFAULT '',
  `sub_ip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
  `filesize` bigint(20) NOT NULL DEFAULT '0',
  `version` varchar(20) NOT NULL DEFAULT '',
  `homepage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`lid`),
  KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_new`
--


-- --------------------------------------------------------

--
-- Table structure for table `nuke_downloads_userdls`
--

CREATE TABLE IF NOT EXISTS `nuke_downloads_userdls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `ws_date` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;

--
-- Dumping data for table `nuke_downloads_userdls`
--

Run that SQL and let me know.

PERFECT!!!!! worked with no Errors
thanks very much coRpSE really appreciated

No problem.

Will this code make the downloads scroll?

No, this code I supplied to him was just SQL code, for the database.