Database Woes | Peter's Login Redirect | Forum
Back to the login redirect plugin page
Log In
Home
Topic RSS
8:06 am
Hi Peter, thanks for your time in putting this excellent plugin together.
I'm using User Access Manager with your plugin to redirect. At first things seemed good, but now even after reinstalling plugins I'm having trouble.
When I go into the redirect settings and add a redirect, it says added but doesn't list anything. I checked the database and no table was setup, so I added the table and rows as listed in the plugin.
I'm not terribly confident in the table that was setup by hand. Is there a quick list reference I can check to verify database-wise I'm good? Can you think of any other reasons that may be causing this?
Thanks again for your time!
8:10 am
Here's a screen shot of the database I had to make by hand.
http://img4.imageshack.us/img4.....907750.jpg
I also ran a query to create the row, 'rul_url_logout'
1:53 pm
Offline
Hi Travis,
Your database structure looks correct. By default the plugin also creates a default entry with rul_type of "all". However, the bigger issue would seem to be that the table wasn't automatically created in the first place. Perhaps the database user account did not have the sufficient permissions for "create table" and "alter table".
6:50 am
It seems odd that the database user account wouldn't have sufficient permissions. I've installed several other plugins, such as User Access Manager, that installed and setup without a pinch.
Since the database looks right, is there anything else that could be to blame? Your plugin is the perfect fit for my needs and I'm itching to get it up and running!
Thanks so much again for your time!
10:58 am
Offline
Are you using WordPress' multi-site feature? The plugin isn't compatible with it (yet).
The only other thing I could think of to help troubleshoot is to check the error logs on your server and to enable debugging in WordPress to show any errors within the system: http://codex.wordpress.org/Edi......php#Debug
9:09 am
Peter said:
Are you using WordPress' multi-site feature? The plugin isn't compatible with it (yet).
The only other thing I could think of to help troubleshoot is to check the error logs on your server and to enable debugging in WordPress to show any errors within the system: http://codex.wordpress.org/Edi......php#Debug
Hi Peter and Travis,
I had a similar problem after I updated my copy of Peter's plugin a few days ago. During the update process a new column called "rul_url_logout" wasn't created.
However, I just went in to the settings and clicked "Update" under "Specific Roles," and the field was automatically added in my database. I think maybe another one was added, but I wasn't paying that much attention.
You don't have to change anything... just click "Update" under "Specific Roles."
I hope this helps. Peter, thanks for giving the community this plugin.
Take care,
Paul Kaiser
7:48 pm
For some reason, I was having the same issue as Travis. One 3.2.1, I was able to install the plugin...for my needs, there were really only basic requirements of taking the WP role and directing them over to another page (the main home as there is a member script forcing them to another page if not logged in)...
I originally thought that's what it was, some kind of conflict, but when I looked in the database, I noticed that it was in fact creating one row with the role settings and redirection URL, but wouldn't add...it would just change to the next added. (ie: if I put in a subscriber and redirected them, then put in an admin and tried to redirect it, it would only save the admin (most recent) in the DB.
For me, the simple solution was to just copy the record in PHPMyAdmin and insert it as a new row manually entering the WP role...which worked fine...Just posting in case anyone has a similar problem, that seemed like a pretty easy fix, assuming it would work with any of the other setups as well...
12:09 pm
Thanks Tom, and everyone else. Also, not using multi-site; it's on a self-hosted single site installation with the most recent WordPress version (and most recent Peter's redirect).
In using the plugin with another website I've had to manually duplicate entries in the DB like Tom suggested. It works like a charm, although doesn't display listed redirects in the WordPress panel (which would be handy).
