Okay
  Public Ticket #415682
Sql Problem
Closed

Comments

  • Hamid started the conversation

    Hi,

    I have problem with creating demo package and sample_data.sql

    When i want to install demo package with this attachment file i got this errors:

    Table 'pac.mmss_revslider_static_slides' doesn't exist SQL=ALTER TABLE `mmss_revslider_static_slides` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7

    Table 'pac.mmss_revslider_slides' doesn't exist SQL=ALTER TABLE `mmss_revslider_slides` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=50

    Multiple primary key defined SQL=ALTER TABLE `mmss_ucm_content` ADD PRIMARY KEY (`core_content_id`), ADD KEY `tag_idx` (`core_state`,`core_access`), ADD KEY `idx_access` (`core_access`), ADD KEY `idx_alias` (`core_alias`), ADD KEY `idx_language` (`core_language`), ADD KEY `idx_title` (`core_title`), ADD KEY `idx_modified_time` (`core_modified_time`), ADD KEY `idx_created_time` (`core_created_time`), ADD KEY `idx_content_type` (`core_type_alias`), ADD KEY `idx_core_modified_user_id` (`core_modified_user_id`), ADD KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`), ADD KEY `idx_core_created_user_id` (`core_created_user_id`), ADD KEY `idx_core_type_id` (`core_type_id`)

    Multiple primary key defined SQL=ALTER TABLE `mmss_ucm_base` ADD PRIMARY KEY (`ucm_id`), ADD KEY `idx_ucm_item_id` (`ucm_item_id`), ADD KEY `idx_ucm_type_id` (`ucm_type_id`), ADD KEY `idx_ucm_language_id` (`ucm_language_id`)

    Multiple primary key defined SQL=ALTER TABLE `mmss_template_styles` ADD PRIMARY KEY (`id`), ADD KEY `idx_template` (`template`), ADD KEY `idx_home` (`home`)

    Multiple primary key defined SQL=ALTER TABLE `mmss_tags` ADD PRIMARY KEY (`id`), ADD KEY `tag_idx` (`published`,`access`), ADD KEY `idx_access` (`access`), ADD KEY `idx_checkout` (`checked_out`), ADD KEY `idx_path` (`path`), ADD KEY `idx_left_right` (`lft`,`rgt`), ADD KEY `idx_alias` (`alias`), ADD KEY `idx_language` (`language`)

    Multiple primary key defined SQL=ALTER TABLE `mmss_session` ADD PRIMARY KEY (`session_id`), ADD KEY `userid` (`userid`), ADD KEY `time` (`time`)

    Multiple primary key defined SQL=ALTER TABLE `mmss_schemas` ADD PRIMARY KEY (`extension_id`,`version_id`)

    Table 'pac.mmss_revslider_static_slides' doesn't exist SQL=ALTER TABLE `mmss_revslider_static_slides` ADD PRIMARY KEY (`id`)

    Table 'pac.mmss_revslider_slides' doesn't exist SQL=ALTER TABLE `mmss_revslider_slides` ADD PRIMARY KEY (`id`)

    .......

    And +500 codes

    It seems there is problem with rev slider tables.Can you help me ?

    Thanks!

  • Hamid replied

    Attachment file : sql

  • Hamid replied

    Whole error

  •   Max replied privately
  •   Hamid replied privately
  •   Max replied privately