## p_usrloc: location.sql missing columns [location.sql](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda5… should include columns corresponding to `RUID_COL` and `REG_ID_COL`) from [p_usrloc_mod.c](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dd… ### Log Messages ``` kamailio: ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown column 'reg_id' in 'field list' (1054) kamailio: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query kamailio: ERROR: p_usrloc [ul_db_query.c:110]: db_exec_query(): could not query table location. ``` ``` kamailio: ERROR: db_mysql [km_dbase.c:127]: db_mysql_submit_query(): driver error on query: Unknown column 'ruid' in 'field list' (1054) kamailio: ERROR: <core> [db_query.c:132]: db_do_query_internal(): error while submitting query kamailio: ERROR: p_usrloc [ul_db_query.c:110]: db_exec_query(): could not query table location. ``` ### Solutions Adding columns referenced by [p_usrloc_mod.c](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dd… to match `kamdbctl`'s [usrloc-create.sql](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff5… -- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/issues/1265