Users Table Not Created

Hi, I've installed everything fine so far. But I'm getting an error saying Wordpress plugin error: DB - [] - incorrect value. Error: Table 'xxxxxxxdatabasename_amember.users' doesn't exist

I'm not a coder, I have figured out how to add a table in PHP MyAdmin, but I don't know how many fields to give it, or what to put in those fields.

Any help is appreciated!

I'd say if its a fresh install, drop or delete the database and run the setup again.

David

Hi Ann,

Before you drop or delete the database (huge hassle), can you recheck on the settings to make sure that you input the correct value first:

"databasename.tableprefix"

This will usually solve the problem. If you need help, email codeispoetry [at] amemberincremental.com, I will need access to your servers to help you resolve this issue.

Lee

I have the same issue with 3.1.8, it complains about DBName.users. it ignores the prefix.

In the DB, there is DBName.prefix_members but there is no .users. I will check the code, i suspect hardcoding somewhere.

This error shows up in the error log when I try to do rebuild DB trying to port over Wordpress accounts

looks like wordpress plugin has some hardcoding to users table, but I do not see any creation code for the table.

Anyone aware of this issue?

I think its in the amember core side of things- it adds a row to the config table for the new plugin.

David

Yeah the error was user error not aMember.

I have wordpress in a seperate DB, so the DB name under Wordpress setup (in aMember) should have been "database.wp_" not just "database"

I also did not realize that the Rebuild Db brings users from aMembers into Wordpress, and not the other way around. I will need to do some coordination and find a solution to bring the users into amembers.

Not a big deal in my case, I can always force them to sign up again.

Fadi

You can import them, but you'll need to give them all new passwords.

David