[TYPO3-german] kann keine neuen Datensätze anlegen - sys_language_uid nicht übergeben
Silke Capo
s.capo at digital-worx.de
Mon Feb 15 12:19:15 CET 2016
Hallo,
habe schon gegoogelt, aber leider keine Lösung gefunden. Wenn ich einen
neuen Inhalt/Datensatz anlegen möchte, bekomme ich folgende Fehlermeldung:
2: SQL error: 'Incorrect integer value: '' for column 'sys_language_uid'
at row 1'
Die Sprachen sind definiert:
config {
// Language Settings
uniqueLinkVars = 1
linkVars = L(0-5)
sys_language_uid = 0
sys_language_overlay = 1
//sys_language_mode = content_fallback ; 1,0
sys_language_mode = hideNonTranslated
language = de
locale_all = de_DE.UTF-8
htmlTag_langKey = de
}
Es gibt daneben noch Englisch:
#multilanguage setup
[globalVar = GP:L = 1]
config {
sys_language_uid = 1
language = en
locale_all = en_EN
htmlTag_langKey = en
}
[global]
Im Object Browser wird config.sys_language_uid = 0 angezeigt. Aber die
uid 0 wird nicht übergeben.
Hier die komplette Fehlermeldung:
exec_INSERTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
ERROR Incorrect integer value: '' for column 'sys_language_uid' at row 1
lastBuiltQuery INSERT INTO tt_content
(CType,starttime,endtime,layout,colPos,date,header_position,header_layout,imagewidth,imageheight,imageorient,imagecols,imagecaption_position,cols,recursive,menu_type,list_type,table_bgColor,table_border,table_cellspacing,table_cellpadding,target,spaceBefore,spaceAfter,section_frame,sectionIndex,accessibility_title,accessibility_bypass_text,sorting,pid,sys_language_uid,header,header_link,subheader,hidden,linkToTop,fe_group,categories,l18n_diffsource,crdate,cruser_id,tstamp,t3ver_stage)
VALUES
('header','0','0','0','0','0','','0','0','0','0','2','','0','0','0','','0','0','0','0','','0','0','0','1','','','256','958','','','','','0','0','','0','a:20:{s:5:\"CType\";N;s:6:\"colPos\";N;s:16:\"sys_language_uid\";N;s:6:\"header\";N;s:13:\"header_layout\";N;s:15:\"header_position\";N;s:4:\"date\";N;s:11:\"header_link\";N;s:9:\"subheader\";N;s:6:\"layout\";N;s:11:\"spaceBefore\";N;s:10:\"spaceAfter\";N;s:13:\"section_frame\";N;s:6:\"hidden\";N;s:12:\"sectionIndex\";N;s:9:\"linkToTop\";N;s:9:\"starttime\";N;s:7:\"endtime\";N;s:8:\"fe_group\";N;s:10:\"categories\";N;}','1455532965','12','1455532965','0')
debug_backtrace
TYPO3\CMS\Backend\Controller\EditDocumentController->processData#35 //
TYPO3\CMS\Core\DataHandling\DataHandler->process_datamap#512 //
TYPO3\CMS\Core\DataHandling\DataHandler->insertDB#1255 //
TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#6156 //
TYPO3\CMS\Core\Database\DatabaseConnection->debug#218
Will ich einen englischen Datensatz anlegen, bekomme ich eine andere
Fehlermeldung:
exec_INSERTquery
caller TYPO3\CMS\Core\Database\DatabaseConnection::exec_INSERTquery
ERROR Incorrect integer value: '' for column 'l18n_parent' at row 1
lastBuiltQuery INSERT INTO tt_content
(CType,starttime,endtime,layout,colPos,date,header_position,header_layout,imagewidth,imageheight,imageorient,imagecols,imagecaption_position,cols,recursive,menu_type,list_type,table_bgColor,table_border,table_cellspacing,table_cellpadding,target,spaceBefore,spaceAfter,section_frame,sectionIndex,accessibility_title,accessibility_bypass_text,sorting,pid,sys_language_uid,l18n_parent,header,header_link,pi_flexform,hidden,linkToTop,fe_group,pages,categories,l18n_diffsource,crdate,cruser_id,tstamp,t3ver_stage)
VALUES
('list','0','0','0','0','0','','0','0','0','0','2','','0','0','0','ke_search_pi1','0','0','0','0','','0','0','0','1','','','256','958','1','','s','','<?xml
version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\"
?>\n<T3FlexForms>\n <data>\n <sheet index=\"MAIN\">\n <language
index=\"lDEF\">\n <field index=\"resultPage\">\n <value
index=\"vDEF\"></value>\n </field>\n <field index=\"renderMethod\">\n
<value index=\"vDEF\">fluidtemplate</value>\n </field>\n <field
index=\"templateFile\">\n <value
index=\"vDEF\">EXT:ke_search/res/template_pi1.tpl</value>\n </field>\n
<field index=\"cssFile\">\n <value
index=\"vDEF\">EXT:ke_search/res/ke_search_pi1.css</value>\n </field>\n
<field index=\"resultLinkTarget\">\n <value
index=\"vDEF\">_self</value>\n </field>\n <field
index=\"resultLinkTargetFiles\">\n <value
index=\"vDEF\">_blank</value>\n </field>\n <field
index=\"resultChars\">\n <value index=\"vDEF\">200</value>\n </field>\n
<field index=\"resultsNumeration\">\n <value index=\"vDEF\">1</value>\n
</field>\n <field index=\"showTextInsteadOfResults\">\n <value
index=\"vDEF\">0</value>\n </field>\n <field
index=\"showNoResultsText\">\n <value index=\"vDEF\">0</value>\n
</field>\n <field index=\"highlightSword\">\n <value
index=\"vDEF\">1</value>\n </field>\n <field index=\"previewMode\">\n
<value index=\"vDEF\">hit</value>\n </field>\n <field
index=\"resultsPerPage\">\n <value index=\"vDEF\">10</value>\n
</field>\n <field index=\"countSearchPhrases\">\n <value
index=\"vDEF\">1</value>\n </field>\n </language>\n </sheet>\n <sheet
index=\"sorting\">\n <language index=\"lDEF\">\n <field
index=\"sortWithoutSearchword\">\n <value index=\"vDEF\">sortdate
desc</value>\n </field>\n <field index=\"showSortInFrontend\">\n <value
index=\"vDEF\">0</value>\n </field>\n <field index=\"sortByAdmin\">\n
<value index=\"vDEF\">score desc</value>\n </field>\n </language>\n
</sheet>\n <sheet index=\"view\">\n <language index=\"lDEF\">\n <field
index=\"pagebrowserOnTop\">\n <value index=\"vDEF\">0</value>\n
</field>\n <field index=\"pagebrowserAtBottom\">\n <value
index=\"vDEF\">1</value>\n </field>\n <field
index=\"maxPagesInPagebrowser\">\n <value index=\"vDEF\">10</value>\n
</field>\n <field index=\"showQueryTime\">\n <value
index=\"vDEF\">0</value>\n </field>\n <field
index=\"showFilePreview\">\n <value index=\"vDEF\">1</value>\n
</field>\n <field index=\"showPageImages\">\n <value
index=\"vDEF\">1</value>\n </field>\n <field index=\"showNewsImages\">\n
<value index=\"vDEF\">1</value>\n </field>\n <field
index=\"showTypeIcon\">\n <value index=\"vDEF\">1</value>\n </field>\n
<field index=\"showResultUrl\">\n <value index=\"vDEF\">0</value>\n
</field>\n <field index=\"renderResultUrlAsLink\">\n <value
index=\"vDEF\">0</value>\n </field>\n <field index=\"showScore\">\n
<value index=\"vDEF\">0</value>\n </field>\n <field
index=\"showDate\">\n <value index=\"vDEF\">0</value>\n </field>\n
<field index=\"showPercentalScore\">\n <value index=\"vDEF\">0</value>\n
</field>\n <field index=\"showScoreScale\">\n <value
index=\"vDEF\">0</value>\n </field>\n </language>\n </sheet>\n <sheet
index=\"filter\">\n <language index=\"lDEF\">\n <field
index=\"filters\">\n <value index=\"vDEF\"></value>\n </field>\n <field
index=\"hiddenfilters\">\n <value index=\"vDEF\"></value>\n </field>\n
<field index=\"preselected_filters\">\n <value index=\"vDEF\"></value>\n
</field>\n <field index=\"checkFilterCondition\">\n <value
index=\"vDEF\">multi</value>\n </field>\n </language>\n </sheet>\n
<sheet index=\"debug\">\n <language index=\"lDEF\">\n <field
index=\"showTags\">\n <value index=\"vDEF\">0</value>\n </field>\n
<field index=\"logQuery\">\n <value index=\"vDEF\">0</value>\n
</field>\n <field index=\"showTaggedContentOnly\">\n <value
index=\"vDEF\">0</value>\n </field>\n </language>\n </sheet>\n
</data>\n</T3FlexForms>','0','0','','','0','a:21:{s:5:\"CType\";N;s:6:\"colPos\";N;s:16:\"sys_language_uid\";N;s:11:\"l18n_parent\";N;s:6:\"header\";N;s:13:\"header_layout\";N;s:15:\"header_position\";N;s:4:\"date\";N;s:11:\"header_link\";N;s:9:\"list_type\";N;s:11:\"pi_flexform\";N;s:11:\"spaceBefore\";N;s:10:\"spaceAfter\";N;s:13:\"section_frame\";N;s:6:\"hidden\";N;s:12:\"sectionIndex\";N;s:9:\"linkToTop\";N;s:8:\"fe_group\";N;s:5:\"pages\";N;s:9:\"recursive\";N;s:10:\"categories\";N;}','1455533477','12','1455533477','0')
debug_backtrace
TYPO3\CMS\Backend\Controller\EditDocumentController->processData#35 //
TYPO3\CMS\Core\DataHandling\DataHandler->process_datamap#512 //
TYPO3\CMS\Core\DataHandling\DataHandler->insertDB#1255 //
TYPO3\CMS\Core\Database\DatabaseConnection->exec_INSERTquery#6156 //
TYPO3\CMS\Core\Database\DatabaseConnection->debug#218
Hier wird die sys_language_uid also übergeben.
Habe versucht, in die Dateien unten zu schauen, werde aber aus dem PHP
nicht schlau; mir ist nicht klar, woher die Werte für die Sprachen kommen.
Zur Info:
TYPO3 ist Version 6.2.16 und läuft auf Suse Linux (Wunsch des Kunden).
Es wurde von einem System auf einem anderen Server kopiert und von
4.5.35 upgedated auf 6.2.16.
Auf dem alten Server funktioniert alles ohne Probleme.
Hat vielleicht jemand eine Idee, was hier schief geht?
Viele Grüße
Silke
More information about the TYPO3-german
mailing list