Hi, Pat!
A similar thread regarding this issue can be found here [1]
Long story short, you need to make sure your "sql_mode" (mysql> SELECT
@@GLOBAL.sql_mode;) does not include STRICT_TRANS_TABLES.
Regards,
[1]: https://opensips.org/pipermail/users/2013-August/026565.html
Liviu Chircu
OpenSIPS Developer
http://www.opensips-solutions.com
On 19.11.2016 00:20, Pat Burke wrote:
When running "opensipsdbctl create" I get the following error message.
Install presence related tables? (y/n): y
INFO: creating presence tables into opensips_2_2 ...
mysql: [Warning] Using a password on the command line interface can be
insecure.
ERROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or JSON column
'extra_hdrs' can't have a default value
ERROR: Failed to create presence tables!
Regards,
*Pat Burke*
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
