Sql and or dl_mod error Posted:
Wed Jun 24, 2009 12:51 am |
|
|
|
|
|
after going through this a hundred times. i realized you probably have the same error as others. make sure all forum dl tables are there.
here are the tables. look at the error log for missing table or unknown column then find the table below then query it thru phpmyadmin.
| Code:
|
CREATE TABLE `nuke_dl_auth` (
`cat_id` int(11) NOT NULL default '0',
`group_id` int(11) NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '1',
`auth_dl` tinyint(1) NOT NULL default '1',
`auth_up` tinyint(1) NOT NULL default '1',
`auth_mod` tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_dl_auth`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_banlist`
--
CREATE TABLE `nuke_dl_banlist` (
`ban_id` int(11) NOT NULL auto_increment,
`user_id` mediumint(8) NOT NULL default '0',
`user_ip` varchar(8) NOT NULL default '',
`user_agent` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`guests` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`ban_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
--
-- Dumping data for table `nuke_dl_banlist`
--
INSERT INTO `nuke_dl_banlist` VALUES(1, 0, '', 'n/a', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_bug_history`
--
CREATE TABLE `nuke_dl_bug_history` (
`report_his_id` int(11) NOT NULL auto_increment,
`df_id` int(11) NOT NULL default '0',
`report_id` int(11) NOT NULL default '0',
`report_his_type` varchar(10) default '',
`report_his_date` int(11) default '0',
`report_his_value` varchar(255) default NULL,
PRIMARY KEY (`report_his_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `nuke_dl_bug_history`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_bug_tracker`
--
CREATE TABLE `nuke_dl_bug_tracker` (
`report_id` int(11) NOT NULL auto_increment,
`df_id` int(11) NOT NULL default '0',
`report_title` varchar(255) default '',
`report_text` text,
`report_uid` varchar(10) default '',
`report_file_ver` varchar(50) default '',
`report_date` int(11) default '0',
`report_author_id` mediumint(8) NOT NULL default '0',
`report_assign_id` mediumint(8) NOT NULL default '0',
`report_assign_date` int(11) default '0',
`report_status` tinyint(1) NOT NULL default '0',
`report_status_date` int(11) default '0',
`report_php` varchar(50) default '',
`report_db` varchar(50) default '',
`report_forum` varchar(50) default '',
PRIMARY KEY (`report_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `nuke_dl_bug_tracker`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_comments`
--
CREATE TABLE `nuke_dl_comments` (
`dl_id` bigint(20) unsigned NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`username` varchar(32) NOT NULL default '',
`comment_time` int(11) NOT NULL default '0',
`comment_edit_time` int(11) NOT NULL default '0',
`comment_text` text NOT NULL,
`bbcode_uid` varchar(10) NOT NULL default '',
`approve` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`dl_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `nuke_dl_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_config`
--
CREATE TABLE `nuke_dl_config` (
`config_name` varchar(255) NOT NULL default '',
`config_value` varchar(255) NOT NULL default '',
PRIMARY KEY (`config_name`)
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_dl_config`
--
INSERT INTO `nuke_dl_config` VALUES('delay_auto_traffic', '30');
INSERT INTO `nuke_dl_config` VALUES('delay_post_traffic', '30');
INSERT INTO `nuke_dl_config` VALUES('disable_email', '1');
INSERT INTO `nuke_dl_config` VALUES('disable_popup', '0');
INSERT INTO `nuke_dl_config` VALUES('disable_popup_notify', '0');
INSERT INTO `nuke_dl_config` VALUES('dl_click_reset_time', '1223509222');
INSERT INTO `nuke_dl_config` VALUES('dl_direct', '0');
INSERT INTO `nuke_dl_config` VALUES('dl_edit_time', '3');
INSERT INTO `nuke_dl_config` VALUES('dl_links_per_page', '10');
INSERT INTO `nuke_dl_config` VALUES('dl_method', '2');
INSERT INTO `nuke_dl_config` VALUES('dl_method_quota', '2097152');
INSERT INTO `nuke_dl_config` VALUES('dl_mod_version', '5.3.2');
INSERT INTO `nuke_dl_config` VALUES('dl_new_time', '3');
INSERT INTO `nuke_dl_config` VALUES('dl_posts', '25');
INSERT INTO `nuke_dl_config` VALUES('dl_stats_perm', '0');
INSERT INTO `nuke_dl_config` VALUES('download_dir', 'downloads/');
INSERT INTO `nuke_dl_config` VALUES('edit_own_downloads', '0');
INSERT INTO `nuke_dl_config` VALUES('enable_post_dl_traffic', '1');
INSERT INTO `nuke_dl_config` VALUES('guest_stats_show', '1');
INSERT INTO `nuke_dl_config` VALUES('hotlink_action', '1');
INSERT INTO `nuke_dl_config` VALUES('icon_free_for_reg', '0');
INSERT INTO `nuke_dl_config` VALUES('latest_comments', '1');
INSERT INTO `nuke_dl_config` VALUES('limit_desc_on_index', '0');
INSERT INTO `nuke_dl_config` VALUES('newtopic_traffic', '524288');
INSERT INTO `nuke_dl_config` VALUES('overall_traffic', '104857600');
INSERT INTO `nuke_dl_config` VALUES('physical_quota', '524288000');
INSERT INTO `nuke_dl_config` VALUES('prevent_hotlink', '1');
INSERT INTO `nuke_dl_config` VALUES('recent_downloads', '10');
INSERT INTO `nuke_dl_config` VALUES('remain_traffic', '0');
INSERT INTO `nuke_dl_config` VALUES('reply_traffic', '262144');
INSERT INTO `nuke_dl_config` VALUES('report_broken', '1');
INSERT INTO `nuke_dl_config` VALUES('report_broken_lock', '1');
INSERT INTO `nuke_dl_config` VALUES('report_broken_message', '1');
INSERT INTO `nuke_dl_config` VALUES('shorten_extern_links', '10');
INSERT INTO `nuke_dl_config` VALUES('show_footer_legend', '1');
INSERT INTO `nuke_dl_config` VALUES('show_footer_stat', '1');
INSERT INTO `nuke_dl_config` VALUES('show_real_filetime', '1');
INSERT INTO `nuke_dl_config` VALUES('stop_uploads', '0');
INSERT INTO `nuke_dl_config` VALUES('sort_preform', '0');
INSERT INTO `nuke_dl_config` VALUES('thumb_fsize', '0');
INSERT INTO `nuke_dl_config` VALUES('thumb_xsize', '200');
INSERT INTO `nuke_dl_config` VALUES('thumb_ysize', '150');
INSERT INTO `nuke_dl_config` VALUES('traffic_retime', '1223509222');
INSERT INTO `nuke_dl_config` VALUES('upload_traffic_count', '1');
INSERT INTO `nuke_dl_config` VALUES('use_ext_blacklist', '1');
INSERT INTO `nuke_dl_config` VALUES('use_hacklist', '1');
INSERT INTO `nuke_dl_config` VALUES('user_dl_auto_traffic', '0');
INSERT INTO `nuke_dl_config` VALUES('user_traffic_once', '0');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_ext_blacklist`
--
CREATE TABLE `nuke_dl_ext_blacklist` (
`extention` varchar(10) NOT NULL default ''
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_dl_ext_blacklist`
--
INSERT INTO `nuke_dl_ext_blacklist` VALUES('asp');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('cgi');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('dhtm');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('dhtml');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('exe');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('htm');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('html');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('jar');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('js');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('php');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('php3');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('pl');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('sh');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('shtm');
INSERT INTO `nuke_dl_ext_blacklist` VALUES('shtml');
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_favorites`
--
CREATE TABLE `nuke_dl_favorites` (
`fav_id` int(11) NOT NULL auto_increment,
`fav_dl_id` int(11) NOT NULL default '0',
`fav_dl_cat` int(11) NOT NULL default '0',
`fav_user_id` mediumint(8) NOT NULL default '0',
PRIMARY KEY (`fav_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `nuke_dl_favorites`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_hotlink`
--
CREATE TABLE `nuke_dl_hotlink` (
`user_id` mediumint(8) NOT NULL default '0',
`session_id` varchar(32) NOT NULL default '',
`hotlink_id` varchar(32) NOT NULL default '',
`code` varchar(5) NOT NULL default ''
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_dl_hotlink`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_notraf`
--
CREATE TABLE `nuke_dl_notraf` (
`user_id` mediumint(8) NOT NULL default '0',
`dl_id` int(11) NOT NULL default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_dl_notraf`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_ratings`
--
CREATE TABLE `nuke_dl_ratings` (
`dl_id` int(11) default '0',
`user_id` mediumint(8) default '0',
`rate_point` varchar(10) default '0'
) TYPE=MyISAM;
--
-- Dumping data for table `nuke_dl_ratings`
--
-- --------------------------------------------------------
--
-- Table structure for table `nuke_dl_stats`
--
CREATE TABLE `nuke_dl_stats` (
`dl_id` bigint(20) unsigned NOT NULL auto_increment,
`id` int(11) NOT NULL default '0',
`cat_id` int(11) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`username` varchar(32) NOT NULL default '',
`traffic` bigint(20) NOT NULL default '0',
`direction` tinyint(1) NOT NULL default '0',
`user_ip` varchar(8) NOT NULL default '',
`browser` varchar(20) NOT NULL default '',
`time_stamp` int(11) NOT NULL default '0',
PRIMARY KEY (`dl_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
|
|
|
|
|
38.107.179.217
