Skip to:
Content
Pages
Categories
Search
Top
Bottom

Step two errors

  • Installation went smoothly thru step one.

    When the step two page came up it displayed the following errors.


    bbPress database error: [Incorrect table definition; There can only be one auto column and it must be defined as a key]
    ALTER TABLE bb_users ADD COLUMN ID bigint(20) unsigned NOT NULL auto_increment

    bbPress database error: [Key column 'ID' doesn't exist in table]
    ALTER TABLE bb_users ADD PRIMARY KEY (ID)

    1. Added index bb_users PRIMARY KEY (ID)

    bbPress database error: [Unknown column 'ID' in 'where clause']
    SELECT * FROM bb_users WHERE ID = 1

    bbPress database error: [Unknown column 'ID' in 'where clause']
    SELECT * FROM bb_users WHERE ID = 0

    I checked via MyphpAdmin and have been unable to determine how to correct the errors, or even understand what they are.

    Below the error list it appears as though step two partially worked, i.e. it displays a login link and user name and P-word.

    However the login link returns (paraphrased) “it appears you have not installed bbpress” and a link to the install page.

    The database used was one from a bbpress install of over one year ago.

    I also made a second, but new, database with the same results as described above.

Viewing 3 replies - 1 through 3 (of 3 total)

  • chrishajer
    Participant

    @chrishajer

    I saw this in bb-admin/upgrade.php

    // Very old (pre 0.7) installs may need further upgrade utilities. Post to http://lists.bbpress.org/mailman/listinfo/bbdev if needed

    I wonder what version you were using? In bb-includes/functions.php, there is a section for version.

            case 'version' :
    return '0.73';
    break;

    Maybe that will help someone help the upgrade script for you.

    Bump

    Anyone else with thoughts

    “The database used was one from a bbpress install of over one year ago.”

    Are you trying to run the install script or the upgrade script? If you already have a database, you should be running the upgrade script:

    bb-admin/upgrade.php

    Is it a complete database, or did you only keep certain tables?

    In your PHPMyAdmin, what bb_ tables do you see before and after running the install/upgrade script?

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.