go to phpmyadmin drop the index from the table and then run this one:
ALTER TABLE `cache_forumhome` ADD INDEX ( `userid` )

@Aaron: yes, the table will grow depending on your ammount of online users at the same time, but it should change dynamically, so it would also decrease after 5 hours again :) (you can try to change this value in the hack if you want :))

I am not sure if this is addressed to all of us, therefore: is this something we need to do? :)
Ps, i have no experience in dropping indexes, but dropping tables i have done before! Is that the same thing perhaps?

it was for all of you

i think the index makes the problem you posted before :)

no, droping indexes isn't the same as droping the table ;)

but you can drop the whol table and recreate it again with the new install file, then it should work also :)

Hehe, ok thanks! I will give it a try! :)
I will keep you informed...

Just for incase of disaster, you can take a look at my phpmyadmin screendump. Let me know it it looks alright :)

looks as it should now :)

oh, sadistically as i am i've uploaded another new version now *gg*

it's just a small cahnge in the caching php-code but it can save a lot of db-space if you have instelled the zlib on your php-module

if you install the new version be sure your empty the table before, if not the old format will be coruppted till the next cache update ;)

I just checked with a simple phpinfo script:

ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.3
Linked Version 1.1.3

I seem to have it installed :)
Thanks

:)
then i'm sure it'll reduce the space used in DB a lot :)

Installed! Looks ok by me, but i seem to use 1 querie more somehow. But that could 'i hope' fluctuate...

Page loaded in 1.86 seconds - 28.95% Php - 71.05% MySql with 21 queries.