phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

Download Mod

https://www.phpbb.de/community/viewtopic.php?t=191821

Seite 2 von 4

Re: Download Mod

Verfasst: 06.06.2009 20:34
von Poldi225
Hi,
danke! nein die Tabellen gab es nicht, das war ja mein Problem. Super Support!

Re: Download Mod

Verfasst: 06.06.2009 20:41
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

Re: Download Mod

Verfasst: 06.06.2009 22:35
von oxpus
Ersetze mal die " gegen einfache Hochkommas '

Re: Download Mod

Verfasst: 06.06.2009 23:32
von Poldi225
ok

Re: Download Mod

Verfasst: 06.06.2009 23:39
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

Re: Download Mod

Verfasst: 07.06.2009 14:07
von oxpus
Hm, wenn die Tabelle bei Dir schon nicht existiert, dann lass das "DROP TABLE" mal ganz weg.

Re: Download Mod

Verfasst: 07.06.2009 16:30
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

Re: Download Mod

Verfasst: 07.06.2009 16:35
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' )
);

Re: Download Mod

Verfasst: 07.06.2009 16:47
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

Re: Download Mod

Verfasst: 08.06.2009 10:26
von oxpus
Ah, noch ein Leerzeichen vergessen. Ich habe das SQL-Statement noch mal korrigiert.
Alle Zeiten sind UTC+02:00
Seite 2 von 4

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de