We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 10642
    • 9 Posts
    When installing gallery, the install log showed at least one error. A copy of the log is below. Is this normal? Will the installation work ok?
    Thanks

    /*
    * MODx Console Output
    *
    * @date 2010-07-28 11:47:35
    */
    Grabbing package workspace...

    Package found...now preparing to install.

    Created table`m2_categories_closure`
    SQL: CREATE TABLE `m2_categories_closure` (`ancestor` INT(10) unsigned NOT NULL DEFAULT ’0’,`descendant` INT(10) unsigned NOT NULL DEFAULT ’0’,`depth` INT(10) unsigned NOT NULL DEFAULT ’0’, PRIMARY KEY (`ancestor`,`descendant`)) TYPE=MyISAM


    Language string not found: "gallery"

    Attempting to install package with signature: gallery-1.0.0-pl

    Error 42S02 executing statement:
    INSERT INTO `m2_categories_closure` (`ancestor`, `descendant`, `depth`) VALUES (’1’, ’1’, ’0’)
    Array
    (
    [0] => 42S02
    [1] => 1146
    [2] => Table ’canprod_mr2.m2_categories_closure’ doesn’t exist
    )


    Language string not found: "gallery.menu_desc"

    Workspace environment initiated, now installing package...

    Created table`m2_gallery_tags`
    SQL: CREATE TABLE `m2_gallery_tags` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`item` INT(10) unsigned NOT NULL DEFAULT ’0’,`tag` VARCHAR(255) NOT NULL DEFAULT ’’, PRIMARY KEY (`id`), INDEX `item` (`item`), INDEX `tag` (`tag`)) TYPE=MyISAM


    Created table`m2_gallery_albums`
    SQL: CREATE TABLE `m2_gallery_albums` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`parent` INT(10) unsigned NOT NULL DEFAULT ’0’,`name` VARCHAR(255) NOT NULL DEFAULT ’’,`description` TEXT NOT NULL,`createdon` DATETIME NULL,`createdby` INT(10) unsigned NOT NULL DEFAULT ’0’,`rank` INT(10) unsigned NOT NULL DEFAULT ’0’,`active` TINYINT(1) unsigned NOT NULL DEFAULT ’0’,`prominent` TINYINT(1) unsigned NOT NULL DEFAULT ’0’,`watermark` VARCHAR(255) NOT NULL DEFAULT ’’, PRIMARY KEY (`id`), INDEX `parent` (`parent`), INDEX `name` (`name`), INDEX `createdby` (`createdby`)) TYPE=MyISAM


    Successfully installed package gallery-1.0.0-pl

    Created table`m2_gallery_album_items`
    SQL: CREATE TABLE `m2_gallery_album_items` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`item` INT(10) unsigned NOT NULL DEFAULT ’0’,`album` INT(10) unsigned NOT NULL DEFAULT ’0’,`rank` INT(10) unsigned NOT NULL DEFAULT ’0’, PRIMARY KEY (`id`), INDEX `item` (`item`), INDEX `album` (`album`)) TYPE=MyISAM


    Created table`m2_gallery_album_contexts`
    SQL: CREATE TABLE `m2_gallery_album_contexts` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`album` INT(10) unsigned NOT NULL DEFAULT ’0’,`context_key` VARCHAR(100) NOT NULL DEFAULT ’web’, PRIMARY KEY (`id`), INDEX `album` (`album`), INDEX `context_key` (`context_key`)) TYPE=MyISAM


    Created table`m2_gallery_items`
    SQL: CREATE TABLE `m2_gallery_items` (`id` INTEGER unsigned NOT NULL AUTO_INCREMENT,`name` VARCHAR(100) NOT NULL DEFAULT ’’,`filename` VARCHAR(255) NOT NULL DEFAULT ’’,`description` TEXT NOT NULL,`mediatype` VARCHAR(40) NOT NULL DEFAULT ’image’,`createdon` DATETIME NULL,`createdby` INT(10) unsigned NOT NULL DEFAULT ’0’,`active` TINYINT(1) unsigned NOT NULL DEFAULT ’0’,`duration` VARCHAR(40) NOT NULL DEFAULT ’’,`streamer` TEXT NOT NULL,`watermark_pos` VARCHAR(10) NOT NULL DEFAULT ’tl’, PRIMARY KEY (`id`), INDEX `createdby` (`createdby`)) TYPE=MyISAM



    /* EOF */
      • 28215
      • 4,149 Posts
      It’s fine; the closure table error is a bug in Revo 2.0-pl that’s trivial and wont affect anything at all.
        shaun mccormick | bigcommerce mgr of software engineering, former modx co-architect | github | splittingred.com
        • 10642
        • 9 Posts
        Thanks again