The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Error in obtaining userdata [moved]

Discussion in 'Database Discussions' started by crazynipples, Jun 7, 2006.

  1. crazynipples

    crazynipples Registered

    Joined:
    Jun 5, 2006
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Error in obtaining userdata

    --------------------------------------------------------------------------------

    I am using the below.
    phpBB
    PHP/MySQL based forum

    Description: (v2.0.19)

    This is a cPanel packaged module. (v0.1)

    And i am getting the below when signing into the forums with the admin i provided and password.

    General 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 phpbb_users WHERE username = 'crazynipple'

    Line : 65
    File : login.php

    please help me, I have tryed and tried again and always the same error
     
  2. innovative2001

    innovative2001 Active Member

    Joined:
    Jun 5, 2006
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    Hello

    It seems to the permissions issue on the database. The phpBB scripts are not allowed to add a column that is why you are getting these errors. You will have to now use phpMyAdmin to insert the queries yourself.

    Please, Try running the two SQL commands.

    ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;

    ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;

    Thanks

    Martin

    Technical Support Executive
    Accuwebhosting.com
     
Loading...

Share This Page