database

How to migrate data from custom site to WordPress?

Question

Currently I have a site with around 6.000 articles running on a custom built cms platform, but due to demand from the client, we have been tasked to convert all data to WordPress. Everything is stored in MongoDB in a ...

database, import 4 months 0 Answers 57 views

Can posts have parents?

Question

Are posts supposed to have parents? If so, what would that mean for a post to have a parent? Also, if there are some constraints to posts having parents, then where is that enforced? Not in the DB as I see ...

database, posts 5 months 0 Answers 62 views

Multiple user tables OR one large table for multiple records per User?

Question

I want to allow users to have 1000+ records in my wordpress system. I was wondering is it best to have just one table for all users and their records or one table per user? Keep in mind that I could ...

database 5 months 0 Answers 58 views

Having issues with wp_postmeta and wp_usermeta tables too big

Question

We've got a WP+woocommerce site that is over 8 years old. The site has over 60,000 users and a similar number of orders. The wp_postmeta has over 4,000,000 records and wp_usermeta has over 1,500,000. This is causing all kinds of ...

database 5 months 0 Answers 50 views

Error establishing a database connection(configuration)

Question

I hope you can help me to fix my problem. i am using wordpress for the first time, and i don't know why i am getting Error establishing a database connection knowing that i have created the file wp-config.php by myself ...

database, php, wordpress.org 5 months 0 Answers 63 views

How performant is update_option relative to update_post_meta when updating on each post load?

Question

I've created an AJAX function that updates the views count of each post load. public function updateViewCount() { // ... $postID = $_REQUEST['post_id']; $key = 'post_views_count'; $count = get_post_meta($postID, $key, ...

cron, database, transient, wp-cron 5 months 0 Answers 52 views

WPDB Insert or if exists

Question

im new to wordpress and am working on a plugin, the database array gets send to it when i activate the plugin, but when i deactivate and activate it again it sets the array in the database again, but i ...

database, php 5 months 0 Answers 54 views

Why do database examples sometimes finish with an add_option call?

Question

Take for an example this perfectly ordinary demo of adding a table. I'm assuming we've all seen examples like this before. function create_table() { global $wpdb; $table_name = $wpdb->prefix . 'table_name'; if( $wpdb->get_var( "show tables ...

database 5 months 0 Answers 42 views

How much of my site can I recover from public_html?

Question

While exporting our site in order to migrate it to another hosting, I failed to import the database. This is necessary since all the posts and pages are kept only in the database, and I'm afraid the last database backup ...

database, export, import, posts 5 months 0 Answers 47 views

Get error messages when $wpdb->insert() returns false?

Question

$wpdb->insert() returns false which I've learned means that the insert failed. Now, I would like to know why it fails with the insert. According to this ticket https://core.trac.wordpress.org/ticket/32315 the problem could be that the value is either too long or ...

database, errors, wpdb 5 months 0 Answers 72 views

1 2 … 38

Register Now

Login

Lost Password

Login

Register Now