Ok I am trying to sort all these problems in the deep end of the pool before I can paddle.

Mysql website is so hard to follow

My question is this, when I have duplicate enteries for indexs, can i remove one?

Quote:

I have on some and kept just the primary index and not the extra index and the modules still appers to work.

As if it specifies the same id, primary is still an index so my logic says you only need one index with the data, not 2, one primary and 1 index?

Yet which am I suposed to keep?

First things first. Are you talking about XOOPS core tables, or indexes you've created on your own tables? And if you're relying on PhpMyAdmin to tell you that you've got duplicate indexes, then don't trust it. It has a bug that incorrectly gives a warning, when in fact the index and primary key are NOT the same.

Correctly used indexes makes getting records from a database table quicker. Deleting the index normally won´t break anything (most of the time), but it can make record selection slower if your queries were designed to use the index.

Deleting a primary key is a very bad move.

What are you trying to achieve by deleting indexes and primary keys?

Well I was trying to fix errors in xoops, as i have just lost my site from using 98% resources of the server.

2 years work gone like that!! They gave me no warning and then said do a fresh install, and if it is better you can have your site back.

As you are using to much resources, so I have spent the day trying to reduce errors on my home copy.

As you say phpadmin, says these are errors, as the index is used twice for the same id.

These are some of the XOOPS modules like randon quotes which has primary key =id and index =id

So I removed the index=id and it still works ok, as primary is also and index.

I am so stressed with it all

Indexes are not your problem. If anything, they would help use less resources, I'd say. Don't listen to phpMyAdmin about indexes, their warnings on indexes are rubbish.