bartus2003
14-11-2007, 15:27
Kiedy chce usuwać nieaktywnych userów wyskakuje na forum błąd:
Wystąpił Błąd
DEBUG MODE
SQL Error : 1146 Table 'bartus_warrock.core_acl_aro' doesn't exist
SELECT aro_id FROM core_acl_aro WHERE name = '!Szakal!'
Line : 487
File : functions_remove.phplinię pogrubiam:
//joomla<->przemo start
require_once( '../../configuration.php' );
$sql = "SELECT aro_id
FROM ".$mosConfig_dbprefix."core_acl_aro
WHERE name = '$username'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$aro_id = $row['aro_id'];
$sql = "DELETE FROM ".$mosConfig_dbprefix."users
WHERE username = '$username'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM ".$mosConfig_dbprefix."core_acl_aro
WHERE name = '$username'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM ".$mosConfig_dbprefix."core_acl_groups_aro_map
WHERE aro_id = '$aro_id'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
//joomla<->przemo end
Wystąpił Błąd
DEBUG MODE
SQL Error : 1146 Table 'bartus_warrock.core_acl_aro' doesn't exist
SELECT aro_id FROM core_acl_aro WHERE name = '!Szakal!'
Line : 487
File : functions_remove.phplinię pogrubiam:
//joomla<->przemo start
require_once( '../../configuration.php' );
$sql = "SELECT aro_id
FROM ".$mosConfig_dbprefix."core_acl_aro
WHERE name = '$username'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$aro_id = $row['aro_id'];
$sql = "DELETE FROM ".$mosConfig_dbprefix."users
WHERE username = '$username'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM ".$mosConfig_dbprefix."core_acl_aro
WHERE name = '$username'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM ".$mosConfig_dbprefix."core_acl_groups_aro_map
WHERE aro_id = '$aro_id'";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, '', '', __LINE__, __FILE__, $sql);
}
//joomla<->przemo end