No idea. If it sees the index it wont try and add it.

Welp.. If you give up, so do I... Nice feature.. Not worth the headache

And it doesn't seem I am the only one with a similar problem. Nor do I have a problem with any other products

Since I have neither access to your server or forum, there is nothing I can do. I cant just produce magic answers out of thin air. :)

I dont see anyone else having an issue creating the index.

How many of those "other products" create an index on (or alter) the post table, Im guessing none, since they obviously would have the same problem (the issue is mysql creating the index, not the product).

I understand that.. And I will continue to enjoy the majority of your addons and appreciate your effort in making them.. Unfortunately this one just isn't working out.


I noticed you said something about the problem of the index being created slow and timing out in post # 28... Which is similar to my issue I guess (or at least I thought).. Weird thing is, that the index is created.. I verified it's there. Perhaps it is something on mysql, but I can't imagine what since I am having no other issues with anything whatsoever. Not really meaning to point fingers as you may have taken it that way. Just lost for a solution as I have no other symptoms to go off of

If you are absolutely sure the index has been created, you can simply comment out the line in the product xml that tries to create it, it will then install (line 76 I believe). Be aware that if the index isnt created ok, you may find the top posters page slow to generate and load.

I appreciate the fact you still do want to help Paul.. I really do.. I more wanted to give up because I don't want to burden you. But since you posted again.. :)

As far as I can tell, it is created. But my knowledge in this stuff is quite limited. I actually started combing over the product to find where it instructs to create the index. I wasn't sure so I decided to lay off. In any case, before I try the commenting out.. Take a looksy at these screen shots and tell me if it appears that it is created and created successfully. Thanks again for taking the time to respond. I really don't want to be a pain.. Just check these out and tell me if you see any issue with the index... I think its ok.. But I would feel comfortable knowing someone who knows a lot more thinks its ok before I take a suggestion that starts with 'If you are absolutely sure the index has been created'.. lol Sorry that this is going out of the scope of what you would normally support. I understand if you decline to continue

Neither of those screenshots shows the indexes, they are listed in phpmyadmin under the structure listing (see screenshot). You can also run the following command to list them ;

SHOW INDEX FROM post

Eeek... Problem found

My guess would be to start by deleting all the dateline indexes and then the dateline field? Then attempt reimporting again? Might end up with the same results

Hope I said that right...

I also noticed some tables named postindex_temp*****-*** that may or may not have been there before and may or may not have anything to do with this. I get by with people's help on here or other forums.. Sorry for my noobishness

You can delete all the indexes listed except these four : PRIMARY, userid, threadid, dateline.


Do not delete the dateline field in your database, you will break your forum, bigtime.

This kills my DB as well, btw. Just tried installing it on a fresh DB, it creates the index then corrupts my post table.

The hack should have some kind of note/warning for users with big forums, as it creates an index on one of the biggest tables in the DB (post).

Edited for clarity: Folks may need to set their mysql timeouts higher for this to run on big tables.