WordPress-People?

Okay, lesson learned.
DON’T PUT THE PLUG-IN INFORMATION ON PAGES THAT DON’T NEED IT.

New zip file uploaded on my forum. Should fix the activation issue.

The strange thing is I still have an error. My username is set to 10, but wordpress still thinks I need a “promotion”. Does anyone know what’s wrong?

Okay, here’s the issue:
Since I put the plug-in information on both files, you probably tried to install the wrong file. So, you have to deactivate the plug-in. Update with the latest change and then reactivate the plug-in.

If that doesn’t work, let me know. I’ll try to figure something out.

I can’t deactivate the wp-people-admin plugin. It won’t let me even get to the plugin page. I try just uploading the admin page by itself and I get the same error as before. I am stuck. ??

You should be able to remove the plugin file from the plugins directory and WP should let you back in.

Yeah. I deleted them from the site, but I still want to use the plugin. I hope someone can help.

if ($user_level < 7)
{
die("<div class=\"wrap\">
<h2>WP People</h2>
You do not have the proper access (Level " . $user_level . ") to edit the WP-People
database for this blog. <br>Ask for a promotion from your
blog admin</div>");
}


Try commenting out the above code in the wp-people-admin.php file. That should get you past the first error, so you can deactivate the plug-in. And then get the lastest files and activate the plug-in again.

Thanks. That solved part of the problem. But now, when I try to access the wp-people-admin and install the table, I get this message:
The necessary table or columns have not been found – click the install button to perform the database changes now.

Warning: Invalid argument supplied for foreach() in /home/.waldorf/bando89/band-o.org/wp-content/plugins/wp-people-admin.php on line 220

Any idea what that is about?

Thanks for finding these errors for me. ??

Okay, that error was in the error message part.
I put a new zip file up, it’s the same link as before.
The version of the plug-in should be 1.6 now.

Again, thanks for finding these issues.

Okay. That fixed pretty much everything. Except the actual script. I go in to install the table in the database and it won’t let me. I click install and the page refreshes, but nothing happens. I went into my database and the table wasn’t there. I tried putting the MYSQL commands into the database, but I got the following message:
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 313
STR: ‘
SQL: CREATE TABLE ‘wp_people’ (
people_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
user_ID bigint(20) NOT NULL,
people_name VARCHAR(160) NOT NULL,
people_nickname VARCHAR(100) NOT NULL,
people_bio TEXT NOT NULL,
people_url VARCHAR(255),
people_image_url VARCHAR(255),
people_image_title_nm VARCHAR(160)’);

SQL-query :

CREATE TABLE ‘wp_people’ ( people_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, user_ID bigint(20) NOT NULL, people_name VARCHAR(160) NOT NULL, people_nickname VARCHAR(100) NOT NULL, people_bio TEXT NOT NULL, people_url VARCHAR(255), people_image_url VARCHAR(255), people_image_title_nm VARCHAR(160)’);

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ”wp_people’ (
people_ID INT NOT NULL AUTO_INCREMENT PRIMARY K

Strange, huh?

I fixed it by just going through and making the table step by step, but I just wanted to let you know that it wasn’t working. Thanks for such a great plugin! ??

Sorry for the troubles, I mentioned that I needed people to test it first. It’s hard to test every possiblity, especially when I already have the tables setup.

I’ll checked the queries.
It was actually a typo in the instructions and a typo in the action command to create the table. Fixed. version 1.6.1 is zipped up and put on my site.

The problem with that table creation line is there isn’t a quote to start the query, but there is one to end it. Simply add ‘ after ‘wp_people’ ( to get CREATE TABLE 'wp_people' (' people_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, user_ID bigint(20) NOT NULL, people_name VARCHAR(160) NOT NULL, people_nickname VARCHAR(100) NOT NULL, people_bio TEXT NOT NULL, people_url VARCHAR(255), people_image_url VARCHAR(255), people_image_title_nm VARCHAR(160)');

Mark, thanks, but that wasn’t the problem.
The query text shown is from the error message and wasn’t 100% the same as the actual query. There was a hidden value in the form to kick off the query. Because the value was “None” and not “none”, the query wasn’t kicking off.

Well, I reinstalled the database (only had 1 person on the manually installed one) and now it is working like clockwork. Sorry I made you go through all that extra effort. Wonderful plugin. I honestly couldn’t live without it. ??