<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><tt>Hi, Pat!</tt></p>
<p><tt>A similar thread regarding this issue can be found here [1]</tt></p>
<p><tt>Long story short, you need to make sure your "sql_mode"
(mysql> SELECT @@GLOBAL.sql_mode;) does not include
STRICT_TRANS_TABLES.<br>
</tt></p>
<p><tt>Regards,</tt><br>
<meta http-equiv="content-type" content="text/html;
charset=windows-1252">
</p>
<p><tt>[1]:
<a class="moz-txt-link-freetext" href="https://opensips.org/pipermail/users/2013-August/026565.html">https://opensips.org/pipermail/users/2013-August/026565.html</a><br>
</tt></p>
<pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 19.11.2016 00:20, Pat Burke wrote:<br>
</div>
<blockquote
cite="mid:1682b792bb71e134380e59c6a919b5ec@voxtelesys.com"
type="cite">
<title></title>
<div class="iw_mail" dir="ltr">
<div>When running "opensipsdbctl create" I get the following
error message.</div>
<div><br>
</div>
<div>
<div>Install presence related tables? (y/n): y</div>
<div>INFO: creating presence tables into opensips_2_2 ...</div>
<div>mysql: [Warning] Using a password on the command line
interface can be insecure.</div>
<div>ERROR 1101 (42000) at line 2: BLOB, TEXT, GEOMETRY or
JSON column 'extra_hdrs' can't have a default value</div>
<div>ERROR: Failed to create presence tables!</div>
</div>
<div><br>
</div>
<div class="signature">
<div style="font-family: arial, helvetica, sans-serif;
font-size: 16px;"><span data-mce-style="color: #808080;
font-family: arial,helvetica,sans-serif; font-size: 11pt;"
style="color: rgb(128, 128, 128); font-size: 11pt;">Regards,</span></div>
<div style="font-family: arial, helvetica, sans-serif;
font-size: 16px;">
<span data-mce-style="color: #808080; font-family:
arial,helvetica,sans-serif; font-size: 11pt;"
style="color: rgb(128, 128, 128); font-size: 11pt;"><strong>Pat
Burke</strong></span><br>
<br>
<div><br>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>