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

learn more… | top users | synonyms

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 ...
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
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
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 ...
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
0answers
67 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
147 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
0answers
27 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
0answers
21 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
0answers
141 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
88 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
26 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
22 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
0answers
17 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
0answers
22 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
46 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
0answers
24 views

Database level import of featured images and link to posts - How?

I have been attempting to import about 50,000 images into 50,000 posts in WP 4.2.2. The _posts table data is all correctly imported already. I know I need to import to _postmeta table and add new ...
0
votes
0answers
62 views

Loading posts from another wordpress database on the same server

I've searched quite a while and found several solution but apparently I'm doing a lot of stuff wrong. I'm having 4 different Wordpress sites and need to load the latest 2 posts of each site. For ...
0
votes
0answers
11 views

MYSQL ignore categories on Wordpress widget

I have this WP widget that pulls random products from the DB. What I really want is to be able to include just a few products categories (or exclude). Can anyone help me? I appreciate. <?php ...
0
votes
0answers
161 views

wp_editor content in plugin options page

Hi I'm writing a plugin it involves the site builder / user adding content via wp_editor this content is then saved and submitted via a submit_button. I've wrapped the editor in form action = ...
0
votes
0answers
18 views

wp_include_post in custom post with coustom field

I'm new in wordpress and my english are not good. I'm using Custom Post Type UI plugin to create a post type "Product" and Advanced Custom Fields plugin to create some custom fields like address. Now ...
0
votes
0answers
105 views

Database migration tool for GoDaddy Managed WordPress

I’m about to revoke my Managed WordPress subscription because tools that I have paid for (such as WP Migrate DB Pro) that are an integral part of my development process that sync or migrate my local ...
0
votes
0answers
7 views

Users getting registration errors when signing up but still being registered on the backend?

Having a very strange issue on a Wordpress install - we cannot replicate the error ourselves, but multiple customers have complained about it: They fill out the registration form and get an error ...
0
votes
0answers
167 views

Google-App-Engine[PHP]: Error trying to establish database connection

Hi to whom this may interest, I am finding a problem with the cloudsql as database connection is not being established. I have followed the following site step-by-step ...
0
votes
0answers
145 views

Insert XML data into the existing posts

I have nba videos news website and I want to insert xml data into the existing posts. For ex I have this post Pacers vs Timberwolves Match report and I want to import data from this xml: ...
0
votes
0answers
344 views

How to configure the file wp-db.php at /home/…/public_html/wp-includes/wp-db.php on line 1444

I need your support guys ! When I try to connect to my website I got this error: WordPress database error: [Lost connection to MySQL server during query] SELECT cm_posts.* FROM cm_posts INNER JOIN ...
0
votes
0answers
50 views

wpdb giving different results then query in SQL Editor

I'm trying to read candidates and the relation with expertises from 2 custom tables in my WP Database. This is my WPDB query : $candidates = $wpdb->get_results(" SELECT * FROM ...
0
votes
0answers
20 views

Return search for custom post type name

It is easy to write code that will only return posts from a certain custom post type. However, I haven't been able to find a way to return posts that search for the actual name of the custom post ...
0
votes
0answers
27 views

Deleted empty posts - menu gone

I just discovered that my site had a lot of posts with no title and content. I thought it was empty posts I had created when misclicking on create post instead of create page, so I sent them to trash. ...
0
votes
0answers
26 views

Return image urls with specific base string?

I have two wordpress sites on the same server (for ref call them site1 and site2). site2 hotlinks some images from site1. The problem is I recently used a CDN on site1 and told the CDN to disable ...
0
votes
0answers
53 views

version control for wordpress? (wordpress folder and database at same time)

I am familiar with version control to some extent. I have been using git and github for school purposes. Now when I use wordpress it makes sense that I can use git when developing on my local ...
0
votes
0answers
221 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). ...
0
votes
0answers
43 views

What am I doing wrong here? WordPress database error

I'm just trying to insert values into custom table of wordpress and it throws me this error WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to ...
0
votes
0answers
32 views

Adding Database Tables for Reviews functionality that incorporates Tags/Categories

I'm wanting to build onto to the Wordpress database in order to give myself the functionality to create/retrieve customer reviews based upon tags/categories. More specifically, the reviews are not ...
0
votes
0answers
30 views

get_results is not working properly

I tried to find an answer in many forums for this problem, but it has been impossible. My problem is that when I do $wpdb->get_results in an empty table, mi webpage immediately stops working. ...
0
votes
0answers
20 views

Pages edit as posts

I'm currently dealing with the fallout of the following question (How to change post to page). I got all my pages back though all the pages' URLs were changed so there is no hierarchy and when I try ...
0
votes
0answers
219 views

save content in to wordpress wp_post table of database

i write code to get content from other site. now I want save content in to wp_post of wordpress database.. date .. content.. titile ,.. wp_insert function wp_publish function thise my php ...
0
votes
0answers
32 views

Moving Site: Is Re-downloading Files After Changing URLs necessary?

On the Wordpress Codex: Moving Site page under Changing Your Domain Name and URLs, it states that you should re-download your site files (Step 5) after changing your site URLs (Step 4). Is Step 5 ...
0
votes
0answers
31 views

wordpress database error

I write code to extract peice from website with curl. this should be refresh page to get price. I want store data in the wordpress database with foreach. when I refreshing page but give this ...
0
votes
0answers
71 views

Handling Massive Amounts of Data in a Wordpress Plugin

I've been working on my own version of a Youtube Post Importer plugin for Wordpress and I've run into a bit of a wall. I'm using the 3rd version of the Youtube Data API seen here ...
0
votes
0answers
612 views

two wordpress sites, two themes, one database, same content

I am doing research about wordpress and there are many interesting stuff to learn, i browse the wordpress forum and i found a post about duplicating site.. or multisite.. I am not sure exactly how it ...
0
votes
0answers
24 views

WP DB Location for “Next Post to Create” Index Value

I have a malformed DB (no mystery here, I deleted some data directly rather than through the WP admin interface). I've deleted all posts and meta for 400+ but when I create a new post, the sequencing ...
0
votes
0answers
1k views

Wordpress + Postgresql

I’ve painted myself into a corner. I hired someone to build a database with all kinds of cool search features and such. The programmer wasn't aware that my site is built on Wordpress. He wrote his ...
0
votes
0answers
33 views

Backend - Categories and Menus conflicts

I'm having a big problem with my WP instance which is frustrating. Every time I add a new Category ( a simple default category with no custom posts or taxonomies ) it adds, as expected, that new ...
0
votes
0answers
68 views

Should I store multiple data in a single wp_post field

I hope this is the right place to ask this question. I have chosen to work in a Wordpress environment so this should apply here. I have to design an application that will store hundreds of thousands ...