News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

2.0 RC4 Wrong value type sent to the database.

Started by ACPh, November 04, 2010, 02:16:49 AM

Previous topic - Next topic

ACPh

When clicking or opening the member's profile...
"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?
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

ACPh

Fresh installation with mods...

Here's the error log
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?
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

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...
// 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() . ';',
);
}
SlammedDime
Former Lead Customizer
BitBucket Projects
GeekStorage.com Hosting
                      My Mods
SimpleSEF
Ajax Quick Reply
Sitemap
more...
                     

ACPh

Ok thanks,

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

I can see any profiles now, including me.  ;D


Again Big Thanks.

Please Close this thread!

Dan ♠



Advertisement: