Kunena 7.0.5 & Kunena 6.4.11 – Security Updates Released

The Kunena team has announce the arrival of Kunena 7.0.5 [K 7.0.5] 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 eleventh version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Solved Error when using Trash Manager

More
13 years 10 months ago - 13 years 10 months ago #129230 by hkymre
*** Noticed on config site was on php 5.2 - moved to 5.3 and working ok ***


Noticed I had a couple of hundred messages in the trash manager so went to delete them.

Selected the first page full (100)
And the page said

Number of Items: Items being Deleted:
0

Pressed delete anyway and this error came up


Code:
#0 KunenaError::checkDatabaseError() called at [/home/sitename/public_html/administrator/components/com_kunena/libraries/forum/topic/topic.php:916] #1 KunenaForumTopic->update() called at [/home/sitename/public_html/administrator/components/com_kunena/libraries/forum/topic/topic.php:1008] #2 KunenaForumTopic->recount() called at [/home/sitename/public_html/administrator/components/com_kunena/libraries/forum/topic/topic.php:1002] #3 KunenaForumTopic->recount() called at [/home/sitename/public_html/administrator/components/com_kunena/libraries/forum/topic/topic.php:946] #4 KunenaForumTopic->update(KunenaForumMessage Object ([id] => 99989,[] => KunenaMessages,[] => JDatabaseMySQL Object ([name] => mysql,[_nullDate] => 0000-00-00 00:00:00,[_nameQuote] => `,[_sql] => SELECT * FROM jos_kunena_messages AS m INNER JOIN jos_kunena_messages_text AS t ON t.mesid=m.id WHERE m.thread='99989' AND m.hold= ORDER BY m.time ASC, m.id ASC,[_errorNum] => 1064,[_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.time ASC, m.id ASC LIMIT 0, 1' at line 2 SQL=SELECT * FROM jos_kunena_messages AS m INNER JOIN jos_kunena_messages_text AS t ON t.mesid=m.id WHERE m.thread='99989' AND m.hold= ORDER BY m.time ASC, m.id ASC LIMIT 0, 1,[_table_prefix] => jos_,[_resource] => Resource id #26,[_cursor] => ,[_debug] => 0,[_limit] => 1,[_offset] => 0,[_ticker] => 0,[_log] => Array (),[_utf] => 1,[_quoted] => Array (),[_hasQuoted] => ,[_errors] => Array (),[debug] => 0),[] => Array (),[] => Array (),[] => KunenaForumTopic Object ([id] => 99989,[unread] => 0,[lastread] => 0,[] => KunenaTopics,[] => JDatabaseMySQL Object ([name] => mysql,[_nullDate] => 0000-00-00 00:00:00,[_nameQuote] => `,[_sql] => SELECT * FROM jos_kunena_messages AS m INNER JOIN jos_kunena_messages_text AS t ON t.mesid=m.id WHERE m.thread='99989' AND m.hold= ORDER BY m.time ASC, m.id ASC,[_errorNum] => 1064,[_errorMsg] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY m.time ASC, m.id ASC LIMIT 0, 1' at line 2 SQL=SELECT * FROM jos_kunena_messages AS m INNER JOIN jos_kunena_messages_text AS t ON t.mesid=m.id WHERE m.thread='99989' AND m.hold= ORDER BY m.time ASC, m.id ASC LIMIT 0, 1,[_table_prefix] => jos_,[_resource] => Resource id #26,[_cursor] => ,[_debug] => 0,[_limit] => 1,[_offset] => 0,[_ticker] => 0,[_log] => Array (),[_utf] => 1,[_quoted] => Array (),[_hasQuoted] => ,[_errors] => Array (),[debug] => 0),[] => Array ([71] => Array ([post.read] => ,[post.delete] => )),[] => Array ([71] => Array ([post.read] => ,[post.delete] => )),[] => Array ([71] => Array ([Read] => ,[Unlocked] => )),[] => 3,[] => 1,[] => ,[] => KunenaForumTopic,[] => 1,[] => ,[_errors] => Array (),[category_id] => 3,[subject] => John Bishop,[icon_id] => 0,[locked] => 0,[hold] => ,[ordering] => 0,[posts] => 13,[hits] => 426,[attachments] => 0,[poll_id] => 0,[moved_id] => 0,[first_post_id] => 0,[first_post_time] => 0,[first_post_userid] => 0,[first_post_message] => ,[first_post_guest_name] => ,[last_post_id] => 0,[last_post_time] => 0,[last_post_userid] => 0,[last_post_message] => ,[last_post_guest_name] => ,[params] => ),[] => 1,[] => 0,[] => KunenaForumMessage,[] => ,[] => ,[_errors] => Array (),[parent] => 0,[thread] => 99989,[catid] => 3,[name] => NVFC1992,[userid] => 1138,[email] => [email protected],[subject] => John xxxxx,[time] => 1338578919,[ip] => 86.29.94.157,[topic_emoticon] => 0,[locked] => 0,[hold] => 1,[ordering] => 0,[hits] => 426,[moved] => 0,[modified_by] => ,[modified_time] => ,[modified_reason] => ,[message] => Sorry if someone has posted this before . http://www.youtube.com/watch?v=SRXXjdWHRyU), 0) called at [/home/sitename/public_html/administrator/components/com_kunena/libraries/forum/message/message.php:640] #5 KunenaForumMessage->update() called at [/home/sitename/public_html/administrator/components/com_kunena/libraries/forum/message/message.php:515] #6 KunenaForumMessage->delete() called at [/home/sitename/public_html/administrator/components/com_kunena/controllers/trash.php:60] #7 KunenaAdminControllerTrash->purge() called at [/home/sitename/public_html/libraries/joomla/application/component/controller.php:236] #8 JController->execute(purge) called at [/home/sitename/public_html/administrator/components/com_kunena/admin.kunena.php:81] #9 require_once(/home/sitename/public_html/administrator/components/com_kunena/admin.kunena.php) called at [/home/sitename/public_html/libraries/joomla/application/component/helper.php:162] #10 JComponentHelper->renderComponent(com_kunena) called at [/home/sitename/public_html/administrator/includes/application.php:136] #11 JAdministrator->dispatch(com_kunena) called at [/home/sitename/public_html/administrator/index.php:67]

Despite the error it did delete the messages.

Deleted the next page full with out any errors.

So two issues - one the error & two the number of messages to be deleted always says zero

This message contains confidential information

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Enabled |

This message contains confidential information
htaccess: Exists | PHP environment: Max execution time: 240 seconds | Max execution memory: 512m | Max file upload: 12M

Kunena menu details:

Warning: Spoiler!

Joomla default template details : rt_tachyon_j15 | author: RocketTheme, LLC | version: 1.5.10 | creationdate: March 27, 2012

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.1 | creationdate: 2012-07-07

Kunena version detailed: Kunena 2.0.1 | 2012-07-07 [ Balozi ]
| Kunena detailed configuration:

Warning: Spoiler!
| Kunena integration settings:
Warning: Spoiler!
| Joomla! detailed language files installed:
Warning: Spoiler!

Third-party components: CommunityBuilder 1.8.1 | UddeIM 2.7

Third-party SEF components: None

Plugins: Content - Kunena Discuss 1.7.2

Modules: Kunena Latest 1.6.4


*** Noticed on config output that site was on php 5.2 - moved to 5.3 and working ok ***
Last edit: 13 years 10 months ago by hkymre. Reason: Solved - wrong level of PHP

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

More
13 years 10 months ago #129245 by xillibit
Hello,

Thanks for report, i have added it to bug list

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.

More
13 years 10 months ago #129368 by xillibit
I can't try to reproduce the issue on my 64 bits system, php 5.2 is unsupported now

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.

More
13 years 9 months ago #130325 by hbmj2
Same Problem
No message deleted!

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

More
13 years 9 months ago #130650 by xillibit
Are-you using too php 5.2 ?

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.

Time to create page: 0.248 seconds