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

learn more… | top users | synonyms

0
votes
0answers
10 views

Couldn't fetch mysqli_result on another domain, what might be the reason?

I'm developing a plugin and it works fine on my wordpress website, but i've testesed it on other domains with different wordpress instances and when trying to activate the plugin on some other sites ...
0
votes
0answers
12 views

How is my meta_id related to category?

I have installed a plugin that enables me to add image for category. And i found the image on wp_postmeta table, but i couldn't find how it's related to category that i assigned this image with. ...
2
votes
1answer
25 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
30 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
15 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
10 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
42 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
6 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
37 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
30 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
7 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
38 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
14 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
11 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
25 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
15 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 ...
0
votes
1answer
21 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. ...
-1
votes
1answer
23 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
12 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
41 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
16 views

How to make an insert in wp_posts and use the data inside of WordPress?

I need to do a vehicle system and would like to know how to use the wp_insert function to insert data in the Wordpress database. I must also know how to enter the meta values. Example : color, size ...
0
votes
0answers
3 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
31 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
11 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
0answers
17 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
1answer
31 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
1answer
40 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 ...
0
votes
2answers
45 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 ...
4
votes
1answer
128 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
3answers
63 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
1answer
39 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 ...
0
votes
1answer
25 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 ...
0
votes
0answers
28 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
30 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
0answers
13 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 ...
0
votes
0answers
11 views

multiple wordpress installation with shared usertable on an different database

I have multiple wordpress installation, and I would like them to share the same usertable. The wordpress installations are already up and running, and they all have their own database. Is it ...
1
vote
1answer
25 views

When open add new post or page Wordpress add post with ID=0 continuously [closed]

When open add new post or page Wordpress add post with ID=0 continuously. and instead of publish there is submit for review
0
votes
1answer
34 views

Problem in using wpdb

I used "wpdb" in my code But it was not working and the following error: Fatal error: Call to a member function insert() on a non-object Notice: Trying to get property of non-object" in ...
0
votes
0answers
14 views

Hook upon database insertion?

I have downloaded a plugin that inserts a new row into a table in my database. I want to perform a calculation on this row as soon as it is inserted into the database, in my own plugin. I've seen a ...
0
votes
1answer
40 views

Cannot unserialize Wordpress serialized values in `wp_options` table?

I have nav_menu_options in my Wordpress database as below. 284,'nav_menu_options','a:2:{i:0;b:0;s:8:\"auto_add\";a:0:{}}' I tried to deserialize this value but the result is empty string - I put a ...
0
votes
1answer
42 views

Build a website with a database connection in Wordpress?

I have built multiple websites using Node.js, PHP, Java and have knowledge on basic web development tools. Except for wordpress. I'm required to build a webpage that does some file manipulation, ...
1
vote
1answer
15 views

When and why should I use $wpdb different return types?

This one returns an object $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10"); An associative array $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE ...
0
votes
1answer
30 views

Structure of postmeta meta_value for woocommerce product download

So I'm working on a monster script to port all of our existing stuff from Joomla/Virtuemart to Wordpress/WooCommerce. So far I've got just about everything done with moving over our product ...
0
votes
1answer
46 views

Get the post permalink within the loop but without additional DB query

I am looking to create a custom 'directory' page which will link to several thousands of posts. Because of the large number I am trying to limit the number of DB queries. I notice that to link to each ...
5
votes
0answers
55 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
10 views

Text with sub bullets not saved correctly

I'm having problems with sub list items. In my backoffice it looks like this (text is blurred): Visual: Text: In the text editor it looks good but when I save the post I get this in my database ...
0
votes
2answers
65 views

Disable Database Update Required ? break my website

Im having an issue if i want to login to the dashboard, it needs a "Database Update Required" I'd like to disable it, because once it update the Database, if I go to any post of single-pages, it ...
0
votes
0answers
20 views

WordPress and user security

When we talk about Information Security, many things come into mind and people tend to use CMS to be clear on security as CMS people do the job for you, in terms on hashing passwords, encryption etc. ...
0
votes
0answers
22 views

Two same URL domain

I have a problem with my wordpress . I just migrate to a new install only the post and categories . But now entering a link or search the CSS BASE URL for example doubles A href attribute URL : ...
0
votes
1answer
6 views

Changed meta_key value in structures, now dashboard shows zero users

I was trying to edit the email form field so that it accepts int values like of a phone number. I knew very less about how database values work and this is what i did: 1. Figured out that email field ...