https://www.icyphoenix.com/viewtopic.php?f=35&t=7911
-----------------------------------
Aerosmith
Tue 05 Jul, 2011 02:14

"[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
Hello.

I have a problem with the indexes in my database.

 [img]http://www.icyphoenix.com/files/images/141/indice.png[/img]

[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.[/quote]

He says that the indices are repeated.

What should I do?

Thank you.

[hr]

Hola.

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

 [img]http://www.icyphoenix.com/files/images/141/indice.png[/img]

[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.[/quote]

Me dice que los indices están repetidos.

¿Que debo hacer?

Gracias.


-----------------------------------
Aerosmith
Thu 07 Jul, 2011 15:20

Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla
-----------------------------------
Does anyone could give me a hand with this problem?

[hr]

¿Alguien me podria dar una mano con este problema?


-----------------------------------
Joshua203
Fri 08 Jul, 2011 09:02

Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla
-----------------------------------
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!!


-----------------------------------
mort
Fri 08 Jul, 2011 10:10

Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla
-----------------------------------
Run this SQL on your DB - Change the prefix if necessary.

Post results here.

[b]SHOW INDEX FROM ip_cms_layout_special;[/b]


-----------------------------------
Aerosmith
Fri 08 Jul, 2011 20:11

Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla
-----------------------------------
Hello friends.

Thanks for responding.

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

 [img]http://www.icyphoenix.com/files/images/141/captura.png[/img] 

What's the verdict

[hr]

Hola amigos.

Gracias por responder.

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

 [img]http://www.icyphoenix.com/files/images/141/captura.png[/img] 

Cual es el veredicto


-----------------------------------
mort
Sat 09 Jul, 2011 01:46

Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla
-----------------------------------
Change the title of this thread to:

"[b][BUG] SQL Tables creating invalid indexes[/b]"

MG will need to look at it?


-----------------------------------
Aerosmith
Sat 09 Jul, 2011 05:35

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
Thanks Mort.

I will wait for GM

[hr]

Gracias Mort.

Esperare por MG


-----------------------------------
Joshua203
Sat 09 Jul, 2011 11:05

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
I think it would be wise to tell what version/release you are using [u]before[/u] MG asks you  :wink:


-----------------------------------
Aerosmith
Sat 09 Jul, 2011 17:30

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
Hi Joshua.

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

Thank you.

[hr]

Hola Joshua.

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

Gracias

[spoiler]URL: [url=http://acuaristasdevenezuela.com.ve/portal]Web
Template: Frozen Phoenix, the defect with Icy Phoenix 1.3.0.53b 
MODs installed:
- Topic Cement
- Limit Post Edit Time
- Medal Mod
- Obligue A User To Post First In Presentations
- Simlpe Karma System
- Tips By Post
- BBcodes In Quick Reply
- Logout confirmation
- ACP Announcement Centre
- Posting Template
- Thanks Per Post
- Counter complete statistics.
PhpBB Version: Icy Phoenix 1.3.0.53b 
Installed patches: None
Server: http://www.calcanet.com (payment) 
If an upgrade from another version Icy Phoenix: 1.27  
If an upgrade from another version of phpBB: No (clean installation)[/spoiler]


-----------------------------------
spydie
Sat 09 Jul, 2011 18:45

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
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 [b]don´t[/b] remove them


-----------------------------------
mort
Sun 10 Jul, 2011 00:27

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
These aren't errors, just warnings.

What the error means, is that redundant indexes exist.

It's also not uncommon.

[url=http://www.google.com.au/search?q=More+than+one+INDEX+key+was+created+for&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a]Google

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

[url=http://stackoverflow.com/questions/6147131/mysql-more-than-one-index-key-for-the-same-column]mysql-more-than-one-index-key-for-the-same-column


-----------------------------------
Mighty Gorgon
Sun 10 Jul, 2011 21:00

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
[quote user="spydie" post="53099"]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 [b]don´t[/b] remove them[/quote]
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.


-----------------------------------
Aerosmith
Wed 13 Jul, 2011 06:24

Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices"
-----------------------------------
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.

[hr]

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.


