SQL Prepare return an error

Hello, I newbie in using asterisk and I got this message when trying to register the device through Zoiper.

WARNING[29110]: res_odbc.c:538 ast_odbc_print_errors: SQL Prepare returned an error: 42S22: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.27-0ubuntu0.18.04.1]Unknown column 'endpoint' in 'where clause'
WARNING[29110]: res_config_odbc.c:122 custom_prepare: SQL Prepare failed! [SELECT * FROM ps_endpoint_id_ips WHERE endpoint = ? ORDER BY endpoint]

Can anybody help me ?

Are you trying to use Asterisk Realtime Architecture? If so, your database schema is incomplete. You are missing a definition for the column “endpoint”.

thank for the help. Yes the attribute endpoint is incorrectly written as endpoints.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.