Database - Read For Learn

Help with $wpdb on custom code

If the IDuser field is an integer, try: $um_profile_id = um_profile_id(); $fivesdrafts = $wpdb->get_results(“SELECT * FROM wpjk_vuln WHERE IDuser = $um_profile_id”);

Error during installation (DB)

How can i restore a WordPress site with the DB and WordPress Files

Incase someone stumbles across the same problem, here is how i managed to restore my db. I tried many different versions of mysql but all of them refused to start. The best i managed to do was to get it to start but with missing table contents by deleting the ibdata1 files. Switching from windows … Read more

Where do I put my create_new_table function()?

The code you are currently using for being used as a plugin. register_activation_hook is reserved for plugin use only. It only fires when plugin in activated. If you want to create database table from your theme you can use after_switch_theme. It can be used like bellow: add_action(“after_switch_theme”, “mental_health_providers_create_db”); function mental_health_providers_create_db() { global $wpdb; $charset_collate = … Read more

Removing old_slug and old_date from WordPress Database

Firstly it’s great to clean up your database, and doing this may make some queries faster. Bear in mind that the size of the data in this case is small and these postmeta keys may not be often used so there is little value in removing them, especially if you find you need them late: … Read more

WordPress fails to install with “Can’t Select Database” Error (WAMPServer)

First are you 100% sure you only have one MySQL server that both your PHPMyAdmin and WAMP can be connecting to? If so, the easiest way to resolve this is start from scratch and setup a new MySQL user, a new database, then give that new user access to the database. You need to connect … Read more

How to fix Uploaded to this post option to see group of images uploaded to a post?

First thing to try is to export and import the whole content inside of one single xml file. Maybe this does the trick. If there are no reasons for seperating the posts and the media, you should try to not do this. It can be an issue. If this isn’t working too, you can maybe … Read more