[TYPO3-commerce] SQL error when editing

[Morten Olesen]

replying to my self here since I forgot to include that the problem 
dates back to 03/11/2008 (atleast) see
"[TYPO3-commerce] SQL error: 'Unknown column 'sum_price_gross' in	'field 
list''" by John Kavanagh in this list


Morten Olesen wrote:
> Hello Ingo,
> 
> Typo3 4.2.1
> Commerce ( svn r12207 )
> 
> Running of course a host other plugin's but even after disabling any 
> that has to do with commerce and clearing cache i still get the problem. 
> The complete list of modules follows (after disabling all commerce 
> related modules );
> 
> dynaflex    1.11.0
> rtehtmlarea    1.7.5
> version    1.2.0
> commerce    0.9.6
> direct_mail    2.6.0
> phpmyadmin    0.2.1
> wizard_crpagetree    1.0.0
> css_styled_content    0.4.0
> tt_address    2.2.1
> automaketemplate    0.1.0
> devlog    2.4.0
> graytree    0.2.1
> moneylib    1.2.1
> static_info_tables    2.0.10
> t3skin    4.2.0
> 
> 
> 
> /Morten Olesen
> 
> Ingo Schmitt wrote:
>> Hi Morten,
>>
>> could you give me please a list of extensions, t3core version, so I 
>> can check this.
>>
>>
>> Bets regards
>>
>> Ingo
>>> Hello group,
>>>
>>> When editing an order article in the backend I get the error
>>>
>>> "2: SQL error: 'Unknown column 'sum_price_gross' in 'field list'' 
>>> (tx_commerce_order_articles:###)"
>>>
>>> where ### is the order_article uid.
>>>
>>> After going over the code with fine comb so to speak I'm unable to 
>>> locate anywhere where the TCA's field list includes that or is 
>>> modified to include it.
>>>
>>> Being determined to figure it out I added the field to the table 
>>> which made it complain about sum_price_net - adding this field also 
>>> means that the orders total sum and net are now written on 
>>> order_articles, where it clearly does not belong - so the questions 
>>> are these:
>>>
>>> Where does this poisoning of the field list occur?
>>> How does it even get the data ( the total sums I mean )?
>>>
>>> /Morten Olesen
>>
>>
>>
>> Mit freundlichen Gruessen