Kunena 6.3.0 released

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

Question Fatal error: Unable to alter fb_subscriptions table

SimonFinch
Topic Author
Offline
New Member

14 years 10 months ago #1 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

14 years 10 months ago #2 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

14 years 10 months ago - 14 years 10 months ago #3 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: 14 years 10 months ago by SimonFinch.

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

xillibit
Offline
Administrator

14 years 10 months ago #4 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

14 years 10 months ago #5 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

14 years 10 months ago #6 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.

xillibit
Offline
Administrator

14 years 10 months ago #7 by xillibit

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

It hasn't reported before, now it is.

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

14 years 10 months ago #8 by SimonFinch

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

Matias,

Great, thanks for the offer, I'm at work at the moment but I'll set you up an admin account on my site and db access then PM you with the details.

Your help appreciated.

Simon

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

SimonFinch
Topic Author
Offline
New Member

14 years 10 months ago #9 by SimonFinch

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

Matias,

I've PM'd you. Thanks

Simno

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

Matias
Offline
Administrator

14 years 10 months ago #10 by Matias

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

The table was missing index. Everything should work now.

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

Time to create page: 0.540 seconds