Idea "Unable to save result set in ..." error message

Profile Information
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 0.073 seconds, 4.11 MB
Application afterRoute: 0.081 seconds, 4.54 MB
Application afterDispatch: 0.198 seconds, 8.25 MB
Application afterRender: 0.486 seconds, 11.87 MB
Memory Usage
12542140
Queries logged

1.
SELECT *
FROM jos_session
WHERE session_id = 'c44018caf88d017c80832f2f53e1b339'
2.
DELETE
FROM jos_session
WHERE ( time < '1294917183' )
3.
SELECT *
FROM jos_session
WHERE session_id = 'c44018caf88d017c80832f2f53e1b339'
4.
UPDATE `jos_session`
SET `time`='1294920783',`userid`='62',`usertype`='Super Administrator',`username`='Chris',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:37;s:19:\"session.timer.start\";i:1294911398;s:18:\"session.timer.last\";i:1294920254;s:17:\"session.timer.now\";i:1294920452;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13\";s:8:\"registry\";O:9:\"JRegistry\":{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"Chris\";s:5:\"email\";s:22:\"\";s:8:"2c666bb354adff5a5fa1ac396a51113e:k8tqPaz65aUbmUkT2gEFc8GQm9xMd2eJ\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-06-18 11:49:33\";s:13:\"lastvisitDate\";s:19:\"2011-01-12 18:32:12\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:58:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=5.5\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;s:7:\"_para";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"f02d191e1efb1d2f8a9d563cd7f0092f\";s:12:\"jd_edit_user\";a:2:{s:2:\"id\";s:2:\"62\";s:7:\"file_id\";s:3:\"370\";}}comments-captcha-code|s:5:\"549bk\";'
WHERE session_id='c44018caf88d017c80832f2f53e1b339'
5.
SELECT *
FROM jos_components
WHERE parent = 0
6.
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
7.
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
8.
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
9.
SELECT *
FROM jos_jcomments_settings
10.
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 2
AND a.state >= 0
ORDER BY f.ordering
LIMIT 0, 9
11.
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 2
AND a.state >= 0
ORDER BY f.ordering
12.
SELECT count(*)

FROM jos_jcomments

WHERE object_id = 171

AND object_group = 'com_content'
13.
SELECT count(*)

FROM jos_jcomments

WHERE object_id = 170

AND object_group = 'com_content'
14.
SELECT count(*)

FROM jos_jcomments

WHERE object_id = 164

AND object_group = 'com_content'
15.
SELECT count(*)

FROM jos_jcomments

WHERE object_id = 167

AND object_group = 'com_content'
16.
SELECT count(*)

FROM jos_jcomments

WHERE object_id = 163

AND object_group = 'com_content'
17.
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
18.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_jdownloads'
AND published = 1
19.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_jdownloads&view=viewcategories'
AND published = 1
20.
SELECT cat_id
FROM jos_jdownloads_cats
WHERE published = 1
AND cat_access <= 22
21.
SELECT *
FROM jos_jdownloads_files
WHERE published = 1
AND cat_id IN (1,2,4,3,5,6,7,
ORDER BY downloads DESC
LIMIT 12
22.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-01-13 12:13:03' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2011-01-13 12:13:03' )
AND s.id > 0
AND a.access <= 2
AND cc.access <= 2
AND s.access <= 2
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 6
23.
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND s.id > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-01-13 12:13:03' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2011-01-13 12:13:03' )
AND a.access <= 2
AND cc.access <= 2
AND s.access <= 2
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 0, 6
24.
SELECT *
FROM jos_kunena_config
25.
SELECT *
FROM jos_kunena_sessions
WHERE userid = '62'
26.
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='62'
ORDER BY g.id
27.
SELECT c.id, c.pub_access, c.pub_recurse, c.admin_access, c.admin_recurse

FROM jos_kunena_categories c

WHERE published='1'
28.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id = 62
29.
SELECT COUNT(DISTINCT t.thread)
FROM jos_kunena_messages AS t

INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread

WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)

AND t.hold IN (0,1,2,3)
AND t.moved=0
AND t.catid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)
AND t.time>'1292328784'
30.
SELECT m.id, MAX(t.id) AS lastid
FROM jos_kunena_messages AS t

INNER JOIN jos_kunena_messages AS m
ON m.id=t.thread

WHERE m.moved='0'
AND m.hold IN (0,1,2,3)
AND m.catid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)

AND t.hold IN (0,1,2,3)
AND t.moved='0'
AND t.catid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42)
AND t.time>'1292328784'

GROUP BY t.thread

ORDER BY lastid DESC
LIMIT 0, 18
31.
SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments,
l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, c.name AS catname, c.class_sfx

FROM (
SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL
AND f.userid='62') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount,
COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='62', m.id, NULL)) AS mycount,
MAX(m.id) AS lastid, MAX(IF(m.userid='62', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime

FROM jos_kunena_messages AS m
LEFT JOIN jos_kunena_favorites AS f
ON f.thread = m.thread

LEFT JOIN jos_kunena_attachments AS a
ON a.mesid = m.id

WHERE m.hold IN (0,1,2,3)
AND m.moved='0'
AND m.thread IN (67,82,81,72,73,74,75,71,70,55,65,64,63,62,59,58,2,56)

GROUP BY thread
) AS l

INNER JOIN jos_kunena_messages AS a
ON a.thread = l.thread

INNER JOIN jos_kunena_messages_text AS t
ON a.id = t.mesid

LEFT JOIN jos_users AS j
ON j.id = a.userid

LEFT JOIN jos_kunena_users AS u
ON u.userid = j.id

LEFT JOIN jos_kunena_categories AS c
ON c.id = a.catid

LEFT JOIN jos_kunena_attachments AS aa
ON aa.mesid = a.id

WHERE (a.parent='0' OR a.id=l.lastid )

GROUP BY a.id

ORDER BY lastid DESC
32.
SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS k
ON k.userid=u.id

INNER JOIN jos_session AS s
ON s.client_id=0
AND s.userid=u.id

GROUP BY s.userid

ORDER BY username ASC
33.
SELECT id, username AS username
FROM jos_users
WHERE block='0' OR activation=''
ORDER BY id DESC
LIMIT 0, 1
34.
SELECT u.name, u.username, u.block AS blocked, ku.*

FROM jos_users AS u

LEFT JOIN jos_kunena_users AS ku
ON u.id = ku.userid

WHERE u.id IN (62,90,147,71,131,154)
35.
SELECT thread, MIN(id) AS lastread, SUM(1) AS unread
FROM jos_kunena_messages
WHERE hold IN (0,1,2,3)
AND moved='0'
AND thread NOT IN (0)
AND thread IN (67,82,81,72,73,74,75,71,70,55,65,64,63,62,59,58,2,56)
AND time>'1294238504'
GROUP BY thread
36.
SELECT u.id
FROM jos_users AS u
WHERE u.block='0'
AND u.usertype IN ('Administrator', 'Super Administrator')
37.
SELECT u.id AS uid, m.catid
FROM jos_users AS u
INNER JOIN jos_kunena_users AS p
ON u.id=p.userid
LEFT JOIN jos_kunena_moderation AS m
ON u.id=m.userid
LEFT JOIN jos_kunena_categories AS c
ON m.catid=c.id
WHERE u.block='0'
AND p.moderator='1'
AND (m.catid IS NULL OR c.moderated='1')
38.
SELECT code, `location`
FROM jos_kunena_smileys
39.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_jdownloads'
AND published = 1
40.
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_jdownloads&view=viewcategories'
AND published = 1
41.
SELECT cat_id
FROM jos_jdownloads_cats
WHERE published = 1
AND cat_access <= 22
42.
SELECT *
FROM jos_jdownloads_files
WHERE published = 1
AND cat_id IN (1,2,4,3,5,6,7,
ORDER BY date_added DESC
LIMIT 25
43.
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
44.
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE client_id = 0
AND a.guest = 0
45.
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos_polls
WHERE id = 15
AND published = 1
46.
SELECT id, text
FROM jos_poll_data
WHERE pollid = 15
AND text <> ""
ORDER BY id

Legacy Queries logged

Language Files Loaded

* /home/karaliya/public_html/language/en-GB/en-GB.ini 1
* /home/karaliya/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None

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

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

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 30 seconds | Max execution memory: 64M | Max file upload: 10M

Joomla default template details : rt_zephyr_j15 | author: RocketTheme, LLC | version: 1.5.2 | creationdate: October 13, 2010

Kunena default template details : Aphotic II | author: snilloconator | version: 1.6.2 | creationdate: 2010-12-30

Kunena version detailled: Installed version: 1.6.2 | Build: 3894 | Version name: Team | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Xtreme chaos
board_offline	0
board_ofset	0.00
offline_message	<h2>The Forum is currently offline for maintenance.</h2> <div>Check back soon!</div>
enablerss	1
enablepdf	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
jmambot	0
disemoticons	0
template	aphotic-II
showannouncement	0
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	0
mailfull	1
allowavatar	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	2048
allowimageupload	0
allowimageregupload	1
imageheight	800
imagewidth	800
imagesize	10000
allowfileupload	0
allowfileregupload	1
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	10000
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_name	1
userlist_username	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	28,33,34
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
usernamechange	0
rules_infb	1
rules_cid	1
help_infb	1
help_cid	1
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
fbsessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories	1,2,3,4
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	recent
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	0
showfileforguest	0
pollnboptions	4
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	replyid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	1
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	jxtended
integration_login	jomsocial
integration_avatar	jomsocial
integration_profile	jomsocial
integration_private	jomsocial
integration_activity	jomsocial
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	0
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	1
lightbox	1
activity_limit	100
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Disabled or not installed | Jomsocial: Installed (Version : 2.0.5) | UddeIm: Disabled or not installed

Third-party SEF components: sh404sef: Disabled or not installed | ARTIO JoomSEF: Disabled or not installed | AceSEF: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Enabled | JFirePHP: Disabled or not installed | Kunena Discuss: Disabled or not installed | Kunena Search: Enabled (Version : 1.6.2) | My Kunena Forum Menu: Enabled (Version : 1.6.2) | My Kunena Forum Posts: Disabled or not installed

Modules: Kunena Latest: Enabled (Version : 1.6.2) | Kunena Stats: Disabled or not installed | Kunena Login: Disabled or not installed