Nach Installation nicht ganzes Menü sichtbar

Erstellt am 14. Dezember 2004 · 8 Antworten · letzte Antwort am 4. Februar 2005

orlando · 14. Dezember 2004 09:40

Huhu zusammen,

ich bin zugegebenermaßen typo3-noob 🙂 und habe nach der installation folgendes problem. es sind nicht alle
menüpunkte sichtbar auf der linken seite. woran liegt das? bestimmt ist das irgendwo beschrieben, aber ich finde es
ums verrecken nicht. wäre klasse, wenn mir jemand nen tipp geben könnte wie ich mal nachsehen kann. viele dank 🙂

folgende punkte sind nur sichtbar:

View
Plugins
Template
Photo Marathon
Images
Task center
User Admin
DB check
Configuration
Log
Indexing
phpMyAdmin

adrianms · 19. Dezember 2004 21:21

Hallo Adrian!

Ich habe das gleiche Problem. Bei mir läuft Typo3 auf einem Root-Server mit Linux 9.0. Außerdem Confixx. Die Datenbank&User haben volle Rechte etc.

Bin verzweifelt und habe schon sehr viele Quellen nach dem Fehler durchsucht - ohne Lösung. Auch Neuinstallationen haben nichts geholfen...

Sorry, dass ich nicht weiterhelfen konnte. Hoffe sehr, dass uns jemand helfen kann.

Viele Grüße,
adrianms

mstuebner · 19. Dezember 2004 22:02

orlando schrieb
ich bin zugegebenermaßen typo3-noob 🙂 und habe nach der installation folgendes problem. es sind nicht alle menüpunkte sichtbar auf der linken seite. woran liegt das?

Dann installier doch mal das Dummy Paket und berichte. Evtl. wäre auch interessant welches OS Du benutzt.

adrianms · 19. Dezember 2004 22:04

Hallo,

bei mir ist das Dummy-Package installiert, mit der gleichen Fehlermeldung...

gruß,
adriams

mstuebner · 19. Dezember 2004 22:36

adrianms schrieb
bei mir ist das Dummy-Package installiert, mit der gleichen Fehlermeldung...

Dann wüsste ich nicht wie man euch ohne einen Blick ins BE weiterhelfen könnte.

orlando · 20. Dezember 2004 09:15

huhu,

ich glaube ich habe vielleicht das problem gefunden. es ist
so banal, dass ich mich kaum traue das hier zu sagen 8-)

normalerweise benutze ich den firefox, und habe bei dem
browser auch die probleme gehabt. als ich mir den kram
mal im internet explorer angesehen habe, war das ganze
menu sichtbar ...

kannst ja mal sehen, ob das bei dir auch so ist.

gruss,
orlando

mstuebner · 20. Dezember 2004 12:02

orlando schrieb
ich glaube ich habe vielleicht das problem gefunden. es ist
so banal, dass ich mich kaum traue das hier zu sagen 8-)

Diese "Lösung" wäre alles andere als trivial!

orlando schrieb
normalerweise benutze ich den firefox, und habe bei dem
browser auch die probleme gehabt. als ich mir den kram
mal im internet explorer angesehen habe, war das ganze
menu sichtbar ...

kannst ja mal sehen, ob das bei dir auch so ist.

Ich benutze ausschliesslich den Firefox und kann Dir nach Vergleich sagen, dass das Menü im FireFox genauso lückenhaft aussieht wie im IE6. Gott sei dank.

Selbiges konnte ich bisher in keiner meiner Installationen beobachten. Ich würde daher eher auf fehlerhaftes chacing/DB-Probleme tippen.

mstuebner · 20. Dezember 2004 12:10

Die Lösung ist wohl etwas anders.

Geh mal in das Installtool und auf Database Analyser. Wenn Du dann ein Compare machst wirst Du folgenden Output sehen:

ALTER TABLE be_groups CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE be_groups CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE title title varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE be_groups CHANGE db_mountpoints db_mountpoints varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE be_groups CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE file_mountpoints file_mountpoints varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE be_groups CHANGE hidden hidden tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE inc_access_lists inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE lockToDomain lockToDomain varchar(50) DEFAULT '' NOT NULL;
	Current value: varchar(50) DEFAULT '' NOT NULL
	ALTER TABLE be_groups CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_groups CHANGE hide_in_lists hide_in_lists tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE be_sessions CHANGE ses_id ses_id varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE be_sessions CHANGE ses_name ses_name varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE be_sessions CHANGE ses_iplock ses_iplock varchar(15) DEFAULT '' NOT NULL;
	Current value: varchar(15) DEFAULT '' NOT NULL
	ALTER TABLE be_sessions CHANGE ses_hashlock ses_hashlock int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE be_sessions CHANGE ses_userid ses_userid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_sessions CHANGE ses_tstamp ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE be_users CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE username username varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE password password varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE admin admin tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE disable disable tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE starttime starttime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE endtime endtime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE lang lang char(2) DEFAULT '' NOT NULL;
	Current value: char(2) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE email email varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE db_mountpoints db_mountpoints varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE options options tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE realName realName varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE file_mountpoints file_mountpoints varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE fileoper_perms fileoper_perms tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE lockToDomain lockToDomain varchar(50) DEFAULT '' NOT NULL;
	Current value: varchar(50) DEFAULT '' NOT NULL
	ALTER TABLE be_users CHANGE disableIPlock disableIPlock tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE lastlogin lastlogin int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE be_users CHANGE createdByAction createdByAction int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE cache_hash CHANGE hash hash varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE cache_hash CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_hash CHANGE ident ident varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE cache_imagesizes CHANGE md5hash md5hash varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE cache_imagesizes CHANGE md5filename md5filename varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE cache_imagesizes CHANGE tstamp tstamp int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE cache_imagesizes CHANGE imagewidth imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL;
	Current value: mediumint(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_imagesizes CHANGE imageheight imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL;
	Current value: mediumint(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE uid uid int(11) DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE pages CHANGE pid pid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE t3ver_oid t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE t3ver_id t3ver_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE t3ver_label t3ver_label varchar(30) DEFAULT '' NOT NULL;
	Current value: varchar(30) DEFAULT '' NOT NULL
	ALTER TABLE pages CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE sorting sorting int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE deleted deleted tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE perms_userid perms_userid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE perms_groupid perms_groupid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE perms_user perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE perms_group perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE perms_everybody perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE editlock editlock tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE doktype doktype tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE storage_pid storage_pid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE is_siteroot is_siteroot tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE php_tree_stop php_tree_stop tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE tx_impexp_origuid tx_impexp_origuid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE hidden hidden tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE starttime starttime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE endtime endtime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE urltype urltype tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE shortcut shortcut int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE shortcut_mode shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE no_cache no_cache int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE fe_group fe_group int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE layout layout tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE target target varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE pages CHANGE lastUpdated lastUpdated int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE cache_timeout cache_timeout int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE newUntil newUntil int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE no_search no_search tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE SYS_LASTCHANGED SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE module module varchar(10) DEFAULT '' NOT NULL;
	Current value: varchar(10) DEFAULT '' NOT NULL
	ALTER TABLE pages CHANGE extendToSubpages extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE author_email author_email varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE pages CHANGE nav_hide nav_hide tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE content_from_pid content_from_pid int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE mount_pid mount_pid int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE mount_pid_ol mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE pages CHANGE alias alias varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE pages CHANGE l18n_cfg l18n_cfg tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE sys_be_shortcuts CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_be_shortcuts CHANGE userid userid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_be_shortcuts CHANGE sorting sorting int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_be_shortcuts CHANGE sc_group sc_group tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE sys_filemounts CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_filemounts CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_filemounts CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_filemounts CHANGE title title varchar(30) DEFAULT '' NOT NULL;
	Current value: varchar(30) DEFAULT '' NOT NULL
	ALTER TABLE sys_filemounts CHANGE path path varchar(120) DEFAULT '' NOT NULL;
	Current value: varchar(120) DEFAULT '' NOT NULL
	ALTER TABLE sys_filemounts CHANGE base base tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_filemounts CHANGE hidden hidden tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_filemounts CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_history CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_history CHANGE sys_log_uid sys_log_uid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_history CHANGE recuid recuid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_history CHANGE tablename tablename varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE sys_history CHANGE tstamp tstamp int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_history CHANGE snapshot snapshot tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE sys_lockedrecords CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_lockedrecords CHANGE userid userid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_lockedrecords CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_lockedrecords CHANGE record_table record_table varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE sys_lockedrecords CHANGE record_uid record_uid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_lockedrecords CHANGE record_pid record_pid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_lockedrecords CHANGE username username varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE sys_log CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_log CHANGE userid userid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE action action tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE recuid recuid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE tablename tablename varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE sys_log CHANGE recpid recpid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE error error tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE type type tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE details_nr details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_log CHANGE IP IP varchar(39) DEFAULT '' NOT NULL;
	Current value: varchar(39) DEFAULT '' NOT NULL
	ALTER TABLE sys_log CHANGE event_pid event_pid int(11) DEFAULT '-1' NOT NULL;
	Current value: int(11) DEFAULT '-1' NOT NULL
	ALTER TABLE sys_log CHANGE NEWid NEWid varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE sys_language CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_language CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_language CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_language CHANGE hidden hidden tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_language CHANGE title title varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE sys_language CHANGE flag flag varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE sys_language CHANGE static_lang_isocode static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pages CHANGE id id int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE cache_pages CHANGE hash hash varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE cache_pages CHANGE page_id page_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pages CHANGE reg1 reg1 int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pages CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pages CHANGE expires expires int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pagesection CHANGE page_id page_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pagesection CHANGE mpvar_hash mpvar_hash int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_pagesection CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE cache_typo3temp_log CHANGE md5hash md5hash varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE cache_typo3temp_log CHANGE tstamp tstamp int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE cache_md5params CHANGE md5hash md5hash varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE cache_md5params CHANGE tstamp tstamp int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE cache_md5params CHANGE type type tinyint(3) DEFAULT '0' NOT NULL;
	Current value: tinyint(3) DEFAULT '0' NOT NULL
	ALTER TABLE fe_groups CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE fe_groups CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_groups CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_groups CHANGE title title varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE fe_groups CHANGE hidden hidden tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_groups CHANGE lockToDomain lockToDomain varchar(50) DEFAULT '' NOT NULL;
	Current value: varchar(50) DEFAULT '' NOT NULL
	ALTER TABLE fe_groups CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_session_data CHANGE hash hash varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE fe_session_data CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_sessions CHANGE ses_id ses_id varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE fe_sessions CHANGE ses_name ses_name varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE fe_sessions CHANGE ses_iplock ses_iplock varchar(15) DEFAULT '' NOT NULL;
	Current value: varchar(15) DEFAULT '' NOT NULL
	ALTER TABLE fe_sessions CHANGE ses_hashlock ses_hashlock int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE fe_sessions CHANGE ses_userid ses_userid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_sessions CHANGE ses_tstamp ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE fe_users CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE username username varchar(50) DEFAULT '' NOT NULL;
	Current value: varchar(50) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE password password varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE disable disable tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE starttime starttime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE endtime endtime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE name name varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE telephone telephone varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE fax fax varchar(20) DEFAULT '' NOT NULL;
	Current value: varchar(20) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE email email varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE lockToDomain lockToDomain varchar(50) DEFAULT '' NOT NULL;
	Current value: varchar(50) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE title title varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE zip zip varchar(10) DEFAULT '' NOT NULL;
	Current value: varchar(10) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE city city varchar(50) DEFAULT '' NOT NULL;
	Current value: varchar(50) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE country country varchar(40) DEFAULT '' NOT NULL;
	Current value: varchar(40) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE www www varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE company company varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE fe_users CHANGE module_sys_dmail_category module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE module_sys_dmail_html module_sys_dmail_html tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE fe_cruser_id fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE lastlogin lastlogin int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE fe_users CHANGE is_online is_online int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE uid uid int(11) DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE pages_language_overlay CHANGE pid pid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE t3ver_oid t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE t3ver_id t3ver_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE t3ver_label t3ver_label varchar(30) DEFAULT '' NOT NULL;
	Current value: varchar(30) DEFAULT '' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE sys_language_uid sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE hidden hidden tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE starttime starttime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE endtime endtime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE author_email author_email varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE pages_language_overlay CHANGE tx_impexp_origuid tx_impexp_origuid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE static_template CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE static_template CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE static_template CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE static_template CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_domain CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_domain CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_domain CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_domain CHANGE hidden hidden tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_domain CHANGE domainName domainName varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE sys_domain CHANGE redirectTo redirectTo varchar(120) DEFAULT '' NOT NULL;
	Current value: varchar(120) DEFAULT '' NOT NULL
	ALTER TABLE sys_domain CHANGE sorting sorting int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_domain CHANGE prepend_params prepend_params int(10) DEFAULT '0' NOT NULL;
	Current value: int(10) DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE uid uid int(11) DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_template CHANGE pid pid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE t3ver_oid t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE t3ver_id t3ver_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE t3ver_label t3ver_label varchar(30) DEFAULT '' NOT NULL;
	Current value: varchar(30) DEFAULT '' NOT NULL
	ALTER TABLE sys_template CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE sorting sorting int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE hidden hidden tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE starttime starttime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE endtime endtime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE root root tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE clear clear tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE nextLevel nextLevel varchar(5) DEFAULT '' NOT NULL;
	Current value: varchar(5) DEFAULT '' NOT NULL
	ALTER TABLE sys_template CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE includeStaticAfterBasedOn includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE static_file_mode static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_template CHANGE tx_impexp_origuid tx_impexp_origuid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE uid uid int(11) DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE tt_content CHANGE pid pid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE t3ver_oid t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE t3ver_id t3ver_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE t3ver_label t3ver_label varchar(30) DEFAULT '' NOT NULL;
	Current value: varchar(30) DEFAULT '' NOT NULL
	ALTER TABLE tt_content CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE hidden hidden tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE sorting sorting int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE CType CType varchar(30) DEFAULT '' NOT NULL;
	Current value: varchar(30) DEFAULT '' NOT NULL
	ALTER TABLE tt_content CHANGE header_position header_position varchar(6) DEFAULT '' NOT NULL;
	Current value: varchar(6) DEFAULT '' NOT NULL
	ALTER TABLE tt_content CHANGE imagewidth imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL;
	Current value: mediumint(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE imageorient imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE imagecols imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE imageborder imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE layout layout tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE deleted deleted tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE cols cols tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE starttime starttime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE endtime endtime int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE colPos colPos tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE spaceBefore spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE spaceAfter spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(4) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE fe_group fe_group int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE imagecaption_position imagecaption_position varchar(6) DEFAULT '' NOT NULL;
	Current value: varchar(6) DEFAULT '' NOT NULL
	ALTER TABLE tt_content CHANGE image_zoom image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE image_noRows image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE image_effects image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE image_compression image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE header_layout header_layout varchar(30) DEFAULT '0' NOT NULL;
	Current value: varchar(30) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE text_align text_align varchar(6) DEFAULT '' NOT NULL;
	Current value: varchar(6) DEFAULT '' NOT NULL
	ALTER TABLE tt_content CHANGE text_face text_face tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE text_size text_size tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE text_color text_color tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE text_properties text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE menu_type menu_type varchar(30) DEFAULT '0' NOT NULL;
	Current value: varchar(30) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE list_type list_type varchar(36) DEFAULT '0' NOT NULL;
	Current value: varchar(36) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE table_border table_border tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE table_cellspacing table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE table_cellpadding table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE table_bgColor table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE select_key select_key varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE tt_content CHANGE sectionIndex sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE linkToTop linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE filelink_size filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE section_frame section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE date date int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE splash_layout splash_layout varchar(30) DEFAULT '0' NOT NULL;
	Current value: varchar(30) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE image_frames image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE recursive recursive tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE imageheight imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL;
	Current value: mediumint(8) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE module_sys_dmail_category module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL;
	Current value: int(10) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE rte_enabled rte_enabled tinyint(4) DEFAULT '0' NOT NULL;
	Current value: tinyint(4) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE sys_language_uid sys_language_uid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE tx_impexp_origuid tx_impexp_origuid int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE tt_content CHANGE l18n_parent l18n_parent int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE static_tsconfig_help CHANGE uid uid int(11) DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE static_tsconfig_help CHANGE guide guide int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL
	ALTER TABLE static_tsconfig_help CHANGE md5hash md5hash varchar(32) DEFAULT '' NOT NULL;
	Current value: varchar(32) DEFAULT '' NOT NULL
	ALTER TABLE sys_note CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_note CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_note CHANGE deleted deleted tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_note CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_note CHANGE crdate crdate int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_note CHANGE cruser cruser int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_note CHANGE author author varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE sys_note CHANGE email email varchar(80) DEFAULT '' NOT NULL;
	Current value: varchar(80) DEFAULT '' NOT NULL
	ALTER TABLE sys_note CHANGE personal personal tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_note CHANGE category category tinyint(3) unsigned DEFAULT '0' NOT NULL;
	Current value: tinyint(3) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_notepad CHANGE uid uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL auto_increment
	ALTER TABLE sys_notepad CHANGE pid pid int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_notepad CHANGE tstamp tstamp int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_notepad CHANGE cruser_id cruser_id int(11) unsigned DEFAULT '0' NOT NULL;
	Current value: int(11) unsigned DEFAULT '0' NOT NULL
	ALTER TABLE sys_notepad CHANGE crdate crdate int(11) DEFAULT '0' NOT NULL;
	Current value: int(11) DEFAULT '0' NOT NULL

Wenn Du die Änderungen dann auf Write to Database klickst, wirst Du danach selbige Datenbankabwichung wieder sehen, was für mich heisst, dass die Änderungen an den Datenbanken nicht ausgeführt werden, warum auch immer.

tommic · 4. Februar 2005 14:42

Moinsen alle zusammen.

Ich hab auch das Problem gehabt. Deshalb bin ich auch auf euer Topic gestossen.
Ich habe mir mal die Stelle im Typo Object Browser genauer angeschaut wo die Config steht zum anzeigen einer Sitemap, die ich in meinem Fall gebrucht habe und auch ein Menüpunkt nicht angezeigt wurde.

Im Typo Object Browser steht drinne das die Abfrage an die Datenbank mit der WHERE Bedingung : sectionIndex!=0 gebunden ist.

tt_content.menu.20.3.select.andWhere = sectionIndex!=0

also hab ich mir mal den phpMyAdmin geöffnet und mir den DB Eintrag angeschaut und siehe da ... die Punkte die nicht angezeigt werden konnten hatten den eintrag "0". Warum da eine "0" steht weiss ich auch nicht (noch nicht).

Aber ich hab die 0 mal flux in eine 1 gezaubert und dann wurde alles angezeigt.

Ich hoffe ich konnte euch helfen.