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.

phpBB broken in cPanel 10.8.2-C118

Discussion in 'General Discussion' started by viptexting, Jun 4, 2006.

  1. viptexting

    viptexting Well-Known Member

    Joined:
    Sep 19, 2005
    Messages:
    74
    Likes Received:
    0
    Trophy Points:
    6
    phpBB is broken in cPanel 10.8.2-C118....

    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 = 'asilentcry_admin'

    Line : 65
    File : login.php
     
  2. viptexting

    viptexting Well-Known Member

    Joined:
    Sep 19, 2005
    Messages:
    74
    Likes Received:
    0
    Trophy Points:
    6
    There is something seriously wrong with this install...

    Had to add the following to columns to the phpbb_users table:

    user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
    user_last_login_try int(11) DEFAULT '0' NOT NULL,

    And then add the following table:

    CREATE TABLE phpbb_sessions_keys (
    key_id varchar(32) DEFAULT '0' NOT NULL,
    user_id mediumint(8) DEFAULT '0' NOT NULL,
    last_ip varchar(8) DEFAULT '0' NOT NULL,
    last_login int(11) DEFAULT '0' NOT NULL,
    PRIMARY KEY (key_id, user_id),
    KEY last_login (last_login)
    );

    Then now I can finally login to admin it reports itself as 2.0.17 even though this is supposed to be 2.0.19:

    Your installation does not seem to be up to date. Updates are available for your version of phpBB, please visit http://www.phpbb.com/downloads.php to obtain the latest version.
    The latest available version is phpBB 2.0.20. You are running phpBB 2.0.17.

    Seams like this is a screwed up, mixed up version of 2.0.17 and 2.0.19!!!
     
  3. viptexting

    viptexting Well-Known Member

    Joined:
    Sep 19, 2005
    Messages:
    74
    Likes Received:
    0
    Trophy Points:
    6
    Quick fix...

    Just patch to version 2.0.20 from phpBB site...

    Probably Quicker fix...

    Don't use the dodgy cPanel installers and just install version 2.0.20 from the phpBB site ;-)
     
Loading...

Share This Page