Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19232

Missing eztags table after a fresh install of ez publish 2012.2

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • None
    • None
    • Install
    • None
    • Operating System: Ubuntu 11/10
      PHP Version: 5.3.6-13ubuntu3.6
      Database and version: MySql 5.1
      Browser (and version): Chrome 17.0.x

    Description

      Hello, i jsut installed ezp. 2012.2, but when i did try to add an entry in ez tags i got an error, after a db check i found which was missing this table eztags

      so i did create it using this code :
      CREATE TABLE eztags (
      id int(11) NOT NULL AUTO_INCREMENT,
      parent_id int(11) NOT NULL DEFAULT '0',
      main_tag_id int(11) NOT NULL DEFAULT '0',
      keyword varchar(255) NOT NULL DEFAULT '',
      depth int(11) NOT NULL DEFAULT '1',
      path_string varchar(255) NOT NULL DEFAULT '',
      modified int(11) NOT NULL DEFAULT '0',
      remote_id varchar(100) NOT NULL DEFAULT '',
      PRIMARY KEY ( id ),
      KEY eztags_keyword ( keyword ),
      KEY eztags_keyword_id ( keyword, id ),
      UNIQUE KEY eztags_remote_id ( remote_id )
      );
      CREATE TABLE eztags_attribute_link (
      id int(11) NOT NULL AUTO_INCREMENT,
      keyword_id int(11) NOT NULL DEFAULT '0',
      objectattribute_id int(11) NOT NULL DEFAULT '0',
      objectattribute_version int(11) NOT NULL DEFAULT '0',
      object_id int(11) NOT NULL DEFAULT '0',
      PRIMARY KEY ( id ),
      KEY eztags_attr_link_keyword_id ( keyword_id ),
      KEY eztags_attr_link_kid_oaid_oav ( keyword_id, objectattribute_id, objectattribute_version ),
      KEY eztags_attr_link_kid_oid ( keyword_id, object_id ),
      KEY eztags_attr_link_oaid_oav ( objectattribute_id, objectattribute_version )
      );

      and it worked

      Steps to reproduce

      Install EzPublish 2012.2
      Login into admin interface
      Move to Ez Tags
      Add New Tag

      Attachments

        Activity

          People

            unknown unknown
            buby84 buby84
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: