OXPUS.de

phpBB-Support, PC Hilfe und vieles mehr...
https://www.oxpus.de:443/

Download Mod 4.0.11 problem

https://www.oxpus.de:443/viewtopic.php?t=8596

Seite 1 von 1

Download Mod 4.0.11 problem

Verfasst: Mi 03.Aug, 2005 18:42
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

Verfasst: Mi 03.Aug, 2005 20:08
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');

Verfasst: Mi 03.Aug, 2005 23:09
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

Verfasst: Do 04.Aug, 2005 00:35
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');

Verfasst: Do 04.Aug, 2005 00:37
von Anonymous
Iste Türkün gücü!
Helal olsun kardes, realy realy thansk for youre support.
It's nice.

Verfasst: Do 04.Aug, 2005 00:38
von BIG Mule
No Problems.

Best Regards
Alle Zeiten sind UTC+01:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de