The problem is that your images reside in /wp-content/uploads/ and without this folder, everything will be restored except images and some files you have previously uploaded to the Media Library. The plugin(s) and the theme you used could be installed (uploaded and activated) again. To backup a WordPress websites you only need to backup the … Read more
User roles are not stored in wp_user table. They are stored as User Metadata. In wp_usermeta you can find two rows for every user: <prefix>capabilities (for example wp_capabilities) which contains serialized array of roles assigned to that user <prefix>user_level (for example wp_user_level) which contains level of given user. It’s important to remember, that keys for … Read more
The database password is not stored in the database itself, so importing the database via phpmyadmin will not also import the password. You need to manually edit your local copy of wp-config.php, and enter your local username and password for MySQL ( or any other database you are using ). Usually the default username for … Read more
There is no WordPress specific query log unless you build one yourself. The only history you’ll get will be the history that MySQL itself provides. Unfortunately, the database does not distinguish between applications, so you will have to filter by tables and database to just those relevant to you. How you might do that is … Read more
Try disabling the plugins – it may be that one of them is causing an error that is preventing the database connection from even executing and thus giving you an error regarding the database not being connected. Do those two sites have a common plugin?
Welcome to WPSE. There’s probably more than one way to do this, but here’s my first thoughts. The first thing you may want to do is to register a custom post type (CPT) for the video content. This way you can have “video library” at the backend (i.e. Dashboard) for managing the video content. If … Read more
We downloaded a database back up via UpdraftPlus from the Azure WordPress. And the problem became pretty clear. Take a look at the Storage Engine and Collation of the create query: CREATE TABLE `wp_options` ( `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `option_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT ”, `option_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, … Read more
When a session is destroyed, it’s removed from the list in the meta. Importantly, if the list is empty, the meta is deleted. So if a user logs out, if a session expires, if a user is deleted, or if the user clears their sessions on their profile page, these can all result in no … Read more
You can use the wp_create_user function to create users without a defined email To log in without a password you can see this question
Thanks to @GTsvetanov from Stackoverflow.com. Missing part of my code is $request->get_json_params(); for getting json request then compare it with schema using rest_validate_value_from_schema() then using rest_sanitize_value_from_schema() for saving proper data to database. $schema = $this->user_playtime_meta_schema(); $val = $request->get_json_params();//<– my mistake $result = rest_validate_value_from_schema( $values, $schema ); if ( ! is_wp_error( rest_validate_value_from_schema( $val, $schema ) ) … Read more