Download Mod Error

[JeRicHoOL]

Ich habe den Download Mod installiert aber bekomme nun leider folgenden Error beim AUfruf meiner Seite.

General Error
SQL ERROR [ mysql4 ]

Table 'web158sql1.phpbb_dl_config' doesn't exist [1146]

SQL

SELECT config_value FROM phpbb_dl_config WHERE config_name = 'use_hacklist'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 3664
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 159
CALL: page_header()

Ich erinnere mich als ich das Install Script gestartet habe kam ein Error. Dann bin ich im Browser auf "Zurück" gegangen und habe das Script nochmal gestartet und da bekam ich folgende Meldung.

Download MOD Installation

Installation not possible!

The script found an existing installation, so you can not use the installation script again.

Updaten ist leider auch nicht möglich denn da kommt folgender Fehler.

General Error
SQL ERROR [ mysql4 ]

Table 'web158sql1.phpbb_dl_config' doesn't exist [1146]

SQL

SELECT config_value FROM phpbb_dl_config WHERE config_name = 'dl_mod_version'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: install/install_update.php
LINE: 138
CALL: dbal_mysql->sql_query()

FILE: install/index.php
LINE: 395
CALL: install_update->main()

FILE: install/index.php
LINE: 272
CALL: module->load()

Es existieren noch keine Datenbankeinträge für diesen Mod. Installation und Update via Installations-Script ist auch nicht möglich. Alle Dateiänderungen wurden vorgenommen und geuploaded.

Ich hoffe man kann mir hier weiterhelfen.

[oxpus]

Table 'web158sql1.phpbb_dl_config' doesn't exist [1146]

Die Tabelle fehlt schlichterdings.
Bitte dazu folgende SQL-Anweisungen in der Datenbank (z. B. mittels phpmyadmin) ausführen:

Code: Alles auswählen

CREATE TABLE phpbb_dl_config (
	config_name VARCHAR(255) NOT NULL DEFAULT '',
	config_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY  (config_name)
);
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', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_popup', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('disable_popup_notify', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_click_reset_time', '0');
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', '10');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_method', '2');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_method_quota', '2097152');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_mod_version', '6.2.7');
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 ('dl_stats_perm', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_topic_forum', '');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('dl_topic_text', '');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('download_dir', 'dl_mod/downloads/');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('download_vc', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('drop_traffic_postdel', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('edit_own_downloads', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('enable_dl_topic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('enable_post_dl_traffic', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('ext_new_window', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('guest_stats_show', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('hotlink_action', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('icon_free_for_reg', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('latest_comments', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('limit_desc_on_index', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('newtopic_traffic', '524288');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('overall_guest_traffic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('overall_traffic', '104857600');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('physical_quota', '524288000');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('prevent_hotlink', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('recent_downloads', '10');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('remain_guest_traffic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('remain_traffic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('reply_traffic', '262144');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('report_broken', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('report_broken_lock', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('report_broken_message', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('report_broken_vc', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('shorten_extern_links', '10');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('show_footer_legend', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('show_footer_stat', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('show_real_filetime', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('sort_preform', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('stop_uploads', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('thumb_fsize', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('thumb_xsize', '200');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('thumb_ysize', '150');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('traffic_retime', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('upload_traffic_count', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('use_ext_blacklist', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('use_hacklist', '1');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('user_dl_auto_traffic', '0');
INSERT INTO phpbb_dl_config (config_name, config_value) VALUES ('user_traffic_once', '0');

[JeRicHoOL]

I ran the SQL command succesfully but now I get another error.

General Error
SQL ERROR [ mysql4 ]

Table 'web158sql1.phpbb_downloads' doesn't exist [1146]

SQL

SELECT count(id) as total FROM phpbb_downloads WHERE hacklist = 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 3674
CALL: dbal_mysql->sql_query()

FILE: index.php
LINE: 159
CALL: page_header()

I need all the SQL commands because something went wrong with the installation I guess.

[oxpus]

I think the installation itself was not successfull.

Possible solution:
Please unmod the file includes/constants.php and re-run the installation again.

[JeRicHoOL]

This gives me the following error.

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_downloads' already exists [1050]

SQL

CREATE TABLE phpbb_downloads ( id INT(11) auto_increment NOT NULL, description BLOB, file_name VARCHAR(255) DEFAULT '', klicks INT(11) DEFAULT '0', free TINYINT(1) DEFAULT '0', extern TINYINT(1) DEFAULT '0', long_desc BLOB, sort INT(11) DEFAULT '0', cat INT(11) DEFAULT '0', hacklist TINYINT(1) DEFAULT '0', hack_author VARCHAR(255) DEFAULT '', hack_author_email VARCHAR(255) DEFAULT '', hack_author_website TINYTEXT, hack_version VARCHAR(32) DEFAULT '', hack_dl_url TINYTEXT, test varchar(50) DEFAULT '', req BLOB, todo BLOB, warning BLOB, mod_desc BLOB, mod_list TINYINT(1) DEFAULT '0', file_size BIGINT(20) NOT NULL DEFAULT '0', change_time INT(11) DEFAULT '0', add_time INT(11) DEFAULT '0', rating SMALLINT(5) DEFAULT '0' NOT NULL, file_traffic BIGINT(20) NOT NULL DEFAULT '0', overall_klicks INT(11) DEFAULT '0', approve TINYINT(1) DEFAULT '0', add_user MEDIUMINT(8) DEFAULT '0', change_user MEDIUMINT(8) DEFAULT '0', last_time INT(11) DEFAULT '0', down_user MEDIUMINT(8) DEFAULT '0' NOT NULL, thumbnail VARCHAR(255) DEFAULT '' NOT NULL, broken TINYINT(1) NOT NULL DEFAULT 0, mod_desc_uid VARCHAR(8) DEFAULT '' NOT NULL, mod_desc_bitfield VARCHAR(255) DEFAULT '' NOT NULL, mod_desc_flags INT(11) UNSIGNED DEFAULT 0 NOT NULL, long_desc_uid VARCHAR(8) DEFAULT '' NOT NULL, long_desc_bitfield VARCHAR(255) DEFAULT '' NOT NULL, long_desc_flags INT(11) UNSIGNED DEFAULT 0 NOT NULL, desc_uid VARCHAR(8) DEFAULT '' NOT NULL, desc_bitfield VARCHAR(255) DEFAULT '' NOT NULL, desc_flags INT(11) UNSIGNED DEFAULT 0 NOT NULL, warn_uid VARCHAR(8) DEFAULT '' NOT NULL, warn_bitfield VARCHAR(255) DEFAULT '' NOT NULL, warn_flags INT(11) UNSIGNED DEFAULT 0 NOT NULL, dl_topic INT(11) DEFAULT 0 NOT NULL, PRIMARY KEY (id) )

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: install/install_install.php
LINE: 355
CALL: dbal_mysql->sql_query()

FILE: install/install_install.php
LINE: 102
CALL: install_install->load_schema()

FILE: install/index.php
LINE: 395
CALL: install_install->main()

FILE: install/index.php
LINE: 272
CALL: module->load()

When I use the modded constants.php file I can't even use the update feature because it says.

Download MOD Update

Update not possible!

Your release of this MOD: 6.2.7

The Download MOD must at least have the release 5.0.0, to be able to use this module zu be updated to the newest version or the MOD is not installed correctly.
Please update the MOD by yourself to this release, before you can use this script again.

[oxpus]

When all tables must be dropped before going on.
So delete all tables like "phpbb_download_" and "phpbb_dl_" and query the following sql statements:

Code: Alles auswählen

ALTER TABLE phpbb_groups DROP COLUMN group_dl_auto_traffic;

ALTER TABLE phpbb_users DROP COLUMN user_allow_new_download_email;
ALTER TABLE phpbb_users DROP COLUMN user_allow_fav_download_email;
ALTER TABLE phpbb_users DROP COLUMN user_allow_new_download_popup;
ALTER TABLE phpbb_users DROP COLUMN user_allow_fav_download_popup;
ALTER TABLE phpbb_users DROP COLUMN user_dl_update_time;
ALTER TABLE phpbb_users DROP COLUMN user_new_download;
ALTER TABLE phpbb_users DROP COLUMN user_traffic;
ALTER TABLE phpbb_users DROP COLUMN user_dl_note_type;
ALTER TABLE phpbb_users DROP COLUMN user_dl_sort_fix;
ALTER TABLE phpbb_users DROP COLUMN user_dl_sort_opt;
ALTER TABLE phpbb_users DROP COLUMN user_dl_sort_dir;
ALTER TABLE phpbb_users DROP COLUMN user_dl_sub_on_index;

DELETE FROM phpbb_modules WHERE module_basename = 'downloads';
DELETE FROM phpbb_modules WHERE module_langname = 'DOWNLOADS';

DELETE FROM phpbb_acl_options WHERE auth_option LIKE 'a_dl_*';

Be sure your includes/constants.php does not have any rows added by the download mod and re-run the installation script again.
After this you can re-install the rest of the mod.

[JeRicHoOL]

Thank you very much. It's working now.

[oxpus]

Fine and thanks for the feedback.