3
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