Support Center

ViMP Support

FAQ Installation and First steps

ViMP Enterprise Ultimate - update to ViMP 2.0.9

Editions: Enterprise Ultimate
Versions: 2.0.9

Additionally to the standard update procedure for ViMP 2.0.9 the new modules "Albums" and "Newsletter" have to be integrated into the database on ViMP Enterprise Ultimate installations.

The following steps have to be done with the update:

- Extract the new vimp.framework-2.0.9-r18710-enterprise-ultimate.tar.gz within the ViMP installation folder:
 
tar xvzf vimp.framework-2.0.9-r18710-enterprise-ultimate.tar.gz
and
./symfony rebuild

- With updating to v2.0.9 this time you have to execute some additional MySQL statements in the database. The easiest way to do so is to open the database via phpMyAdmin. Copy and paste the following statements into the text box under the SQL tab and confirm with clicking OK.
 
MySQL statements:

CREATE TABLE `album`
      (
        `aid` INTEGER(11)  NOT NULL AUTO_INCREMENT,
        `albumtype` INTEGER(11)  NOT NULL,
        `objectid` INTEGER(11)  NOT NULL,
        `visibility` INTEGER(11) default 0 NOT NULL,
        `title` VARCHAR(255)  NOT NULL,
        `description` TEXT,
        `created_at` DATETIME  NOT NULL,
        `updated_at` DATETIME  NOT NULL,
        PRIMARY KEY (`aid`),
        KEY `a_i_album`(`albumtype`, `objectid`),
        KEY `a_i_album_visibility`(`albumtype`, `objectid`, `visibility`),
        KEY `a_i_albumtype`(`albumtype`),
        KEY `a_i_objectid`(`objectid`)
      )Type=InnoDB;

      CREATE TABLE `album_media`
      (
        `aid` INTEGER(11)  NOT NULL,
        `mid` INTEGER(11)  NOT NULL,
        `weight` INTEGER(11) default 0 NOT NULL,
        `created_at` DATETIME  NOT NULL,
        `updated_at` DATETIME  NOT NULL,
        PRIMARY KEY (`aid`,`mid`),
        KEY `am_i_aid`(`aid`),
        KEY `am_i_mid`(`mid`),
        CONSTRAINT `am_fk_aid`
          FOREIGN KEY (`aid`)
          REFERENCES `album` (`aid`),
        CONSTRAINT `am_fk_mid`
          FOREIGN KEY (`mid`)
          REFERENCES `media` (`mid`)
      )Type=InnoDB;

      INSERT INTO `role_permission` (`rid`, `perm`, `created_at`) VALUES
      (0, 'access album', NOW()),
      (0, 'search album', NOW()),
      (1, 'access album', NOW()),
      (1, 'administer album', NOW()),
      (1, 'create album', NOW()),
      (1, 'delete album', NOW()),
      (1, 'delete own album', NOW()),
      (1, 'edit album', NOW()),
      (1, 'edit own album', NOW()),
      (1, 'manage album media', NOW()),
      (1, 'manage own album media', NOW()),
      (1, 'search album', NOW()),
      (2, 'access album', NOW()),
      (2, 'create album', NOW()),
      (2, 'delete album', NOW()),
      (2, 'delete own album', NOW()),
      (2, 'edit album', NOW()),
      (2, 'edit own album', NOW()),
      (2, 'manage album media', NOW()),
      (2, 'manage own album media', NOW()),
      (2, 'search album', NOW()),
      (3, 'access album', NOW()),
      (3, 'create album', NOW()),
      (3, 'delete own album', NOW()),
      (3, 'edit own album', NOW()),
      (3, 'manage own album media', NOW()),
      (3, 'search album', NOW());
      
      CREATE TABLE `newsletter`
      (
        `nlid` INTEGER(11)  NOT NULL AUTO_INCREMENT,
        `status` INTEGER(11) default 0 NOT NULL,
        `name` VARCHAR(255)  NOT NULL,
        `created_at` DATETIME  NOT NULL,
        `updated_at` DATETIME  NOT NULL,
        PRIMARY KEY (`nlid`)
      )Type=InnoDB;

      CREATE TABLE `newsletter_issue`
      (
        `nliid` INTEGER(11)  NOT NULL AUTO_INCREMENT,
        `nlid` INTEGER(11)  NOT NULL,
        `status` INTEGER(11) default 0 NOT NULL,
        `subject` VARCHAR(255)  NOT NULL,
        `message_html` TEXT  NOT NULL,
        `message_text` TEXT  NOT NULL,
        `from_email` VARCHAR(255)  NOT NULL,
        `from_name` VARCHAR(255)  NOT NULL,
        `reply_email` VARCHAR(255)  NOT NULL,
        `reply_name` VARCHAR(255)  NOT NULL,
        `test_users` TEXT  NOT NULL,
        `last_receiver_id` INTEGER(11) default 0 NOT NULL,
        `count_send` INTEGER(11) default 0 NOT NULL,
        `execute_at` DATETIME  NOT NULL,
        `started_at` DATETIME,
        `finished_at` DATETIME,
        `created_at` DATETIME  NOT NULL,
        `updated_at` DATETIME  NOT NULL,
        PRIMARY KEY (`nliid`),
        INDEX `FI__fk_nlid` (`nlid`),
        CONSTRAINT `ncn_fk_nlid`
          FOREIGN KEY (`nlid`)
          REFERENCES `newsletter` (`nlid`)
      )Type=InnoDB;

      CREATE TABLE `newsletter_subscription`
      (
        `nlid` INTEGER(11)  NOT NULL,
        `uid` INTEGER(11)  NOT NULL,
        `created_at` DATETIME  NOT NULL,
        `updated_at` DATETIME  NOT NULL,
        PRIMARY KEY (`nlid`,`uid`),
        CONSTRAINT `un_fk_nlid`
          FOREIGN KEY (`nlid`)
          REFERENCES `newsletter` (`nlid`),
        INDEX `FI_fk_uid` (`uid`),
        CONSTRAINT `un_fk_uid`
          FOREIGN KEY (`uid`)
          REFERENCES `user` (`uid`)
      )Type=InnoDB;

- Next execute the following commands within the ViMP folder:

./symfony rebuild
./symfony i18n:import


- Finally the newsletter module needs, analoge to the transcoding, a cronjob:

*/1 * * * * /path/to/vimp/scripts/send_newsletters.sh > /dev/null 2>&1

ViMP Enterprise Ultimate is now installed completely!

Last update on 2013/11/12 by Admin.

Go back

 

Inquiry
Inquiry
Demo