Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post "[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.

 indice

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.

 indice

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.
 



 
Last edited by Aerosmith on Sat 09 Jul, 2011 05:33; edited 1 time in total 
AerosmithSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla 
 
Does anyone could give me a hand with this problem?




¿Alguien me podria dar una mano con este problema?
 



 
AerosmithSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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  

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!!
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.

SHOW INDEX FROM ip_cms_layout_special;
 



 
mortSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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.

 captura

What's the verdict




Hola amigos.

Gracias por responder.

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

 captura

Cual es el veredicto
 



 
AerosmithSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Problems With Indexes Of Table/Problemas Con Los índices De La Tabla 
 
Change the title of this thread to:

"[BUG] SQL Tables creating invalid indexes"

MG will need to look at it?
 



 
mortSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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




Gracias Mort.

Esperare por MG
 



 
AerosmithSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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 before MG asks you  
 




____________
www.DutchaGoGo.com (development/under construction ...Forever?¿?)
 
Joshua203Send private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.




Hola Joshua.

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

Gracias

Spoiler: [ Show ]

 



 
AerosmithSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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 don´t remove them
 




____________
Out of Order
 
spydieSend private messageVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.

Google

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

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



 
mortSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: "[BUG] SQL Tables Creating Invalid Indexes"/"[Bug] Tablas De SQL No Válida La Creación De índices" 
 
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.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post 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.




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.
 



 
AerosmithSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron