[TYPO3-commerce] SQL error when editing

[Morten Olesen]

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