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

learn more… | top users | synonyms

0
votes
2answers
38 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
11 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
1answer
54 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 ...
2
votes
2answers
1k views

Ways of managing staging and production wordpress sites?

Ok I've see a lot similar questions.. but they all either outdated or do not fall in in my problem. So the problem is: We have a website and its clone stage website. On that website apart form me ...
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
26 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
34 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
37 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
26 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
30 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
19 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
30 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-...
1
vote
1answer
40 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
38 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
36 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
51 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
28 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, $...
2
votes
2answers
2k views

what to do when your WordPress database is too large?

Well I have asked this question in WP Forums, StackOverflow, and GoDaddy community as well, but nothing worked out. Hoping something is in here. I used 2 separated subdomains for my blog and site (...
2
votes
1answer
32 views

Change setting name in Customizer and keep the data

I created a theme while back when I was new to Customizer API and for some weird reasons I named theme settings as: $wp_customize->add_setting('thefunk_theme_options[header_color] Instead of just ...
0
votes
0answers
27 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
51 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
23 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
69 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
22 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
58 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 ...
0
votes
1answer
33 views

WordPress database error (wp_terms)

I'm having the following issue. Whenever WordPress try to get any term from database (product_tag, portfolio_tag, etc) I see messages like: WordPress database error: [Error writing file '/tmp/...
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 ...
2
votes
1answer
259 views

Can I store my custom comment_type into wp_comments table?

I'm developing a system where a post can have multiple replies/feedbacks. As of now I's storing each of the comments as a serialized postmeta. But just today I figured out that I can use the existing ...
1
vote
1answer
42 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
36 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
44 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
69 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
5answers
34k views

Custom form that store input in database

I have never used WordPress before, but have done a lot of programming. But what is the normal way of making customs forms? I need to create a form where a user fill some input fields and on submit ...
0
votes
2answers
46 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
2
votes
4answers
3k views

How to empty wordpress custom post Database table

I have around 2000 custom posts. And 7 regular wp pages. I want to delete all those custom post without effecting the pages. I thought the easiest way would be to empty the custom post table but I ...
0
votes
0answers
16 views

WordPress Integration with Drupal

I could use some assistance. Can I build a site using WordPress as a CMS for one function, and use Drupal for another site (more of a CRM suite app) elsewhere, and grant permissions to records within ...
0
votes
1answer
49 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
62 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
81 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
1k views

Issue with wp_insert_post and post_content field error Could not update post in the database

I'm having issues creating an import / caching script to be used within a WordPress site. This feed comes from a single text file that is then parsed and returned as an array. When running through ...
0
votes
0answers
261 views

Link wordpress with a SQl + MongoDB + .NET

This may sound a bit crazy, I have a website using different DB, One SQl; one MongoDB, and a .net API I would really really love to be able to move this to a wordpress installation ( or Magento). ...
2
votes
1answer
56 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
53 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 ...
3
votes
1answer
605 views

$wpdb->prepare() warning in WordPress 3.5

I am receiving this warning when I try to run a database query: Warning: Missing argument 2 for wpdb::prepare() The offending query is: $result = $wpdb->get_var( $wpdb->prepare( ...
0
votes
0answers
61 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
59 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 ...
2
votes
1answer
628 views

how to show database content in wordpress post

I'm a beginner for WordPress. I have a database app written in PHP and MySQL and I need to convert it to WordPress and also I what to post the database rows info by shortcode were id="x" like: [...
1
vote
1answer
68 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
49 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-...