Summary:	ASTERISK-18355: sqlite realtime_multi_func wrongly assumes commented column exists
Reporter:	Walter Doekes (wdoekes)	Labels:
Date Opened:	2011-08-27 10:24:12	Date Closed:	2011-11-03 15:29:15
Priority:	Major	Regression?	No
Status:	Closed/Complete	Components:	Resources/res_config_sqlite
Versions:		Frequency of Occurrence	Constant
Related Issues:	is related to ASTERISK-18354 sqlite crash for realtime action if config_table is not set is related to ASTERISK-18356 chan_sip realtime_peer has several memory leaks
Environment:		Attachments:	( 0) issueA18355-sqlite-realtime_multi_func-commented-1.8.x.patch
Description:	(Related to ASTERISK-18354) The check done in the SQLite realtime_func whether a table has the commented=0 field or not is not performed for the realtime_multi_func. This means that ast_load_realtime_multientry will yield 0 results and instead a "no column" error: {code} SQL query: SELECT * FROM 'sipfriend' WHERE commented = 0 AND host = '127.0.0.1' ORDER BY host; no such column: commented {code} The fix: do the same (patched) check as observed in ASTERISK-18354 in realtime_multi_handler. See the (soon to be) attached patch. Regards, Walter Doekes OSSO B.V.
Comments: