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

learn more… | top users | synonyms

0
votes
1answer
31 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
77 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
50 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
2answers
198 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
20 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 ...
3
votes
1answer
564 views

Can a post ID be 0?

I couldn't find explicit confirmation of this, can it be 0?
1
vote
0answers
36 views

admin_print_scripts in admin-header creating issues when creating/editing post/page [closed]

Whenever I try to add a new post or page to my wordpress site, the page either gets stuck at loading, or loads incomplete, unable to insert content and publish.. Through a little debugging, I found ...
0
votes
1answer
75 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 ...
0
votes
0answers
266 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
32 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 ...
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 ...
1
vote
1answer
32 views

Unable to set a default serialized array using dbdelta()

I am trying to set up a table with dbDelta() and one of the columns will have as default a serialized array with predefined values. The issue here is that dbDelta() explodes the query using ...
0
votes
0answers
47 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
0answers
71 views

siteurl value getting populated with junk in wp_options table

My website was getting this error on every page : Catchable fatal error: Object of class WP_Error could not be converted to string in /home/juhisheth/public_html/wp-includes/default-constants.php on ...
0
votes
1answer
135 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
72 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
49 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
76 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
91 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
529 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 ...
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 ...
0
votes
1answer
73 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 ---------------------- ...
0
votes
1answer
33 views

How to add an external php page with wordpress?

i want to add a page with html data to show form and get input from user,store it to database and after successful query show next page with massage that the data is inserted successfully.
0
votes
1answer
27 views

Installation question

I am a brand new developer to wordpress and about to begin work on a client's website that is already up and running. The site is very simple, it is more-or-less just a brochure with very little use ...
0
votes
1answer
166 views

Remove empty rows from the database

I'm writing a script to alter the post content column in the database and I just notice it has a lot of empty rows, these seem to be deleted posts that now have no content or anything, I don't like ...
0
votes
2answers
360 views

What's The Proper Way To SAnitize Checkbox Value Sent To The Database

I have tried using sanitize_text_field() and esc_attr() to filter checkbox data when saving their values to the database, but it is causing the data not being saved. What is causing it and what's the ...
0
votes
1answer
69 views

Show a table from data submitted by a form from a user

I would like to show a table on my wordpress site, which is filled by registered users. How can I realize this? So my thoughts are: Registered users should be able to submit 2 variables through a ...
0
votes
1answer
39 views

special characters not supporting in wordpress

First I dont know from which thing I am facing problem. I have created a wordpress website and it was working fine. I have moved it later to justhost.com and then I have got this problem. Special ...
1
vote
0answers
137 views

Create a table with wordpress plugin boilerplate

I am a new wordpress developer and i would like to create my first wordpress plugin based to wp plugin boilerplate template plugin. My plugin will have to do with my clients data so for this reason i ...
1
vote
0answers
229 views

Slow SQL_CALC_FOUND_ROWS Query

We are experiencing very slow performance with queries that use SQL_CALC_FOUND_ROWS within the admin section of WordPress. We currently have about 125,000 posts on our site and use Varnish to cache ...
1
vote
1answer
33 views

Storing Array from returned database query and using the array in a new query

I'm currently storing results in a variable from a db table like this : $followed = $wpdb->get_results("SELECT user_id1 FROM wp_um_followers WHERE user_id2 = 1", ARRAY_A); This returns an array ...
0
votes
1answer
190 views

What might be the reason of Couldn't fetch mysqli_result on another domain?

I'm developing a plugin and it works fine on my Wordpress website, but I've tested it on other domains with different Wordpress instances. When trying to activate the plugin on some other sites and ...
2
votes
1answer
34 views

What are conventions about the schema of the $table_prefix

I wonder if there are any conventions or best practices about the table prefix of any WordPress set up. The official documentation on wordpress.org does not make any statements to that topic. ...
0
votes
1answer
53 views

Changing order of db results when encoding to JSON

There is probably a very simple solution to this but I just can't work it out. I am getting some info from the wp database, bypassing WP's built in classes, then echoing the results as encoded JSON ...
0
votes
1answer
73 views

WP_Query always returning the last custom post

I have code that works fine on our live system, and I'm porting it to a new theme. In the new theme, the WP_Query always seems to return the last custom post. My function is: function ...
0
votes
1answer
27 views

Send data to database after redirect (and popping out of iframe)

I am using $wpdb->insert to place form data into a custom database. There a multiple things happening, though. The page that sends the data to the database is caught in an iframe. I know how to get it ...
-3
votes
2answers
56 views

Problem with form database connectivity

Many people has asked the same question, I have read those things and mine is different, I am trying to insert some values inside the database from the form but it's not getting inserted I have a ...
0
votes
0answers
34 views

Querying same column twice with wpdb (for postmeta values, specifically latitude and longitude)

I've seen similar questions around, but I just can't apply them to my case, I'm quite new at this, apologies. I'm trying to create a google map of my posts, using a latitude and longitude that are ...
0
votes
2answers
48 views

Database SQL Error, Should Work

I'm trying to get my posts to order by radius, and so far i'm struggling, I've been using the following tut by Steve MArks, http://biostall.com/performing-a-radial-search-with-wp_query-in-wordpress ...
0
votes
1answer
70 views

Wordpress mysql table double prefixes

Currently working on updating a wordpress website for a client of mine. The wordpress mysql database has double prefixes in it though. The standard wp_ prefix and her own custom prefix for the ...
0
votes
1answer
79 views

WP Database generate content for post_name column

I ran a query that deleted all content in post_name (used for SEO-friendly URLs) column. UPDATE wp_posts SET post_name = '' I thought that WordPress would automatically populate new ones if I ...
0
votes
1answer
77 views

Database Query not working

I've been following a tutorial by Steve Marks which goes throught adding information from posts to a new Database Table as well as the usual postmeta one. However no matter what I try, It will not ...
0
votes
0answers
66 views

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for

In my wordpress showing this error: WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ...
0
votes
0answers
17 views

Where are user records awaiting to be confirmed stored in the database? Where's the Lock ?

Per the title : I have a user that claims to have not received their "confirmation" email - I (the db) has no record of their email address, because I manually deleted it via the 'dashboard' due to ...
0
votes
0answers
146 views

create a form and save data into new table

I want to create new form to add my customer details including name, email, contact num, address Once created, this form should store all these values into newly created table and also generate 4 ...