Fatal Error when updateing Core

FreePBX
1

Hello to You all!
I am new in FreePBX, installed yesterday and already having problem.

Most of modules does not work, Core needs to be enabled, to enable core must update core, when tryed to update this message appears:

Please wait while module actions are performed
Downloading and Installing core
Downloading core
Found module locally, verifying…Verified. Using Local
Installing core
Untarring…Done
Checking if directdids need migrating…already done
updating zap callgroup, pickupgroup…not needed
checking for delay_answer field …already exists
checking for reversal field …already exists
checking for pricid field …already exists
Checking if trunk table migration required…FATAL ERROR

CREATE TABLE `trunks`
(
	`trunkid` INTEGER,
	`name` VARCHAR( 50 ) NOT NULL DEFAULT '',
	`tech` VARCHAR( 20 ) NOT NULL ,
	`outcid` VARCHAR( 40 ) NOT NULL DEFAULT '',
	`keepcid` VARCHAR( 4 ) DEFAULT 'off',
	`maxchans` VARCHAR( 6 ) DEFAULT '',
	`failscript` VARCHAR( 255 ) NOT NULL DEFAULT '',
	`dialoutprefix` VARCHAR( 255 ) NOT NULL DEFAULT '',
	`channelid` VARCHAR( 255 ) NOT NULL DEFAULT '',
	`usercontext` VARCHAR( 255 ) NULL,
	`provider` VARCHAR( 40 ) NULL,
	`disabled` VARCHAR( 4 ) DEFAULT 'off',
	`continue` VARCHAR( 4 ) DEFAULT 'off',

	PRIMARY KEY  (`trunkid`, `tech`, `channelid`)
)
 [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]

Trace Back/var/www/html/admin/modules/core/install.php:333 die_freepbx()

0:
CREATE TABLE trunks
(
trunkid INTEGER,
name VARCHAR( 50 ) NOT NULL DEFAULT ‘’,
tech VARCHAR( 20 ) NOT NULL ,
outcid VARCHAR( 40 ) NOT NULL DEFAULT ‘’,
keepcid VARCHAR( 4 ) DEFAULT ‘off’,
maxchans VARCHAR( 6 ) DEFAULT ‘’,
failscript VARCHAR( 255 ) NOT NULL DEFAULT ‘’,
dialoutprefix VARCHAR( 255 ) NOT NULL DEFAULT ‘’,
channelid VARCHAR( 255 ) NOT NULL DEFAULT ‘’,
usercontext VARCHAR( 255 ) NULL,
provider VARCHAR( 40 ) NULL,
disabled VARCHAR( 4 ) DEFAULT ‘off’,
continue VARCHAR( 4 ) DEFAULT ‘off’,

	PRIMARY KEY  (`trunkid`, `tech`, `channelid`)
)
 [nativecode=1071 ** Specified key was too long; max key length is 767 bytes]

/var/www/html/admin/modules/core/install.php:457 __migrate_trunks_to_table()

/var/www/html/admin/libraries/modulefunctions.class.php:2288 include_once()

/var/www/html/admin/libraries/modulefunctions.class.php:2240 module_functions->_doinclude()

/var/www/html/admin/libraries/modulefunctions.class.php:1799 module_functions->_runscripts()

[2]:

/var/www/html/admin/page.modules.php:269 module_functions->install()

/var/www/html/admin/config.php:341 include()

I installed FreePBX on ubuntu 14.04, latest version from
wiki.freepbx. org/display/HTGS/Installing+FreePBX+12+on+Ubuntu+Server+14.04+LTS

I also have problem when I press Apply it appears

Reload failed because retrieve_conf encountered an error: 255

exit: 255
PHP Fatal error: Call to undefined function core_devices_list() in /var/www/html/admin/modules/callforward/functions.inc.php on line 47

Thank You
Radomir

2

First off, you created your tables as UTF8, which is not supported until FreePBX 13. So your primary key length is too small. THEN you created your tables as “InnoDB” (767 bytes long). We only support MyISAM (1000 bytes long).

I suggest you fix both issues.

3

TM,

Thank you for your reply, any help how to do that? I search google but there is only how to convert to UTF8…

Thank you

4

TM,

When I install Ubuntu I install it with pack of MySQL and Apache2 so that created problem. I Re-Install everything and that part is ok now, but I have other errors, I will paste it in new post.

TM thank you for pointing me in right direction.

Cheers,
Radomir