2.0 RC4 Wrong value type sent to the database.

[ACPh]

When clicking or opening the member's profile...

Code Select Expand

"Wrong value type sent to the database. Array of integers expected. (groups)"

[Aleksi "Lex" Kilpinen]

I can't reproduce this on my own install. Was this a fresh installation, or an upgraded installation?

[ACPh]

Fresh installation with mods...

Here's the error log

Code Select Expand

Apply Filter: Only show the error messages of this URL
http://www.avanzaclub.ph/forum/index.php?action=profile;u=2
Apply Filter: Only show the errors with the same message
Wrong value type sent to the database. Array of integers expected. (groups)
Function: cache_getMembergroupListForProfile
Apply Filter: Only show the errors from this file
File: /home/vol1/0adz.com/adz0_6303436/avanzaclub.ph/htdocs/forum/Sources/Subs-Membergroups.php
Line: 787

[Aleksi "Lex" Kilpinen]

Sadly I don't have a fresh RC4 on my hands to test, but did this happen before mod installations - or only after them?

[ACPh]

I did not check any profile before the mods

here's the screeny...

[SlammedDime]

Looks like a mod has modified that code, that is not the default code from 2.0 RC4's subs-membergroups.php file

This is the original code...

Code Select Expand

// Retrieve a list of (visible) membergroups used by the cache.
function cache_getMembergroupList()
{
global $scripturl, $smcFunc;

$request = $smcFunc['db_query']('', '
SELECT id_group, group_name, online_color
FROM {db_prefix}membergroups
WHERE min_posts = {int:min_posts}
AND hidden = {int:not_hidden}
AND id_group != {int:mod_group}
AND online_color != {string:blank_string}
ORDER BY group_name',
array(
'min_posts' => -1,
'not_hidden' => 0,
'mod_group' => 3,
'blank_string' => '',
)
);
$groupCache = array();
while ($row = $smcFunc['db_fetch_assoc']($request))
$groupCache[] = '<a href="' . $scripturl . '?action=groups;sa=members;group=' . $row['id_group'] . '" ' . ($row['online_color'] ? 'style="color: ' . $row['online_color'] . '"' : '') . '>' . $row['group_name'] . '</a>';
$smcFunc['db_free_result']($request);

return array(
'data' => $groupCache,
'expires' => time() + 3600,
'refresh_eval' => 'return $GLOBALS[\'modSettings\'][\'settings_updated\'] > ' . time() . ';',
);
}


[ACPh]

Ok thanks,

I got the back-up of my subs-membergroups.php file and restored!

I can see any profiles now, including me. 


Again Big Thanks.

Please Close this thread!

[Dan ♠]

You can lock the thread yourself.

[petesky]

This mod causes the behavior: http://custom.simplemachines.org/mods/index.php?mod=620