Is on the right side of your abnincp under post thanks.
Did you optimize through your board or phpmyadmin?

If the board do it from phpmyadmin.

When I did it it was through PHPmyadmin. I am currently on the last recounter 'rebuild' right now. Hopefully that will help speed things up a tad. Weird that this would be the one thing affected during the move (that I'm aware of).

Thanks again!

As it's going through the last counter - Update Post Thanks Post Amount - which I think is about 670k posts... It got to about 130k and really bogged down there, I got an email report that the SQL server has gone away, and then it picked back up and is very smooth since. Does it make sense that it would get to a certain portion of the counter and die down, and then get through it? Would that potentially point to an issue in that 'counted' area, or maybe now that it's doing its recounting it may have fixed what was wrong in the database?

Just rambling until it's done! I just love the thanks hack and the recent thanks, hoping not to lose either of them!

If it stumbled on something that wasn't right it will load sql.
It could of been a moved or deleted post or thread. Never know.
All you know atm is something isn't right
Hope it will correct any issue.
Trouble shooting after a move is time consuming.

Hood luck

I did all of the above earlier today and things seemed a little smoother for awhile. Now it's back to just hanging when I click on recent thanks, or taking an awfully long time, and getting sporadic emails with recent_thanks as the script and that the mysql server has gone away. But again, it's not the server, as everything else loads quickly and flawlessly.

Is my only option going to be to remove the post thanks 7.83? I've reuploaded and overwrote all files and reinstalled the xml, but I'm hoping to not have to uninstall and lose what took so long to accumulate. :(

Thanks!

Just to add, which is odd, but this seems to happen each time now... Once the issue starts, then it gets worse, then it worsens until the SQL server hangs and I get the error. Often, after that, it miraculously starts working for awhile again, and flawlessly, until it starts again. But through it all, nothing else is affected. And what I mean by that is every automated email I get is in reference to recent_thanks, and nothing else ever hangs up when clicked on.

I'm in a little bit of distress mode now! LOL

I decided this morning to uninstall the post thanks 7.83 hack and start over. But when I click on uninstall, it just sits there forever. Something must be screwy in the database. Tried like 10x and can't uninstall. But now, opening ANY thread on the board (where a thanks must have been made), the thread won't open and I get a SQL error as noted below. Anyway to fix this and uninstall the post thanks and recent thanks hack manually?

Thanks!

For future readers in a similar situation, at least I figured out my uninstall problem. I first went into "plugin manager" and deactivated all "post thank you" references. Then I uninstalled the "recent thanks" hack first. Then it let me uninstall the post thanks hack finally. I don't know if removing the other hack allowed me to uninstall the other, or if it was deactivating plugins, or just sheer luck.

I completelt reinstalled everything from scratch again, just like I did from the get go. Hopefully that will put and end to my issue!

:crossing finger smiley:

Thanks!

4.2.2 does not work on how to make it work?

Maybe posting any error logs or something to show us its not working for you as its hard to guess