|
Page 1 of 1
|
Aerosmith
Joined: August 2006
Posts: 51
Location:
|
"[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.
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.
Last edited by Aerosmith on Sat 09 Jul, 2011 05:33; edited 1 time in total |
#1 Tue 05 Jul, 2011 02:14 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
|
Aerosmith
Joined: August 2006
Posts: 51
Location:
|
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?
|
#2 Thu 07 Jul, 2011 15:20 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
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?¿?)
|
#3 Fri 08 Jul, 2011 09:02 |
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
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;
|
#4 Fri 08 Jul, 2011 10:10 |
|
Aerosmith
Joined: August 2006
Posts: 51
Location:
|
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.
What's the verdict
Hola amigos.
Gracias por responder.
Realice la consulta SQL que me pediste mort, aquí la imagen.
Cual es el veredicto
|
#5 Fri 08 Jul, 2011 20:11 |
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
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?
|
#6 Sat 09 Jul, 2011 01:46 |
|
Aerosmith
Joined: August 2006
Posts: 51
Location:
|
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
|
#7 Sat 09 Jul, 2011 05:35 |
|
Joshua203
Joshua 203
Dutch A Go Go
Joined: August 2008
Posts: 1754
Location: Earth, Europe, the Netherlands, Rotterdam
|
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?¿?)
|
#8 Sat 09 Jul, 2011 11:05 |
|
Aerosmith
Joined: August 2006
Posts: 51
Location:
|
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
URL: 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)
|
#9 Sat 09 Jul, 2011 17:30 |
|
spydie
Joined: December 2008
Posts: 1796
Location: In the Boxes
|
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
|
#10 Sat 09 Jul, 2011 18:45 |
|
mort
Spam Basher
Joined: August 2010
Posts: 998
Location: Up a tree
|
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
|
#11 Sun 10 Jul, 2011 00:27 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7191
Location: Borgo San Michele
|
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
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
|
#12 Sun 10 Jul, 2011 21:00 |
|
Aerosmith
Joined: August 2006
Posts: 51
Location:
|
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.
|
#13 Wed 13 Jul, 2011 06:24 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
Link this topic |
URL |
|
BBCode |
|
HTML |
|
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
|
|
|
|