hi,
ich habe eine extension geschrieben in der ich hauptsächlich mit dem TCA arbeite.
Nun habe ich die Datenbank Tabellen umbenannt.
Habe dies natürlich in meinen Scripten ebenfalls angepasst. Aber der TCA macht mir jetzt bei einem Feld Probleme.
Der Witz ist bei Stud geht es aber bei mod nicht mehr. Jemand eine Idee?
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM tx_hfuspo_Mod, pages WHERE pages.uid=tx_hfuspo_Mod.pid
AND page' at line 1
This may indicate a table defined in tables.php is not existing in the database!
$TCA['tx_hfuspo_Fa'] = array (
'ctrl' => $TCA['tx_hfuspo_Fa']['ctrl'],
'interface' => array (
'showRecordFieldList' => 'sys_language_uid,l10n_parent,l10n_diffsource,hidden,name,stud,se,mod,ec,sw,be'
),
'feInterface' => $TCA['tx_hfuspo_Fa']['feInterface'],
'columns' => array (
't3ver_label' => array (
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.versionLabel',
'config' => array (
'type' => 'input',
'size' => '30',
'max' => '30',
)
),
'sys_language_uid' => array (
'exclude' => 1,
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.language',
'config' => array (
'type' => 'select',
'foreign_table' => 'sys_language',
'foreign_table_where' => 'ORDER BY sys_language.title',
'items' => array(
array('LLL:EXT:lang/locallang_general.xml:LGL.allLanguages', -1),
array('LLL:EXT:lang/locallang_general.xml:LGL.default_value', 0)
)
)
),
'l10n_parent' => array (
'displayCond' => 'FIELD:sys_language_uid:>:0',
'exclude' => 1,
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.l18n_parent',
'config' => array (
'type' => 'select',
'items' => array (
array('', 0),
),
'foreign_table' => 'tx_hfuspo_Fa',
'foreign_table_where' => 'AND tx_hfuspo_Fa.pid=###CURRENT_PID### AND tx_hfuspo_Fa.sys_language_uid IN (-1,0)',
)
),
'l10n_diffsource' => array (
'config' => array (
'type' => 'passthrough'
)
),
'hidden' => array (
'exclude' => 1,
'label' => 'LLL:EXT:lang/locallang_general.xml:LGL.hidden',
'config' => array (
'type' => 'check',
'default' => '0'
)
),
'name' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.name',
'config' => array (
'type' => 'input',
'size' => '30',
'max' => '255',
'eval' => 'required',
)
),
'stud' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.stud',
'config' => array (
'type' => 'select',
'foreign_table' => 'tx_hfuspo_Stud',
'foreign_table_where' => 'ORDER BY tx_hfuspo_Stud.uid',
'size' => 1,
'minitems' => 0,
'maxitems' => 1,
"MM" => "tx_hfuspo_Fa_stud_mm",
'wizards' => array(
'_PADDING' => 2,
'_VERTICAL' => 1,
'add' => array(
'type' => 'script',
'title' => 'Create new record',
'icon' => 'add.gif',
'params' => array(
'table' => 'pages',
'pid' => '###CURRENT_PID###',
'setValue' => 'prepend'
),
'script' => 'wizard_add.php',
),
'list' => array(
'type' => 'script',
'title' => 'List',
'icon' => 'list.gif',
'params' => array(
'table' => 'pages',
'pid' => '###CURRENT_PID###',
),
'script' => 'wizard_list.php',
),
'edit' => array(
'type' => 'popup',
'title' => 'Edit',
'script' => 'wizard_edit.php',
'popup_onlyOpenIfSelected' => 1,
'icon' => 'edit2.gif',
'JSopenParams' => 'height=350,width=580,status=0,menubar=0,scrollbars=1',
),
),
)
),
'se' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se',
'config' => array (
'type' => 'select',
'items' => array (
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.0', '1'),
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.1', '2'),
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.2', '3'),
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.3', '4'),
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.4', '5'),
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.5', '6'),
array('LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.se.I.6', '7'),
),
'size' => 1,
'maxitems' => 1,
)
),
'mod' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.mod',
'config' => array (
'type' => 'select',
'items' => array (
array('',0),
),
'foreign_table' => 'tx_hfuspo_Mod',
'foreign_table_where' => 'ORDER BY tx_hfuspo_Mod.uid',
'size' => 1,
'minitems' => 0,
'maxitems' => 1,
"MM" => "tx_hfuspo_Fa_mod_mm",
'wizards' => array(
'_PADDING' => 2,
'_VERTICAL' => 1,
'add' => array(
'type' => 'script',
'title' => 'Create new record',
'icon' => 'add.gif',
'params' => array(
'table' => 'tx_hfuspo_Mod',
'pid' => '###CURRENT_PID###',
'setValue' => 'prepend'
),
'script' => 'wizard_add.php',
),
'list' => array(
'type' => 'script',
'title' => 'List',
'icon' => 'list.gif',
'params' => array(
'table' => 'tx_hfuspo_Mod',
'pid' => '###CURRENT_PID###',
),
'script' => 'wizard_list.php',
),
'edit' => array(
'type' => 'popup',
'title' => 'Edit',
'script' => 'wizard_edit.php',
'popup_onlyOpenIfSelected' => 1,
'icon' => 'edit2.gif',
'JSopenParams' => 'height=350,width=580,status=0,menubar=0,scrollbars=1',
),
),
)
),
'ects' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.ec',
'config' => array (
'type' => 'input',
'size' => '4',
'max' => '4',
'eval' => 'int',
'checkbox' => '0',
'range' => array (
'upper' => '1000',
'lower' => '1'
),
'default' => 0
)
),
'sw' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.sw',
'config' => array (
'type' => 'input',
'size' => '4',
'max' => '4',
'eval' => 'int',
'checkbox' => '0',
'range' => array (
'upper' => '1000',
'lower' => '1'
),
'default' => 0
)
),
'be' => array (
'exclude' => 0,
'label' => 'LLL:EXT:hfu_spo/locallang_db.xml:tx_hfuspo_Fa.be',
'config' => array (
'type' => 'text',
'cols' => '30',
'rows' => '5',
'wizards' => array(
'_PADDING' => 2,
'RTE' => array(
'notNewRecords' => 1,
'RTEonly' => 1,
'type' => 'script',
'title' => 'Full screen Rich Text Editing|Formatteret redigering i hele vinduet',
'icon' => 'wizard_rte2.gif',
'script' => 'wizard_rte.php',
),
),
)
),
),
'types' => array (
'0' => array('showitem' => 'sys_language_uid;;;;1-1-1, l10n_parent, l10n_diffsource, hidden;;1, name, stud, se, mod, ec, sw, be;;;richtext[]:rte_transform[mode=ts]')
),
'palettes' => array (
'1' => array('showitem' => '')
)
);