Question Install warning - Upgrade from 1.0.7b to 1.0.8

I got the following messages when upgrading Kunena from 1.0.7b to 1.0.8

Warning: Unable to fix fb_favorites table. All Favorites will be removed.\nDB function failed with error number 1044
Access denied for user 'xxx'@'%' to database 'xxx' SQL=CREATE TEMPORARY TABLE jos_fb_temp SELECT thread, userid FROM jos_fb_favorites WHERE userid>0 GROUP BY thread, userid
SQL =

CREATE TEMPORARY TABLE jos_fb_temp SELECT thread, userid FROM jos_fb_favorites WHERE userid>0 GROUP BY thread, userid

in xxx\components\com_kunena\lib\kunena.debug.php on line 69

Warning: Unable to fix fb_subscriptions table. All Subscriptions will be removed.\nDB function failed with error number 1044
Access denied for user 'xxx'@'%' to database 'xxx' SQL=CREATE TEMPORARY TABLE jos_fb_temp SELECT thread, userid, future1 FROM jos_fb_subscriptions WHERE userid>0 GROUP BY thread, userid
SQL =

CREATE TEMPORARY TABLE jos_fb_temp SELECT thread, userid, future1 FROM jos_fb_subscriptions WHERE userid>0 GROUP BY thread, userid
xxx\components\com_kunena\lib\kunena.debug.php on line 69

I hope this is all the info that you need. If you need any more then just ask and I will do my best to answer.

EDIT: Having a quick play around and it seems to have installed ok. All features seem to be working as expected and it showed Install:Successful

Many thanks.

Hi,

Yes we expect to see this on some system. It is non critical - just a warning.

There was a severe security vulnerability in prior releases that allowed unregistered users to submit countless subscription and favorite requests to the server. This could have eventually crashed the server.

In order to fix the problem we had to cleanup the existing tables.

The warning is because your MySQL user id does not have the proper authorization to perform a create temporary table statement.

The fall back logic is to remove all favorites and subscriptions if invalid ones have been detected.

We appologize for the warning but had to code a logic that guarantees that security and content is restored.

FYI This is an old FB security bug, most likely there since very early releases, potentially dating back to before FB.

The install finishes even if you encounter these warnings.

We will add it to the requirements pages and FAQ so other know what is happening here.

Have a great day!

fxstein

Thanks for the quick reply.
I see that it isn't a problem, unfortunately I am with a shoddy host who doesn't allow temporary tables.
Thanks for the great work, having a quick look and so far it does seem quicker. I will post back with anything I notice.

Again, thanks. Now time to hit the pub for a week or 2?