SQL Prepare return an error

devhils19 · September 18, 2019, 9:09am

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 ?

david551 · September 18, 2019, 9:23am

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

devhils19 · September 23, 2019, 1:55am

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

system · October 23, 2019, 1:55am

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