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

learn more… | top users | synonyms

0
votes
2answers
21 views

Export only pages and posts with mysql dump

How to export only pages and posts using mysql database to database approach? More precisely: what tables should one select for dump (I suppose wp-posts and wp-post-meta ) is it safe to export only ...
0
votes
1answer
8 views

SELECT SQL_CALC_FOUND_ROWS with wordpress search

When I make a search on my site no posts are retrieved and through wordpress debug I get this error message: WordPress database error: [Table 'theme_se.wp_comments' doesn't exist] SELECT ...
0
votes
0answers
24 views

Connect Local Install to Remote Database

I would like to connect a local installation of WordPress to a remote database. How would I go about accomplishing this?
0
votes
1answer
25 views

Child theme functions.php file change database entries

I'm sure my title is not the correct terminology. I will do my best to explain what I'm trying to accomplish. Years ago I spent countless hours customizing a theme. I was finally forced to update ...
1
vote
2answers
30 views

Setup 3 Sites To Connect To 1 Database and Share Data

How do I setup 3 different Wordpress installations on 3 different servers, all of which connect to a single database and also share the same data? I'd like to set up 3 different servers. One for ...
0
votes
0answers
33 views

How can i change posts dates random?

I have totaly 5k content. I need change all of them dates. How can i set randomly dates? SQL? Example from 01.01.2010 to 20.06.2016 everyday can be dates.
0
votes
0answers
13 views

wpDataTables Front-End Editing with Custom Post Types [on hold]

Has anyone used wpDataTables front-end enditing with custom post types? It seems as if it might be impossible for this to work because wpDataTables can only update one table at a time, and custom post ...
-1
votes
0answers
20 views

Error establishing a database connection using Azure

We're using Azure to host our website, last week we accidently hit our maximum number of connections so Azure stopped our website. But today, Azure has re-enabled out website but now it isn't working. ...
0
votes
1answer
43 views

Ajax not working to insert, query and result data

On my site, through a form I send/register same information in database, do a SELECT/query and return it! Return the last table saved in database, just that user just entered on the form (along with ...
0
votes
0answers
11 views

Database with mixed collation (utf8mb4 & utf8_general_ci)

Each time I was uploading my WP install from offline to online, I was noticing strange characters in text and digging a bit I have discovered that wp-config.php on the online server was set to define('...
2
votes
1answer
26 views

Get all tags not just first 10 with wp api 2.0

if I do /wp-json/wp/v2/tags I only can get first 10, and seems the adding per_page=0 no longer work on it for getting actually all tags. Anyone knows how to actually get all the tags with wp-api 2.0?
0
votes
0answers
15 views

Override $table_prefix only for the options table

The only documentation i found was too obsolete. (https://wordpress.org/support/topic/two-sites-two-themes-one-database-same-content) and this one (Change options table prefix only) doesn't help me. ...
0
votes
1answer
24 views

Wordpress plugin boilerplate table create

Hi I have a terrible problem. I generated the code plug on the page: http://wppb.me/ And now, in no way do I add a table to the SQL database installation. I tried to do it this way: includes/class-my-...
0
votes
0answers
14 views

How to insert an uploaded file programmatically to DB?

I have uplaoded a 1GB file with extension bin.part (xxx,bin.part),directly to the uploads folder in the server, but I dont see it in the media library in the wordpress admin . I have tried using the "...
0
votes
0answers
14 views

Call to a member function insert()

I did a POST form and try to sign in to the Wordpress database is showing this error. Fatal error: Call to a member function insert() on a non-object in C:\wamp\www\teste\wp-content\themes\...
1
vote
1answer
34 views

Wordpress Integration with Google Groups

I'm having some trouble trying to make an area on my WordPress site, that must be accessible only to members of my Google Group. I tried to make it with some plugin, but most of them would take me to ...
0
votes
0answers
37 views

How to generate notifications when MySQL data base changes

I am developing a WordPress multisite and I am wondering how I can generate notifications when MySQL database changes? For example the user in site #1 can sell his society. When he selected it, it ...
3
votes
1answer
34 views

stdObject stored in database. How does one convert it to usable format?

So I logged on phpmyadmin, went to check out how data is stored in a table and saw it''s 'data' columns contents (pasted below): a:8:{i:2;O:8:"stdClass":2:{s:5:"label";s:6:"Vardas";s:5:"value";s:1:"A"...
-2
votes
1answer
46 views

Fetch all categories from database

My Android project needs to fetch the database every day. I have a category structure like: console tablet camera phone laptop other The structure of the WordPress database is very confusing. I ...
0
votes
0answers
27 views

How to display the results of inner join to user?

I have three tables of contents. And I put them together and display the result to the user, how can I do this? MY CODE THAT INSERT DATA IN TABLES: function cadastra_experiencia($nome, $email, $...
0
votes
0answers
15 views

Sharing tables between 2 different websites based on the same database

I have 2 different websites installed on the same database. The 2 websites are sharing the users tables, but I want them to share the posts tables too. I tried to do it by editing wp-db.php. After ...
0
votes
1answer
38 views

How to connect and insert data in database of wordpress?

On my website, there is a section called "My Ideal plank." It is a form where the user will enter their data and there will be a return message with the type of ideal board for the person. First ...
0
votes
0answers
21 views

Wordpress Authentication without Wordpress functionality

The requirement is to authenticate against the WordPress users tables to get past the paywall but not offer any WordPress functionality. The problem to resolve is that since the user is ...
1
vote
1answer
67 views

Store and Work with huge array in WP [closed]

I need to get all terms that have post with dates in custom field. So I need a list for all dates from the term. I need to know exactly what is tha dates within each term in my site. It's not in term, ...
0
votes
0answers
15 views

Trim data before insert?

Recently I use this syntax to input data like below: $STRING_DATA = StrToLower(Trim($input_data)); $wpdb->query ( $wpdb->prepare ( 'SQL SYNTAX WITH PARAMETER STRING', $STRING_DATA ) ); Do I ...
3
votes
1answer
52 views

Right way of storing large number of custom post fields

On one of the sites of my multi-site network; I'm creating a custom post type 'Events'. Each of the 'Events' post will have about 30-50 custom post fields - because we require event creators to enter ...
-1
votes
0answers
29 views

Wordpress Theme linking to a Sharetribe Database

I am a wordpress newbie and am building a site and am keen to use a Wordpress Theme and then link it to a Sharetribe.com database. I do however want to have a multifunction search bar on the home page ...
0
votes
1answer
14 views

Regenerate user_nicename column

I'm struggling with a database issue. I took control over a solution created by someone else. When inserting / updating users in the database, the earlier developers wrote a custom database script to ...
-1
votes
0answers
16 views

Dump new user data into codeigniter user's table

Here is the flow: Add new user from WordPress dashboard. Grab the newly registered user's data. dump user's data into codeigniter app database What i have tried: using user_register action hook ...
1
vote
1answer
36 views

Trying to establish connection to External Database

I'm trying to get a connection to a separate external database from the database the wordpress site depends on. I have a PHP file inside the same location of my theme, it is basically a blank PHP it ...
0
votes
1answer
35 views

Get posts and include taxonomy term

How can I return taxonomy terms within post data, from the same query. Currently I'm calling get_posts / wp_query and then looping over and calling wp_get_post_terms. Needless to say it thrashes the ...
0
votes
0answers
26 views

INNODB Supports transactions, row-level locking, and foreign keys

When I try to create a table for a plugin (that was dropped in the past) I get the error: #1005 - Can't create table 'database_db.wordpress_popularpostssummary' (errno: -1) (Details…) And the ...
0
votes
1answer
42 views

$wpdb->delete column values IN ARRAY()?

I am wondering if this is possible? $wpdb->delete( 'table_name', array('id' => array(1, 2, 3)), array('%d') ); So, in this situation, it should remove 3 rows at once, and call the ...
0
votes
2answers
37 views

Change options table prefix only

I am not able to find, How can I change the only options table prefix. I do not want to change other tables prefix only need to change options prefix. Please guide me. Thanks
0
votes
1answer
43 views

Get wp_current_user_id using PHP and MySQL

awesome people of the Stack Community! Like the newbie coder I am, it took many hours but at last I got: a HTML form inside wordpress -> to submit value to MySQL database -> and then store the ...
3
votes
1answer
50 views

Is sanitize_text_field() is enough to save to DB?

So here is the situation. We allow users to enter input data, i.e. user_first_name and user_additional_comments. Then we use sanitize_text_field() , which is named as save. But after this filter: ...
1
vote
1answer
53 views

what are pmxi tables? [closed]

I'm on multisite mode. I can see that for each site of the network there are 4 'pmxi' tables. What are they for? They're something like this siteprefix_pmxi_files siteprefix_pmxi_imports ...
2
votes
1answer
47 views

Usage of Direct Database Call Without Caching Error

I have a custom function that creates a dynamic copyright year range based on the year of the first and last posts in the database: function jldc_copyright_dates() { global $wpdb; $...
0
votes
3answers
50 views

moving wordpres from one VPS to another - Error establishing a database connection

I had a wordpress site on VPS server and decided to move to faster one - with the same host provider. I had VPS on CentOS with Plesk and moved my domain to another one with the same OS. I have ...
0
votes
0answers
38 views

Search result by taxonomy name

Currently my search filters by title and I'm trying to filtered by taxonomy tags. How do you I do that. Here is my code: $query = " SELECT * FROM $wpdb->posts WHERE $wpdb->posts.post_status = '...
0
votes
1answer
48 views

Sorting custom post type columns with external data and without meta values

I created a custom post type 'Book', for which data is stored in an external database (like ISBN, author etc). The WordPress database contains the ISBN per custom post, which connects the correct data ...
1
vote
1answer
44 views

Wordpress Database lost auto increment

After rolling back a Wordpress database to a backup version it seems that all the tables lost their auto_increment on the primary key columns. I read on another post this could be to do with InnoDB ...
1
vote
0answers
30 views

The word 'exit' in a content box causes WordPress to serve a 'Not Found' page [closed]

I've been developing with WordPress for years, and this is a new one. When the word 'exit' is included in the content of a post, even if inside another word like 'complexity', the post will not save. ...
0
votes
1answer
36 views

wpdb query on custom table not working [closed]

I want to show one custom table from my database on which WordPress is installed. So I googled this code: <?php $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM sparte-...
-1
votes
1answer
33 views

1000+ records per user: Multiple user tables or one large table

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 ...
1
vote
1answer
19 views

Can I transfer a mysql database to another site?

I've been playing around with WP for about 2 years so I know my way around, but I'm kinda new to working with databases. I've been making sites not relying on a database too much. However, I have a ...
0
votes
0answers
13 views

Exporting a multisite DB for a single site production site

So I have a wordpress multisite that houses all of my client test sites(14). This means that its all one database obviously. This client is now ready to go live on a single wordpress instance so I'm ...
0
votes
0answers
32 views

Storing Unique Data on the Database

I have created a custom table on my database using the code below: function dbcreator_activate() { global $wpdb; $table_name = $wpdb->prefix . "ftbstatistics"; if( $wpdb->get_var('...
0
votes
1answer
25 views

How to transfer one domain to another domain without losing theme options (customizer)?

I have developed the one wordpress site with custom theme, Here I used the custom customizer options. Then site completed on my local machine I mean localhost (http://127.0.0.1/wordpress). Now the ...
0
votes
1answer
26 views

Finding the login page from database?

long story short I was given the login information for an older gentleman who unfortunately passed away who managed a young lady's Wordpress website. Was asked to manage and update the site for the ...