Kunena 7.0.8 Released

The Kunena team has announce the arrival of Kunena 7.0.8 [K 7.0.8] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question upgrade

More
10 years 10 months ago #168609 by sublevel4
upgrade was created by sublevel4
when i logged in it the site indicated that there was and update to Kunena available. So i told it to update. i got the following error
Code:
SQL Query: UPDATE `#__kunena_user_categories` SET `allreadtime_new`=if(UNIX_TIMESTAMP(`allreadtime`), UNIX_TIMESTAMP(`allreadtime`), `allreadtime`); ... FAILED SQL Query: ALTER TABLE `#__kunena_user_categories` DROP `allreadtime` ; ... FAILED SQL Query: ALTER TABLE `#__kunena_user_categories` CHANGE `allreadtime_new` `allreadtime` INT(11) NOT NULL DEFAULT '0'; ... FAILED SQL Query: UPDATE #__kunena_user_categories AS c INNER JOIN #__kunena_sessions AS s ON c.user_id=s.userid SET c.allreadtime=s.lasttime WHERE c.category_id=0 AND s.lasttime>c.allreadtime; ... FAILED

Now forum is stuck in maintenance mode and won't install. What do I need to do to fix this?

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #168610 by 810
Replied by 810 on topic upgrade
from which version are you updating?

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #168611 by sublevel4
Replied by sublevel4 on topic upgrade
Hmmm.... i was trying to figure that out. I didn't look before i clicked upgrade, I should have checked.

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #168616 by sozzled

sublevel4 wrote: Now the forum is stuck in maintenance mode and won't install.

You may still be able to access your configuration report . If you can access your configuration report, it may help to post the information here.

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #168638 by sublevel4
Replied by sublevel4 on topic upgrade
The configuration report said 4.0.5 :(

I added the column and then the install worked, not neat and tidy but my forum is back up. Thank you all for the help I wish i could have provided more information to help in the future.

Dylan

Please Log in or Create an account to join the conversation.

More
10 years 6 months ago #172626 by chrimisotof
Replied by chrimisotof on topic upgrade
I have the same problem.



Kunena installatie mislukt!
SQL Query: UPDATE `#__kunena_user_categories` SET `allreadtime_new`=if(UNIX_TIMESTAMP(`allreadtime`), UNIX_TIMESTAMP(`allreadtime`), `allreadtime`); ... FAILED

Bereid installatie voor ... OK
Bezig met installeren van Kunena - Alphauserpoints plugin ... OK
Bezig met installeren van Kunena - Community plugin ... OK
Bezig met installeren van Kunena - Comprofiler plugin ... OK
Bezig met installeren van Kunena - Gravatar plugin ... OK
Bezig met installeren van Kunena - Uddeim plugin ... OK
Bezig met installeren van Kunena - Kunena plugin ... OK
Bezig met installeren van Kunena - Joomla plugin ... OK
SQL Query: UPDATE `#__kunena_user_categories` SET `allreadtime_new`=if(UNIX_TIMESTAMP(`allreadtime`), UNIX_TIMESTAMP(`allreadtime`), `allreadtime`); ... FAILED
SQL Query: ALTER TABLE `#__kunena_user_categories` DROP `allreadtime` ; ... FAILED
SQL Query: ALTER TABLE `#__kunena_user_categories` CHANGE `allreadtime_new` `allreadtime` INT(11) NOT NULL DEFAULT '0'; ... FAILED
SQL Query: UPDATE #__kunena_user_categories AS c INNER JOIN #__kunena_sessions AS s ON c.user_id=s.userid SET c.allreadtime=s.lasttime WHERE c.category_id=0 AND s.lasttime>c.allreadtime; ... FAILED
Database bijgewerkt naar versie 3.0.94 ... OK

Please Log in or Create an account to join the conversation.

Time to create page: 0.249 seconds