Editor - Update record when DB field has space in the name

ddimitrov

I am using editor version 1.5.3 and a MySQL table with space in the column name.
The Backticks ( ` ) allow me to read the table.

Update a field with space in the name throw following error.
error: "SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens"

Is there any workaround of the issue ?

allan

Hi,

Unfortunately there is no workaround for this at the moment. The issue comes from the database abstraction libraries that Editor is using, where the space means that the parameter is not fully escaped. The only fix at the moment is to use columns names that don't include a space - sorry.

Allan

ddimitrov

Thanks !

I did figure it out.