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

learn more… | top users | synonyms

0
votes
0answers
46 views

Get custom value from external database

a non-coder here but fairly competent to put together blocks of code :) I´m trying to build a prototype using Wordpress and one need I have is to connect to one or more different databases to get a ...
0
votes
0answers
33 views

Can't seem to replicate permalink structure for localhost development site

I'm helping a friend migrate her WordPress powered shop. I'm to the part where I manually re enter all of her products on WooCommerce. On her current live site the link looks like: ...
0
votes
0answers
153 views

call stored procedure without parameters

I asked this question last week, but then I deleted it because it was stated to be off-topic because I use a function within buddypress. However, I am convinced that whatever I am doing wrong is more ...
0
votes
0answers
119 views

Strange Deadlock database error for the query “Delete From wp_options”

I'm experiencing a strange Database error in these days, and it could the the cause of the slowness of my website (tasc.it) in these days. I found this error in the PHP error log, I can see about 4-5 ...
0
votes
0answers
28 views

Does wordpress has Presentation, Data and Logic layer?

I am using wordpress to create websites for a long time but now I have an order that i don't know what technology to use. All the client requirements can be done using wordpress except one - the ...
0
votes
0answers
95 views

Change post category via MySQL

I'm currently building a management program that works separately from Wordpress but interacts directly with the Wordpress MySQL database. I have it working updating, adding and deleting posts and ...
0
votes
0answers
120 views

How to split the Wordpress database?

I have a site that is used to log client and meal information. It is based on Wordpress, but has quite a bit of custom code. We have custom taxonomies set for the client and meal data. Our problem ...
0
votes
0answers
90 views

Error establishing a database connection - WordPress Multistage in Sub-Folder

I have a website running on my production server which I moved to localhost. The folder structure is as follow: localhost/xxx/main - Here are the website files. I have updates the database by ...
0
votes
0answers
62 views

External json physician database to display results in WordPress

We're working on a physician network site in WordPress using the Divi template and we have most work completed. However, we've also been tasked to have a physician search that will bring up results ...
0
votes
0answers
55 views

RSS Feed has no Items (Possible Plugins Conflict)

I am the webmaster of the German WordPress website http://www.kunstplaza.de. Recently, I have noticed that there are no items in the RSS feed, although there should be some as I am posting new ...
0
votes
0answers
71 views

Update entry in WP database through backend form

I'm trying to find a way to UPDATE a entry in my WP DB via a form. My idea is to grab the current entry values, link to another page with another form and display them there inside containers. That ...
0
votes
0answers
217 views

Would manually deleting the dumping data fix a “#1062 - Duplicate entry '1' for key 'PRIMARY'” phpMyAdmin error?

I'm new to PHP! I'm trying to import an SQL database file into myPhpAdmin for a WordPress I'm migrating, but I keep getting this error message: SQL query: `-- -- Dumping data for table ...
0
votes
0answers
176 views

Get thumbnail using wpdb from external wordpress database

I'm trying to get thumbnails from posts using a wpdb query where the wordpress database I'm querying is not the one from which the wpdb query is being called. That may be a little unclear, so here is ...
0
votes
0answers
334 views

Check if values exists DB

I am getting nutts with this one. I want to check if the email introduced in the form already exists in the database before creating a new record. But for some reason the email is empty at search ...
0
votes
0answers
48 views

Inserting posts to database

I want to import a bunch of posts directly into the database and I'm wondering how I can do this? I found this script ...
0
votes
0answers
100 views

wp_insert_post another database with custom field

wp_insert_post with the command you want to transfer the contents to another database, I use the following command <?php require('wp-config.php'); $conn = mysql_connect($dbHost, $dbUser, ...
0
votes
0answers
140 views

How to parse meta value from user specific post to google charts?

I'm currently working on a project where i need to visualize the progress of users (fitness). For that i have created a custom post type with custom fields. I want to parse the meta values associated ...
0
votes
0answers
59 views

How to select from a WP table every 10s in a class (OOP)?

I'm trying to select records every ten 10 seconds from columns message and messagetwo from my WordPress table wp_userlogin, but the code is not being executed. I'm calling wp_schedule_event when my ...
0
votes
0answers
171 views

A plugin is giving me “You do not have sufficient permissions to access this page.” error

I noticed this morning that I was logged off from my site. Whenever I tried to access /wp-admin it gave me a "You do not have sufficient permissions to access this page." error. After an hour of ...
0
votes
0answers
24 views

Save voting stats with Posts 2 Posts

I am working on a website where I make connections from posts to posts with the Wordpress Posts 2 Posts plugin. Now I want my website users can vote whether they think the 2 connected posts are a good ...
0
votes
0answers
39 views

Mysterious template change after database import/export

When I switch databases from my local environment to the host, some of the pages inexplicably change templates. E.g. there is a custom template "Home" and when I switch the db's it ends up with the ...
0
votes
0answers
88 views

Problem with Featured Image and database

I have an issue with with WordPress install which I just haven't been able to resolve... I have tried disabling all plugins and reverting back to default theme, but the problem remains. The issue is ...
0
votes
0answers
73 views

wp_usermeta key problem

I am trying to add a meta key to wp_usermeta but it does not work at all. The key would get value from a checkbox. I used the code from Wordpress codex tutorial and it's not adding anything. I will ...
0
votes
0answers
22 views

Are custom tables a good solution for adding lots of data to the site?

On a fairly high trafficked website (10-20 million page views per month), we're looking to add a large amount of data to build data-driven pages. Think of adding 1000s of restaurants to create ...
0
votes
0answers
16 views

Bookmarking a post in exchange for an email?

I was asked to implement a feature that this website https://medium.com/ has, which is the ability to bookmark a specific post by making the user register an account with the website. This is the ...
0
votes
0answers
52 views

Email notifications: Where in database to save user options?

I'm working on an email notifications plugin which sends emails when events happen on my site. So for example, if someone comments on a post, the post author will receive a custom email notification. ...
0
votes
0answers
51 views

What method should I use to store my plugin data (multi level menus with options on each item)

So the background on my plugin - it generates taxonomy/term filters to give you a filtering system similar to what you'd see on NewEgg where you filter your results by category/manufacturer/other ...
0
votes
0answers
36 views

Author ID mismatch from database

The author->ID for one particular author is returning a different value than what exists in the database. The database has the author's id as 2, but when I query author->ID, it returns the value 11. ...
0
votes
0answers
75 views

Add more tables under wp_term_taxonomy

How do I add default fields/columns in the taxonomy terms? I can add custom fields using plugins like ACF but I have no idea on how to query them from the database. I can query the name, slug, and ...
0
votes
0answers
69 views

Why this function not working for install database on plugin activation

I followed codex instructions from wordpress site but for some reason it's not working for me and i can't understand why is there any debug settings or options to activate to explain me where i go ...
0
votes
0answers
23 views

Incorporating Biology Database with Thousands of Records

I'm a WordPress newbie working on a Mac with MAMP. I have a series of database-driven websites that I'd like to incorporate into WordPress. My biggest website focuses on biology, especially animals. ...
0
votes
0answers
116 views

Import Issue (ACF Repeater+WP Ultimate Importer)

I'm trying to import a bunch of data from my DB and there's plenty of fields, now i'm using advanced custom fields, repeaters to be specific. I had to make my own CSV file and I did this by exporting ...
0
votes
0answers
34 views

Category not displaying in add post, edit post, and categories page.

I have faced one problem after updating WordPress to 3.8.1. When I try to add or edit a post the category list at right side panel is blank, even though I have several categories on the site. Please ...
0
votes
0answers
300 views

Displaying database table in backend of wordpress

So basically I'm working on a job website for a client where they post jobs and users can apply for these jobs with a form that writes to the database with their inputed information.. I have set up a ...
0
votes
0answers
130 views

“Database Connection Error” upon install in Apache VirtualHost document root.. Why did this happen?

I have apache virtualhosts up and confirmed working. I want to install wordpress for one of the vhosts, so I unpacked all the wordpress files in the document root for that vhost. I proceeded to follow ...
0
votes
0answers
47 views

Transposh translation plugin querying wrong database

I've noticed my PHP error log growing very quickly, and it all seems to be a similar error: '[database name].wp_translations' doesn't exist However, the database it's trying to use is for a system ...
0
votes
0answers
132 views

Collaborate on wordpress local website, share files via dropbox?

How can one share and sync files of a WordPress website with users that can edit (collaborate on) the website locally on their own instance? Can Dropbox be used to share the WordPress website files ...
0
votes
0answers
74 views

Get fatal error when using wpdb in jQuery.post target URL

Why am I getting a Fatal error whenever I use wpdb in the target URL of my jQuery.post? Here is my code so far. My process.php is this: <?php $to = 'myemail@gmail.com'; $subject = ...
0
votes
0answers
27 views

Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”

At first I thought it was a resource issue because I'm only using the lowest AWS ec2 instance, but now I think it might be something else. I Google'd about a bit as it seems to be a common problem ...
0
votes
0answers
89 views

Perform database function in target URL using jQuery.post

I have a popup which gets the users input (name and email) and sends it to a process.php so I can send an email. I pretty much have that done. But I need to add a functionality wherein it will also ...
0
votes
0answers
110 views

Querying the DB to get sum of column from custom meta box (only published posts)

I am trying to get the SUM total of a custom meta box, from all published posts, from a custom post type. By using $wpdb I am able to get the sum from all of the posts (published and otherwise), but ...
0
votes
0answers
46 views

Blog Not Loading, Can't Access Admin Page, No Trace of WordPress on Server

I recently took over as the webmaster for a small company, and I was asked to figure out what's going on with the company's blog, which uses WordPress. Essentially, the blog won't load, and this ...
0
votes
0answers
44 views

How Can I Put Meta_Compare in the Database-Query?

Yes, I know that this can easily be done with built in wp_query but I need this in Wpdb query. I have a custom field and I need to display posts where this field does not exist. By the way can I get ...
0
votes
0answers
37 views

Download user generated data from Wordpress

I have created a Wordpress site which I allow users to enter information about themselves such as name, age, sex and address etc. Now that I have this n formation I would like to know the steps I ...
0
votes
0answers
32 views

How do I authenticate/turn off a plugin remotely for plugin SaaS like functionality?

I have a client whom we created a custom plugin for. We are charging monthly for access to this plugin but the only way we have to disable it is manually in the Wordpress admin. How would I go about ...
0
votes
0answers
46 views

Broken Images After DB Name Change

I have a problem I have been unsuccessful in troubleshooting or finding other questions and answers for. My site was displaying fine. I changed the name of my database from "mydomain_beta" to ...
0
votes
0answers
206 views

Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet

Why do developers make it so darn hard to use the tools they develop? Don't answer, I already know :) Have had some success using this: https://github.com/bainternet/Admin-Page-Class ...to develop a ...
0
votes
0answers
159 views

Why are my WordPress post queries so slow?

I'm working on a larger WordPress site and trying to troubleshoot why my site is so slow. I've installed W3 Total Cache and have run multiple page speed and plugin tests with no luck. What's strange ...
0
votes
0answers
21 views

Plugins folder broken-No website functionality

After some plugin updates caused me to receive a database error, I was unable to access my dashboard. I changed the name of the plugins folder in FTP and it came back online. I then deleted my ...
0
votes
0answers
30 views

I have a problem with my WordPress DB after I tried to install multi-site

I tried to install WordPress Multi-Site. But I ran into some problems with the DB. wp_1_posts: Table 'studioc_editionspanda.wp_1_posts' doesn't exist wp_1_comments: Table ...