[@cosmich Member 16 years, 1 month ago]

hey ck

that suggestion didn’t make sense to me, since as i mentioned in my last post, the errors refer to my WordPress users table, not bbPress. still, after i worked out how i could change table names without using a query, i did as you said. the result was the same errors i got in my original post.

however as i now knew how to change table names, what Chris had said earlier suggested that i should try adding the database name as a table prefix to my WP users table. i did that, and when i tried to log in, one of the errors was gone. however the other error that came up was that bbPress was now looking for my WP usermeta table. so again i added the database name as a prefix to that and i was in!

unfortunately, while i got in with admin access, i no longer had access to the settings, so i couldn’t delete the database prefix to the tables.

i’ve decided that this is becoming such a mishmash that i’m going to uninstall bbPress and reinstall it again, trying to avoid the error with the database prefix. in any case, thanks to both of you and Chris for your help, i learnt some handy things in the process!

[@cosmich Member 16 years, 1 month ago]

hi chris and ck

i missed something obvious, didn’t explain about my databases and probably confused you in the process.

so i’m going to try to clarify. bbPress and WordPress have separate databases. by substituting db for the name of my database, i obscured the fact that the errors referred to in my initial post are looking for my WordPress users table ie in my WordPress database, not bbPress.

in phpMyAdmin i can see that my WordPress tables have no prefix, while my bbPress tables have an underscore prefix:

i tried putting db (my database) as a prefix in my wp-config file just to see if that would work, but i still got the same errors (so changed it back to what it was, since it also took my WordPress site down, though it was fine again once i removed the prefix from wp-config).

so i still have no idea of what to do.

i remember when i was setting up integration for bbPress that i specified a table prefix – i’m wondering whether it would be simpler to uninstall bbPress and reinstall it again, trying to avoid the prefix problem? i’d lose a bit of stuff i entered, but there’s not much and i could easily recreate it.

[@cosmich Member 16 years, 1 month ago]

hi chris

actually i don’t think i even need the screenshot. i had a look at phpMyAdmin and the tables have no prefix.

so there’s the database name, then tables names eg

users, user_meta, topic

so the full name is for example db.users, not db.dbusers. so i’m pretty confident that’s what the error is – i’ve mistakenly given a table prefix when there is none. but i still don’t know how to get round it.

i thought table prefixes might be defined in a file somewhere, but if so i can’t find it. and if you have do do something in phpMyAdmin i don’t know what.

[@cosmich Member 16 years, 1 month ago]

Yes i do have db access with phpMyAdmin, but i don’t know what to do.