Hello Everyone, I am trying to save data into table but I am getting below error: Unable to execute

U03D56SF151

Hello Everyone,
I am trying to save data into table but I am getting below error:

Unable to execute INSERT statement [INSERT INTO pyz_bsl_data_range_channels_details (id_channel_detail, fk_id_category, key, title, seo_alias, fk_locale) VALUES (:p0, :p1, :p2, :p3, :p4, :p5)];
INSERT INTO pyz_bsl_data_range_channels_details (id_channel_detail, fk_id_category, key, title, seo_alias, fk_locale, created_at) VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6)
Error - Exception: Object of class Propel\Runtime\Connection\StatementWrapper could not be converted to string

Before inserting data into table, prepare data like below:
$channelEntity = PyzBslDataRangeChannelsDetailsQuery::create()
->filterByFkIdCategory($categoryId)
->filterByKey($channel['key'])
->filterByFkLocale($localeId)
->findOneOrCreate();
// convert into data set
$channelDataSet = new DataSet([
'fk_id_category' => $categoryId,
'key' => $channel['key'],
'title' => $channel['title'],
'seo_alias' => $channel['seoAlias'],
'fk_locale' => $localeId
]);

// update data
$channelEntity = $channelEntity->fromArray($channelDataSet->getArrayCopy());
$channelEntity->save();

Do you have any idea what is issue in it?
Thanks

U03B1JNQB9S

Hi. Just an idea - key is a reserved sql keyword, make sure it is properly encapsulated in quotes. Maybe try executing the query without it to see if the error occurs due to it

Alberto Reyer

I doubt key is the problem here, Propel will take care of the escaping.

Maybe you've forgotten to remove a debug statement (var_dump or something alike) that prints the Statement

U03D56SF151

@U03B1JNQB9S Thanks. It was key field issue. I have changed it and it is working fine now.
Thanks again.