BUG. PHQL error while only inserting to table with 2 columns

[etilley]

I have a table in my database that has 2 columns in it. First column is the id and the second one is the name. if i try to run

$this->modelsManager->executeQuery('INSERT INTO ModelName (column_name) VALUES (\'test\')');

I will get "Unknown expression" but if I do

$this->modelsManager->executeQuery('INSERT INTO ModelName (id, column_name) VALUES ( \'\'  \'test\')');

it will add the row. I added an extra column to the table for test and it would add the row without me specifying the id column.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[mywebcontent]

Hello,

I have the same issue, I solved with something like this:

$this->modelsManager->executeQuery("INSERT INTO Featured (id,articleid) VALUES (:id:,:articleid:)",array('id' => NULL,'articleid' => $value[$i]));

although it's not a beautiful solution.
It seems that PHQL runs into trouble if trying to insert a record into a table with only an id and one another columns. You can try a solution like this:

$featured=new Featured();
$featured->articleid=$value[$i];
$featured->save();

[Green-Cat]

@andresgutierrez fixed in #2328

[maxgalbu]

It's probably not fixed on 2.0, but I didn't check