Icy Phoenix

Hello.

I have a problem with the indexes in my database.

Quote:

Problems with indexes of table `` ip_cms_layout_special
Page_id page_id_3 indices and possibly look the same and can be removed one.
Page_id page_id_2 indices and possibly look the same and can be removed one.

He says that the indices are repeated.

What should I do?

Thank you.

---

Hola.

Tengo un problema con los indices de mi Base de Datos.

Quote:

Problemas con los índices de la tabla `ip_cms_layout_special`
Los índices page_id y page_id_3 parecen ser iguales y posiblemente se puede remover uno.
Los índices page_id y page_id_2 parecen ser iguales y posiblemente se puede remover uno.

Me dice que los indices están repetidos.

¿Que debo hacer?

Gracias.

Does anyone could give me a hand with this problem?

---

¿Alguien me podria dar una mano con este problema?

It would not mess up your site to keep them in there until you get some expert advice on this (I think someone will answer eventually.. please wait for that person)

My feeling about this is ..
If you don t know why they are there it should be quite safe to remove 2 and 3, you may have added them by accident in some weird way?
By default there should be only one "Page_id" in the "ip_cms_layout_special" table :wink:

But don't take my word for it .... I'm not an IcyPhoenix expert


EDIT: if you choose to remove them without waiting for a second opinion, make sure that you make a database backup first!!

Run this SQL on your DB - Change the prefix if necessary.

Post results here.

SHOW INDEX FROM ip_cms_layout_special;

Hello friends.

Thanks for responding.

Perform the SQL query you asked mort, the image here.



What's the verdict

---

Hola amigos.

Gracias por responder.

Realice la consulta SQL que me pediste mort, aquí la imagen.



Cual es el veredicto

Change the title of this thread to:

"[BUG] SQL Tables creating invalid indexes"

MG will need to look at it?

Thanks Mort.

I will wait for GM

---

Gracias Mort.

Esperare por MG

I think it would be wise to tell what version/release you are using before MG asks you :wink:

Hi Joshua.

Here is the information you ask for, and a little more.

Thank you.

---

Hola Joshua.

Aqui esta la informacion que pides, y un poco mas.

Gracias

the page ID 2 , 3 and so on come from the posts on index page.

Icy creates automaticly new pages , if the number of posts on index is bigger then given in ACP configuration.

so don´t remove them

These aren't errors, just warnings.

What the error means, is that redundant indexes exist.

It's also not uncommon.

Google

Some explanation of why it's happening and how it can be avoided.

mysql-more-than-one-index-key-for-the-same-column

spydie wrote: [View Post]

the page ID 2 , 3 and so on come from the posts on index page.

Icy creates automaticly new pages , if the number of posts on index is bigger then given in ACP configuration.

so don´t remove them

If that is true, then the mod isn't coded properly, since if you add a key you should not have duplicated values... in my opinion there is no need to have those fields, but I don't know how the mod is working.

Those indices are not present in plain Icy Phoenix, this means that is not an Icy Phoenix bug... but a bug added by one (or more) mod.

Hello friends.

Thanks for the replies.

Check all Mod install, and no SQL query is performed to this table.

I understand, so let everyone agrees.

So for now, do not touch anything.

Thank you all for your answers, links and tips.

---

Hola amigos.

Gracias por las respuestas.

Revise todos los Mod que instale, y en ninguno se realiza consulta SQL a esta tabla.

Segun entiendo, todos concuerdan en dejarlo asi.

Asi que por lo pronto, no tocare nada.

Gracias a todos por sus respuestas, enlaces, y consejos.