Ich als Admin kann auch alle Bereiche einsehen und die Dateien herunterladen. Normale Benutzer bekommen aber einen Fehler:
Allgemeiner Fehler
SQL ERROR [mysql4]
Unknown column 'v.ver_active' in 'where clause' [1054]
Allgemeiner Fehler
SQL ERROR [mysql4]
Unknown column 'v.ver_active' in 'where clause' [1054]
Code: Alles auswählen
update phpbb_config set config_value = '7.0.0' where config_name = 'dl_ext_version';
Code: Alles auswählen
Allgemeiner Fehler
SQL ERROR [ mysql4 ]
Unknown column 'ver_active' in 'field list' [1054]
SQL
INSERT INTO phpbb_dl_versions (dl_id, ver_file_name, ver_real_file, ver_file_hash, ver_file_size, ver_version, ver_add_time, ver_change_time, ver_add_user, ver_change_user, ver_active, ver_text) VALUES (33, 'http://lotgd.aszlig.net/blog/download/SchneeundEisscreensaver.rar', '', '', '0', '1.0.0', '1261686262', '1261686262', '2', '2', 0, '')
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()
FILE: [ROOT]/ext/oxpus/dl_ext/includes/admin/dl_admin_files.php
LINE: 722
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/oxpus/dl_ext/acp/main_module.php
LINE: 271
CALL: include('[ROOT]/ext/oxpus/dl_ext/includes/admin/dl_admin_files.php')
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: oxpus\dl_ext\acp\main_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Hioxpus hat geschrieben:Setze mal bitte in der Tabelle phpbb_config den Wert für dl_ext_version auf "7.0.0", leere danach den Forum Cache, deaktiviere und aktiviere dann die Download Extension.
Dann stellt diese alle fehlenden Felder in der Datenbank ein.
Code: Alles auswählen
Allgemeiner Fehler
SQL ERROR [ mysql4 ]
Unknown column 'ver_active' in 'field list' [1054]
SQL
INSERT INTO phpbb_dl_versions (dl_id, ver_file_name, ver_real_file, ver_file_hash, ver_file_size, ver_version, ver_add_time, ver_change_time, ver_add_user, ver_change_user, ver_active, ver_text) VALUES (17, 'http://lotgd.aszlig.net/blog/download/Wallpaper3.3.1.rar', '', '', '0', '3.3.1', '1245442431', '1351954298', '2', '2', 0, '')
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()
FILE: [ROOT]/ext/oxpus/dl_ext/includes/admin/dl_admin_files.php
LINE: 722
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/oxpus/dl_ext/acp/main_module.php
LINE: 271
CALL: include('[ROOT]/ext/oxpus/dl_ext/includes/admin/dl_admin_files.php')
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: oxpus\dl_ext\acp\main_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Code: Alles auswählen
insert into phpbb_config (config_name, config_value) values ('dl_download_dir', '1');
create table phpbb_dl_ver_files (
ver_file_id int(11) unsigned auto_increment,
dl_id int(11) default 0,
ver_id int(11) default 0,
real_name varchar(255) default '',
file_name varchar(255) default '',
file_title varchar(255),
file_type tinyint(1) default 0,
PRIMARY KEY (ver_file_id)
);
alter table phpbb_dl_versions add column ver_text mediumtext;
alter table phpbb_dl_versions add column ver_uid char(8);
alter table phpbb_dl_versions add column ver_bitfield varchar(255);
alter table phpbb_dl_versions add column ver_flags int(11) default 0;
alter table phpbb_dl_versions add column ver_active tinyint(1) default 0;