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: |
| ||||||
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: |