[TYPO3-templavoila] Odd TV-related sql error

[Christopher Torgalson]

Christopher Torgalson wrote:
> Christopher Torgalson wrote:
>> Hi there,
>>
>> Dmitry Dulepov wrote:
>>> Christopher Torgalson wrote:
>>>> A client reported sql errors in the BE of a site, so I enabled the 
>>>> sql debug setting in the install tool to find out what there were. 
>>>> Here's the result:
>>>
>>> Are you sure that this does not come from another extension? 
>>> tx_templavoila_next_ds exists only in pages and I could not find any 
>>> code in tv that uses this field for tt_content.
>>
>> Not at all sure at the moment, just trying to narrow down the 
>> possibilities.
>>
>> -CT
> 
> 
> More info & cross-posted to .dev. Some of the info below duplicates what 
> was in the original message, but this way it's all in one place:
> 
> 
> 1. Summary:
> 
> -- error messages occurring when content records are saved in the BE
> -- debug shows they're caused by a nonsensical TV-related SQL query.
> 
> 
> 2. The debug output again:
> 
> 
> caller
> ------------------------------------------------------------
> t3lib_DB::exec_SELECTquery
> 
> ERROR
> ------------------------------------------------------------
> Unknown column 'tx_templavoila_next_ds' in 'field list'
> 
> lastBuiltQuery
> ------------------------------------------------------------
> SELECT uid,tx_templavoila_ds,pid,tx_templavoila_next_ds
> FROM tt_content
> WHERE uid=13
> AND tt_content.deleted=0
> 
> debug_backtrace
> ------------------------------------------------------------
> sc_alt_doc->processdata //
> t3lib_tcemain->process_datamap //
> t3lib_tcemain->updatedb //
> t3lib_tcemain->updaterefindex //
> t3lib_refindex->updaterefindextable // 
> t3lib_refindex->generaterefindexdata //
> t3lib_refindex->getrelations //
> t3lib_befunc::getflexformds //
> t3lib_db->exec_selectquery // t3lib_db->debug
> 
> 
> 3. The problem has no obvious connection to any extension (there are two 
> custom extensions on the site, but the problem persists even if they are 
> uninstalled and all caches cleared). Besides the two custom extensions 
> (neither of which has any special relation to TV), the extensions in use 
> on the site are very common ones, principally:
> 
> --TYPO3 4.0.4 + system versions of rtehtmlarea, css_styled_content and 
> indexed_search
> --RealURL 1.1.3
> --TV 1.1.1
> --Static Info Tables 2.0.0
> --macina_searchbox 2.0.0
> 
> 4. The same error (or a variation) also apparently occurs /every time/ 
> the reference index functions are invoked (e.g. when the Reference Index 
> tools in Tools -> DB Check are used).
> 
> 5. The uid referred to in the lastBuiltQuery is the uid of the PAGE 
> record, NOT the content record.
> 
> 6. tx_templavoila_ds and tx_templavoila_next_ds are tables in pages, NOT 
> tt_content
> 
> 7. The errors cease if TV is disabled.
> 
> 
> 
> I'm cross-posting to .dev because it's not completely clear to me that 
> it's TV's /fault/, though it's clearly related.

One other note: aggravatingly, I cannot reproduce the problem on other 
TYPO3 4.0.4 installations.

-CT