database index problem

Discussion in 'General' started by icphedia, Jul 11, 2006.

  1. icphedia

    icphedia New Member

    hi,
    all joomla sites have a this problem..

    how can i fix? thanks..

    Problems with indexes of table `jos_categories`
    Warning More than one INDEX key was created for column `section`
    Problems with indexes of table `jos_core_acl_aro`
    Warning More than one UNIQUE key was created for column `section_value`
    Warning More than one INDEX key was created for column `hidden`
    Problems with indexes of table `jos_core_acl_aro_groups`
    Warning More than one INDEX key was created for column `parent_id`
    Problems with indexes of table `jos_core_acl_aro_sections`
    Warning More than one UNIQUE key was created for column `value`
    Warning More than one INDEX key was created for column `hidden`
    Problems with indexes of table `jos_jstats_ipaddresses`
    Warning PRIMARY and INDEX keys should not both be set for column `id`
    Problems with indexes of table `jos_jstats_pages`
    Warning PRIMARY and INDEX keys should not both be set for column `page_id`
    Problems with indexes of table `jos_jstats_visits`
    Warning More than one INDEX key was created for column `userid`
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess Joomla has created Indexes plus set the same column to primary in several tables. You can delete the indexes on these columns, as setting the column to primary is an index too.

    This is not an ISPConfig error, it is a problem with the database index creation in Joomla.
     
  3. icphedia

    icphedia New Member

    this problem last only for one week. Before everthing was okey.
     
  4. falko

    falko Super Moderator Howtoforge Staff

    Did you try what Till suggested? Make a backup of your database before.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess you did install any MySQL or Joomla related updates. I posted the solution for your problem in my first post.
     

Share This Page