DAM Dateien bearbeiten

Sauerwald · #1 13.12.07, 19:07

Hallo Leute,
ich habe nur die Extesion DAM installiert wie ich das in den FILM VIEDEO2BRAIN gesehen habe.
Soweit klappt auch alles, nur wenn ich in der Dateiliste bin, kann ich die Dateien nicht bearbeiten?

Auch werden keine Thubnails abgezeigt. Trotz das ich diese angehakt habe.

*Media (DAM)* (dam)

So ich habe festgestellt das etwas nicht in die DB eingetragen wurde.

Code:

CREATE TABLE tx_dam (
uid int(11) NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
cruser_id int(11) unsigned NOT NULL default '0',
parent_id int(11) NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
active tinyint(4) unsigned NOT NULL default '0',
sorting int(10) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
starttime int(11) unsigned NOT NULL default '0',
endtime int(11) unsigned NOT NULL default '0',
fe_group int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
l18n_parent int(11) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL,
t3ver_oid int(11) NOT NULL default '0',
t3ver_id int(11) NOT NULL default '0',
t3ver_label varchar(60) NOT NULL default '',
media_type tinyint(4) unsigned NOT NULL default '0',
title text NOT NULL,
category int(11) NOT NULL default '0',
index_type varchar(8) NOT NULL default '',
file_mime_type varchar(90) NOT NULL default '',
file_mime_subtype varchar(90) NOT NULL default '',
file_type varchar(8) NOT NULL default '',
file_type_version varchar(18) NOT NULL default '',
file_name varchar(200) NOT NULL default '',
file_path text NOT NULL,
file_size int(11) unsigned NOT NULL default '0',
file_mtime int(11) unsigned NOT NULL default '0',
file_inode int(11) NOT NULL default '0',
file_ctime int(11) unsigned NOT NULL default '0',
file_hash varchar(64) NOT NULL default '',
file_status tinyint(4) unsigned NOT NULL default '0',
file_orig_location text NOT NULL,
file_orig_loc_desc varchar(90) NOT NULL default '',
file_creator varchar(90) NOT NULL default '',
file_dl_name varchar(200) NOT NULL default '',
file_usage int(11) unsigned NOT NULL default '0',
meta text NOT NULL,
ident varchar(90) NOT NULL default '',
creator varchar(90) NOT NULL default '',
keywords text NOT NULL,
description text NOT NULL,
alt_text text NOT NULL,
caption text NOT NULL,
abstract text NOT NULL,
search_content text NOT NULL,
language char(6) NOT NULL default '',
pages int(4) unsigned NOT NULL default '0',
publisher varchar(90) NOT NULL default '',
copyright text NOT NULL,
instructions text NOT NULL,
date_cr int(11) unsigned NOT NULL default '0',
date_mod int(11) unsigned NOT NULL default '0',
loc_desc varchar(90) NOT NULL default '',
loc_country char(6) NOT NULL default '',
loc_city varchar(90) NOT NULL default '',
hres int(11) unsigned NOT NULL default '0',
vres int(11) unsigned NOT NULL default '0',
hpixels int(11) unsigned NOT NULL default '0',
vpixels int(11) unsigned NOT NULL default '0',
color_space varchar(8) NOT NULL default '',
width float unsigned NOT NULL default '0',
height float unsigned NOT NULL default '0',
height_unit char(6) NOT NULL default '',
PRIMARY KEY (uid),
KEY parent (pid),
KEY media_type (media_type),
KEY t3ver_oid (t3ver_oid),
KEY file_type (file_type),
KEY file_hash (file_hash),
KEY file_name (file_name),
KEY file_path (file_path)
);

MySQL meldet:
#1170 - BLOB/TEXT column 'file_path' used in key specification without a key length

Code:

SQL-Befehl: 

CREATE TABLE tx_dam( uid int( 11 ) NOT NULL AUTO_INCREMENT ,
pid int( 11 ) NOT NULL default '0',
tstamp int( 11 ) unsigned NOT NULL default '0',
crdate int( 11 ) unsigned NOT NULL default '0',
cruser_id int( 11 ) unsigned NOT NULL default '0',
parent_id int( 11 ) NOT NULL default '0',
deleted tinyint( 4 ) unsigned NOT NULL default '0',
active tinyint( 4 ) unsigned NOT NULL default '0',
sorting int( 10 ) unsigned NOT NULL default '0',
hidden tinyint( 4 ) unsigned NOT NULL default '0',
starttime int( 11 ) unsigned NOT NULL default '0',
endtime int( 11 ) unsigned NOT NULL default '0',
fe_group int( 11 ) NOT NULL default '0',
sys_language_uid int( 11 ) NOT NULL default '0',
l18n_parent int( 11 ) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL ,
t3ver_oid int( 11 ) NOT NULL default '0',
t3ver_id int( 11 ) NOT NULL default '0',
t3ver_label varchar( 60 ) NOT NULL default '',
media_type tinyint( 4 ) unsigned NOT NULL default '0',
title text NOT NULL ,
category int( 11 ) NOT NULL default '0',
index_type varchar( 8 ) NOT NULL default '',
file_mime_type varchar( 90 ) NOT NULL default '',
file_mime_subtype varchar( 90 ) NOT NULL default '',
file_type varchar( 8 ) NOT NULL default '',
file_type_version varchar( 18 ) NOT NULL default '',
file_name varchar( 200 ) NOT NULL default '',
file_path text NOT NULL ,
file_size int( 11 ) unsigned NOT NULL default '0',
file_mtime int( 11 ) unsigned NOT NULL default '0',
file_inode int( 11 ) NOT NULL default '0',
file_ctime int( 11 ) unsigned NOT NULL default '0',
file_hash varchar( 64 ) NOT NULL default '',
file_status tinyint( 4 ) unsigned NOT NULL default '0',
file_orig_location text NOT NULL ,
file_orig_loc_desc varchar( 90 ) NOT NULL default '',
file_creator varchar( 90 ) NOT NULL default '',
file_dl_name varchar( 200 ) NOT NULL default '',
file_usage int( 11 ) unsigned NOT NULL default '0',
meta text NOT NULL ,
ident varchar( 90 ) NOT NULL default '',
creator varchar( 90 ) NOT NULL default '',
keywords text NOT NULL ,
description text NOT NULL ,
alt_text text NOT NULL ,
caption text NOT NULL ,
abstract text NOT NULL ,
search_content text NOT NULL ,
language char( 6 ) NOT NULL default '',
pages int( 4 ) unsigned NOT NULL default '0',
publisher varchar( 90 ) NOT NULL default '',
copyright text NOT NULL ,
instructions text NOT NULL ,
date_cr int( 11 ) unsigned NOT NULL default '0',
date_mod int( 11 ) unsigned NOT NULL default '0',
loc_desc varchar( 90 ) NOT NULL default '',
loc_country char( 6 ) NOT NULL default '',
loc_city varchar( 90 ) NOT NULL default '',
hres int( 11 ) unsigned NOT NULL default '0',
vres int( 11 ) unsigned NOT NULL default '0',
hpixels int( 11 ) unsigned NOT NULL default '0',
vpixels int( 11 ) unsigned NOT NULL default '0',
color_space varchar( 8 ) NOT NULL default '',
width float unsigned NOT NULL default '0',
height float unsigned NOT NULL default '0',
height_unit char( 6 ) NOT NULL default '',
PRIMARY KEY ( uid ) ,
KEY parent( pid ) ,
KEY media_type( media_type ) ,
KEY t3ver_oid( t3ver_oid ) ,
KEY file_type( file_type ) ,
KEY file_hash( file_hash ) ,
KEY file_name( file_name ) ,
KEY file_path( file_path ) 
)

Ich hoffe es hat einer eine Idee.

Danke im Voraus

Markus