[TYPO3-commerce] SQL error when editing

[Ingo Schmitt]

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
-- 
Ingo Schmitt                        mailto:is at marketing-factory.de
Marketing Factory Consulting GmbH   http://typo3.marketing-factory.de/
Content Management mit Typo3: Beratung - Schulung - Realisierung