Kunena 7.0.6 & Kunena 6.4.12 – Security Updates Released

The Kunena team has announce the arrival of Kunena 7.0.6 [K 7.0.6] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.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.

The Kunena team is also pleased to announce the twelfth version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.

Question Fatal error: Unable to alter fb_subscriptions table

SimonFinch
Topic Author
Offline
New Member

17 years 3 days ago #19213 by SimonFinch

Fatal error: Unable to alter fb_subscriptions table was created by SimonFinch

I've upgraded to FB 1.05 no problems. Now just trying to upgrade to Kunena 1.08. Everything goes ok until I get a meesage about

Installed version: Kunena 1.0.8 | 2009-02-17 | 1166 [ Speakup! ] | php 4.4.7 | mysql 4.1.22-standard

Fatal error: Unable to alter fb_subscriptions table, please contact Kunena team at www.kunena.com!\nDB function failed with error number 0

SQL =

SELECT VERSION() as mysql_version

in /home/mysite/public_html/components/com_kunena/lib/kunena.debug.php on line 59

Any ideas?

Cheers,

Simon

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

xillibit
Offline
Administrator

17 years 3 days ago #19217 by xillibit

Replied by xillibit on topic Re:Fatal error: Unable to alter fb_subscriptions table

Hello,

It will be more helpful to set in the joomla configuration panel on debug mode, for obtain a more precise error message. Why do you upgrade to kunena 1.0.8, you can upgrade to the latest version 1.0.9 or 1.0.10.

I don't provide support by PM, because this can be useful for someone else.

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

SimonFinch
Topic Author
Offline
New Member

17 years 3 days ago - 17 years 3 days ago #19238 by SimonFinch

Replied by SimonFinch on topic Re:Fatal error: Unable to alter fb_subscriptions table

Thanks, I'll try the joomla debug option. I downloaded the latest version (filename com_kunena_v1.0.10_stable_b1344_2009-05-21.tar) However,the output from the install program attached) shows 1.08.

Code:

Upgrading "com_kunena" (Version: 1.0.5RC2 / Version Date: 2008-10-27 / Install Date: 2009-06-10 / Build: 817 / Version Name: Redwood)
 
Version: 1.0.5 (Version Date: 2008-12-1, Build: 855, Version Name: Redwood)
Including file

/home/two1062/public_html/administrator/components/com_kunena/install/kunena.special.upgrade.1.0.5.php

Running SQL Query

CREATE TABLE IF NOT EXISTS `jos_fb_groups`(
                        `id` int(4) NOT NULL  auto_increment  , 
                        `title` varchar(255) NULL   , 
                        PRIMARY KEY (`id`) )

Running SQL Query

CREATE TABLE IF NOT EXISTS `jos_fb_ranks`(
                        `rank_id` mediumint(8) unsigned NOT NULL  auto_increment  , 
                        `rank_title` varchar(255) NOT NULL   , 
                        `rank_min` mediumint(8) unsigned NOT NULL  DEFAULT '0'  , 
                        `rank_special` tinyint(1) unsigned NOT NULL  DEFAULT '0'  , 
                        `rank_image` varchar(255) NOT NULL   , 
                        PRIMARY KEY (`rank_id`) )

Running SQL Query

UPDATE `jos_fb_sessions` SET `allowed`='na'

Running SQL Query

UPDATE `jos_fb_users` SET `rank`=8 WHERE `moderator`=1 AND `rank`=0

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "&#039;", "'")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "&quot;", '"')

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "&nbsp;", " ")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "<br />", "\n")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "<br>", "\n")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "&lt;", "<")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "&gt;", ">")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "&amp;", "&")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[IMG", "[img")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[/IMG]", "[/img]")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[URL", "[url")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[/URL]", "[/url]")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[QUOTE", "[quote")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[/QUOTE]", "[/quote]")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[CODE", "[code")

Running SQL Query

UPDATE `jos_fb_messages_text` SET `message` = REPLACE(`message`, "[/CODE", "[/code")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "&#039;", "'")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "&quot;", '"')

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "&nbsp;", " ")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "<br />", "\n")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "<br>", "\n")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "&lt;", "<")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "&gt;", ">")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "&amp;", "&")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[IMG", "[img")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[/IMG]", "[/img]")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[URL", "[url")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[/URL]", "[/url]")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[QUOTE", "[quote")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[/QUOTE]", "[/quote]")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[CODE", "[code")

Running SQL Query

UPDATE `jos_fb_users` SET `signature` = REPLACE(`signature`, "[/CODE", "[/code")

Version: 1.0.6 (Version Date: 2009-01-10, Build: 870, Version Name: Communicate)
Running SQL Query

ALTER TABLE `jos_fb_messages` ADD KEY `parent_hits`(`parent`,`hits`)

Running SQL Query

ALTER TABLE `jos_fb_users` ADD KEY `posts` ( `posts` )

Running SQL Query

ALTER TABLE `jos_fb_users` ADD KEY `uhits` ( `uhits` )

Version: 1.0.8 (Version Date: 2009-02-17, Build: 1166, Version Name: Speakup!)
variable 	value
$0	"
key 	value
$file	"/home/two1062/public_html/components/com_kunena/lib/kunena.debug.php"
$line	"45"
$function	"debug_callstackinfo"
[args]	Nested Array
"
$1	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_kunena/install/kunena.special.upgrade.1.0.8.php"
$line	"53"
$function	"trigger_dberror"
[args]	Nested Array
"
$2	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_kunena/lib/fx.upgrade.class.php"
$line	"328"
[args]	Nested Array
$function	"require"
"
$3	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_kunena/lib/fx.upgrade.class.php"
$line	"295"
$function	"processnode"
$class	"fx_upgrade"
$type	"->"
[args]	Nested Array
"
$4	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_kunena/install/kunena.install.php"
$line	"98"
$function	"doupgrade"
$class	"fx_upgrade"
$type	"->"
[args]	Nested Array
"
$5	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_installer/component/component.class.php"
$line	"195"
$function	"com_install"
[args]	Nested Array
"
$6	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_installer/admin.installer.php"
$line	"147"
$function	"install"
$class	"mosinstallercomponent"
$type	"->"
[args]	Nested Array
"
$7	"
key 	value
$file	"/home/two1062/public_html/administrator/components/com_installer/admin.installer.php"
$line	"51"
$function	"installfromdirectory"
[args]	Nested Array
"
$8	"
key 	value
$file	"/home/two1062/public_html/administrator/index2.php"
$line	"69"
[args]	Nested Array
$function	"require_once"
"
Installed version: Kunena 1.0.8 | 2009-02-17 | 1166 [ Speakup! ] | php 4.4.7 | mysql 4.1.22-standard

Fatal error: Unable to alter fb_subscriptions table, please contact Kunena team at www.kunena.com!\nDB function failed with error number 0

SQL =

SELECT VERSION() as mysql_version

in /home/two1062/public_html/components/com_kunena/lib/kunena.debug.php on line 59

Last edit: 17 years 3 days ago by SimonFinch.

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

xillibit
Offline
Administrator

17 years 3 days ago #19242 by xillibit

Replied by xillibit on topic Re:Fatal error: Unable to alter fb_subscriptions table

This problem has been reported some time, but now there is no solutions for this.

I don't provide support by PM, because this can be useful for someone else.

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

SimonFinch
Topic Author
Offline
New Member

17 years 3 days ago #19243 by SimonFinch

Replied by SimonFinch on topic Re:Fatal error: Unable to alter fb_subscriptions table

Does this mean that I can't upgrade to Kunena at all?

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

Matias
Offline
Administrator

17 years 3 days ago #19252 by Matias

Replied by Matias on topic Re:Fatal error: Unable to alter fb_subscriptions table

It has been reported? Wow, how did I miss it.

I think I know how to fix this one. Can you make me account to your site (admin)? Also access to the database would help me.

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

Time to create page: 0.303 seconds