planetthoughtful

Hi Otto42,

Thanks for the reply. Then, do you have any idea how WordPress maintains state across pages?

Is it essentially through cookies rather than sessions, or some other method?

Many thanks,

pt

@barunio: someone else had a similar problem and it turned out that their wp_options table didn’t have autoincrement on the options_id field, where the rewrite rules are actually stored.

See: https://www.ads-software.com/support/topic/59907?replies=3

Much warmth,

planetthoughtful

[Moderated. ‘Signatures’ in posts are not permitted as they are impossible to police in terms of size, contents and links. It is appreciated if they would not be used.
Thank you. – Podz]

Actually, don’t worry, I found it via one of your other posts.

Try:


<?php
$SQL = "SELECT ID, post_title FROM wp_posts ORDER BY post_date DESC LIMIT 5";
$rs = mysql_query($SQL);
echo "<ul>";
while ($row = mysql_fetch_object($rs)){
echo "<li><a href='https://www.cheaperholidays.com/late-deals/?p={$row->ID}'>{$row->post_title}</a></li>";
}
echo "</ul>";
mysql_free_result($rs);
?>

Simply drop that on the page where you would like to see the 5 most recent post titles and it should provide them for you.

Hope this helps.

Much warmth,

planetthoughtful

[Moderated. ‘Signatures’ in posts are not permitted as they are impossible to police in terms of size, contents and links. It is appreciated if they would not be used.
Thank you. – Podz]

Hi cheaper,

Can you give me a link to your WP blog, so I can check the URL format you’re using?

Much warmth,

planetthoughtful

[Moderated. ‘Signatures’ in posts are not permitted as they are impossible to police in terms of size, contents and links. It is appreciated if they would not be used.
Thank you. – Podz]

Hi Matt,

The easiest way to do this with MySQL is to produce a ‘dummy’ post_name value. The post_name value simply has to be unique amongst the other post_name values in the records in your wp_posts table. There’s no benefit from WP’s point of view in it being derived from the post_title value – that’s just a convenient way for WP to derive the value.

So, if you’re okay with something like ‘post-1’, ‘post-2’, ‘post-3’ etc values for these particular records, do something like the following.

Disclaimer: please make sure you have a backup of wp_posts before proceding, and you know how to restore that backup. I won’t guarantee this will work, and I won’t guarantee that it won’t cause other issues. In other words, you get what you pay for, which is free advice. ??

Assumptions: I’m assuming the records you’re having problems with have either a zero-length string or NULL value in post_name. I’m assuming each record validly contains a unique integer value in the ID field.

After reading the above, if you want to go ahead, issue the following:

UPDATE wp_posts SET post_name = CONCAT('post-', CAST(ID as CHAR)) WHERE LENGTH(post_name) = 0 OR post_name IS NULL

What this should do: the records with missing post_name values should now have a post_name value of ‘post-‘ with the unique id from the ID field appended. So, if the record in question had an ID value of 212, then post_name should now have the value of ‘post-212’.

Hope this helps. Feel free to ask questions if you’re uncertain how to procede.

Much warmth,

planetthoughtful

If you don’t have any luck finding one, let me know. I’m sure I could put a plugin together for you to do that in a few minutes.

Much warmth,

planetthoughtful

[Moderated. ‘Signatures’ in posts are not permitted as they are impossible to police in terms of size, contents and links. It is appreciated if they would not be used.
Thank you. – Podz]

I don’t see anything wrong with the links page either. Which browser are you seeing a problem in?

Much warmth,

planetthoughtful
—
“Lost in thought”
https://www.planetthoughtful.org

“Urban legends, superstitions, ghost
stories and folklore”
https://www.ulblog.org

Hmmm. I don’t know if the structure changed between WP 1.5.2 and WP 2.0.x, but in my install quicktags.js is in /wp-includes/js/quicktags.js

Are you sure you have it in the right directory? If not, that may explain why it’s being ignored.

Much warmth,

planetthoughtful

[Moderated. ‘Signatures’ in posts are not permitted as they are impossible to police in terms of size, contents and links. It is appreciated if they would not be used.
Thank you. – Podz]

Hi Renee,

Yes, I got your message – thank you very much for the positive feedback. I’ve sent a reply via email.

Much warmth,

planetthoughtful
—
“Lost in thought”
https://www.planetthoughtful.org

“Urban legends, superstitions, ghost
stories and folklore”
https://www.ulblog.org

I believe this is done automatically by WP 2.x. Depending on your permalink structure, you should be able to access the feed for a particular category by:

https://www.example.com/category/Music/feed/

Or, if you don’t have ‘friendly’ permalinks, and your Mucic category had a category of, eg, 4, you could probably get to it via something like:

https://www.example.com/?cat=4&feed=rss

Note: for valid XHTML, if you include the example directly above in a clickable link, it should appear as:

<a href='https://www.example.com/?cat=4&amp;feed=rss'>Feed for the Music Category</a>

Note the use of & in the href instead of just &.

Hope this helps.

Much warmth,

planetthoughtful

Okay, I’ve created a draft Codex article at https://codex.www.ads-software.com/Displaying_Posts_Using_a_Custom_Select_Query

I’ll leave it in draft for a couple of days in case anyone has any comments / edits / changes they’d like me to make, and if I don’t get any feedback, I’ll move it over to the ‘New page created’ category for Codex editors to review.

Much warmth,

planetthoughtful

Thanks for the tip, Kafkaesqui. I think I will put this on the wiki, if only to save other plugin authors who want to roll their own select queries for post loops a few headaches. I just need to figure out where it needs to go.

Much warmth,

planetthoughtful

Are you commenting as yourself? Have you tried logging out and commenting as someone else? I only picked up using WP in 2.0 (after playing around with it a little bit in previous versions) and one thing that I didn’t expect, at least in 2.0 if not earlier versions, is that you don’t get sent an email notification if you comment and you are also the post author. I guess the logic being that you know you’ve commented.

If other people people have commented and you’re not getting email notifications, we’re going to have to do some more digging, unless someone else has encountered / fixed this before?

Much warmth,

planetthoughtful

So, Level10 Blog Matrix Plugin needs some work? Is there any etiquette / guideline involved in messing around with someone else’s distributed plugin?

Much warmth,

planetthoughtful

Yup, however I’ve seen the same thing when people have had both the textile and markdown plugins activated, so that each line in the post gets two paragraph tags etc.

If tweaking your CSS doesn’t help, check to make sure you don’t have conflicting plugins (as the two above) activated.

Much warmth,

planetthoughtful