Tagged Questions

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

learn more… | top users | synonyms

0
votes
1answer
38 views

Help With a Large Wordpress Based MySQL Database on Shared Hosting

I have close to 500K posts in my WordPress database. The site is not yet live, I have the data on my local computer. I was reading about the WOrdpress' https://wordpress.org/plugins/hyperdb/ plugin ...
0
votes
2answers
82 views

How To Get Some Data From WordPress Database Using WordPress $wpdb Query?

I am trying to get some data from WordPress database tables in a plugin. For that, I am using the below code... global $wpdb; $findID = $wpdb->get_var("SELECT ID FROM wp_posts WHERE post_name = ...
0
votes
0answers
17 views

Why is wordpress trying to re-install itself?

I ran out of space on my MySQL server so I got a bigger disk and moved the files to the new disk, restarted MySQL and things were fine. But I went to my sites and now wordpress is acting like its ...
0
votes
1answer
14 views

Where should I put this custom data?

My client needs to store food nutrient data in his site's database. I have food name, calories, protein, fat, carb, fiber and other data to store for many food items. I'm a developer but new to WP. ...
0
votes
0answers
14 views

What's the point of wp_blog_versions?

The documentation says about wp_blog_versions: The current database version status of each site is maintained in the wp_blogs_versions table and is updated as each site is upgraded. but what's ...
0
votes
2answers
42 views

dbDelta SQL Query Not Working

I know the specifics of using dbDelta and I've read the documentation (http://codex.wordpress.org/Creating_Tables_with_Plugins), read other answers to the question I'm asking, but I'm just not seeing ...
0
votes
1answer
70 views

How To Make Connection To WordPress Data Base In A Plugin?

I am learning Plugins and I am trying to connect WordPress database wp-config.php in my Plugin PHP code. Currently for checking my code, I used the below connection and it is working fine. Now I ...
3
votes
1answer
52 views

wp_options table value

I am trying to understand a wordpress behaviour. When I add a tag in the admin panel mysql does a sequence of queries. Essentially: update wp_terms update wp_term_taxonomy and udate wp_options with ...
0
votes
0answers
11 views

saving and retrieving data

I been following some tutorials on how to create wordpress plugin, but i did not understand how to save data into a table, from admin e.g asking some questions and then on the front end displaying it ...
1
vote
1answer
97 views

Wordpress database import: Row size too large

I've done a dump of my Wordpress database using Windows's command prompt: mysqldump -u username -p databasename > filename.sql Then, on a different server, imported it using: mysql -u username ...
0
votes
0answers
22 views

Theme options not being sent to Database

Currently working on a little project for a theme, doing this so i can learn the in's and out's of wordpress. So far i've got to the point of adding sections, and fields within those sections. ...
0
votes
0answers
27 views

Custom Post Types and Posts are mixed

I need help with a problem related with CPT and WP Database. I have a wordpress install with bbPress and a custom post type called Destinos. The problem is that when I´m looking for the forums, or ...
0
votes
1answer
32 views

How to Determine a Post's Last Edited Date?

I'm writing a little extract script to do a DB pull. I've been asked to get all restaurant posts (custom post type) that are among the 1000 top hit, OR have been added or edited in the last 3 years. ...
0
votes
0answers
30 views

Restoring .sql backup results in “Error establishing a database connection”

I'm trying to get the database dump (.sql) of a remote site to work with my local setup. Sort of like migrating from remote to local. I've already ftp-ed the site itself, but having problems ...
0
votes
1answer
39 views

How can I retrieve data from alternate database using wpdb class?

I'm attempting to retrieve data from a separate WordPress installation on the same server. I'm able to use the wpdb class to successfully connect to the alternate database and get results, however, I ...
0
votes
1answer
30 views

How to save information related to post in database?

I created a post-to-email plugin and I need to save something in the database when the post is sent so I don't allow users to send it twice. How do I save this in the database? And how can I retrieve ...
0
votes
2answers
70 views

Wacky taxonomy in wordpress

I have my main site, www.whatsthatbug.com, and a test site, test.whatsthatbug.com. They are identical as far as I can tell - same version of wordpress, same plugins at the same versions, same theme ...
0
votes
2answers
58 views

Storing user submitted forms [closed]

I was wondering what's the best way to create a form which can only be seen by registered users. The main idea I'd like to achieve here is for users to log in and gain access to a page where there's ...
0
votes
1answer
45 views

Advanced SELECT query with condtional statements

I am having trouble understanding the proper way to write an advanced select query. I have the following the code here. if (!empty($_GET['3321body_type'])) { $bt = $_GET['3321body_type']; ...
0
votes
1answer
16 views

Updating options into the wp database performance

I have a question about the performance of my plugin. On the settings page of my plugin I have about 20 options the user can change (checkboxes, dropdown and normal text inputs). Currently I just ...
0
votes
1answer
41 views

Is there any way to recover deleted menu from database sql backup

i accidently deleted my main menu but i have a .sql database backup file and i want to recover my menu from this file. Is it possible? Thanks.
1
vote
2answers
81 views

Select Multiple meta_value from WP DB; Single Query

I am trying to retrieve each user's first and last name, phone, email, and address from the usermeta table. I'm having trouble selecting multiple meta_values, each with its own meta_key, using a ...
0
votes
0answers
31 views

Redirect Issue: Wordpress database

I have an issue with my wordpress site that seems to relate to the settings in wordpress. However, it seems to go into a redirect loop. I can confirm upon a fresh installation the issue disappears. I ...
0
votes
0answers
17 views

How does one change the posts database table of a site?

I am currently in the process of developing a mobile site to accompany a site that I have been operating for a while. I came up with the idea to use multisite to create a second site with a ...
0
votes
1answer
58 views

How can I store data from custom fields to custom tables?

I know how to make custom fields for my custom post types. I also know there is the Advanced Custom Fieldsplugin. But I need to know how I can store my custom fields in my custom post type to my ...
0
votes
1answer
103 views

Safely store code(html/js..) into database

So I'm working on a small plugin, and this plugin allows users to save data to my db. This data is mostly plain text but 3 fields are will have tags inside them. 1 field can be used to save all kind ...
0
votes
1answer
42 views

WordPress Theme Migration Local to Live Assets Not Loading

I have a fully working custom WordPress theme built off underscores served up locally via MAMP. Normally when migrating to a live server, I move over the wp-content directory and the .sql file, ...
0
votes
0answers
43 views

Error establishing database connection on app engine

Error establishing database connection on app engine after deploying wordpress. I got an error Notice: Undefined property: batcache::$query in ...
0
votes
0answers
38 views

trying to update post meta in bulk

I have been trying to arrange my site so that my URL structure is set to domain.com/collection/%collection%/%product-group% Where %collection% is a taxonomy term, collection is the index, and ...
0
votes
0answers
95 views

Unserializeing multiple column values that are stored in one database results variable

Lately i have created a custom template to search for data in a database, and also displaying it, by the use of checkboxes. So, a user can select multiple checkboxes to search data on and the query ...
2
votes
2answers
65 views

Where is the old post permalink slug stored?

I published an article with permalink slug: http://domain.com/writing Then after publishing, I changed the permalink slug to writing-lorem. Now, whenever I visit /writing, it redirects to ...
0
votes
2answers
38 views

WP_Options high

I have a site where the options_id field in the wp_options table have grown very, very large. After a month and a half after the installation the auto_increment value is now at over 10 million. ...
0
votes
0answers
25 views

GET user's metadata, list it in descending order and GET user's list number

I have a custom user metadata with meta_key reputation. The value is numeric. It is like a points system. The higher value the user has, the higher reputation they have. How do I GET where each user ...
2
votes
1answer
14 views

Weird issue with database migration and SSL links

I want to move my database to my another mirror server (for testing & stuff). My original one is using SSL and I am forcing it to do so. When I migrate with DB Migrate plugin, the non-ssl server ...
0
votes
0answers
35 views

Getting data from database and use it to complete a form

I have the following files: Main plugin file: <?php /* Plugin Name: FixFormData Description: If you want to autocomplete a form with existing data, this plugin is for you. ...
0
votes
1answer
26 views

Update image links in database

I recently changed the URL of a wordpress site and I can't seem to find some of the image links I was able to update most of the links in the wp_posts tables update wp_posts set guid = REPLACE(guid, ...
0
votes
1answer
53 views

Link to handle $_GET request

I have a set of items retrieved from a database custom table that work. So believe me that $ticket->ID outputs some integer. Say I want to delete some of them. While printing them I offer a link to ...
1
vote
0answers
37 views

Child parent relationship inside WP DB

i am a .net user so i am unfamiliar with not using a foreign key inside of the database. On my WP application, user's are able to create videos on the application, the videos are stored on a ...
0
votes
0answers
25 views

Reset postmeta entries every month

I have this currently running on my site, which counts how many times each 'post' has been viewed, adds one view to the count and then saves it in postmeta: function getPostViews($postID){ $count_key ...
0
votes
0answers
32 views

Show WP content on different PHP Sites

we are about to start developing a big dynamic web project (Probably on ZF2) which will have some modules&tabs to act as CMS module (displaying news, galleries, posts etc). Let's assume we have ...
0
votes
1answer
26 views

Wordpress sync with phpbb

How can i sync the wordpress database users with phpbb database users so i can log on each one with the same user at any time and if there`s no user created for the wordpress to log in with the phpbb ...
0
votes
1answer
25 views

What's wrong with my $wpdb query?

I'm just trying to query the first user, but it outputs this error, WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for ...
0
votes
1answer
22 views

WordPress plugin DB upgrade

I am writing plugin. I have added 1 custom table in database. Suppose my plugin's current version is 1.0 After few days i am upgrading plugin and now its version 1.2. Same for after some time and now ...
0
votes
2answers
47 views

how to store arrays into a database

I'm trying the store multiple rows into a database. The number of fields will change. Below is the way that I use to store just one row. <?php if(isset($_POST['save'])){ ...
0
votes
1answer
58 views

Change Wordpress URL in sql file via Terminal

I've got a 40mb database file that I've exported from an old host and need to import it into a new host on a new domain. I normally open up the database in my code editor and find-replace, but as this ...
0
votes
1answer
37 views

Importing posts from old website to new conflicting post ID's?

I am wondering when I am importing posts from my old site into my new website, which has already some posts in it. Do the imported posts get a new ID or do they overrule the existing posts ID's?
0
votes
0answers
19 views

Best way to define a database with product codes and back-end support?

First let me explain what my wanted situation is: I have a WordPress site where I want the Admin to have access to about 10.000 "product keys". These codes will be inserted in a database of some sort ...
0
votes
2answers
44 views

Dump custom post type database

I have a custom post type filled with 7k entries by mistake. I want to empty the database for that custom post type. What is the best way to do it?
0
votes
0answers
46 views

Create user assessment and use results in sql query

I am building a plugin that displays custom post types based on a user's assessment result. For that I need the user to fill out a form (not a very complicated one). This form submission needs to save ...
0
votes
1answer
23 views

How to change the publishing date of each posts? [duplicate]

I need to set the publishing date of many posts with the post date (the creation date). I know that I can do it editing the single post and changing the Published on value but this procedure is ...