⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

bug when edit



fredo2009

fredo2009
  • profile picture
  • Member

Posted 11 August 2017 - 13:17 PM

Hi,

 

I can't edit:

<h1>An Error Was Encountered</h1>
        <p>SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous --- #0 /var/www/dev_chronospheres/organisateurs/application/libraries/GroceryCrudEnterprise/zendframework/zend-db/src/Adapter/Driver/Pdo/Connection.php(360): PDO->query('SELECT `events_...')

 

 

Query is wrong:

SELECT `events_inscrits`.`id` AS `id` FROM `events_inscrits` LEFT JOIN `events_tarifs` ON `events_inscrits`.`id_tarif` = `events_tarifs`.`id` WHERE `id` = '490' AND events_inscrits.id_event AND `events_tarifs`.`id_event` = '7'

 

How is made query?