Seite 1 von 1

Attachment Mod (2.3.9) - keine Anzeige der Beschreibung

Verfasst: 26.01.2004 13:45
von Puppetmaster
Hallo!

Ich habe den Attachment Mod erfolgreich installiert, funktioniert alles soweit auch ganz locker, bis auf die Tatsache, dass auf der viewtopic.php in der Tabele mit den Attahcments eines Beitrages keine Beschreibungen angezeigt werden. Evtl. jemand eine Idee??

Verfasst: 02.06.2004 13:44
von Groovecommander
habe ebenfalls das Problem. Wurde dazu ein Lösung gefunden?

Vielen Dank im voraus

Verfasst: 02.06.2004 20:31
von rabbit
hast du das db-update korrekt ausgeführt? bei mir läuft der mod ohne probleme...

Verfasst: 02.06.2004 23:48
von Groovecommander
Ich habe die mod_table_inst.php nochmal ausgeführt, doch es geht immer noch nicht. Hier mal meine Meldung, die daraufhin bekam.
Running :: CREATE TABLE phpbb_attachments_config ( config_name varchar(255) NOT NULL, config_value varchar(255) NOT NULL, PRIMARY KEY (config_name) ) -> FAILED ---> Table 'phpbb_attachments_config' already exists

Running :: CREATE TABLE phpbb_forbidden_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, extension varchar(100) NOT NULL, PRIMARY KEY (ext_id) ) -> FAILED ---> Table 'phpbb_forbidden_extensions' already exists

Running :: CREATE TABLE phpbb_extension_groups ( group_id mediumint(8) NOT NULL auto_increment, group_name char(20) NOT NULL, cat_id tinyint(2) DEFAULT '0' NOT NULL, allow_group tinyint(1) DEFAULT '0' NOT NULL, download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, upload_icon varchar(100) DEFAULT '', max_filesize int(20) DEFAULT '0' NOT NULL, forum_permissions varchar(255) default '' NOT NULL, PRIMARY KEY group_id (group_id) ) -> FAILED ---> Table 'phpbb_extension_groups' already exists

Running :: CREATE TABLE phpbb_extensions ( ext_id mediumint(8) UNSIGNED NOT NULL auto_increment, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, extension varchar(100) NOT NULL, comment varchar(100), PRIMARY KEY ext_id (ext_id) ) -> FAILED ---> Table 'phpbb_extensions' already exists

Running :: CREATE TABLE phpbb_attachments_desc ( attach_id mediumint(8) UNSIGNED NOT NULL auto_increment, physical_filename varchar(255) NOT NULL, real_filename varchar(255) NOT NULL, download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, comment varchar(255), extension varchar(100), mimetype varchar(100), filesize int(20) NOT NULL, filetime int(11) DEFAULT '0' NOT NULL, thumbnail tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (attach_id), KEY filetime (filetime), KEY physical_filename (physical_filename(10)), KEY filesize (filesize) ) -> FAILED ---> Table 'phpbb_attachments_desc' already exists

Running :: CREATE TABLE phpbb_attachments ( attach_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, privmsgs_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id_1 mediumint(8) NOT NULL, user_id_2 mediumint(8) NOT NULL, KEY attach_id_post_id (attach_id, post_id), KEY attach_id_privmsgs_id (attach_id, privmsgs_id) ) -> FAILED ---> Table 'phpbb_attachments' already exists

Running :: CREATE TABLE phpbb_quota_limits ( quota_limit_id mediumint(8) unsigned NOT NULL auto_increment, quota_desc varchar(20) NOT NULL default '', quota_limit bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (quota_limit_id) ) -> FAILED ---> Table 'phpbb_quota_limits' already exists

Running :: CREATE TABLE phpbb_attach_quota ( user_id mediumint(8) unsigned NOT NULL default '0', group_id mediumint(8) unsigned NOT NULL default '0', quota_type smallint(2) NOT NULL default '0', quota_limit_id mediumint(8) unsigned NOT NULL default '0', KEY quota_type (quota_type) ) -> FAILED ---> Table 'phpbb_attach_quota' already exists

Running :: ALTER TABLE phpbb_forums ADD auth_download TINYINT(2) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'auth_download'

Running :: ALTER TABLE phpbb_auth_access ADD auth_download TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'auth_download'

Running :: ALTER TABLE phpbb_posts ADD post_attachment TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'post_attachment'

Running :: ALTER TABLE phpbb_topics ADD topic_attachment TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'topic_attachment'

Running :: ALTER TABLE phpbb_privmsgs ADD privmsgs_attachment TINYINT(1) DEFAULT '0' NOT NULL -> FAILED ---> Duplicate column name 'privmsgs_attachment'

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_dir','files') -> FAILED ---> Duplicate entry 'upload_dir' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('upload_img','images/icon_clip.gif') -> FAILED ---> Duplicate entry 'upload_img' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('topic_icon','images/icon_clip.gif') -> FAILED ---> Duplicate entry 'topic_icon' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('display_order','0') -> FAILED ---> Duplicate entry 'display_order' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize','262144') -> FAILED ---> Duplicate entry 'max_filesize' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_quota','52428800') -> FAILED ---> Duplicate entry 'attachment_quota' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_filesize_pm','262144') -> FAILED ---> Duplicate entry 'max_filesize_pm' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments','3') -> FAILED ---> Duplicate entry 'max_attachments' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('max_attachments_pm','1') -> FAILED ---> Duplicate entry 'max_attachments_pm' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('disable_mod','0') -> FAILED ---> Duplicate entry 'disable_mod' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_pm_attach','1') -> FAILED ---> Duplicate entry 'allow_pm_attach' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attachment_topic_review','0') -> FAILED ---> Duplicate entry 'attachment_topic_review' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('allow_ftp_upload','0') -> FAILED ---> Duplicate entry 'allow_ftp_upload' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('show_apcp','0') -> FAILED ---> Duplicate entry 'show_apcp' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('attach_version','2.3.9') -> FAILED ---> Duplicate entry 'attach_version' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_upload_quota', '0') -> FAILED ---> Duplicate entry 'default_upload_quota' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('default_pm_quota', '0') -> FAILED ---> Duplicate entry 'default_pm_quota' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_server','') -> FAILED ---> Duplicate entry 'ftp_server' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_path','') -> FAILED ---> Duplicate entry 'ftp_path' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('download_path','') -> FAILED ---> Duplicate entry 'download_path' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_user','') -> FAILED ---> Duplicate entry 'ftp_user' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pass','') -> FAILED ---> Duplicate entry 'ftp_pass' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('ftp_pasv_mode','1') -> FAILED ---> Duplicate entry 'ftp_pasv_mode' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_display_inlined','1') -> FAILED ---> Duplicate entry 'img_display_inlined' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_width','0') -> FAILED ---> Duplicate entry 'img_max_width' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_max_height','0') -> FAILED ---> Duplicate entry 'img_max_height' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_width','0') -> FAILED ---> Duplicate entry 'img_link_width' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_link_height','0') -> FAILED ---> Duplicate entry 'img_link_height' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_create_thumbnail','0') -> FAILED ---> Duplicate entry 'img_create_thumbnail' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_min_thumb_filesize','12000') -> FAILED ---> Duplicate entry 'img_min_thumb_filesize' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('img_imagick', '') -> FAILED ---> Duplicate entry 'img_imagick' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('use_gd2','0') -> FAILED ---> Duplicate entry 'use_gd2' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('wma_autoplay','0') -> FAILED ---> Duplicate entry 'wma_autoplay' for key 1

Running :: INSERT INTO phpbb_attachments_config (config_name, config_value) VALUES ('flash_autoplay','0') -> FAILED ---> Duplicate entry 'flash_autoplay' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (1,'php') -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (2,'php3') -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (3,'php4') -> FAILED ---> Duplicate entry '3' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (4,'phtml') -> FAILED ---> Duplicate entry '4' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (5,'pl') -> FAILED ---> Duplicate entry '5' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (6,'asp') -> FAILED ---> Duplicate entry '6' for key 1

Running :: INSERT INTO phpbb_forbidden_extensions (ext_id, extension) VALUES (7,'cgi') -> FAILED ---> Duplicate entry '7' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (1,'Images',1,1,1,'',0,'') -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (2,'Archives',0,1,1,'',0,'') -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (3,'Plain Text',0,0,1,'',0,'') -> FAILED ---> Duplicate entry '3' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (4,'Documents',0,0,1,'',0,'') -> FAILED ---> Duplicate entry '4' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (5,'Real Media',0,0,2,'',0,'') -> FAILED ---> Duplicate entry '5' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (6,'Streams',2,0,1,'',0,'') -> FAILED ---> Duplicate entry '6' for key 1

Running :: INSERT INTO phpbb_extension_groups (group_id, group_name, cat_id, allow_group, download_mode, upload_icon, max_filesize, forum_permissions) VALUES (7,'Flash Files',3,0,1,'',0,'') -> FAILED ---> Duplicate entry '7' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (1, 1,'gif', '') -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (2, 1,'png', '') -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (3, 1,'jpeg', '') -> FAILED ---> Duplicate entry '3' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (4, 1,'jpg', '') -> FAILED ---> Duplicate entry '4' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (5, 1,'tif', '') -> FAILED ---> Duplicate entry '5' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (6, 1,'tga', '') -> FAILED ---> Duplicate entry '6' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (7, 2,'gtar', '') -> FAILED ---> Duplicate entry '7' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (8, 2,'gz', '') -> FAILED ---> Duplicate entry '8' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (9, 2,'tar', '') -> FAILED ---> Duplicate entry '9' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (10, 2,'zip', '') -> FAILED ---> Duplicate entry '10' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (11, 2,'rar', '') -> FAILED ---> Duplicate entry '11' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (12, 2,'ace', '') -> FAILED ---> Duplicate entry '12' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (13, 3,'txt', '') -> FAILED ---> Duplicate entry '13' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (14, 3,'c', '') -> FAILED ---> Duplicate entry '14' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (15, 3,'h', '') -> FAILED ---> Duplicate entry '15' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (16, 3,'cpp', '') -> FAILED ---> Duplicate entry '16' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (17, 3,'hpp', '') -> FAILED ---> Duplicate entry '17' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (18, 3,'diz', '') -> FAILED ---> Duplicate entry '18' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (19, 4,'xls', '') -> FAILED ---> Duplicate entry '19' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (20, 4,'doc', '') -> FAILED ---> Duplicate entry '20' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (21, 4,'dot', '') -> FAILED ---> Duplicate entry '21' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (22, 4,'pdf', '') -> FAILED ---> Duplicate entry '22' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (23, 4,'ai', '') -> FAILED ---> Duplicate entry '23' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (24, 4,'ps', '') -> FAILED ---> Duplicate entry '24' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (25, 4,'ppt', '') -> FAILED ---> Duplicate entry '25' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (26, 5,'rm', '') -> FAILED ---> Duplicate entry '26' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (27, 6,'wma', '') -> FAILED ---> Duplicate entry '27' for key 1

Running :: INSERT INTO phpbb_extensions (ext_id, group_id, extension, comment) VALUES (28, 7,'swf', '') -> FAILED ---> Duplicate entry '28' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (1, 'Low', 262144) -> FAILED ---> Duplicate entry '1' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (2, 'Medium', 2097152) -> FAILED ---> Duplicate entry '2' for key 1

Running :: INSERT INTO phpbb_quota_limits (quota_limit_id, quota_desc, quota_limit) VALUES (3, 'High', 5242880) -> FAILED ---> Duplicate entry '3' for key 1


COMPLETE!

Some queries failed. Please contact me via email, pm, at the board or whatever, so we can solve your problems...
To Undo the changes to your database please execute mod_table_uninst.php.

NOW DELETE THIS FILE
Ich kann einfach keine "Beschreibung" zu den Attachments hinzufügen..
Hat noch einer ne Idee? Welcher wäre denn der Eintrag für die "Beschreibung" in der Datenbank. Mal schauen, ob der da ist.

Verfasst: 04.06.2004 11:53
von Groovecommander
Habe die Anleitung nochmal von Hand überprüft, ob alle Einträge gemäß der Anleitung da sind. Es lässt sich einfach keine Beschreibung zu den Attachments hinzufügen. Was kann man denn noch machen?

Verfasst: 04.06.2004 13:11
von Christian_W
Es fehlt die Beschreibung des Attachments?
Ist die Zeile da und es fehlt nur die Beschreibung oder fehlt die ganze Zeile?
Kann beim anhängen eine Beschreibung eingegeben werden?
Schau mal in die Tabelle "attachments_desc" ob bei "comment" die Beschreibung drin steht.
Wird die Beschreibung bei einem PN-Attachment angezeigt?
Welche Version des Mods hast Du eingebaut?
Link um sich das mal anzusehen am besten mit Testaccount?

Gruß Christian

Verfasst: 04.06.2004 13:25
von Groovecommander
Danke Christian,
Schau mal in die Tabelle "attachments_desc" ob bei "comment" die Beschreibung drin steht.
da war comment groß geschrieben (COMMENT). hab es klein geschrieben, und nun funzt es.

:lol: