RavenNuke 2.51 - Account Page/Messages Summary-False Reading

Worker Joined: Jun 21, 2010 Posts: 102

All users get the same summary listed below.
Inbox : 1 New: 3 Read: 2 Saved: 6 Outbox: 7

I am fine-tuning a new installation in XAMPP. The installation works well or as designed.

This error comes from migrating custom settings from a previous RavenNuke 2.51 installation. My theme is fisubice.

Site Admin Joined: Aug 22, 2007 Posts: 1772

Yes its a bug, I found it on a installation from a customer some months ago.

Open /modules/Your_Account/includes/ui-0privmsgs.php

find:

php Code:

	$sql = 'SELECT 1, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type IN (0, 1, 5) UNION '


		. 'SELECT 2, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 0 UNION '


		. 'SELECT 3, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 1 UNION '


		. 'SELECT 4, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_from_userid = ' . $uid . ' AND privmsgs_type = 2 UNION '


//		. 'SELECT 5, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 3 UNION '


		. 'SELECT 6, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_from_userid = ' . $uid . ' AND privmsgs_type = 4 UNION '


		. 'SELECT 7, COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 5';


	$result = $db->sql_query($sql);


	list(, $ya_totpms) = $db->sql_fetchrow($result); // 1


	list(, $ya_oldpms) = $db->sql_fetchrow($result); // 2


	list(, $ya_newpms) = $db->sql_fetchrow($result); // 3


	list(, $ya_outpms) = $db->sql_fetchrow($result); // 4


//	list(, $ya_savpms) = $db->sql_fetchrow($result); // 5


	list(, $ya_savpms) = $db->sql_fetchrow($result); // 6


	list(, $ya_outpms) = $db->sql_fetchrow($result); // 7

replace it with:

php Code:

	$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type IN (0, 1, 5)');


	list($ya_totpms) = $db->sql_fetchrow($result);


	$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 0');


	list($ya_oldpms) = $db->sql_fetchrow($result);


	$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 1');


	list($ya_newpms) = $db->sql_fetchrow($result);


	$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 2');


	list($ya_outpms) = $db->sql_fetchrow($result);


	$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 4');


	list($ya_savpms) = $db->sql_fetchrow($result);


	$result = $db->sql_query('SELECT COUNT(*) FROM ' . $prefix . '_bbprivmsgs WHERE privmsgs_to_userid = ' . $uid . ' AND privmsgs_type = 5');


	list($ya_outpms) = $db->sql_fetchrow($result);

Posted: Mon Oct 30, 2017 9:19 am

Error fixed.
Inbox : 0 New: 0 Read: 0 Saved: 0 Outbox: 0

neralex, thank you. Very Happy

Posted: Mon Oct 30, 2017 9:38 am