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

learn more… | top users | synonyms

0
votes
1answer
27 views

Why this query is not showing any result on wordpresss home page?

I am learning wordpress database, And I have written this query for showing the data from the post table with id=2, but not showing anything. What is wrong with the following query? please help. ...
0
votes
0answers
29 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
45 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
10 views

DTAP with wordpress + plugins [duplicate]

I'm struggling to find a good way to set up a DTAP street. We've have 4 separate environments (Development, Testing, Acceptance and Production) Codewise (so the .php files) migrating is trivially ...
1
vote
1answer
56 views

Select two sums with single get_var statement

I am trying the following global $wpdb; $sum = $wpdb->get_var("select sum(first), sum(second) from table where id > 1"); I am unable to get the values from each request. I have tried ...
0
votes
0answers
81 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
1answer
54 views

phpMyAdmin displays error when importing database

I'm migrating a WordPress for a friend to a different server. I have already backed up all files and was given a copy of the database by the old server admin. The problem is that when I try and import ...
3
votes
1answer
296 views

How is custom menu hierarchy output handled?

I'm looking to pass custom nav_menus through an RSS feed so I can grab them on other sites to create the same custom menu on multiple sites. What I can't figure out by looking through the database is ...
4
votes
1answer
97 views

Dealing with Many Meta Values, 30+

I have a "Listing" post type with 30+ meta keys which I feel like can cause a strain on the database when there's 100+ posts. Usually what I do is save each meta value 1 by 1 like so: ...
1
vote
2answers
43 views

How to correctly add a table to the Wordpress MySQL database

I want to add a new table to the Wordpress database. I need this one for a specific section of my Wordpress website, that requires something a bit different than what I can achieve through custom ...
0
votes
2answers
65 views

Extracting the post_id via the wp_insert_post action (external db query)

i'm writing a little action plugin. everytime a new post is created, a new table should be created in an external db. The name of the table sholud reflect the post_id of the newly created post, but i ...
0
votes
2answers
3k views

Does WordPress MultiSite use separate MySql databases?

I ask because I cannot find the options from a plug-in I created on my second blog. Adding this plug-in to the main site and the options show up. I am confused because there is a column in ...
0
votes
1answer
218 views

Custom Post Type or Custom Tables

I am in the process of writing a plugin that allows end-users to submit a form that includes customer information. Upon submission, I am notified that a new customer has submitted the request form. ...
0
votes
1answer
342 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
1answer
116 views

Display single post inside accordion based on form submission results

*Note - for full background see previous question here: http://bit.ly/1gaF673 Ok, so after fixing the problem above and a couple of issues that followed. My form submission returns the results I ...
0
votes
2answers
38 views

Database custom table issues - incorrect result displayed

First things first: I've spent most of today going over these forums; the stackoverflow forums; the php.net manual; and a bunch of random sites I found through Google Search - so, if I've missed the ...
0
votes
2answers
69 views

Error establishing a database connection - Multi-site with subsite don't exisit

I have a multi site setup to which I have placed define( 'NOBLOGREDIRECT', 'http://www.example.com' ); In the wp-config.php file However when I visit a site which dose not exist (e.g. ...
0
votes
1answer
90 views

Add field to user meta table in database when link is clicked

I am working on function that enables registered users on my site to bookmark posts. I have searched for plugins but none seemed to do the job properly. I have a page where users can see their info ...
0
votes
0answers
92 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 ...
3
votes
2answers
413 views

$wpdb won't insert NULL into table column

When i try something like this $status = NULL; $wpdb->update( 'table', array( 'status' => $status, ), array( 'id' ...
0
votes
1answer
38 views

Cannot update custom database table row

I am trying to update a row in a custom database table by $wpdb->update();. In my opinion my code is right but for some reason my database row doesn't update. Can anyone help me with this? I want ...
0
votes
1answer
18 views

4th Network Site Database Errors?

4th site created but not available in the admin menu or the my sites screen. So the my sites screen /wp-admin/my-sites.php only shows three, not the 4th. The My Sites menu at the top also only shows ...
0
votes
1answer
29 views

How to add data from wordpress tables to new database tables you have created

I'm just learning this database stuff and so I am a bit confused and was hoping someone could push me in the right direction. I have managed to create users in the wp_tables I have created in my ...
0
votes
0answers
243 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 ...
1
vote
1answer
31 views

Is there a way to run upgrade.php for one blog?

I just ran the auto update to verion 3.9 today, but am having problems with the "Network Update". I seem to have a firewall or network problem with this error : Your server may not be able to ...
4
votes
3answers
7k views

WooCommerce with thousands of products - site is very slow - optimize db queries? [closed]

So far I've got around 8,000 products in my WooCommerce and the product page on the front end takes several seconds to load, even after caching. My VPS host says that I should have multiple ...
3
votes
3answers
90 views

Uploading/Deploying a Multi Site Install

So I was looking to create a multi site for a clients since the goal is to have the same branded theme on several sub domains to deal with different countries (e.g. mysite.com, usa.mysite.com, ...
0
votes
1answer
23 views

how to remove category from database

is there a way to remove the category from the database? I just moving my old wordpress blog (that has the category in url), to new domain (without category). I change everything except the ...
-1
votes
1answer
131 views

Connect to a remote database for wordpress in my own hosting server

Yesterday I had asked this question but it was down voted due to the rules of this forum. Anyway, this is my learning and I really thank to the moderators who down voted this as they helped me to gain ...
0
votes
2answers
64 views

When I click edit on a post, all the content disappear. Does anyone know how to fix this?

I am working on a site: greatlakesecho.org When I try to edit a post, the content just disappears from the visual editor. I am running the latest version of Word Press but this happened on the ...
0
votes
1answer
75 views

delete_option() and update_option() returning false

I know that when delete_option() or update_option() fail to perform their respective database interactions, they return false. Does anyone know why they wouldn't be able to perform these actions? ...
1
vote
0answers
35 views

Is there an atomic way to update_option in Wordpress (to ensure data integrity)?

I want to update an option which is an array by adding a new value, but there's no atomicity or guarantee of data integrity. EXAMPLE //Get the option value (an array) $val = get_option( ...
0
votes
1answer
101 views

How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category

I have tried the following phpMyAdmin query in an effort to delete all posts, from wordpress category 378, that are over 400 days old. delete a,b,c,d FROM wp_posts a LEFT JOIN wp_term_relationships b ...
0
votes
1answer
94 views

How Do I Merge Categories With phpMyAdmin

I tried the following phpMyAdmin query to merge my category 112747 into my category 112748: UPDATE wp_term_relationships SET term_taxonomy_id = 112747 WHERE term_taxonomy_id = 112748; It did not ...
0
votes
1answer
73 views

How to set search query for joining two tables in sql?

What's the wrong with this query? SELECT l.company_name,DISTINCT c.sub_cat_name FROM tbl_listing l,tbl_sub_category c WHERE l.company_name LIKE '%cy%' and l.city_id='2' and l.area_id=23 ORDER BY ...
1
vote
1answer
45 views

Why does dbDelta() not catch MysqlErrors?

From what I can see, dbDelta() is designed to suppress database errors that occur during its operation. Generally speaking, this seems to be the case, but New Relic is still reporting MysqlErrors ...
2
votes
1answer
54 views

Detecting errors generated by $wpdb->get_results()

How do I detect errors when using $wpdb->get_results()? For example: $result = $wpdb->get_results("SELECT * FROM this is not a valid query"); The preceding code doesn't generate any exceptions ...
1
vote
0answers
50 views

Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin

I have a wordpress table like so (phpmyadmin and MySQL) | id | meta_key | meta_value | +----+-----------+------------+ | 1 | import_id | abc | | 2 | import_id | abc | | 3 | ...
0
votes
0answers
39 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
57 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
119 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
1answer
121 views

$wpdb->get_var - What value is returned when zero records are found?

I have the following code: $queryPermission = $wpdb->get_var( $wpdb->prepare("SELECT Active FROM testers WHERE user_id = '$user_id' ")); ...
0
votes
1answer
73 views

single.php not pulling in any data from database

My single.php doesnt seem to be fulling any information through from the database for the current post. here is my single.php code: <?php get_header(); ?> <div class="main-container"> ...
0
votes
2answers
114 views

Installing local to live WP into subdirectory

I am having a bit of trouble moving a local WP site live and into a subdirectory. I want a static homepage for now (index.html in the root folder) while I work on the live site (would be found in ...
0
votes
2answers
73 views

Duplicate domain database to local - How?

I've noticed that my process is rather slow and i'd like to speed it up. I want to be able to duplicate my database from my domain which is blueharlequin.com and work locally thus speeding up the ...
2
votes
2answers
336 views

Should I global $wpdb outside of any of my plugin's functions scope?

I know that the general advice to global variables is to not use them at all. Still, when doing something with the Wordpress database, it is required to do global $wpdb; to access the methods ...
1
vote
1answer
126 views

Wordpress database error - Error in SQL syntax - I can't identify any error?

I am trying to write function that checks whether an email address is stored in my database or not. I've written the following PHP code:: function check_my_users( $email_address ) { global ...
3
votes
4answers
603 views

How many users can WordPress handle?

I want to design a member login site in WP but I have a doubt that is WordPress can handle more than 40000 users on same database? I am not sure about this so I am stooping my work here. So please ...
0
votes
1answer
42 views

Understanding WordPress Search

I am trying to create a custom search similar to the one on totaljobs.com but through a WordPress site. Essentially I would be able to search for both search terms and location simultaneously. The ...
1
vote
1answer
117 views

How to store custom user data on the database?

I'm developing a WP multi-site network which have a goal of 10,000 sub blogs. The site needs to store custom data related to the user. There are additional 20 fields of data for each user. What is the ...