Download Mod

Du hast Probleme beim Einbau oder bei der Benutzung eines Mods? In diesem Forum bist du richtig.
Forumsregeln
phpBB 3.0 hat das Ende seiner Lebenszeit überschritten
phpBB 3.0 wird nicht mehr aktiv unterstützt. Insbesondere werden - auch bei Sicherheitslücken - keine Patches mehr bereitgestellt. Der Einsatz von phpBB 3.0 erfolgt daher auf eigene Gefahr. Wir empfehlen einen Umstieg auf die neuste phpBB-Version, welches aktiv weiterentwickelt wird und für welches regelmäßig Updates zur Verfügung gestellt werden.
Poldi225
Mitglied
Beiträge: 55
Registriert: 23.07.2008 19:44

Re: Download Mod

Beitrag von Poldi225 »

Hi,
danke! nein die Tabellen gab es nicht, das war ja mein Problem. Super Support!
Poldi225
Mitglied
Beiträge: 55
Registriert: 23.07.2008 19:44

Re: Download Mod

Beitrag von Poldi225 »

wenn ich das hier eingebe:

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")
);

INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_click_reset_time','1243890536');
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','50');
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
	('enable_post_dl_traffic','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('newtopic_traffic','524288');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('recent_downloads','10');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('reply_traffic','262144');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('user_dl_auto_traffic','512000');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('overall_traffic','53687091200');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('remain_traffic','10547228');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('traffic_retime','1243890536');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('stop_uploads','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
	('physical_quota','5368709120');
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_popup','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('disable_email','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('guest_stats_show','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_method','3');
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_stats_perm','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_mod_version','6.2.15 RC1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('use_hacklist','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('use_mod_desc','1');
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','200');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('thumb_fsize','204800');
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
	('limit_desc_on_index','150');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('use_ext_blacklist','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('disable_popup_notify','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
	('report_broken','2');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('user_traffic_once','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('prevent_hotlink','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('hotlink_action','0');
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
	('download_vc','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
	('edit_own_downloads','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
	('icon_free_for_reg','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('latest_comments','3');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('sort_preform','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('drop_traffic_postdel','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('enable_dl_topic','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_topic_forum','5');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_topic_text','Diskussionsthema zum Download');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('overall_guest_traffic','314572800');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('remain_guest_traffic','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('ext_new_window','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_char_trans','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_back_color','969696');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_chess','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_lines','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_carree_x','0');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_carree_y','15');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_carree_color','FFFFFF');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_contrast','0.8');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_type','1');
INSERT INTO "phpbb_dl_config" ("config_name", "config_value") VALUES
	('dl_cap_jpeg_qual','75');
dann kommt dieser Fehler:
SQL-Befehl:

DROP TABLE IF EXISTS "phpbb_dl_config";

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"phpbb_dl_config"' at line 1
Benutzeravatar
oxpus
Ehemaliges Teammitglied
Beiträge: 5395
Registriert: 03.02.2003 12:33
Wohnort: Bad Wildungen
Kontaktdaten:

Re: Download Mod

Beitrag von oxpus »

Ersetze mal die " gegen einfache Hochkommas '
Grüße
OXPUS
Kein Support bei unaufgeforderten PNs, E-Mails oder auf anderem Weg!!
Poldi225
Mitglied
Beiträge: 55
Registriert: 23.07.2008 19:44

Re: Download Mod

Beitrag von Poldi225 »

ok
Poldi225
Mitglied
Beiträge: 55
Registriert: 23.07.2008 19:44

Re: Download Mod

Beitrag von Poldi225 »

probiert, selbes Problem, leider
Fehler

SQL-Befehl:

DROP TABLE IF EXISTS 'phpbb_dl_config';

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''phpbb_dl_config'' at line 1
Code:

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')
);

INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_click_reset_time','1243890536');
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','50');
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
	('enable_post_dl_traffic','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('newtopic_traffic','524288');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('recent_downloads','10');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('reply_traffic','262144');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('user_dl_auto_traffic','512000');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('overall_traffic','53687091200');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('remain_traffic','10547228');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('traffic_retime','1243890536');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('stop_uploads','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
	('physical_quota','5368709120');
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_popup','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('disable_email','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('guest_stats_show','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_method','3');
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_stats_perm','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_mod_version','6.2.15 RC1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('use_hacklist','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('use_mod_desc','1');
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','200');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('thumb_fsize','204800');
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
	('limit_desc_on_index','150');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('use_ext_blacklist','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('disable_popup_notify','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
	('report_broken','2');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('user_traffic_once','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('prevent_hotlink','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('hotlink_action','0');
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
	('download_vc','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
	('edit_own_downloads','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
	('icon_free_for_reg','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('latest_comments','3');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('sort_preform','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('drop_traffic_postdel','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('enable_dl_topic','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_topic_forum','5');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_topic_text','Diskussionsthema zum Download');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('overall_guest_traffic','314572800');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('remain_guest_traffic','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('ext_new_window','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_char_trans','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_back_color','969696');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_chess','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_lines','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_carree_x','0');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_carree_y','15');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_carree_color','FFFFFF');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_contrast','0.8');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_type','1');
INSERT INTO 'phpbb_dl_config' ('config_name', 'config_value') VALUES
	('dl_cap_jpeg_qual','75');
Laut Editor sind keine " mehr drinnen
Benutzeravatar
oxpus
Ehemaliges Teammitglied
Beiträge: 5395
Registriert: 03.02.2003 12:33
Wohnort: Bad Wildungen
Kontaktdaten:

Re: Download Mod

Beitrag von oxpus »

Hm, wenn die Tabelle bei Dir schon nicht existiert, dann lass das "DROP TABLE" mal ganz weg.
Grüße
OXPUS
Kein Support bei unaufgeforderten PNs, E-Mails oder auf anderem Weg!!
Poldi225
Mitglied
Beiträge: 55
Registriert: 23.07.2008 19:44

Re: Download Mod

Beitrag von Poldi225 »

ok, probiert:
Fehler

SQL-Befehl:

CREATE TABLE 'phpbb_dl_config'(
'config_name'varchar( 255 ) NOT NULL default ' ',
'config_value'varchar( 255 ) default NULL ,
PRIMARY KEY ( 'config_name' )
);

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''phpbb_dl_config' (
'config_name' varchar(255) NOT NULL default ' ',
' at line 1
Benutzeravatar
oxpus
Ehemaliges Teammitglied
Beiträge: 5395
Registriert: 03.02.2003 12:33
Wohnort: Bad Wildungen
Kontaktdaten:

Re: Download Mod

Beitrag von oxpus »

Jetzt hast du auch nötige Leerzeichen entfernt.
So wäre das korrekt:

Code: Alles auswählen

CREATE TABLE 'phpbb_dl_config' (
'config_name' varchar( 255 ) NOT NULL default ' ',
'config_value' varchar( 255 ) default NULL ,
PRIMARY KEY ( 'config_name' )
);
Grüße
OXPUS
Kein Support bei unaufgeforderten PNs, E-Mails oder auf anderem Weg!!
Poldi225
Mitglied
Beiträge: 55
Registriert: 23.07.2008 19:44

Re: Download Mod

Beitrag von Poldi225 »

hi,
dieser Code löst komischerweise diesen Fehler aus:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''phpbb_dl_config'( 'config_name' varchar( 255 ) NOT NULL default ' ', 'config_' at line 1
CREATE TABLE 'phpbb_dl_config'(
'config_name'varchar( 255 ) NOT NULL default ' ',
'config_value'varchar( 255 ) default NULL ,
PRIMARY KEY ( 'config_name' )
);

:cry: danke für deine Hilfe
Benutzeravatar
oxpus
Ehemaliges Teammitglied
Beiträge: 5395
Registriert: 03.02.2003 12:33
Wohnort: Bad Wildungen
Kontaktdaten:

Re: Download Mod

Beitrag von oxpus »

Ah, noch ein Leerzeichen vergessen. Ich habe das SQL-Statement noch mal korrigiert.
Grüße
OXPUS
Kein Support bei unaufgeforderten PNs, E-Mails oder auf anderem Weg!!
Antworten

Zurück zu „[3.0.x] Mod Support“