kikelidia
Machacateclados
Machacateclados

Cuando me quiero loguear desde mi foro, me sale este error:

Error in obtaining userdata

DEBUG MODE

SQL Error : 1054 Unknown column 'user_login_tries' in 'field list'

SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try FROM nuke_users WHERE username = 'enrique'

Line : 69
File : login.php

Nota: He abierto login.php, que esta en modules/Forums, e aditado el archivo y e ido a la linea 69 pero en esa linea no hay nada.(es por si sirve de algo).

Avatar Image
@man / @woman
@man / @woman

Fijate si en login php tenés algún include... y contá desde la 1ra incluyendo las líneas de código de esos archivos para encontrar la que te da el error.

kikelidia
Machacateclados
Machacateclados

Si tengo include en el archivo login.php, pero todas estan bien. Esque nose como resolverlo.

Avatar Image
@man / @woman
@man / @woman

El error te devuelve un número de línea (pero al buscar esa línea no encontrás nada...), así que:

Comienzas a contar desde la 1ra línea del archivo login.php (incluso las que no tienen nada).

Cuando encuentras un include, te fijas cuántas líneas tiene ese archivo y le sumas lo que venías contando (o sea: un include no se cuenta como 'uno' sino como la cantidad de líneas que contiene).

Luego continúas hasta que encuentres la que te dice el error.

kikelidia
Machacateclados
Machacateclados

Vale, aver yo en la linea 68 encuentro un include eso cuantas lineas serian?

Avatar Image
@man / @woman
@man / @woman

Ahí (en la 68) le agregás la cantidad de líneas que tiene el archivo incluido.

kikelidia
Machacateclados
Machacateclados

Vale el archivo incluido tiene 1 solo, entonces serian 69.

Que ago mas?

kikelidia
Machacateclados
Machacateclados

Te dejo el codigo de login.php

Código:
<?php
/***************************************************************************
*                                login.php
*                            -------------------
*   begin                : Saturday, Feb 13, 2001
*   copyright            : (C) 2001 The phpBB Group
*   email                : support@phpbb.com
*
*   Id: login.php,v 1.47.2.23 2006/01/13 20:10:02 grahamje Exp $
*
*
***************************************************************************/

/***************************************************************************
*
*   This program is free software; you can redistribute it and/or modify
*   it under the terms of the GNU General Public License as published by
*   the Free Software Foundation; either version 2 of the License, or
*   (at your option) any later version.
*
***************************************************************************/
if (!eregi("modules.php", $_SERVER['SCRIPT_NAME'])) {
    die ("You can't access this file directly...");
}
$module_name = basename(dirname(__FILE__));
require("modules/".$module_name."/nukebb.php");

//
// Allow people to reach login page if
// board is shut down
//
define("IN_LOGIN", true);

define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Set page ID for session management
//
$userdata = session_pagestart($user_ip, PAGE_LOGIN, $nukeuser);
init_userprefs($userdata);
//
// End session management
//

// session id check
if (!empty($HTTP_POST_VARS['sid']) || !empty($HTTP_GET_VARS['sid']))
{
    $sid = (!empty($HTTP_POST_VARS['sid'])) ? $HTTP_POST_VARS['sid'] : $HTTP_GET_VARS['sid'];
}
else
{
    $sid = '';
}

if( isset($HTTP_POST_VARS['login']) || isset($HTTP_GET_VARS['login']) || isset($HTTP_POST_VARS['logout']) || isset($HTTP_GET_VARS['logout']) )
{
    if( ( isset($HTTP_POST_VARS['login']) || isset($HTTP_GET_VARS['login']) ) && (!$userdata['session_logged_in'] || isset($HTTP_POST_VARS['admin'])) )
    {
        $username = isset($HTTP_POST_VARS['username']) ? phpbb_clean_username($HTTP_POST_VARS['username']) : '';
        $password = isset($HTTP_POST_VARS['password']) ? $HTTP_POST_VARS['password'] : '';

        $sql = "SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try
            FROM " . USERS_TABLE . "
            WHERE username = '" . str_replace("\\'", "''", $username) . "'";
        if ( !($result = $db->sql_query($sql)) )
        {
            message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);
        }

        if( $row = $db->sql_fetchrow($result) )
        {
            if( $row['user_level'] != ADMIN && $board_config['board_disable'] )
            {
                redirect(append_sid("index.$phpEx", true));
            }
            else
            {
                // If the last login is more than x minutes ago, then reset the login tries/time
                if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $row['user_last_login_try'] < (time() - ($board_config['login_reset_time'] * 60)))
                {
                    $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);
                    $row['user_last_login_try'] = $row['user_login_tries'] = 0;
                }
                
                // Check to see if user is allowed to login again... if his tries are exceeded
                if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $board_config['max_login_attempts'] &&
                    $row['user_last_login_try'] >= (time() - ($board_config['login_reset_time'] * 60)) && $row['user_login_tries'] >= $board_config['max_login_attempts'] && $userdata['user_level'] != ADMIN)
                {
                    message_die(GENERAL_MESSAGE, sprintf($lang['Login_attempts_exceeded'], $board_config['max_login_attempts'], $board_config['login_reset_time']));
                }

                if( md5($password) == $row['user_password'] && $row['user_active'] )
                {
                    $autologin = ( isset($HTTP_POST_VARS['autologin']) ) ? TRUE : 0;

                    $admin = (isset($HTTP_POST_VARS['admin'])) ? 1 : 0;
                    $session_id = session_begin($row['user_id'], $user_ip, PAGE_INDEX, FALSE, $autologin, $admin);

                    // Reset login tries
                    $db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);

                    if( $session_id )
                    {
                        $url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
                        redirect(append_sid($url, true));
                    }
                    else
                    {
                        message_die(CRITICAL_ERROR, "Couldn't start session : login", "", __LINE__, __FILE__);
                    }
                }
                // Only store a failed login attempt for an active user - inactive users can't login even with a correct password
                elseif( $row['user_active'] )
                {
                    // Save login tries and last login
                    if ($row['user_id'] != ANONYMOUS)
                    {
                        $sql = 'UPDATE ' . USERS_TABLE . '
                            SET user_login_tries = user_login_tries + 1, user_last_login_try = ' . time() . '
                            WHERE user_id = ' . $row['user_id'];
                        $db->sql_query($sql);
                    }

                    $redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : '';
                    $redirect = str_replace('?', '&', $redirect);

                    if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
                    {
                        message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
                    }

                    $template->assign_vars(array(
                        'META' => '<meta http-equiv=\"refresh\" content=\"3;url=' . append_sid("login.$phpEx?redirect=$redirect") . '\">')
                    );

                    $message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], '<a href=\"' . append_sid("login.$phpEx?redirect=$redirect") . '\">', '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');

                    message_die(GENERAL_MESSAGE, $message);
                }
            }
        }
        else
        {
            $redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "";
            $redirect = str_replace("?", "&", $redirect);

            if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
            {
                message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
            }

            $template->assign_vars(array(
                'META' => '<meta http-equiv=\"refresh\" content=\"3;url=' . append_sid("login.$phpEx?redirect=$redirect") . '\">')
            );

                        $message = $lang['Error_login'] . '<br /><br />' . sprintf($lang['Click_return_login'], '<a href=\"' . append_sid("login.$phpEx?redirect=$redirect") . '\">', '</a>') . '<br /><br />' .  sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');

            message_die(GENERAL_MESSAGE, $message);
        }
    }
    else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
    {
        // session id check
        if ($sid == '' || $sid != $userdata['session_id'])
        {
            message_die(GENERAL_ERROR, 'Invalid_session');
        }

        if( $userdata['session_logged_in'] )
        {
            session_end($userdata['session_id'], $userdata['user_id']);
        }

        if (!empty($HTTP_POST_VARS['redirect']) || !empty($HTTP_GET_VARS['redirect']))
        {
            $url = (!empty($HTTP_POST_VARS['redirect'])) ? htmlspecialchars($HTTP_POST_VARS['redirect']) : htmlspecialchars($HTTP_GET_VARS['redirect']);
            $url = str_replace('&', '&', $url);
            redirect(append_sid($url, true));
        }
        else
        {
            redirect(append_sid("index.$phpEx", true));
        }
    }
    else
    {
        $url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
        redirect(append_sid($url, true));
    }
}
else
{
    //
    // Do a full login page dohickey if
    // user not already logged in
    //
    if( !$userdata['session_logged_in'] || (isset($HTTP_GET_VARS['admin']) && $userdata['session_logged_in'] && $userdata['user_level'] == ADMIN))
    {
        $page_title = $lang['Login'];
                include("modules/$module_name/includes/page_header.php");

        $template->set_filenames(array(
            'body' => 'login_body.tpl')
        );

        $forward_page = '';

        if( isset($HTTP_POST_VARS['redirect']) || isset($HTTP_GET_VARS['redirect']) )
        {
            $forward_to = $HTTP_SERVER_VARS['QUERY_STRING'];

            if( preg_match("/^redirect=([a-z0-9\.#\/\?&=\+\-_]+)/si", $forward_to, $forward_matches) )
            {
                $forward_to = ( !empty($forward_matches[3]) ) ? $forward_matches[3] : $forward_matches[1];
                $forward_match = explode('&', $forward_to);

                if(count($forward_match) > 1)
                {
                    for($i = 1; $i < count($forward_match); $i++)
                    {
                        if( !ereg("sid=", $forward_match[$i]) )
                        {
                            if( $forward_page != '' )
                            {
                                $forward_page .= '&';
                            }
                            $forward_page .= $forward_match[$i];
                        }
                    }
                    $forward_page = $forward_match[0] . '?' . $forward_page;
                }
                else
                {
                    $forward_page = $forward_match[0];
                }
            }
        }

                Header("Location: modules.php?name=Your_Account&redirect=$forward_page");
        $username = ( $userdata['user_id'] != ANONYMOUS ) ? $userdata['username'] : '';

        $s_hidden_fields = '<input type="hidden" name="redirect" value="' . $forward_page . '" />';
        $s_hidden_fields .= (isset($HTTP_GET_VARS['admin'])) ? '<input type="hidden" name="admin" value="1" />' : '';

        make_jumpbox('viewforum.'.$phpEx);
        $template->assign_vars(array(
            'USERNAME' => $username,

            'L_ENTER_PASSWORD' => (isset($HTTP_GET_VARS['admin'])) ? $lang['Admin_reauthenticate'] : $lang['Enter_password'],
            'L_SEND_PASSWORD' => $lang['Forgotten_password'],

            'U_SEND_PASSWORD' => append_sid("profile.$phpEx?mode=sendpassword"),

            'S_HIDDEN_FIELDS' => $s_hidden_fields)
        );

        $template->pparse('body');

                include("modules/$module_name/includes/page_tail.php");
    }
    else
    {
        redirect(append_sid("index.$phpEx", true));
    }

}

?>
Avatar Image
@man / @woman
@man / @woman

¿ puedes contar?

kikelidia
Machacateclados
Machacateclados

que va, todabia no e llegado a eso..

q pena

Avatar Image
@man / @woman
@man / @woman

Tiempo al tiempo, ya aprenderás.

kikelidia
Machacateclados
Machacateclados

jeje, eso es tiempo al tiempo, bueno igualmente gracias

Un saludiyo

kikelidia
Machacateclados
Machacateclados

Ya arregle el problema, Gracias por la ayuda XD

Un saludo

ATENCIÓN: Este tema no tiene actividad desde hace más de 6 MESES,
te recomendamos abrir un nuevo tema en lugar de responder al actual
Opciones:
Ir al subforo:
Permisos:
TU NO PUEDES Escribir nuevos temas
TU NO PUEDES Responder a los temas
TU NO PUEDES Editar tus propios mensajes
TU NO PUEDES Borrar tus propios mensajes
Temas similares
TemaUsuariosRespuestasVisitasActividad
Por: , el 30/Jul/2008, 07:25
alferezauxiliar NoSetup.org22kJul/08
Por: , el 29/Ago/2009, 21:12
paganmetalradio kikelidia NoSetup.org22kSep/09
Por: , el 14/Feb/2006, 08:34
gerardroig NoSetup.org12kFeb/06
Por: , el 17/Mar/2009, 03:03
KeViNeM GestionXls32kMar/09
Por: User 4161798, el 05/Oct/2008, 02:43
User 4161798 NoSetup.org12kOct/08