Important Forum crash

My error:

JDatabaseMySQL::query: 1064 - Something is wrong in your syntax obok '( SELECT thread, MAX(time) AS lastpost ' w linii 10 SQL=SELECT a.*, t.message AS messagetext, m.mesid AS attachmesid, f.thread AS favthread, u.avatar, c.name AS catname, b.lastpost FROM jos_fb_messages AS a JOIN ( SELECT thread, MAX(time) AS lastpost FROM jos_fb_messages WHERE time >'1231265664' AND hold=0 AND moved=0 AND catid IN (1,2,3,4,5,6,7) GROUP BY 1) AS b ON b.thread = a.thread JOIN jos_fb_messages_text AS t ON a.thread = t.mesid LEFT JOIN jos_fb_categories AS c ON c.id = a.catid LEFT JOIN jos_fb_attachments AS m ON m.mesid = a.id LEFT JOIN jos_fb_favorites AS f ON f.thread = a.id && f.userid = 0 LEFT JOIN jos_fb_users AS u ON u.userid = a.userid WHERE a.parent=0 AND a.moved=0 AND a.hold=0 GROUP BY a.id ORDER BY lastpost DESC LIMIT 0,20

Call stack
# Function Location
1 jsite->dispatch() c:\usr\krasnal\www\sobi\index.php:68
2 jcomponenthelper::rendercomponent() c:\usr\krasnal\www\sobi\includes\application.php:124
3 require_once() c:\usr\krasnal\www\sobi\libraries\joomla\application\component\helper.php:162
4 include() c:\usr\krasnal\www\sobi\components\com_kunena\kunena.php:763
5 database->loadobjectlist() c:\usr\krasnal\www\sobi\components\com_kunena\template\default_ex\latestx.php:161
6 database->query() c:\usr\krasnal\www\sobi\libraries\joomla\database\database\mysql.php:458
7 jerror::raiseerror() c:\usr\krasnal\www\sobi\libraries\joomla\database\database\mysql.php:231
8 jerror::raise() c:\usr\krasnal\www\sobi\libraries\joomla\error\error.php:171
9 jexception->jobject() c:\usr\krasnal\www\sobi\libraries\joomla\error\error.php:136
10 call_user_func_array() c:\usr\krasnal\www\sobi\libraries\joomla\base\object.php:48
11 jexception->__construct()

As Matias asked before:

1.) Please provide the Kunena version and build you are running
2.) php and mysql versions

From what I can tell this could be a version conflict with an old/outdated MySQL install. The next version of Kunena (1.0. includes a version check during the install and will not allow the install to start/complete if the minimum versions are not present on the system.

Thx!

fxstein

@ piotrkaz:

That query runs fine in MySQL 5.0.54 and 5.0.67

You seem to have older version which does not support that query. Can you share us your MySQL version?

I have upgrated mysql server to version no.: 5.0.45.
The old version of my mysql server was 3......
Everything is working now.

Thank you for helping me.

piotrkaz wrote:

I have upgrated mysql server to version no.: 5.0.45.
The old version of my mysql server was 3......
Everything is working now.

Thank you for helping me.

Glad we could help. As I said the next verison 1.0.8 we do a version check prior to the install/upgrade to avoid these kinds of problems to start with.

Have a great day!

fxstein

@nix:

Is that possibly the same root cause for your problem?