SQL Fatal Error - Help!

I was working on my backup server today and now I’m getting the following when in the Trunk section. I can’t create any new trunks and any that I have created disappear if i try and save.

2.11.0.12
1.8.9.3

FATAL ERROR
INSERT INTO trunks (trunkid, name, tech, outcid, keepcid, maxchans, failscript, dialoutprefix, channelid, usercontext, provider, disabled, continue) VALUES ( ‘1’, ‘1’, ‘dahdi’, ‘1’, ‘off’, ‘’, ‘’, ‘’, ‘g0’, ‘notneeded’, ‘’, ‘off’, ‘off’ ) [nativecode=1054 ** Unknown column ‘continue’ in ‘field list’]SQL -
INSERT INTO trunks (trunkid, name, tech, outcid, keepcid, maxchans, failscript, dialoutprefix, channelid, usercontext, provider, disabled, continue) VALUES ( ‘1’, ‘1’, ‘dahdi’, ‘1’, ‘off’, ‘’, ‘’, ‘’, ‘g0’, ‘notneeded’, ‘’, ‘off’, ‘off’ )
Trace Back
/var/www/html/admin/libraries/sql.functions.php:25 die_freepbx()
[0]: INSERT INTO trunks (trunkid, name, tech, outcid, keepcid, maxchans, failscript, dialoutprefix, channelid, usercontext, provider, disabled, continue) VALUES ( ‘1’, ‘1’, ‘dahdi’, ‘1’, ‘off’, ‘’, ‘’, ‘’, ‘g0’, ‘notneeded’, ‘’, ‘off’, ‘off’ ) [nativecode=1054 ** Unknown column ‘continue’ in ‘field list’]SQL -
INSERT INTO trunks (trunkid, name, tech, outcid, keepcid, maxchans, failscript, dialoutprefix, channelid, usercontext, provider, disabled, continue) VALUES ( ‘1’, ‘1’, ‘dahdi’, ‘1’, ‘off’, ‘’, ‘’, ‘’, ‘g0’, ‘notneeded’, ‘’, ‘off’, ‘off’ )

/var/www/html/admin/modules/core/functions.inc.php:6017 sql()
[0]: INSERT INTO trunks (trunkid, name, tech, outcid, keepcid, maxchans, failscript, dialoutprefix, channelid, usercontext, provider, disabled, continue) VALUES ( ‘1’, ‘1’, ‘dahdi’, ‘1’, ‘off’, ‘’, ‘’, ‘’, ‘g0’, ‘notneeded’, ‘’, ‘off’, ‘off’ )

Fixed it!

I compared the SQL table ‘trunks’ between the primary and secondary and noticed I was missing the column ‘continue’

I run post restore hooks to jiggle about trunk orders which involves SQL imports. The ‘continue’ column must have been added as part of a module update at some point.

phew!