● Advanced Downloads V1.2.1

Wed Jun 12, 2013 7:29 am
NOOB!!!
2 Posts
Reputation: 1
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
Wed Jun 12, 2013 10:52 am
Clan Leader
Top Dog
Nuke Dev / Coder
2836 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 40.6hrs.
Total Played: 231hrs.


  
Don't get much, huh?
Reputation: 7033.5
votes: 6
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.


Expand
Wed Jun 12, 2013 11:55 am
Original Poster
NOOB!!!
2 Posts
Reputation: 1
‚ÄĒ 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


 
Wed Jun 12, 2013 12:12 pm
Clan Leader
Top Dog
Nuke Dev / Coder
2836 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 40.6hrs.
Total Played: 231hrs.


  
Don't get much, huh?
Reputation: 7033.5
votes: 6
No problem.


 
Sun Jan 03, 2016 11:53 am
Blabbing Noob
64 Posts
Reputation: 270.4
Will this code make the downloads scroll?
Sun Jan 03, 2016 8:59 pm
Clan Leader
Top Dog
Nuke Dev / Coder
2836 Posts
coRpSE
Currently Offline
Offline

Most Played:
This week: 40.6hrs.
Total Played: 231hrs.


  
Don't get much, huh?
Reputation: 7033.5
votes: 6
No, this code I supplied to him was just SQL code, for the database.


 
Forums ©