<?php
// !!! do not use variable $rs as record-set;
$sql='SELECT ResourceId,COUNT(*) as c FROM '.$g_TablePrefix.'Category GROUP BY 1 HAVING c>1';
$rs2 = $ado->Execute($sql);
if ($rs2 && !$rs2->EOF)
{
	$result|=$failCheck;
	$CheckErrors[] = 'You have duplicate ResourceId in table "'.$g_TablePrefix.'Category"';
}
$sql='SELECT ResourceId,COUNT(*) as c FROM '.$g_TablePrefix.'PortalGroup GROUP BY 1 HAVING c>1';
$rs2 = $ado->Execute($sql);
if ($rs2 && !$rs2->EOF)
{
	$result|=$failCheck;
	$CheckErrors[] = 'You have duplicate ResourceId in table "'.$g_TablePrefix.'PortalGroup"';
}
$sql='SELECT ResourceId,COUNT(*) as c FROM '.$g_TablePrefix.'PortalUser GROUP BY 1 HAVING c>1';
$rs2 = $ado->Execute($sql);
if ($rs2 && !$rs2->EOF)
{
	$result|=$failCheck;
	$CheckErrors[] = 'You have duplicate ResourceId in table "'.$g_TablePrefix.'PortalUser"';
}
?>