[sr-dev] [kamailio/kamailio] p_usrloc: location.sql missing RUID_COL and REG_ID_COL (#1265)

[Andrew Siplas]

## p_usrloc: location.sql missing columns

[location.sql](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/location.sql) should include columns corresponding to `RUID_COL` and `REG_ID_COL`) from [p_usrloc_mod.c](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/p_usrloc_mod.c#L65)

### 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/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/p_usrloc_mod.c#L65) to match `kamdbctl`'s [usrloc-create.sql](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/utils/kamctl/mysql/usrloc-create.sql#L3)

-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-dev/attachments/20171008/82e3e214/attachment.html>