MariaDB 10.2 Error on Table for SIP-AIX_phone.sql

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

MariaDB 10.2 Error on Table for SIP-AIX_phone.sql

Postby ruben23 » Fri Jul 12, 2019 9:05 am

version: 2.14b0.5
SVN Version: 3067
DB Schema Version: 1564
DB Schema Update Date: 2019-03-01 18:32:30
Password Encryption:DISABLED - S1 - C1
Auto User-add Value: 101
Recording Prompt Count: 0
Install Date: 2019-03-01
ASterisk 1.8
Scratch install Ubuntu Server

HI guys any idea what error is this somehow.? and how to correct this, this actually works with MariaDB 5.5 but wen we used it on MariaDB 10.2 it projecting error already

Code: Select all
MariaDB [asterisk]> \. /usr/src/astguiclient/trunk/extras/sip-iax_phones.sql
ERROR 1364 (HY000) at line 1 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 2 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 3 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 4 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 5 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 6 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 7 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 8 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 9 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 10 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 11 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 12 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 13 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 14 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 15 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 16 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 17 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 18 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 19 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 20 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 21 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 22 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 23 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 24 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 25 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 26 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 27 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 28 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 29 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 30 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 31 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 32 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 33 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 34 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 35 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 36 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 37 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 38 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 39 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 40 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 41 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 42 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 43 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 44 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 45 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 46 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 47 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 48 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 49 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 50 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 51 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 54 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 55 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 56 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 57 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 58 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 59 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 60 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 61 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 62 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 63 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 64 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 65 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 66 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 67 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 68 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 69 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 70 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 71 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 72 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 73 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 74 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 75 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 76 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 77 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 78 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 79 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 80 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 81 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 82 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 83 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 84 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 85 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 86 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 87 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 88 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 89 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 90 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 91 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 92 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 93 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 94 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 95 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 96 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 97 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 98 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 99 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 100 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 101 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 102 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 103 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
ERROR 1364 (HY000) at line 104 in file: '/usr/src/astguiclient/trunk/extras/sip-iax_phones.sql': Field 'template_id' doesn't have a default value
MariaDB [asterisk]> quit
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Re: MariaDB 10.2 Error on Table for SIP-AIX_phone.sql

Postby ruben23 » Fri Jul 12, 2019 10:00 am

HI guys this was corrected already by executing this on the mysql console, no more Errors

mysql> ALTER TABLE phones ALTER template_id SET DEFAULT '';
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines


Return to Support

Who is online

Users browsing this forum: No registered users and 68 guests