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

learn more… | top users | synonyms

1
vote
3answers
1k views

Safest way to bulk delete post revisions

One of my clients is on a rather large blog in terms of number of posts and traffic. I'm trying to get her database down to a manageable size, and one thing that's bulking up is literally tens of ...
0
votes
1answer
31 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
93 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
1answer
46 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
33 views

How to set max users to 17.000

For a website i need a range of user_id's from 10.000 to 17.000 I've already been able to set the minimum, but i'm clueless as how to set the maximum. I've been Googling around for a while now, hoping ...
0
votes
1answer
32 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
108 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
176 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
30 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
144 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 ...
1
vote
3answers
534 views

Bootstrapping Wordpress MultiSite Outsite of Wordpress - No $wpdb

I'm working on a plugin for a system to use Wordpress as the authentication backend, so that I can use my existing Wordpress users in another application. The plugin works great when running in single ...
2
votes
1answer
33 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
25 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 ...
0
votes
1answer
50 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
28 views

Local Content different from Remote Content

Problem Description I am developing a project using Wordpress as a CMS for a web page of a Scientific Research Group to Publish Information, News, Publications and Projects of the Scientific Group. ...
0
votes
1answer
56 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 ...
-3
votes
2answers
53 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
2answers
45 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
64 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
27 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
1answer
55 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
61 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 ...
3
votes
5answers
2k views

How to run Two Wordpress blogs with different themes and with single database and same content

How do you run two Wordpress blogs with different themes using one database where the content remains the same in both sites? The issue that I am getting is at the Domain mapping in both blogs.
0
votes
0answers
56 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
14 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
2answers
1k views

Plugin: connect to external database without showing password

I am creating a WP plugin, which shows information from an external database. The plugin will be distributed, the external database is on my own server. I know the following code will connect to my ...
0
votes
0answers
119 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 ...
0
votes
1answer
120 views

Multiple WordPress sites installs sharing the same database but with different content and domains

I was wondering if it is possible to have multiple WordPress websites installed using the same database and database user. For example, I have site 1 and site 2 - www.site1.com and www.site2.com ...
-1
votes
1answer
42 views

Access and navigate Wordpress database outside of wordpress

I am developing my own website that will act as a new blog, however when I switch from my wordpress blog to this one I don't want to lose all of my posts, users and comments. I assume all of this is ...
0
votes
1answer
40 views

Custom metabox does not store data

I'm troubled with a custom metabox, could someone give me a helping hand? I've got a custom post type which uses it, but unfortunately it's not storing the data into the database. Any clue? ...
0
votes
1answer
62 views

Check if a database is well installed

I tried to install wordpress under eclipse and xampp under ubuntu. I created the database (user: root, password: empty) by a sql command create database wordpress;, that is it. The wordpress seems to ...
0
votes
1answer
105 views

Multiple wp_options tables to share content across installs

My application has >10 user_roles, each able to perform completely different tasks, provided with an custom backend and no access to wp-admin. The extra functionality each user_role gets to use is ...
0
votes
0answers
23 views

Wordpress autosuggestion box

I have been searching all day for a solution, but I think I'm to noob to distill an answer to my problem from the various sources in the community. I'm trying to create an autosuggestion/autocomplete ...
0
votes
1answer
56 views

How to delete all the content of a wordpress site without deleting the Post and pages?

Is there any way to delete all the content of every post without actually deleting the post! Suppose , I have articles how to install wordpress ? what is wordpress . . . . and so on ...
0
votes
0answers
19 views

Array or Database

I have a question concerning the storage of variables. For my website I would like to add fields for education to the profile of users. To promote uniformity I would like that every user picks from ...
0
votes
2answers
82 views

Database Name Change

I read it was more secure to use something else besides wp_ as the database prefix, so I downloaded my .sql file replaced all instances of wp_ with tsi_ and then dropped the wp_ tables and imported my ...
0
votes
1answer
104 views

How to insert a single row to WP database table?

Intro: I have a function that handles a contact form variables in my website. user enters name, email and text. function.php gets variables using javascript. I get more information on the user ...
5
votes
1answer
162 views

So much data in postmeta

Last year started using custom fields and in one year I have 230,540 rows in wp_postmeta table. This year will add more data and new fields and I don't know what to do, to create new table or continue ...
0
votes
2answers
97 views

Error establishing a database connection on Installation

I was working on my MacOS System with everything well configured and working. Now I try to migrate all of my work to Windows using the same software as in MacOS MAMP to run Wordpress on localhost. So ...
1
vote
4answers
5k views

Converting WordPress into Android or iPhone app

I've had a request from my client to convert their WordPress website into an App for Android and iPhone. I've looked around at a number of options and it seems doable especially for just the blog ...
4
votes
2answers
467 views

Using Vagrant for customizable Wordpress Multi-sites [closed]

Background: My partner and I have a goal to create a customizable vagrant project that uses Wordpress multi site, as a local development environment. Ideal Use Case: Various developers on our team ...
0
votes
3answers
82 views

Can I create a table on my DB without creating a plugin?

I have a built in form I created on my WP website . I want to store the inputs to a table on my DB. All tutorials that explane how to create a talke include the fact that I have to create a plugin ...
0
votes
0answers
59 views

Multiple domain with one database

I have multiple domain (Multiple domain + subdomain as well) for the different countries and for the different states of it. Now i want to run all the domain from one signle database, all the domain ...
0
votes
1answer
403 views

What is the purpose of the option name hack_file in the options table?

I was looking at the options table in a WordPress install and noticed an option name hack_file. At first I thought the site was compromised and then realized it is a default option ...
1
vote
2answers
825 views

Wordpress doesn't show all posts in database

I have around 140 post in database but wordpress admin page shows just 50 post. How could I let wordpress shows all the posts in database? Thanks
0
votes
1answer
54 views

Create a new table on the database and save parameters from a contact form

I have a wordpress function in functions.php which gets parameters from a form I made and gets parameters like IP addresses and UTM tags (from the URL) and sends them to me by email. I want to get ...
4
votes
6answers
10k views

Site stuck in “Database Update Required” loop

I just updated to 3.1.3 and now when I go to the admin I get the "Database Update Required" /wp-admin/upgrade.php screen. I click 'Upgrade Now' and it says it's done, but then trying to access ...
0
votes
0answers
106 views

Use a Firebase DB as main DB

I was wondering if it was possible to use a Firebase database as a main database? Or do you have another solution to use a unique DB across multiple dev station? Thanks :)
0
votes
0answers
22 views

WordPress Database Update Required

This is my first time experiencing the "DataBase update required" and then will not login in to the site. I am currently running version 4.2.2. I have read many blogs and see many people have had ...