Tagged Questions

0
votes
1answer
16 views

Split WP_POST table based on post types

I was wondering if it's possible to get my posts from 2 databases depending on the post type. I'm using HyperDB but can't seem to get it to specify the database based on post type. I Basically need ...
1
vote
1answer
18 views

Extracting post categories

I'm in the middle of assisting a colleague in reconfiguring a Wordpress database for use on another platform. The database is essentially details regarding all the posts and accompanying metadata, ...
0
votes
1answer
32 views

Insert data in custom table during new post creation

I want to in insert data in my custom db table when creating a post. Suppose there are three categories (php, wordpress & jquery). When i create a post in wordpress, i want to insert post id and ...
0
votes
1answer
46 views

Import custom database into wp and keep the post id

Hello guys I have a project where I need to import an old database to wp but I need a solution to keep the old id's as posts id so i can make the links look the same as the old website in this way we ...
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 ...
0
votes
1answer
43 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
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
1answer
126 views

Most recent post from another database

I am trying to add the most recent post from another Wordpress database (on the same server in all actuality), but am getting the following error: Fatal error: Call to undefined method ...
0
votes
1answer
68 views

why there are so many posts whoes post_type is revision? will these records waste too much database space?

from the following data we may know there are only 30 records which are meaningful, and there are 92 records of revision post_type which can not be shown on the blog. so will these records waste too ...
0
votes
1answer
26 views

why the posts queried from sql is more than those showed on the page?

i am using WordPress multisite, the issue i face is that the posts queried from sql is more than those showed on the page, the details is as follows: mysql> select count(*) from wp_137_posts where ...
1
vote
0answers
42 views

Copy post to separate database with “add_action(…)”

I'm basically trying to have a copy of a post be sent to another database's table when it's published. I've gotten it to add a new row in the new table, with my own static arguments, but I'm not sure ...
-1
votes
1answer
30 views

Shortcode returning specific content of a post

I'm currently building a plugin to display specific part of post after accepting verification code. Can a shortcode return a part of a post? I mean: Bla bla bla [shortcode postID="100"] Special bla ...
5
votes
1answer
131 views

How can I increase the character limit for post passwords?

When I want to protect a post on one of my blogs, I like to use a passphrase instead of a password (albeit purely for the sake of creativity, not security — they're stored plainly anyway). However, ...
0
votes
1answer
75 views

Making my plugin create a page?

I have created a plugin that creates a table in the database and allows users to add an Item to the table. I would like each item to also create a page for its self so that when the items are listed I ...
1
vote
1answer
195 views

How do I write this SQL statement for Posts written in last 24 hours?

Someone gave me this SQL code to count the number of posts (of post_type 'mixtapes') in the last 7 days. I tried to convert it to 'in the last 24 hours' as well, but it's giving the wrong number. ...
0
votes
1answer
265 views

database columns: post_title vs post_name

I changed post_title, post_contents, and post_name to allow for utf by changing collating sequence to: utf8_general_ci Then using add new post, I type for the title three Hebrew ALEFs. The post_title ...
2
votes
2answers
182 views

Tons of Twitter rows in my database

I have 264,307 "http" (post_type = http) rows in my wp_posts table. 99% of those have them have this post_title: GET http://twitter.com/statuses/user_timeline/@xcentric.json?count=100 and "error" ...
0
votes
4answers
61 views

Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?

I made a backup for my clients site the other night, apparently after I made the backup they made a few posts. I then moved the site to another host and resetup wordpress and imported the database and ...
4
votes
2answers
959 views

Can posts have parents?

Are posts supposed to have parents? If so, what would that mean for a post to have a parent? Also, if there are some constraints to posts having parents, then where is that enforced? Not in the DB as ...
0
votes
1answer
103 views

Load posts from external source if not found in database

I want to modify WordPress so that it requests content from a function if content is not found in the database. I want to edit the section of the code which requests and returns the post content ...
0
votes
1answer
155 views

Is there a function to get post info for any publish_status by post ID?

I'm trying to, essentially, check whether a post exists and if it does (in published, draft or auto-draft states) return the post info. I'm finding get_post() doesn't seem to work with drafts, and ...
1
vote
1answer
41 views

Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?

I was wondering if there is a way or a plugin to post something like twitter update messages instead of a post. Something like http://p2demo.wordpress.com/ but better, where a user will post update ...
0
votes
1answer
309 views

Anyone know why wordpress converts some html entities to their numeric equivalents?

Does anyone know why wordpress converts some html entities to their numeric equivalents? I've found that in some posts, where a non-breaking space   entity would be appropriate, wordpress ...
0
votes
1answer
100 views

Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”

I need to clean up my database and I think that a way to do and keep it that way is by deleting all posts that have 3 days of life. One good thing is that those posts I want to delete are in a ...
0
votes
1answer
277 views

How Can I Always Display A Particular Post First Using WP_Query?

My apologies if this question has already been asked somewhere else, I searched but couldn't find anything. I am working on a tours website, there will be individual package pages that show some text, ...
0
votes
1answer
353 views

Help on conditional statement to accompany wp_insert_post function please?

I'm trying to programatically insert posts from an external MySQL database as posts on my wordpress blog, I've got something that works, but there is no way of wordpress checking to see if the post ...
3
votes
3answers
1k views

Moving Wordpress to new server: no posts found

I have a weird problem with moving a Wordpress installation to a new server (just the server changes, domain remains the same, I'm currently accessing the site on the new server via the same domain ...
0
votes
1answer
108 views

What do these phpMyAdmin errors mean on my WordPress databaes?

I'm getting 3 very similar phpMyAdmin errors on one of my WordPress databases. More than one INDEX key was created for column `comment_approved` More than one FULLTEXT key was created for column ...
1
vote
2answers
679 views

Custom Taxonomies Incorrectly Counting Revisions?

(Moderator's note: The original title was "The count of my custom taxonomy is incorrect; it's counting revisions") Has anybody run into this before? I've added two custom taxonomies, and the count ...