Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 11th July 2006, 14:10
icphedia icphedia is offline
Junior Member
 
Join Date: Jul 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default database index problem

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`
Reply With Quote
Sponsored Links
  #2  
Old 11th July 2006, 14:31
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,022
Thanks: 840
Thanked 5,653 Times in 4,462 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 11th July 2006, 14:40
icphedia icphedia is offline
Junior Member
 
Join Date: Jul 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

this problem last only for one week. Before everthing was okey.
Reply With Quote
  #4  
Old 12th July 2006, 13:54
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Did you try what Till suggested? Make a backup of your database before.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 12th July 2006, 14:03
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,022
Thanks: 840
Thanked 5,653 Times in 4,462 Posts
 
Default

Quote:
Originally Posted by icphedia
this problem last only for one week. Before everthing was okey.
I guess you did install any MySQL or Joomla related updates. I posted the solution for your problem in my first post.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 18:58
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 13:20
Mail System doesnt work! crichton Installation/Configuration 3 18th September 2007 00:49
Postfix+MySQL Problem jasutton Installation/Configuration 1 15th June 2006 17:06
Empty Recycle Bin jon335 General 40 6th May 2006 12:56


All times are GMT +2. The time now is 19:07.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.