modx3: Could not load class: modTransportPackage from mysql.modtransportpackage

[patrickatwsrn]

Installed formalicious2.0.5pl / modx3.0.0-beta

Create Table seemed to work fine, but near the end of the installation process an error was thrown:

Konsole läuft …
Versuche, das Package mit der Signatur formalicious-2.0.5-pl zu installieren
Package gefunden … Bereite jetzt die Installation vor.
Greife auf Package-Workspace zu …
Workspace-Umgebung eingerichtet, installiere jetzt das Package …

Created table `modx_formalicious_categories` SQL: CREATE TABLE `modx_formalicious_categories` (`id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `published` TINYINT(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`), INDEX `published` (`published`)) ENGINE=MyISAM
Created table `modx_formalicious_forms` SQL: CREATE TABLE `modx_formalicious_forms` (`id` INT(11) NOT NULL AUTO_INCREMENT, `category_id` INT(10) NOT NULL DEFAULT '0', `name` VARCHAR(255) NOT NULL DEFAULT '', `published` TINYINT(1) NOT NULL DEFAULT '0', `published_from` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', `published_till` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', `saveform` TINYINT(1) unsigned NOT NULL DEFAULT '0', `redirectto` INT(10) unsigned NOT NULL DEFAULT '0', `email` TINYINT(1) unsigned NOT NULL DEFAULT '0', `emailto` TEXT NOT NULL, `emailsubject` VARCHAR(255) NOT NULL DEFAULT '', `emailcontent` TEXT NOT NULL, `fiaremail` TINYINT(1) unsigned NOT NULL DEFAULT '0', `fiaremailto` INT(11) unsigned NOT NULL DEFAULT '0', `fiaremailfrom` TEXT NOT NULL, `fiaremailsubject` VARCHAR(255) NOT NULL DEFAULT '', `fiaremailcontent` TEXT NOT NULL, `fiaremailattachment` TEXT NOT NULL, `prehooks` VARCHAR(255) NOT NULL DEFAULT '', `posthooks` VARCHAR(255) NOT NULL DEFAULT '', `parameters` TEXT NOT NULL, PRIMARY KEY (`id`), INDEX `category_id` (`category_id`), INDEX `saveform` (`saveform`), INDEX `email` (`email`), INDEX `fiaremail` (`fiaremail`)) ENGINE=MyISAM

Created table `modx_formalicious_steps` SQL: CREATE TABLE `modx_formalicious_steps` (`id` INT(11) NOT NULL AUTO_INCREMENT, `form_id` INT(10) NOT NULL DEFAULT '0', `title` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `button` VARCHAR(75) NOT NULL DEFAULT '', `rank` INT(10) NOT NULL, `published` TINYINT(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `form_id` (`form_id`), INDEX `published` (`published`)) ENGINE=MyISAM
Created table `modx_formalicious_fields_types` SQL: CREATE TABLE `modx_formalicious_fields_types` (`id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '', `tpl` VARCHAR(255) NOT NULL DEFAULT '', `answertpl` VARCHAR(255) NOT NULL DEFAULT '', `values` TINYINT(1) unsigned NOT NULL DEFAULT '0', `validation` TEXT NOT NULL, `icon` VARCHAR(255) NOT NULL DEFAULT '', `fields` TEXT NOT NULL, PRIMARY KEY (`id`), INDEX `values` (`values`)) ENGINE=MyISAM

Created table `modx_formalicious_fields` SQL: CREATE TABLE `modx_formalicious_fields` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT, `step_id` INT(10) NOT NULL DEFAULT '0', `title` VARCHAR(255) NOT NULL DEFAULT '', `placeholder` VARCHAR(255) NOT NULL DEFAULT '', `description` TEXT NOT NULL, `directional` TINYINT(1) unsigned NOT NULL DEFAULT '0', `type` INT(10) NOT NULL DEFAULT '0', `required` TINYINT(1) unsigned NOT NULL DEFAULT '0', `published` TINYINT(1) unsigned NOT NULL DEFAULT '0', `rank` INT(10) NOT NULL, `property` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), INDEX `step_id` (`step_id`), INDEX `type` (`type`), INDEX `published` (`published`)) ENGINE=MyISAM
Created table `modx_formalicious_answers` SQL: CREATE TABLE `modx_formalicious_answers` (`id` INT(11) NOT NULL AUTO_INCREMENT, `field_id` INT(10) NOT NULL DEFAULT '0', `name` VARCHAR(255) NOT NULL DEFAULT '', `rank` INT(10) NOT NULL, `published` TINYINT(1) unsigned NOT NULL DEFAULT '0', `selected` TINYINT(1) unsigned NOT NULL DEFAULT '0', `subfield_id` INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `field_id` (`field_id`), INDEX `published` (`published`), INDEX `selected` (`selected`), INDEX `subfield_id` (`subfield_id`)) ENGINE=MyISAM

So far so good...

Could not load class: modTransportPackage from mysql.modtransportpackage
Could not get table name for class:
Error 42000 executing statement: Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS `latestPackage` WHERE `latestPackage`.`package_name` = `modTra...' at line 3 )
Package "formalicious-2.0.5-pl" erfolgreich installiert.

Happy new year

[patrickatwsrn]

According to jako the getTableName method property needs to be fixed, because it is not valid for MODX3

See Sterc/FormIt#247 for a solution