Download Mod 4.0.11 problem

Enthält archivierte Beiträge von Hotschi's Board zum Download MOD.
Posten ist hier nicht möglich, bitte das Supportforum dafür verwenden!
Gesperrt
Anonymous

Download Mod 4.0.11 problem

Beitrag von Anonymous »

I have installed Download Mod 4.0.11
I run db_update.php

But i have this problem :

Code: Alles auswählen

Check Downloads Table phpbb_downloads

+++ successfull


Check Categories Table phpbb_downloads_cat

+++ successfull


Check Permissions Table phpbb_dl_auth

+++ successfull


Check Rating Table phpbb_dl_ratings

+++ successfull


Check Configuration Table phpbb_dl_config

CREATE TABLE phpbb_dl_config ( config_name VARCHAR(255), config_value VARCHAR(255), PRIMARY KEY (config_name))
+++ Failed: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

+++ successfull


Insert/Convert Configuration Values on Table phpbb_dl_config

Alter Groups Table phpbb_groups

Alter User Table phpbb_users

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_click_reset_time', '0')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'dl_click_reset_time'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_edit_time', '3')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'dl_edit_time'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_links_per_page', '10')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'dl_links_per_page'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_new_time', '3')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'dl_new_time'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_posts', '25')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'dl_posts'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('download_dir', 'media/')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'download_dir'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('enable_post_dl_traffic', '1')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'enable_post_dl_traffic'
+++ successfull


INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('newtopic_traffic', '524288')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'newtopic_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('recent_downloads', '10')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'recent_downloads'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('reply_traffic', '262144')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'reply_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('user_dl_auto_traffic', '0')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'user_dl_auto_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('overall_traffic', '104857600')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'overall_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('remain_traffic', '0')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'remain_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('traffic_retime', '1123087152')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'traffic_retime'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('stop_uploads', '0')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'stop_uploads'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('upload_traffic_count', '1')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'upload_traffic_count'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('physical_quota', '524288000')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'physical_quota'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('delay_auto_traffic', '30')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'delay_auto_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('delay_post_traffic', '30')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'delay_post_traffic'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_popup', '0')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'disable_popup'
+++ successfull

INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_email', '1')
+++ Field/Value already up to date

DELETE FROM phpbb_config WHERE config_name = 'disable_email'
+++ successfull

DELETE FROM phpbb_dl_config WHERE config_name='user_dl_permission'
+++ Field/Value already up to date

ALTER TABLE phpbb_groups ADD COLUMN group_dl_auto_traffic INT( 11 ) DEFAULT '0' NOT NULL
+++ Field/Value already up to date

ALTER TABLE phpbb_groups DROP COLUMN group_dl_permission
+++ Field/Value already up to date

ALTER TABLE phpbb_users ADD COLUMN user_traffic INT(255) DEFAULT '0' NOT NULL
+++ Field/Value already up to date

ALTER TABLE phpbb_users ADD COLUMN user_allow_new_download_popup TINYINT(1) DEFAULT '1' NOT NULL
+++ Field/Value already up to date

ALTER TABLE phpbb_users ADD COLUMN user_allow_new_download_email TINYINT(1) DEFAULT '0' NOT NULL
+++ Field/Value already up to date

ALTER TABLE phpbb_users ADD COLUMN user_dl_update_time INT( 11 ) DEFAULT '0' NOT NULL
+++ Field/Value already up to date

ALTER TABLE phpbb_users ADD COLUMN user_new_download TINYINT(1) DEFAULT '0' NOT NULL
+++ Field/Value already up to date

Convert Download Clicks to Overall Clicks

+++ successfull





Database Update now complete!

CREATE TABLE phpbb_dl_config ( config_name VARCHAR(255), config_value VARCHAR(255), PRIMARY KEY (config_name))
+++ Failed: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead


This is my problem.
What i can dou?
Please help me my forum is 1.5 hours closed.

This my error in admin panel :

Code: Alles auswählen

phpBB : Critical Error 

Could not query config information in downloads

DEBUG MODE

SQL Error : 1146 Table 'usr_web27_1.DL_CONFIG_TABLE' doesn't exist

SELECT * FROM DL_CONFIG_TABLE

Line : 33
File : admin_dl_config.php
Nach oben
Anonymous

Beitrag von Anonymous »

Please open your phpmyadmin and run the following sql statement under "SQL":

Code: Alles auswählen

DROP TABLE IF EXISTS `phpbb_dl_config`;
CREATE TABLE `phpbb_dl_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) default NULL,
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM

INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('delay_auto_traffic','30');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('delay_post_traffic','30');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('disable_email','0');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('disable_popup','0');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_click_reset_time','1122892238');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_edit_time','3');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_links_per_page','15');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_new_time','3');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_posts','25');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('download_dir','media/');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('enable_post_dl_traffic','0');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('newtopic_traffic','1048576');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('overall_traffic','524288000');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('physical_quota','104857600');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('recent_downloads','10');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('remain_traffic','18630');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('reply_traffic','512000');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('stop_uploads','0');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('traffic_retime','1122892240');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('upload_traffic_count','1');
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('user_dl_auto_traffic','512000');
Nach oben
Anonymous

Beitrag von Anonymous »

MySQL retourneerde:

#1064 - You have an error in your SQL syntax near 'INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('delay_auto' at line 7

This is a error mesagge
Nach oben
BIG Mule

Beitrag von BIG Mule »

Please open your phpmyadmin and run the following sql statement under "SQL":

Code: Alles auswählen

DROP TABLE IF EXISTS phpbb_dl_config; 
CREATE TABLE phpbb_dl_config ( 
  config_name varchar(255) NOT NULL default '', 
  config_value varchar(255) default NULL, 
  PRIMARY KEY  (config_name) 
) TYPE=MyISAM 

INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('delay_auto_traffic','30'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('delay_post_traffic','30'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('disable_email','0'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('disable_popup','0'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_click_reset_time','1122892238'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_edit_time','3'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_links_per_page','15'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_new_time','3'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('dl_posts','25'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('download_dir','media/'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('enable_post_dl_traffic','0'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('newtopic_traffic','1048576'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('overall_traffic','524288000'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('physical_quota','104857600'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('recent_downloads','10'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('remain_traffic','18630'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('reply_traffic','512000'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('stop_uploads','0'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('traffic_retime','1122892240'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('upload_traffic_count','1'); 
INSERT INTO `phpbb_dl_config` (`config_name`,`config_value`) VALUES ('user_dl_auto_traffic','512000');
Nach oben
Anonymous

Beitrag von Anonymous »

Iste Türkün gücü!
Helal olsun kardes, realy realy thansk for youre support.
It's nice.
Nach oben
BIG Mule

Beitrag von BIG Mule »

No Problems.

Best Regards
Nach oben
Gesperrt

Zurück zu „Archiv zu Hotschi's Download MOD“