[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