[TYPO3-templavoila] Odd TV-related sql error

[Christopher Torgalson]

Christopher Torgalson wrote:
> 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


^$#&^$&*%#%#$#!@&^*(&*)&*%!

Please disregard; the problem seems to have been fixed by removing and 
reinstalling TV...


-CT