cityjohn
Forum Replies Created
-
Forum: Plugins
In reply to: [Custom Login Page Customizer] Customizer stops logout redirectI have to dissapoint you, we’ve been changing a lot on the website and I can’t tell you exactly how to replicate it. The redirect is currently done by:
add_action('check_admin_referer', 'scratchcode_logout_without_confirm', 10, 2); function scratchcode_logout_without_confirm($action, $result){ /** * Allow logout without confirmation */ if ($action == "log-out" && !isset($_GET['_wpnonce'])): $redirectUrl = 'https://website.nl/'; wp_redirect( str_replace( '&', '&', wp_logout_url( $redirectUrl.'?logout=true' ) ) ); exit; endif; }Which now seems to work but I can still reach the page if I go to website/login. I changed the standard links with a plugin called hide-my-WP. Can I disable this redirect somewhere in Customizer? Because no matter what why would I want people to see an empty login customizer page… In hide-my-WP an option is set to show a 404 page when people try to reach /login.
Perfect thanks!
I do have the full version and it stored its tables using no prefix under ‘wpdatatables_#’ which I thought was very odd. It’s worth noting that my actual prefix is wpD. Just wanted to let you guys know.
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]Ok, I’ve told them.
https://ww.wp.xz.cn/support/topic/database-prefix-missing-in-tables/#new-topic-0
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]Wait no that’s not correct, I have a plugin called WPdatatables that makes its own tables without a the wpD prefix and simple uses wp.
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]No no, every one of them right now starts with ‘wpD’, and the prefix set in config.php is ‘wpD’.
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]Hmm I got this error:
“The storage engine for the table doesn’t support r…”
I don’t know if it matters but I have only 2 registered admins.
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]Jep, checked the entire database, they all match the prefix set in config. I’m quite astounded by the register form wanting to send something to the wrong table that doesn’t exist.
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist](I wanted to change the prefix because I’m building an application on top of wordpress and I need my own tables so I wanted to clean up the messy prefix.)
Forum: Fixing WordPress
In reply to: WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]Well as I mentioned I changed the prefix with a plugin from wpD to wp_, which returned the error that wpD doesn’t exist which was correct even though config.php CLEARLY had the prefix wp_ set. Then I changed it back and the error it gave was that wp_ didn’t exist which is also true although the config.php CLEARLY had wpD as a prefix.
I thought it was a server caching issue so I waited a while after which I was able to register a user. Then I thought my problems were over but 5 minutes later I got this error:
WordPress database error: [Unknown column ‘wpdusers.ID’ in ‘field list’]
Now this table does exist 100%, I’m looking at it now.
Thanks! I figure there is no difference between showing the shortcodes and the pages. One huge problem was that Elementor would not load the pages.
@peterschulznl Oke, I figured out how to solve it all by just using PhPmyAdmin, it seems a little easier to make out what the heck I’m doing when designing schemas 🙂 Also read up a bit on composite keys. I think I understand that now though I don’t know exactly how to apply them.
Using the $$USERID$$ seems easy enough, I haven’t tested it yet but the where clause is easy to grasp.
The lookup is also a very nice feature but as I understand it this lookup does not translate to the schema am I correct? As in, the relationship is stored in WPDA and not in my schema so I couldn’t for example see or edit the lookup or other relationships in PHPmyadmin?
What I would really like is for the admin to not have to assign a WP ID to every tutor, pupil, and parent tables. I realize the effort this takes for me to learn and apply is radically disproportionate to any gain anyone might get with 2 tutors and 3 pupils in total but since university has closed I’m all in to creating this amazing dashboard.
@dnuttall Hey thanks for the suggestion, I don’t want name to be unique however I was just messing up thinking it needed to be indexed for me to query based on name haha.
Thanks for the help!
If I remove modal popup and filterable gallery it works…
You know, I’ve noticed something really weird. I didn’t know that each table could have only one Primary Key so I created the pupil table with multiple PK’s… Now that I know that shouldn’t be possible I think it’s strange.
When reading my Database in MySQL workbench it says this:
Table: startracker_pupils Columns: ID int(11) AI PK date_created datetime date_modified datetime name varchar(64) PK rate varchar(10) wpID int(11)Should that be possible?
Hey Peter,
Thanks for getting back to me faster than anyone before, really sorry I wasn’t able to return the favor haha. After dropping the index I still got this error:
The following ALTER TABLE statement failed ALTER TABLE <code>startracker_tutors</code> MODIFY COLUMN <code>ID</code> int(10) NOT NULL AUTO_INCREMENT; ALTER TABLE <code>startracker_tutors</code> ADD PRIMARY KEY (<code>ID</code>); Incorrect table definition; there can be only one auto column and it must be defined as a keyWhile trying to make it a primary key.
If I take out the “auto_increment” to first make the ID column a Key it returns this error:
The following ALTER TABLE statement failed ALTER TABLE <code>startracker_tutors</code> MODIFY COLUMN <code>ID</code> int(10) NOT NULL; ALTER TABLE <code>startracker_tutors</code> ADD PRIMARY KEY (<code>ID</code>); Duplicate entry '0' for key 'PRIMARY'Currently no column is set as ‘Key’ and I’m not able to set one, so I’m taking your advice and rebuilding the entire table.
Since I’m building a tutor-pupil tracking database I’m taking my time to design it properly and preempt any future needs that may arise, therefor I’ve installed Microsoft Access to create the outline first and then re-create it in wpda. I don’t suppose it’s possible to use a mysql client in combination with wpda publisher?
I’m also looking for whether I can merge the wp-user table with my users table and allow users to manage their own contact details. This would eliminate the need for users to be added by an administrator. But I’m not quite sure if this is a good idea.
Thanks so much for the plugin man, learned a ton!