WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
1
vote
1answer
37 views
Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
I have created a category "Book" with a sub category "comics",
to check how wordpress is maintaining the hierarchy structure.
When i check the table "wp_term_taxonomy", I found that such term with a ...
0
votes
0answers
31 views
cap_key problem when sharing users and usermeta tables with two installation
I'm following this Custom User and Usermeta Tables to share users and usermeta tables with two installation.
define('CUSTOM_USER_TABLE', 'bloga_users');
define('CUSTOM_USER_META_TABLE', ...
0
votes
2answers
83 views
How can I restrict php mail() to only send me one email after a db error
I'm in the process of customizing dp-error.php. I'm using the mail() function to alert me when there's a database connection problem on my website. The trouble is, what if 1000 people visit my website ...
0
votes
1answer
27 views
I would like to create a premium area with “extra information”
I would like to use a contact form (contact form 7/secure contact form/etc) and use the data that people send to create a "premium area" where only specific users will have access.
Let's say that I ...
1
vote
1answer
28 views
How to store an extra (surrogate) ID when creating a post with wp_insert_post?
I am generating posts based on rows from a table on an existing database.
If a row in the database gets updated I will have to update the respective post.
The proble is that I have to find the post ...
2
votes
1answer
144 views
Writing a plugin that notify my friends of new post that mentions(@) them
For example, I write a new post with content "Today I'm happy, because I finally met the girl that @David told me about bla blah..." Once the post is published, there should be an email notification ...
0
votes
1answer
88 views
Select From wpdb - Author/User Directory page
I am working on a wordpress site where I have created a directory page(authors.php) that lists all users and certain author meta.
It works fine however I am trying to figure out how to only show ...
4
votes
1answer
175 views
find a random blogid across my multisite network that has at least one post published
I need to find a random blog across my multisite network that has at least one post published of a certain post_type, and return its blogid as a variable so I can use it in a switch_to_blog() call.
I ...
0
votes
0answers
62 views
Category template doesn't show posts for some categories [closed]
I have a site with main categories and subcategories. When you choose a main category, it opens a page with a list of subcategories. When you open a subcategory page it opens a page with a list of ...
0
votes
1answer
61 views
Add Default Wordpress Formatting To Data From External SQL Tables?
I have a number of external SQL tables that have data in exactly the way I want and I would like to use them to populate various wordpress posts with shortcodes.
The problem is that I don't ...
0
votes
2answers
50 views
Your thoughts on the interaction with one custom database table from WP?
Short version:
Step 1/ i am using contact form 7 to collect some user data and i
insert the data into a custom database table.
Step 2/ only the
custom table needs to be altered/updated. In fact at ...
0
votes
1answer
107 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. ...
4
votes
7answers
410 views
How to move existing Wordpress wp-content folder along with database to new server and new domain name?
Running WP 3.5.1 on a LEMP stack (over at Linode) ...
I have a wp-content folder for a WP site along with a full backup of the database. The URL of the site was something like:
...
0
votes
3answers
124 views
How to empty wordpress custom post Database table
I have around 2000 custom posts. And 7 regular wp pages. I want to delete all those custom post without effecting the pages. I thought the easiest way would be to empty the custom post table but I ...
-3
votes
2answers
161 views
Preventing duplicate entries in mySQL database with PHP
I have a contact form (Contact Form 7) that submits all fields into a mySQL database (via the Contact Form 7 to Database Plugin), everything is working fine with that. I want it to however, throw the ...
1
vote
1answer
57 views
Saving into post_excerpt or post_content
When importing a feed into a custom post type does it make any difference if I store the feed description in the post_excerpt field versus the post_content field? Is there some processing that gets ...
0
votes
2answers
69 views
WordPress Site - Connection to MySQL Database: The Basics [closed]
What is/are the best source/s to check to find the nuts and bolts of connecting a MySQL database to my WordPress website? Thanks.
0
votes
1answer
35 views
DB access blocked when initializing WP externally
I have an odd problem I'm hoping the group can help with. The problem is this:
I have a few situations where I load the Wordpress environment without the overhead of the GUI (details)
I am able to ...
1
vote
0answers
44 views
Multisite 404 on pages - rewrite error breaks database
After updating my reading settings on my multisites, I get 404 errors on all my pages.
The only way to fix the issue is by reverting the database to previous version, that is the only way it can be ...
3
votes
2answers
3k views
How to get the post publish date outside the loop?
I need to pull out the post publish date in order to make the post post auto expire. The thing is I can't get the right publish date.
Here is my code:
global $wpdb;
$post_ids = ...
0
votes
0answers
22 views
blank page after downgrade [closed]
i tried to solve my latest problem with downgrading my wordpress to version 3.4
and now when i click on http://ntm.at/r0sa/wp-admin/ everything is empty. whats the problem? i deleted wp-admin and ...
1
vote
2answers
66 views
The plugin generated x characters of unexpected output, $wpdb not defined
I've written a simple Wordpress plugin to create a new database table.
The new table ought to be created when the plugin is activated.
When I try to activate the plugin, I get the following error:
...
0
votes
1answer
77 views
Get value form wordpress database
I'm sorry if this ambiguous but I'll try my best
I have the following php code from a WordPress Plugin
$url = 'http://mydomain.com/'.$ListingID.'/';
I need to define a value for $ListingID
The ...
0
votes
1answer
61 views
How to back-up a database on IIS
I've been having trouble finding a good tutorial on how to back-up a WordPress database using IIS as the web server. I installed WordPress using IIS's web platform installer and now I can't even find ...
3
votes
1answer
240 views
Wordpress admin never finishes saving page on site with large page count
I have a Wordpress install with a very large amount of pages (a few hundred thousand), and over time it has gotten to the point where editing a page takes an extremely long amount of time. It would ...
3
votes
2answers
352 views
How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
Normally, a MySQL database can be exported and imported using these simple SSH commands:
Export:
mysqldump -u USERNAME -p PASSWORD DATABASE_NAME > filename.sql
Import:
mysql -u USERNAME -p ...
2
votes
1answer
51 views
What is the easiest way to implement cascading database upgrade for my plugin?
Lets assume following situation:
I develop a plugin. The plugin requires custom database table to store some kind of information.
From month to month I release new versions of my plugin. Different ...
0
votes
0answers
76 views
Wp super cache causes database problem [closed]
I have a serious problem :
I have a dedicaded server. I did a reboot 4h before and now i have database errors :
The home is okay : http://worldissmall.fr/
wp admin : ...
0
votes
1answer
112 views
Creating and Using Tables in the Wordpress Database
I plan on having over 2,000 pages per subject on my WordPress website and since each subject will require custom page types I would like to create tables for each subject in the WordPress Database. ...
6
votes
4answers
14k views
How to integrate custom database table in Wordpress and using Wordpress functions
I'm on Wordpress 3.0.4 and I'm having a hard time deciding which way to go. The following is my problem:
I have a mysql database table widgets, with about 10 properties like id, size, color etc.
...
0
votes
1answer
89 views
Contact form with database integration issue
This is more a question about the idea I am going to share and ask for advice for.
I would like to have a contact form on my site, where people complete their data and it gets stored inside a ...
0
votes
2answers
95 views
How to run Two Wordpress blogs with different themes and with single database and same content
How do you run two Wordpress blogs with different themes using one database where the content remains the same in both sites? The issue that I am getting is at the Domain mapping in both blogs.
0
votes
1answer
51 views
Saving zero as meta value
I have a meta_key called "_ordre" and each time I create a new custom post, a new meta_value is set for that meta_key.
The thing is, when I set the value of '_ordre' to 0, the meta_value is not saved ...
1
vote
1answer
100 views
How can I create a Bible search engine via WordPress? [closed]
I have some translations of Bible in Turkish language. But, they are as of books. (Matthew, Mark, Luke, John... ) I uploaded them into a website which is being managed by a wordpress software.
...
1
vote
1answer
117 views
Migrating from PDO using SQLite to clean new install using MySQL
I've been using PDO plugin for wordpress and SQLite database. It does not work as expected so I want to use MySQL database, but without PDO for Wordpress since I cannot trust that plugin anymore, It ...
0
votes
1answer
65 views
Accessing + retrieving custom database in WordPress
I am looking for something really simple(?). I am using WordPress as a CMS. I created a new page in which I added a form (questionnaire). Inside WordPress' database (the same database in which all ...
6
votes
2answers
126 views
How to check if image is already stored in a site's post database? (network)
I currently have configured Wordpress so that a post can be copied to other sites within a Wordpress network. However, a post may be broadcast more than once, and I want to check if the image is ...
0
votes
1answer
63 views
Change taxonomy slug in database
I am using Events Calendar Pro and due to a bug multiple Venue taxonomies were created. For example, I have museum, museum-2, etc. I would like to delete the duplicates but assign the event associated ...
3
votes
1answer
673 views
How to convert regular categories to custom taxonomy?
I have a big list of categories/subcategories (around 60 in all). It now makes sense that instead of these categories being available to any post type's category list, these categories should be moved ...
4
votes
1answer
135 views
WP Multisite: load content from site X on site Y
I'm running a WP multisite-network on my professional website (http://mydomain.com). I'd like to play around with jQuery Mobile and deliver a different website and web experience to mobile users, so I ...
2
votes
0answers
96 views
Plugin Not Working, But Only On GoDaddy Hosted site
I'm creating a plugin for a friend to log search terms on his site. It's very basic. It creates a new table to store terms entered in the search box. It converts the search term to lower case, ...
2
votes
2answers
1k views
How do I show data from gravity forms in my template?
Preface
I've installed gravity forms, created a form and users are submitting data to my site.
What I want to do is show the data users are submitting to my site on one of my pages.
I know there's ...
4
votes
2answers
182 views
Is it possible to define two databases for one installation?
Is it possible to define 2 database for one wp installation, I have searched but there are options for one database and 2 installations. I want this because, one of my clients site is hosted on ...
9
votes
2answers
3k views
Wordpress Database Slow - should I switch to InnoDB?
I have a WordPress site with well over 10k posts, and things are starting to get very slow whenever I am adding and editing posts. Pages load nice and fast for users, along with the admin lists of ...
0
votes
1answer
77 views
Inserting into WP DB
I had initially asked a question based on my code (which has since been removed), I need some help/guidance in creating a plugin.
Scenario: I have created a custom post type (CPT), now I need to ...
0
votes
0answers
44 views
downloading BLOB from database [closed]
I have a small problem with the php content-disposition, I kind of understand where the problem lies but I have no idea how to solve it (new to using databases). Calling this php page will result in ...
0
votes
1answer
139 views
$wpdb error (Call to a member function insert() on a non-object)
I have very few knowledge on oo php and databases, and I am simply trying to insert data in my wp_pagesvisites table but I am having some trouble with this error message.
This is my script:
...
-1
votes
4answers
100 views
Insert into db with foreach problem
I have no idea why this foreach it`s not running. When i post the article, only inserts once. Should make it at much as needed. Do you see any problem?
$array_produse = array();
for($i=1; $i<=8; ...
0
votes
1answer
136 views
How to update BuddyPress xprofile fields programmatically?
I update user info using wp_update_user function. I also need to update the table wp_bp_xprofile_data. Is there any function, where I can update data on wp_bp_xprofile_data table?
2
votes
1answer
116 views
BuddyPress: What's the use of wp_bp_xprofile_data table and how does it get updated?
I have a questions related to BuddyPress:
What's the use of wp_bp_xprofile_data table? How does the data in the table get updated?
And when any user updates his information - does the data in this ...
