Fabrik dosen't delete list data

[heero]

Here is the error message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order WHERE `order`.`id` IN ('1')' at line 2 SQL=DELETE FROM order WHERE `order`.`id` IN ('1')

What is wrong? There is no such problem with other lists.

Marek

 

[rob]

No specific ideas here, I've not seen this error before.

What differences do you have with this list compared to the other lists? Check the lists' primary key and auto-inc settings, also is the primary key element set to be an 'internal id' element type and its published?

 

[troester]

DELETE FROM order
order is a reserved word, you shouldn't use it and fabrik should "backtick" the table name.

 

[rob]

ah of course, silly me! - Should be fixed now with this commit https://github.com/Fabrik/fabrik/commit/c450a147747efbad0c1dedd4abd1d15b5467ddae

 

[heero]

I created new list with different database name , now its working

Problem solved.