Hi...
Just made a clean install of FB 1.05 og Joomla 1.56 and all looks fine.
Then added a category abd published it (tried with subcategory too)- then this happened:
Fatal error: Unable to load recent messages.nDB function failed with error number 1064
You have an error in your SQL syntax near 'SELECT msg1.* FROM (SELECT msg2.* FROM jos_fb_messages msg2 WHERE msg2.hold = 0 ' at line 1 SQL=SELECT u.id, IFNULL(u.username, 'Gæst'
AS username, IFNULL(u.name,'Gæst'
AS name, msg.subject, msg.id AS fbid, msg.catid, from_unixtime(msg.time) AS date, thread.hits AS hits, msg.locked, msg.topic_emoticon, msg.parent, cat.name AS catname FROM (SELECT msg1.* FROM (SELECT msg2.* FROM jos_fb_messages msg2 WHERE msg2.hold = 0 AND moved=0 AND msg2.catid IN (1) ORDER BY msg2.time DESC) msg1 GROUP BY msg1.thread) msg LEFT JOIN jos_users u ON u.id = msg.userid LEFT JOIN jos_fb_categories cat ON cat.id = msg.catid LEFT JOIN jos_fb_messages thread ON thread.id = msg.thread ORDER BY msg.time DESC LIMIT 10
SQL =
SELECT u.id, IFNULL(u.username, 'Gæst'
AS username, IFNULL(u.name,'Gæst'
AS name, msg.subject, msg.id AS fbid, msg.catid, from_unixtime(msg.time) AS da in componentscom_fireboardsourcesfb_debug.php on line 37
Nyeste indlæg
variable value
$0 "key value
$file "componentscom_fireboardsourcesfb_debug.php"
$line "36"
$function "debug_callstackinfo"
[args] Nested Array
"
$1 "key value
$file "componentscom_fireboardsourcesfb_debug.php"
$line "45"
$function "trigger_dberror"
[args] Nested Array
... and so on
Unpublishing the category makes everything look fine again.
Tested as guest and admin with same result!
Everything works great until categories are published.
Regards
Bo
Favoured: 0
