WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

0
votes
2answers
30 views

Issue “Error establishing a database connection” problem.

Here's the situation. I needed to create a copy of the website online so that I could redesign it and collaborate with others to redo the content. Consequently: I copied a website (example.org) to ...
0
votes
1answer
41 views

Need help for creating custom table on wordpress

I'm trying to learn how to create and use custom tables on wpdb for a plugin that I'm going to build. So far I've seen a bunch of tutorials and know how to create a table but I'm facing problems ...
0
votes
0answers
39 views

Export User Info into CSV - Additional Column (post_title)

I'm using the 'Export Users to CSV' a plugin for wordpress. By default, The plugin only extracts wp_users and wp_usermeta I have been wanting to add post_title column from wp_posts. I was able to ...
0
votes
0answers
22 views

get backup file from wordpress database in x days

I have a wordpress website with so many posts and custom fields located in meta table. What I have to do is to make backup from each 30 days (for posts and postsmeta table) and append it to my last ...
0
votes
1answer
357 views

Inserting Post Meta From SQL

I'm trying to get post meta to be updated/replaced with $wpdb and running into issues. I have working SQL, but cannot get it work when coding it up for my WP plugin. Extra note: The post meta being ...
1
vote
3answers
822 views

Why does $wpdb return strings for mysql integer values?

I find it very inconvenient and hard to understand that the default behavior of the Wordpress db-interface is to convert all integer (and float?) types to strings. e.g $wp_posts = ...
0
votes
1answer
96 views

Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING

I installed the "Insert PHP" plugin in my Wordpress page, activated it, and put this code in my page: <p> Connection test </p> [insert_php] $mydb = new ...
0
votes
0answers
21 views

Store id from database query in cookie

I need to store an ID value which is generated upon doing a database insert. After the insert, javascript redirects the user to an external page, which will then redirect back to a wordpress page ...
0
votes
2answers
63 views

How do you build a database-centric site in WP?

The best way to explain this might be to relate my site to a comparison shopping site, as I have around seven tables with 500k+ records each. The content on my site is a comparison of items, and ...
0
votes
0answers
22 views

Allow network sites but also allow single sites

Ok, I think I really need some help here. I am feeling like this is more complicated then it should be. Here is my aim. If plugin is used on single wordpress site than allow and use the class ...
0
votes
1answer
100 views

Automatically generate pages from SQL

I'm building a biodiversity database and am looking for the easiest way to display all the information online. I know I can do this without a CMS, but I have too tight a deadline to waste time ...
0
votes
2answers
111 views

Split database on large site?

What will be best way to split large database on single site, not multi-site wp installation? HyperDB is maybe for this (just, less than 10 webmasters managed to figure out how to install it, ...
0
votes
1answer
38 views

Can form entries from a WordPress form go to a database

I am using Wordpress 4.3.1. I have built a stand alone form (form 1) using PHP where one can enter volunteering tasks doable in a city, has fields like volunteering activity, city, state. The values ...
0
votes
0answers
16 views

MyISAM vs InnoDB [duplicate]

We have a Wordpress website with almost 100k posts (and many more drafts and images). Number of simultaneous visitors reach 6k at peak times. Which database is more suitable for us?
1
vote
2answers
39 views

What happens if I overwrite the current wp_options table with a backup from a week ago?

I have a rather silly situation. I tried this query UPDATE wp_options SET option_value = 'a:0:{}' WHERE option_name = 'active_plugins'; which disabled all my plugins. I was testing some issues on ...
0
votes
1answer
691 views

How to create a searchable database with a single-field search box at the front end?

I have seen many websites having developed a (hidden) database of their certified clients (actually details of the clients and the given certificates) and they have devoted a web page where clients ...
1
vote
3answers
2k views

How to initialize $wpdb?

I have a .php page in the theme root to check the data of one CUSTOM form. After receiving this data I need to do a query in a custom mysql table, so I need $wpdb, but I can't use it directly (or ...
0
votes
1answer
77 views

CPT or Custom Table for Repository of Serial Numbers

My app allows users to purchase products from a WooCommerce store. But I need to attach a serial number (cannot be generated on the fly) to each product, depending on type, size and design. The ...
0
votes
0answers
48 views

Website goes slow down after importing long database

I am working on a site which have 2 lakhs post and 15 categories. I have home page with 3 post of each category on home page. And after that its goes down while run home page and shows page not found. ...
0
votes
0answers
19 views

How can I move a Wordpress multi-site's domain seamlessly?

I have a multisite install and I've been setting up local and staging sites fine using a plugin (All-in-one-migration) tool to import / export DBs which handles updating the domain link embedded in ...
0
votes
1answer
33 views

AJAX Not Working With Wordpress Database properly

I have created a simple like system where user can click on like button and the like count will increase by one . And if he has already liked the button and he like the button again then it will ...
0
votes
1answer
28 views

Directly editing WP database issues

I've been struggling with this for a long time and would appreciate some help. I would like to change a value inside WP database using phpmyadmin. Sadly, this change seems to corrupt the database ...
0
votes
1answer
82 views

Store the wordpress “featured image” under »wp_posts« Database table

How to store the WordPress featured image under the wp_posts table. Can any one help me? The reason why I am asking same table details (wp_posts), is because I am using a JSON response to add in my ...
0
votes
1answer
58 views

How do you render posts from outside wordpress?

I'm trying to display posts outside of the wordpress system (another system is pulling from the mysql database). However, the posts stored in the database seem to be void of <p> tags and ...
0
votes
1answer
2k views

Database tables for sports betting integrated in Wordpress

I am currently building a sports betting website, and have problems creating database tables for tipsters who writes sports picks. All the picks should be stored in a database table, with information ...
0
votes
2answers
242 views

Website keeps going down, is it a plugin, database, memory problem, or something else?

So I've been having a problem with one of the websites I manage. Essentially, we keep seeing the cloudflare 'site is offline' message for at least half the day, constantly and consistently. Whenever ...
0
votes
0answers
21 views

Syncronize post from different databases

I have an "engine" site that import rss post from all over the world, all day, like an aggregator. That importing activity is really slowin down things. So in a different neat and clean wordpress ...
0
votes
1answer
78 views

wp_usermeta - Read from database, but save function broken

I added a custom field to the profile-page of WordPress users called "uidnumber" and it reads values from the database just fine, however it just doesn't save anything. I'd rather save it in ...
3
votes
1answer
586 views

Can a post ID be 0?

I couldn't find explicit confirmation of this, can it be 0?
0
votes
0answers
278 views

Need to save data to database from AJAX phone submit form

I have an input that accepts a country code (a select/dropdown form) and a phone number (number input) and submits them via AJAX to a pin verification service. The verification works great, but I need ...
1
vote
1answer
33 views

Moving minor updates between local and live sites - just database?

So after I have created my site on my localhost, and moved it over (files + database + config to new url etc...) I continue to work off the localhost version. The sites are identical. I then add ...
0
votes
0answers
34 views

What would Repair and Optimize Wordpress Database do?

Recently I am getting an error establishing a database connection in a clients Wordpress site. I googled for a solution and an article suggested to enable Wordpress Repairs by adding this to the ...
0
votes
0answers
32 views

$wpdb global causing issues with plugin class

I am currently building a plugin. I have a main init.php file which loads all the necessary plugin classes. Within one of the classes, I have several methods that call the $wpdb global. One of the ...
5
votes
2answers
966 views

Detecting errors generated by $wpdb->get_results()

How do I detect errors when using $wpdb->get_results()? For example: $result = $wpdb->get_results("SELECT * FROM this is not a valid query"); The preceding code doesn't generate any exceptions ...
0
votes
2answers
21 views

Error establishing a database connection for some files

Host: Blue Host I have just moved a friends wordpress site to another host, something I have done a few time now without fault. This time there is an issue with random files. The website loads fine ...
0
votes
1answer
35 views

Hash user emails in database?

I have a wordpress based website, a very important thing is that no one should get to know the email addresses of the people who will admin. I will make the whole website private but I am still ...
8
votes
5answers
9k views

Can posts have parents?

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 ...
0
votes
1answer
616 views

Displaying BLOB PDF File

I have some pdf files that are stored in the wordpress database as a blob and I need to display these files. The files are not linked to any posts directly. The code I have currently is: <div ...
0
votes
3answers
2k views

Saving Custom Post types and fields to a custom table

I have a project in which I am trying to import a large amount of data into a WordPress installation and from that data, create pages on my site (as a custom post type). Since these pages will be ...
7
votes
2answers
193 views

Relaunch 4.2 utf8mb4 databse upgrade

I updated WP to 4.2 while it was on an old server, that doesn't match the utf8mb4 upgrade requirements. I moved to another server that fit these requirements, but WP won't launch this database ...
0
votes
0answers
50 views

how to sync user database with excel sheet

guys! I'm currently building a website for a ONG and I've been asked to create a private page where the user's could see the points they have gathered with our organization and that can latter be ...
0
votes
1answer
143 views

Media Library doesn't allow uploads? Upload Directory

I just put up a WP 4.31 site. Most of the content was copied from a different WP site via FTP. All the stuff in wp-content: uploads, plugins,themes, etc. It all seemed to work as usual, and I've ...
0
votes
0answers
78 views

How to get data from Wordpress form into php or C#

I have a wordpress website and I created a form where the users can put in some information. I want to get that submitted information using preferably C# or any other popular programming language like ...
0
votes
0answers
50 views

why require a refresh page for see the changes from database $wpdb

I used a functions for create a new user, new site, switch to new blog and give new theme. wpmu_create_blog add_user_to_blog switch_to_blog switch_theme(); restore_current_blog(); when form ...
0
votes
0answers
35 views

mySLQ database into wordpress

Ok. I'm not even sure how to ask this but I'm trying to make a leaderboard on my site, where users enter points daily for five different options - on the honor system. I want the users to enter the ...
1
vote
0answers
83 views

Refresh page after update_post_meta

I have created a input field on a front-page where the value of the database is on the same page as the input-field. If a value is passed to the database I have to reload the page for it to show on ...
7
votes
1answer
92 views

Automate Wordpress Database Upgrade

I've set up auto-updates on my Wordpresses by adding /* Updates */ define('WP_AUTO_UPDATE_CORE', true); in the wp-config.php file. Once Wordpress releases a new version, when I try to reach the ...
0
votes
1answer
21 views

Get multisite count without php?

I'm writing a program in Python that outputs information about Wordpress installations and I'm adding some features to detect Multisite installations and their details. I would like it to print how ...
13
votes
1answer
4k views

When is the 'post_content_filtered' column in database cleared by WordPress?

Some WordPress plugins (although very few) use the post_content_filtered column in database to save some data related to a post. For example, Markdown on Save stores the markdown version of a post ...
0
votes
1answer
78 views

How to get product order by two custom taxonomy in wordpress

Yesterday i stuck in the middle of code that how could i retrieve product belong to specific custom taxonomy ordered by other taxonomy. Table wp_posts: id | post_title ---------------------- ...