Einfaches Modul funktioniert nicht

[TWA_DarkSun]

Ich habe mich nun etwas mit Typolight befasst und möchte gern ein Modul für meine Zwecke programmieren.
Das Eventmodul zu Erweitern hielt ich für sinnvoll, und dank dem Tutorial von manela konnt ich mir ein Modul zusammenbasteln.
Nach der Installation (Datenbankupdate, etc.) kann ich nun die Eventbearbeitung nicht mehr öffnen (siehe zip-Datei)
Vielleicht kann mir jemand helfen.

dca/tl_calender_events.php

<?php if (!defined('TL_ROOT')) die('You can not access this file directly!');

//Modify palette
$GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = str_replace('{title_legend}','clan','clantag','clanwebsite','clanmember','clanwartime','xonx','squad','twamember','maps','ticketsopponent','ticketsopponent','score', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default']);

//Add field
$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clan'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clan'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clantag'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clantag'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanwebsite'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanwebsite'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanmember'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanmember'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanwartime'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanwartime'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['xonx'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['xonx'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['squad'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['squad'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['twamember'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['twamember'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['maps'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['maps'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['ticketsopponent'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['ticketsopponent'],
    'inputType'               => 'text'
)

$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['ticketstwa'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['ticketstwa'],
    'inputType'               => 'text'
)
$GLOBALS['TL_DCA']['tl_calendar_events']['fields']['score'] = array
(
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['score'],
    'inputType'               => 'select',
    'options'                 => array ('','win','lose','draw')
    'reference'               => &$GLOBALS['TL_LANG']['tl_calendar_events'],
)
?>

database.sql

-- 
--  Table `tl_calendar_events`
-- 

CREATE TABLE `tl_calendar_events` (
`clan` varchar(250) NOT NULL default '',
`clantag` varchar(50) NOT NULL default '',
`clanwebsite` varchar(450) NOT NULL default '',
`clanmember` varchar(250) NOT NULL default '',
`clanwartime` varchar(250) NOT NULL default '',
`xonx` varchar(250) NOT NULL default '',
`squad` varchar(250) NOT NULL default '',
`twamember` varchar(250) NOT NULL default '',
`maps` varchar(250) NOT NULL default '',
`ticketsopponent` varchar(250) NOT NULL default '',
`ticketstwa` varchar(250) NOT NULL default '',
`score` varchar(100) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[andreas.schempp]

Kommt denn eine Fehlermeldung wenn du die Erweiterungsverwaltung öffnest?

[TWA_DarkSun]

nein leider nicht
nur ein weißer Bildschirm.. der Bearbeitungsmodus ist nicht möglich

EDIT: jedoch ist mir aufgefallen, dass ich über das Install-Tool keinen Tabelleneintrag für "score" erstellen kann.. ich denk da sollte ich int statt varchar benutzen, jedoch besteht das Problem weitherhin

[Toflar]

Interessante Parameter bei str_replace()

[TWA_DarkSun]

$GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = str_replace('{title_legend}','clan','clantag','clanwebsite','clanmember','clanwartime','xonx','squad','twamember','maps','ticketsopponent','ticketsopponent','score', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default']); 

in

$GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = str_replace('{title_legend},','{title_legend},clan,clantag,clanwebsite,clanmember,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketsopponent,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default']); 

eventuell fehlt die Zuordnung (ich möchte diesen Bereich unter "details", also Event-Text hinzufügen:

$GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = str_replace('details,','details;{title_legend},clan,clantag,clanwebsite,clanmember,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketsopponent,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default']); 

ich hoffe es ist so richtig..

[andreas.schempp]

Da haben die anderen richtig erkannt.

1. Im str_replace() solltest du den zu suchenden Wert auch wieder setzen
2. Die tl_calendar_events verwendet keine Palette "default", sondern andere. Schau dir die Vorlage an.

[BugBuster]

EDIT: jedoch ist mir aufgefallen, dass ich über das Install-Tool keinen Tabelleneintrag für "score" erstellen kann.. ich denk da sollte ich int statt varchar benutzen, jedoch besteht das Problem weitherhin

Ich denke hier hilft es schon das Wort DEFAULT klein zu schreiben wie bei den anderen Zeilen.

`score` varchar(100) NOT NULL default '',

[TWA_DarkSun]

ich habe die Ratschläge zu Herzen genommen und folgendes entworfen

<?php if (!defined('TL_ROOT')) die('You can not access this file directly!');

  //Anzeige im Backend
  $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = str_replace('{text_legend},','{text_legend},clanname,clantag,clanmember,clanwebsite,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketstwa,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default']);
  $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['internal'] = str_replace('{text_legend},','{text_legend},clanname,clantag,clanmember,clanwebsite,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketstwa,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['internal']);
  $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['external'] = str_replace('{text_legend},','{text_legend},clanname,clantag,clanmember,clanwebsite,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketstwa,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['external']);

  //Beschreibung des Feldes clanname
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanname'] = array
  (
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanname'],
    'inputType'               => 'text'
    'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes clantag
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clantag'] = array
  (
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clantag'],
    'inputType'               => 'text'
    'eval'                    => array('maxlength'=>15)
  );
  //Beschreibung des Feldes clanmember
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanmember'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanmember'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes clanwebsite
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanwebsite'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanwebsite'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255, 'rgxp'=>'url')
  );
  //Beschreibung des Feldes clanwartime
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanwartime'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanwartime'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('rpxp'=>'time', 'maxlength'=>255)
  );
  //Beschreibung des Feldes xonx
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['xonx'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['xonx'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>100)
  );
  //Beschreibung des Feldes squad
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['squad'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['squad'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes twamember
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['twamember'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['twamember'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes maps
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['maps'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['maps'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes ticketsopponent
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['ticketsopponent'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['ticketsopponent'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255, 'rgxp'=>'digit')
  );
  //Beschreibung des Feldes ticketstwa
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['ticketstwa'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['ticketstwa'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255, 'rgxp'=>'digit')
  );
  //Beschreibung des Feldes score
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['score'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['score'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
                'options'                 => array('win', 'lose', 'draw'),
        'eval'                    => array('includeBlankOption'=>'false')
  );
?>

Gleichzeitig habe ich die database so wie BugBuster beschrieben verändert (dankeschön), sodass nun alle Tabellen eingefügt wurden.

--
--  Table `tl_calendar_events`
--

CREATE TABLE `tl_calendar_events` (
  `clanname` varchar(255) NOT NULL default '',
  `clantag` varchar(15) NOT NULL default '',
  `clanmember` varchar(255) NOT NULL default '',
  `clanwebsite` varchar(255) NOT NULL default '',
  `clanwartime` varchar(255) NOT NULL default '',
  `xonx` varchar(100) NOT NULL default '',
  `squad` varchar(255) NOT NULL default '',
  `twamember` varchar(255) NOT NULL default '',
  `maps` varchar(255) NOT NULL default '',
  `ticketsopponent` varchar(255) NOT NULL default '',
  `ticketstwa` varchar(255) NOT NULL default '',
  `score` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

EDIT: typolight/main.php?do=calendar&table=tl_calendar_events&id=X zeigt weiterhin weißen Hintergrund (keine Fehlermeldung)

[BugBuster]

Hmm, id=X, du hast doch kein Feld id in deiner Tabelle?
Eigentlich üblich sind folgende 4 Felder die in fast jeder Tabelle "zu Hause" sind:

  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `sorting` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',

Die Felder werden normalerweise von TL selbst gefüllt.
Und wenn wir schon mal dabei sind, am Ende:

  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)

In Summe also:

--
--  Table `tl_calendar_events`
--

CREATE TABLE `tl_calendar_events` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `sorting` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0', 
  `clanname` varchar(255) NOT NULL default '',
  `clantag` varchar(15) NOT NULL default '',
  `clanmember` varchar(255) NOT NULL default '',
  `clanwebsite` varchar(255) NOT NULL default '',
  `clanwartime` varchar(255) NOT NULL default '',
  `xonx` varchar(100) NOT NULL default '',
  `squad` varchar(255) NOT NULL default '',
  `twamember` varchar(255) NOT NULL default '',
  `maps` varchar(255) NOT NULL default '',
  `ticketsopponent` varchar(255) NOT NULL default '',
  `ticketstwa` varchar(255) NOT NULL default '',
  `score` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

[andreas.schempp]

Hmm, id=X, du hast doch kein Feld id in deiner Tabelle?
Eigentlich üblich sind folgende 4 Felder die in fast jeder Tabelle "zu Hause" sind:

  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `sorting` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',

Die Felder werden normalerweise von TL selbst gefüllt.
Und wenn wir schon mal dabei sind, am Ende:

  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)

In Summe also:

--
--  Table `tl_calendar_events`
--

CREATE TABLE `tl_calendar_events` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `sorting` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0', 
  `clanname` varchar(255) NOT NULL default '',
  `clantag` varchar(15) NOT NULL default '',
  `clanmember` varchar(255) NOT NULL default '',
  `clanwebsite` varchar(255) NOT NULL default '',
  `clanwartime` varchar(255) NOT NULL default '',
  `xonx` varchar(100) NOT NULL default '',
  `squad` varchar(255) NOT NULL default '',
  `twamember` varchar(255) NOT NULL default '',
  `maps` varchar(255) NOT NULL default '',
  `ticketsopponent` varchar(255) NOT NULL default '',
  `ticketstwa` varchar(255) NOT NULL default '',
  `score` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Sorry, aber da war das Original schon korrekt. Die id-pid usw.-Felder sind bereits in der tl_calendar_events Tabelle vorhanden, die sollten hier nicht nochmals aufgeführt werden.

[BugBuster]

achso, das hatte ich jetzt garnicht geschnallt, ich dachte es wäre ne neue Tabelle,
ok, dann vergesst es ganz schnell.

[BugBuster]

hast du mal die Fehleranzeige eingeschaltet? Sicherlich, aber ich dachte ich frag mal lieber.

[TWA_DarkSun]

ohjee, du hast mich gerettet BugBuster..
ich dachte ich hätte es aktiviert, da es aber eine Fehlermeldung wegen dem Quickpoll ausgab hab ich es vorrübergehend deaktviert.
Es handelte sich um einen Syntaxfehler in der dca, es fehlte ein Komma in Zeile 12 (nach dem 'text')

<?php if (!defined('TL_ROOT')) die('You can not access this file directly!');

  //Anzeige im Backend
  $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default'] = str_replace('{text_legend},','{text_legend},clanname,clantag,clanmember,clanwebsite,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketstwa,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['default']);
  $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['internal'] = str_replace('{text_legend},','{text_legend},clanname,clantag,clanmember,clanwebsite,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketstwa,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['internal']);
  $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['external'] = str_replace('{text_legend},','{text_legend},clanname,clantag,clanmember,clanwebsite,clanwartime,xonx,squad,twamember,maps,ticketsopponent,ticketstwa,score,', $GLOBALS['TL_DCA']['tl_calendar_events']['palettes']['external']);

  //Beschreibung des Feldes clanname
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanname'] = array
  (
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanname'],
    'inputType'               => 'text',
    'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes clantag
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clantag'] = array
  (
    'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clantag'],
    'inputType'               => 'text',
    'eval'                    => array('maxlength'=>15)
  );
  //Beschreibung des Feldes clanmember
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanmember'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanmember'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes clanwebsite
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanwebsite'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanwebsite'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255, 'rgxp'=>'url')
  );
  //Beschreibung des Feldes clanwartime
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['clanwartime'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['clanwartime'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('rpxp'=>'time', 'maxlength'=>255)
  );
  //Beschreibung des Feldes xonx
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['xonx'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['xonx'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>100)
  );
  //Beschreibung des Feldes squad
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['squad'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['squad'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes twamember
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['twamember'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['twamember'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes maps
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['maps'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['maps'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255)
  );
  //Beschreibung des Feldes ticketsopponent
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['ticketsopponent'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['ticketsopponent'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255, 'rgxp'=>'digit')
  );
  //Beschreibung des Feldes ticketstwa
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['ticketstwa'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['ticketstwa'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'text',
        'eval'                    => array('maxlength'=>255, 'rgxp'=>'digit')
  );
  //Beschreibung des Feldes score
  $GLOBALS['TL_DCA']['tl_calendar_events']['fields']['score'] = array
  (
        'label'                   => &$GLOBALS['TL_LANG']['tl_calendar_events']['score'],
        'exclude'                 => true,
        'search'                  => true,
        'inputType'               => 'select',
        'options'                 => array('win', 'lose', 'draw'),
        'eval'                    => array('maxlength'=>255)
  );
?>

ich danke euch vielmals, ihr habt mir wirklich geholfen!