WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
0answers
60 views
Widgets not restored from backup
I've done a little searching here to try to find what I need but most people seem to have these issues when they're moving a site or changing the sql. I'm doing neither so I can't figure out why ...
0
votes
1answer
36 views
Locking one blog of many in a multi user/blog Wordpress installation
I have a multi user /wordpress installation that is working fine. One of the blogs running on that multi user /wordpress installation will never be updated again but I want it there for historic ...
0
votes
1answer
54 views
Merging two wp_posts tables while avoiding duplicates
Is there a simple way to merge two wp_posts tables while avoiding duplicates?
0
votes
1answer
46 views
How safe is it to delete old posts edits to save database space?
After this question:
http://wordpress.stackexchange.com/a/93902/27148
There is an answer that suggests deleting past edits directly from database, which would be nice, because I could create ...
-2
votes
1answer
32 views
Restrict users viewing post using age on database
Is there a way to have a birthday field on database then use the age to restrict viewing posts?
0
votes
1answer
43 views
accessing wordpress serialized data outside wp
I've never worked with serialized data... I need a little help with how to load "text" widgets title and content in php script outside wordpress...
my script just connects to database (including ...
0
votes
1answer
35 views
“sufficient permissions” error for admin after duplicating WP database to new install
I recently copied the tables from a live WP install to a dev site for that same site. I've changed all the prefixes, the site/WP URLs, and the salt values.
I can successfully log into the new dev ...
3
votes
1answer
44 views
Where can I find the database changes between WordPress versions?
Given vX and vX+1, how do I find the difference between each versions database schema?
0
votes
1answer
21 views
What is best for saving lot of extra detail of user?
In my site i need to store 200 extra data for each user. Now i know about the user meta option. But is it a good way to save 200extra field for each user?
Or should i create an extra table in the ...
0
votes
1answer
29 views
Get the url of attachments from the post?
I used the following code to get the images attached to a post
$current_id = get_the_ID();
$rows = $wpdb->get_results("select guid from $wpdb->posts where post_parent = $current_id");
...
0
votes
0answers
63 views
Adding Custom field in a signup form not working
I have used the following code in functions.php to add some custom field to my registration form and add it to the db in the wp_usermeta table. But dont know why it is not working. I am using a custom ...
0
votes
0answers
130 views
Add data from front end into custom made table in database
I have a registration form which contains firstname, lastname, organisation, username, email etc. Here Username and email only will be saved in the db in the wp_users table.
I have created a new table ...
0
votes
1answer
41 views
Specify strict 'order by' in WordPress query
I have a custom post type called Employees where an employee's name is the post_title of each post.
I am trying to figure out how I would sort the post_title column by last name.
So for instance, if ...
0
votes
2answers
55 views
Import External XML
I don't know where to start with this one.
I would like to create custom post type which will list properties on clients website. I would like those properties being feed from another ...
0
votes
0answers
31 views
Two Sub-Directories, One Database
I have an existing site install at mysite.com/wordpress (but it is set to be accessible at simply mysite.com). I have also installed a separate WP installation on a sub-domain (publish.mysite.com). I ...
1
vote
1answer
84 views
Lost administrator privileges and can't find a fix
WordPress 3.5.1
Web Host: Windows Azure Cloud
Database Host: Cleardb
Web Server: IIS 7.5
I've built a custom child theme that runs on the Genesis Framework and it has multiple custom post types ...
0
votes
1answer
176 views
Wordpress error since update 3.2.1 to 3.5.1
Since I have updated wordpress 3.2.1 to 3.5.1 I have this error.
One month looking for this error and so far, I can not find a solution even know what file causing this error.
[16-Mar-2013 11:36:35 ...
0
votes
1answer
34 views
Designing a custom post type with a minimum number of meta fields
I am new to PHP, mySQL and scripting in general. I'm trying to design a WP custom post type which would be like a point on a timeline or an item on a resume. I'm having trouble designing the structure ...
0
votes
1answer
392 views
Insert data in database using form
I am writing a simple plugin that create a table with name "newsletter" in database and provide a shortcode to put a registration form in pages.
the form contain "name" and "email".
i have problem ...
0
votes
3answers
169 views
Insert Extra fields added in the front end registration form to DB
I have added some extra fields like first_name,middle name,last_name etc into the custom registration form. I want to add those details int the DB also. Now only username,email,Display name and ...
0
votes
0answers
72 views
Plugin updating wp_options table and causing mysql issues
A client of mine has a wordpress site with the database and the wp installation in in a different servers. Yesterday I migrated the wp install to a new web server, keeping the database the same.
In ...
0
votes
0answers
37 views
I am trying to send ajax collected data to the current users database
I am using WooCommerce and added an additional field "location_gps" to collect the location (lat,long) added the ajax call to collect the data. Now I'm stuck getting the data into the current users ...
0
votes
1answer
50 views
Where would I find Custom menu attributes in the database?
In what table would I find the title of a custom menu in MySQL for Wordpress 3.5.x?
0
votes
2answers
36 views
Most efficient way of deleting post
I have a cron job set to remove a (sometimes large) number of posts from my database. Of course, I also need to remove all associated data such as custom fields.
This is the function I'm currently ...
0
votes
0answers
39 views
WP_Query returns 100 results on homepage
Bit of a strange one this...
I've recently migrated a site from wordpress.com to my own server. In the new location, however, wp_query always returns 100 posts on the homepage, regardless of which ...
0
votes
1answer
52 views
SymmetricDS in dev + prod workflow?
Has anyone leveraged SymmetricDS in their development and production efforts so as to keep the environments synchronized?
We have a number of WordPress sites that need to be kept in synch. In our ...
0
votes
1answer
31 views
WordPress Multisite platform for different city for single db
I have One WordPress Multisite installation.
myplatform.com (Main platform)
have custom post list for different city say city1, city2 & city3.
Now What I want is on
city1.myplatform.com (city1 ...
1
vote
1answer
121 views
Large database causes slow load
I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button right after I selected a featured image in the media library.
I had a ...
0
votes
1answer
104 views
wp_posts - guid update
Hello and please excuse if this has been answered before but we really need to make sure.
We have developed a website under a domain of ours and then moved it to the live site of the client. We have ...
0
votes
1answer
62 views
Get a custom table to an array
How can I take my table I created like this:
global $wpdb; //Get all the wordpress database stuff
$table_prefix = $wpdb->base_prefix; //Get the global prefix for all sites (on a multisite ...
0
votes
1answer
23 views
Problem with menu categories doubling up when updating database?
I imported a database from a website to my localhost and the menu categories started doubling up. The wordpress dashboard is also missing my custom post types. How can I solve this?
0
votes
1answer
111 views
Theme Options - localhost to new url
Im having this issue that happens to me each time i work on a website.
On every project i start working locally and once im done i export my Database and search replace all localhost url's to the ...
0
votes
1answer
46 views
Fixing YARPP plugin FULLTEXT MySQL indexing
I just found out that the Yet Another Related Posts plugin (YARPP) uses FULLTEXT indexes on the wp-posts table, which greatly slows down sites with a large amount of posts.
Can I can just delete the ...
2
votes
1answer
102 views
How to increase the character limit for post name of 200?
I have post name in Thai which uses UTF-8 character. Many of them encode into super long in ASCII e.g. วิธีการหลีกเลี่ยงข้อผิดพลาดทั้ง-8-ในชีวิตการแต่งงาน
I've changed the type of "post_name" using ...
0
votes
1answer
44 views
How to modify post content?
I still haven't figured this out yet.
Is this the right way? I tried $_POST['content'] = "nothing" and $_POST['content'] = 0 neither work for me. I'm using following way
function changeContent() {
...
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
87 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 ...
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 ...
1
vote
2answers
114 views
How to modify post content before writing to database?
Hi~ I'm back again and I'm trying to add another function to the script I was working on a plugin that notify my friends of new post that mentions(@) them. Now I want to change the plain text of my ...
0
votes
1answer
92 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 ...
2
votes
1answer
146 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
64 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
0answers
63 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
2answers
55 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
109 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. ...
-3
votes
2answers
167 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
59 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
72 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.
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 ...
