This topic contains 2 replies, has 2 voices, and was last updated by Loïc Bertron 9 years, 3 months ago.
- Topic
Hi !
I’m trying to install the zendesk integration. Everything is good so far, except SQL.
I got this error while trying to insert a zendesk integration :1Column not found: 1054 Unknown column 'orocrm_zd_url' in 'field list'" at /home/xxx/sources/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {"exception":"[object] (Doctrine\\DBAL\\DBALException: An exception occurred while executing 'INSERT INTO oro_integration_transport (orocrm_zd_url, orocrm_zd_email, orocrm_zd_token, orocrm_zd_default_user_email, type) VALUES (?, ?, ?, ?, ?)' with params [\"https:\\/\\/xxx.zendesk.com\", \"loic@xxx.com\", \"6GGWkMBPnevUt5woDIxAjNQ3WJYMEvPEcLXkRd3L\", \"support@xxx.com\", \"zendeskresttransport\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'orocrm_zd_url' in 'field list' at /home/xxx/sources/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'orocrm_zd_url' in 'field list' at /home/xxx/sources/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165)"} []Here is the actual structure :
oro_integration_transport
Colonne Type Null Défaut Commentaires MIME
id int(11) Non
type varchar(30) Non
wsdl_url varchar(255) Oui NULL
api_user varchar(255) Oui NULL
api_key varchar(255) Oui NULL
sync_start_date date Oui NULL
sync_range varchar(50) Oui NULL
website_id int(11) Oui NULL
websites longtext Oui NULL (DC2Type:array)(DC2Type:array)
is_extension_installed tinyint(1) Oui NULL
is_wsi_mode tinyint(1) Oui NULL
admin_url varchar(255) Oui NULL
IndexNom de l’index Type Unique Compressé Colonne Cardinalité Interclassement Null Commentaire
PRIMARY BTREE Oui Non id 1 A NonDo you have any idea ?
Thanks.
The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.