[Typo3-german] Login im Backend nicht möglich

Xaver rxreichart at bluewin.ch
Thu Sep 22 17:32:26 CEST 2005


Liebe Liste

Ich habe im Install Tool und bei den Berechtigungen alles mehrfach 
gecheckt und bin all den Hinweisen, die ich gefunden habe nachgegangen, 
trotzdem ist es mir immer noch nicht möglich, mich im Backend 
einzuloggen. Das Frontend läuft grundsätzlich (natürlich ist nach einer 
Neuinstallation noch kein Content da), aber im Backend erhalte ich immer 
eine 500er Internal Server Error Fehlermeldung.
Was ich gecheckt habe:
- Install Tool/Basic Configuration: Keine Hinweise!
- Database Analyzer: Da scheint alles ok zu sein, aber da ich mir nicht 

   ganz sicher bin, füge ich den Output unten an. Die Verbindung zur 
Datenbank steht und das System gibt an, dass 30 Tabellen angelegt sind
- Ordner und Dateiberechtigungen laut Angaben aus den Büchern und 
anderen Unterlagen
- donotcheckReferrer gesetzt
- Cookies und Java enabled
- Admin mit Passwort angelegt
- Safe mode off

Woran kann es noch liegen???
Kann mir jemand einen Hinweis geben?
Herzlichen Dank
Gruss Xaver

Typo3 3.8.0; mysql 4.0.20; php 4.3.8


Output Database Analyzer:

Tables and fields in $TCA, but not in database:
Table and field definitions OK
All fields and tables configured in $TCA appeared to exist in the 
database as well
Tables from database, but not in $TCA:
static_tsconfig_help
Field name:	Info:
uid	int(11) NOT NULL auto_increment
guide	int(11) NOT NULL default '0'
md5hash	varchar(64) NOT NULL default ''
description	text NOT NULL
obj_string	text NOT NULL
appdata	blob NOT NULL
title	text NOT NULL
tx_impexp_presets
Field name:	Info:
uid	int(11) NOT NULL auto_increment
user_uid	int(11) NOT NULL default '0'
title	text NOT NULL
public	tinyint(3) NOT NULL default '0'
item_uid	int(11) NOT NULL default '0'
preset_data	blob NOT NULL


zzz_deleted_tx_impexp_presets
Field name:	Info:
uid	int(11) NOT NULL auto_increment
user_uid	int(11) NOT NULL default '0'
title	text NOT NULL
public	tinyint(3) NOT NULL default '0'
item_uid	int(11) NOT NULL default '0'
preset_data	blob NOT NULL

Extra tables in the database
There are some tables in the database which are not configured in the 
$TCA array. You should probably not worry about this, but please make 
sure that you know what these tables are about and why they are not 
configured in $TCA.

Fields from database, but not in $TCA:
fe_users
Field name:	Info / Suggestion for the field:
module_sys_dmail_category	int(10) unsigned NOT NULL default '0'

"module_sys_dmail_category" => Array (
	"label" => "MODULE_SYS_DMAIL_CATEGORY:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"module_sys_dmail_category" => Array (
	"label" => "MODULE_SYS_DMAIL_CATEGORY:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),

module_sys_dmail_html	tinyint(3) unsigned NOT NULL default '0'

"module_sys_dmail_html" => Array (
	"label" => "MODULE_SYS_DMAIL_HTML:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("Item number 1", "1"),
			Array("Item number 2", "2"),
			Array("-----", "--div--"),
			Array("Item number 3", "3")
		),
		"default" => "1"
	)
),

----- OR -----

"module_sys_dmail_html" => Array (
	"label" => "MODULE_SYS_DMAIL_HTML:",
	"exclude" => 0,
	"config" => Array (
		"type" => "check",
		"default" => "1"
	)
),

is_online	int(10) unsigned NOT NULL default '0'

"is_online" => Array (
	"label" => "IS_ONLINE:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"is_online" => Array (
	"label" => "IS_ONLINE:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),



pages
Field name:	Info / Suggestion for the field:
t3ver_oid	int(11) unsigned NOT NULL default '0'

"t3ver_oid" => Array (
	"label" => "T3VER_OID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"t3ver_oid" => Array (
	"label" => "T3VER_OID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),

t3ver_id	int(11) unsigned NOT NULL default '0'

"t3ver_id" => Array (
	"label" => "T3VER_ID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"t3ver_id" => Array (
	"label" => "T3VER_ID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),



pages_language_overlay
Field name:	Info / Suggestion for the field:
t3ver_oid	int(11) unsigned NOT NULL default '0'

"t3ver_oid" => Array (
	"label" => "T3VER_OID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"t3ver_oid" => Array (
	"label" => "T3VER_OID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),

t3ver_id	int(11) unsigned NOT NULL default '0'

"t3ver_id" => Array (
	"label" => "T3VER_ID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"t3ver_id" => Array (
	"label" => "T3VER_ID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),



tt_content
Field name:	Info / Suggestion for the field:
t3ver_oid	int(11) unsigned NOT NULL default '0'

"t3ver_oid" => Array (
	"label" => "T3VER_OID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"t3ver_oid" => Array (
	"label" => "T3VER_OID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),

t3ver_id	int(11) unsigned NOT NULL default '0'

"t3ver_id" => Array (
	"label" => "T3VER_ID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"t3ver_id" => Array (
	"label" => "T3VER_ID:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),

module_sys_dmail_category	int(10) unsigned NOT NULL default '0'

"module_sys_dmail_category" => Array (
	"label" => "MODULE_SYS_DMAIL_CATEGORY:",
	"exclude" => 0,
	"config" => Array (
		"type" => "input",
		"size" => "8",
		"max" => "20",
		"eval" => "date",
		"default" => "0",
		"checkbox" => "0"
	)
),

----- OR -----

"module_sys_dmail_category" => Array (
	"label" => "MODULE_SYS_DMAIL_CATEGORY:",
	"exclude" => 0,
	"config" => Array (
		"type" => "select",
		"items" => Array (
			Array("[nothing]", 0),
			Array("Extra choice! Only negative values here.", -1),
			Array("__Divider:__", "--div--")
		),
		"foreign_table" => "[some_table_name]"
	)
),


Extra fields in the database
There are some additional fields the database tables which are not 
configured in the $TCA array. You should probably not worry about this, 
but please make sure that you know what these fields are about and why 
they are not configured in $TCA.


Comparison between database and $TCA:
Actual and suggested field definitions
This table shows you the suggested field definitions which are 
calculated based on the configuration in $TCA. If the suggested value 
differs from the actual current database value, you should not panic, 
but simply check if the datatype of that field is sufficient compared to 
the data, you want TYPO3 to put there.

pages
Field name: 	Suggested value from $TCA: 	Actual value from database:
doktype 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
title 	tinytext NOT NULL 	text NOT NULL
TSconfig 	text NOT NULL 	blob NOT NULL
php_tree_stop 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL 
default '0'
is_siteroot 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL 
default '0'
storage_pid 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
t3ver_label 	varchar(30) NOT NULL default '' 	varchar(60) NOT NULL 
default ''
editlock 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL default '0'
layout 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
fe_group 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
extendToSubpages 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned 
NOT NULL default '0'
nav_title 	tinytext NOT NULL 	text NOT NULL
nav_hide 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL default '0'
subtitle 	tinytext NOT NULL 	text NOT NULL
target 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
alias 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
url 	tinytext NOT NULL 	text NOT NULL
urltype 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
lastUpdated 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
newUntil 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
cache_timeout 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
no_cache 	tinyint(3) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
no_search 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
shortcut 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
shortcut_mode 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
content_from_pid 	int(11) NOT NULL default '0' 	int(10) unsigned NOT 
NULL default '0'
mount_pid 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL 
default '0'
keywords 	text NOT NULL 	text NOT NULL
description 	tinytext NOT NULL 	text NOT NULL
abstract 	text NOT NULL 	text NOT NULL
author 	varchar(80) NOT NULL default '' 	text NOT NULL
author_email 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL 
default ''
media 	blob NOT NULL 	blob NOT NULL
mount_pid_ol 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL 
default '0'
module 	varchar(8) NOT NULL default '' 	varchar(20) NOT NULL default ''
fe_login_mode 	int(11) NOT NULL default '0' 	tinyint(4) NOT NULL default '0'
l18n_cfg 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL default '0'


be_users
Field name: 	Suggested value from $TCA: 	Actual value from database:
username 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
password 	varchar(40) NOT NULL default '' 	varchar(80) NOT NULL default ''
usergroup 	blob NOT NULL 	tinyblob NOT NULL
lockToDomain 	varchar(50) NOT NULL default '' 	varchar(100) NOT NULL 
default ''
db_mountpoints 	blob NOT NULL 	varchar(80) NOT NULL default ''
file_mountpoints 	blob NOT NULL 	varchar(80) NOT NULL default ''
email 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
realName 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
disable 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
disableIPlock 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
admin 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
options 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
fileoper_perms 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL 
default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL default '0'
lang 	varchar(2) NOT NULL default '' 	varchar(4) NOT NULL default ''
userMods 	blob NOT NULL 	tinyblob NOT NULL
allowed_languages 	tinyblob NOT NULL 	tinyblob NOT NULL
TSconfig 	text NOT NULL 	blob NOT NULL


be_groups
Field name: 	Suggested value from $TCA: 	Actual value from database:
title 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
db_mountpoints 	blob NOT NULL 	varchar(80) NOT NULL default ''
file_mountpoints 	blob NOT NULL 	varchar(80) NOT NULL default ''
pagetypes_select 	blob NOT NULL 	tinyblob NOT NULL
tables_modify 	blob NOT NULL 	blob NOT NULL
tables_select 	blob NOT NULL 	blob NOT NULL
non_exclude_fields 	tinyblob NOT NULL 	blob NOT NULL
explicit_allowdeny 	tinyblob NOT NULL 	blob NOT NULL
allowed_languages 	tinyblob NOT NULL 	tinyblob NOT NULL
custom_options 	tinyblob NOT NULL 	blob NOT NULL
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
lockToDomain 	varchar(50) NOT NULL default '' 	varchar(100) NOT NULL 
default ''
groupMods 	blob NOT NULL 	tinyblob NOT NULL
inc_access_lists 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned 
NOT NULL default '0'
description 	text NOT NULL 	text NOT NULL
TSconfig 	text NOT NULL 	blob NOT NULL
hide_in_lists 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL 
default '0'
subgroup 	blob NOT NULL 	tinyblob NOT NULL


sys_filemounts
Field name: 	Suggested value from $TCA: 	Actual value from database:
title 	varchar(30) NOT NULL default '' 	varchar(60) NOT NULL default ''
path 	varchar(120) NOT NULL default '' 	varchar(240) NOT NULL default ''
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
base 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL default '0'


sys_language
Field name: 	Suggested value from $TCA: 	Actual value from database:
title 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
static_lang_isocode 	int(11) NOT NULL default '0' 	int(11) unsigned NOT 
NULL default '0'
flag 	int(11) NOT NULL default '0' 	varchar(40) NOT NULL default ''


tt_content
Field name: 	Suggested value from $TCA: 	Actual value from database:
CType 	varchar(10) NOT NULL default '' 	varchar(60) NOT NULL default ''
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL default '0'
fe_group 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
sys_language_uid 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
l18n_parent 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
layout 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
colPos 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
date 	int(11) NOT NULL default '0' 	int(10) unsigned NOT NULL default '0'
header 	tinytext NOT NULL 	text NOT NULL
header_position 	varchar(6) NOT NULL default '' 	varchar(12) NOT NULL 
default ''
header_link 	tinytext NOT NULL 	text NOT NULL
header_layout 	int(11) NOT NULL default '0' 	varchar(60) NOT NULL 
default '0'
subheader 	tinytext NOT NULL 	text NOT NULL
bodytext 	text NOT NULL 	mediumtext NOT NULL
text_align 	varchar(6) NOT NULL default '' 	varchar(12) NOT NULL default ''
text_face 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
text_size 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
text_color 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
text_properties 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned 
NOT NULL default '0'
image 	tinyblob NOT NULL 	blob NOT NULL
imagewidth 	int(11) NOT NULL default '0' 	mediumint(11) unsigned NOT 
NULL default '0'
imageheight 	int(11) NOT NULL default '0' 	mediumint(8) unsigned NOT 
NULL default '0'
imageorient 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
imageborder 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT 
NULL default '0'
image_noRows 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
image_link 	tinytext NOT NULL 	text NOT NULL
image_zoom 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
image_effects 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
image_frames 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
image_compression 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
imagecols 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
imagecaption 	text NOT NULL 	text NOT NULL
imagecaption_position 	varchar(6) NOT NULL default '' 	varchar(12) NOT 
NULL default ''
cols 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL default '0'
pages 	blob NOT NULL 	tinyblob NOT NULL
recursive 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
menu_type 	int(11) NOT NULL default '0' 	varchar(60) NOT NULL default '0'
list_type 	int(11) NOT NULL default '0' 	varchar(72) NOT NULL default '0'
select_key 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL 
default ''
table_bgColor 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
table_border 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
table_cellspacing 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
table_cellpadding 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
media 	tinyblob NOT NULL 	blob NOT NULL
multimedia 	blob NOT NULL 	tinyblob NOT NULL
filelink_size 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
records 	tinyblob NOT NULL 	blob NOT NULL
spaceBefore 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
spaceAfter 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
section_frame 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
splash_layout 	int(11) NOT NULL default '0' 	varchar(60) NOT NULL 
default '0'
sectionIndex 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT 
NULL default '0'
linkToTop 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
rte_enabled 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL 
default '0'
t3ver_label 	varchar(30) NOT NULL default '' 	varchar(60) NOT NULL 
default ''


fe_users
Field name: 	Suggested value from $TCA: 	Actual value from database:
username 	varchar(50) NOT NULL default '' 	varchar(100) NOT NULL default ''
password 	varchar(40) NOT NULL default '' 	varchar(80) NOT NULL default ''
usergroup 	tinyblob NOT NULL 	tinyblob NOT NULL
lockToDomain 	varchar(50) NOT NULL default '' 	varchar(100) NOT NULL 
default ''
name 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
address 	text NOT NULL 	text NOT NULL
telephone 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
fax 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
email 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
title 	varchar(40) NOT NULL default '' 	varchar(80) NOT NULL default ''
zip 	varchar(10) NOT NULL default '' 	varchar(20) NOT NULL default ''
city 	varchar(50) NOT NULL default '' 	varchar(100) NOT NULL default ''
country 	varchar(40) NOT NULL default '' 	varchar(80) NOT NULL default ''
www 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
company 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
image 	blob NOT NULL 	tinyblob NOT NULL
disable 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL default '0'
TSconfig 	text NOT NULL 	blob NOT NULL


fe_groups
Field name: 	Suggested value from $TCA: 	Actual value from database:
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
title 	varchar(20) NOT NULL default '' 	varchar(40) NOT NULL default ''
lockToDomain 	varchar(50) NOT NULL default '' 	varchar(100) NOT NULL 
default ''
description 	text NOT NULL 	text NOT NULL
TSconfig 	text NOT NULL 	blob NOT NULL


sys_domain
Field name: 	Suggested value from $TCA: 	Actual value from database:
domainName 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL 
default ''
redirectTo 	varchar(120) NOT NULL default '' 	varchar(240) NOT NULL 
default ''
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
prepend_params 	tinyint(3) NOT NULL default '0' 	int(10) NOT NULL 
default '0'


pages_language_overlay
Field name: 	Suggested value from $TCA: 	Actual value from database:
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL default '0'
title 	tinytext NOT NULL 	text NOT NULL
subtitle 	tinytext NOT NULL 	text NOT NULL
nav_title 	tinytext NOT NULL 	text NOT NULL
keywords 	text NOT NULL 	text NOT NULL
description 	tinytext NOT NULL 	text NOT NULL
abstract 	text NOT NULL 	text NOT NULL
author 	varchar(80) NOT NULL default '' 	text NOT NULL
author_email 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL 
default ''
media 	blob NOT NULL 	tinyblob NOT NULL
sys_language_uid 	int(11) NOT NULL default '0' 	int(11) unsigned NOT 
NULL default '0'
t3ver_label 	varchar(30) NOT NULL default '' 	varchar(60) NOT NULL 
default ''


sys_template
Field name: 	Suggested value from $TCA: 	Actual value from database:
title 	tinytext NOT NULL 	text NOT NULL
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL default '0'
root 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
clear 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
sitetitle 	tinytext NOT NULL 	text NOT NULL
constants 	text NOT NULL 	blob NOT NULL
resources 	tinyblob NOT NULL 	blob NOT NULL
nextLevel 	int(11) NOT NULL default '0' 	varchar(10) NOT NULL default ''
include_static 	blob NOT NULL 	tinyblob NOT NULL
include_static_file 	blob NOT NULL 	blob NOT NULL
basedOn 	tinyblob NOT NULL 	tinyblob NOT NULL
includeStaticAfterBasedOn 	tinyint(3) NOT NULL default '0' 	tinyint(4) 
unsigned NOT NULL default '0'
config 	text NOT NULL 	blob NOT NULL
editorcfg 	text NOT NULL 	blob NOT NULL
description 	text NOT NULL 	text NOT NULL
static_file_mode 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT 
NULL default '0'
t3ver_label 	varchar(30) NOT NULL default '' 	varchar(60) NOT NULL 
default ''


static_template
Field name: 	Suggested value from $TCA: 	Actual value from database:
title 	tinytext NOT NULL 	text NOT NULL
constants 	text NOT NULL 	blob NOT NULL
include_static 	blob NOT NULL 	tinyblob NOT NULL
config 	text NOT NULL 	blob NOT NULL
editorcfg 	text NOT NULL 	blob NOT NULL
description 	text NOT NULL 	text NOT NULL


sys_note
Field name: 	Suggested value from $TCA: 	Actual value from database:
category 	int(11) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'
subject 	tinytext NOT NULL 	text NOT NULL
message 	text NOT NULL 	text NOT NULL
author 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
email 	varchar(80) NOT NULL default '' 	varchar(160) NOT NULL default ''
personal 	tinyint(3) NOT NULL default '0' 	tinyint(3) unsigned NOT NULL 
default '0'


OS detected: UNIX
UNIX/CGI detected: YES



More information about the TYPO3-german mailing list