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.
1539
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. 🙂
