Step two errors « bbPress Support Forums

bbPress Support Forums › Installation › Step two errors

Info

4 posts
3 voices
Started 5 years ago by amsports
Latest reply from Michael Adams (mdawaffe)
This topic is not resolved

Tags

upgrade

Posts in this topic

Step two errors

- Posted 5 years ago #
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.
- Posted 5 years ago #
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.
- Posted 5 years ago #
Bump

Anyone else with thoughts
- Posted 5 years ago #
"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?
You must log in to post.