jesterz

Follow-up: I’m using the Extended Live Archives plug-in. For some reason, this plug-in assumes I’m using some plug-in called Ultimate Tag Warrior (UTW). Well, I’m not, but the plug-in was detecting UTW and entering the following code block in af-extended-archive-include.php:

// For UTW
if($utw_is_present) {
$query = "SELECT tag_id
FROM $wpdb->posts
INNER JOIN $wpdb->post2cat ON ($wpdb->posts.ID = $wpdb->post2cat.post_id)
INNER JOIN $tablepost2tag ON ($wpdb->posts.ID = $tablepost2tag.post_id)
WHERE post_date > 0
$exclusions $dojustid
ORDER By post_date DESC";
logthis("SQL Query :".$query, __FUNCTION__, __LINE__);
$results = $wpdb->get_results($query);
if ($results) {
foreach($results as $result) {
$this->postToGenerate['tag_id'][] = $result->tag_id;
}
}
}
// End of stuff for UTW

To fix/patch this, all I did was change the second line to:

if(0 && $utw_is_present) {

The “0 &&” short-circuits the conditional and the block gets skipped. Now my post-edits work without a problem!

Hope that helps!

Follow-up: I’m using the Extended Live Archives plug-in. For some reason, this plug-in assumes I’m using some plug-in called Ultimate Tag Warrior (UTW). Well, I’m not, but the plug-in was detecting UTW and entering the following code block in af-extended-archive-include.php:

// For UTW
if($utw_is_present) {
$query = "SELECT tag_id
FROM $wpdb->posts
INNER JOIN $wpdb->post2cat ON ($wpdb->posts.ID = $wpdb->post2cat.post_id)
INNER JOIN $tablepost2tag ON ($wpdb->posts.ID = $tablepost2tag.post_id)
WHERE post_date > 0
$exclusions $dojustid
ORDER By post_date DESC";
logthis("SQL Query :".$query, __FUNCTION__, __LINE__);
$results = $wpdb->get_results($query);
if ($results) {
foreach($results as $result) {
$this->postToGenerate['tag_id'][] = $result->tag_id;
}
}
}
// End of stuff for UTW

To fix/patch this, all I did was change the second line to:

if(0 && $utw_is_present) {

The “0 &&” short-circuits the conditional and the block gets skipped. Now my post-edits work without a problem!

Hope that helps!

I posted this in another thread, but the problem looks to me like it’s in the missing database name here…

SELECT tag_id FROM werdprezz_posts INNER JOIN werdprezz_post2cat ON (werdprezz_posts.ID = werdprezz_post2cat.post_id) INNER JOIN ON (werdprezz_posts.ID = .post_id) WHERE post_date > 0 AND category_id <> 11 AND ID = 227 ORDER By post_date DESC

It could also be the double “INNER JOIN ON” blocks…

SELECT tag_id FROM werdprezz_posts INNER JOIN werdprezz_post2cat ON (werdprezz_posts.ID = werdprezz_post2cat.post_id) INNER JOIN ON (werdprezz_posts.ID = .post_id) WHERE post_date > 0 AND category_id <> 11 AND ID = 227 ORDER By post_date DESC

I don’t know MySQL/SQL syntax, but I’m betting it has something to do with those blocks.

Just my $0.02. Hope that helps (I’m working on trying to find how/why that text is generated).

mylagoon,

I believe he just named his database “werdprezz” instead of “wordpress”. That doesn’t seem to be the problem.

The problem looks to me like it’s in the missing database name here…

SELECT tag_id FROM werdprezz_posts INNER JOIN werdprezz_post2cat ON (werdprezz_posts.ID = werdprezz_post2cat.post_id) INNER JOIN ON (werdprezz_posts.ID = .post_id) WHERE post_date > 0 AND category_id <> 11 AND ID = 227 ORDER By post_date DESC

It could also be the double “INNER JOIN ON” blocks…

SELECT tag_id FROM werdprezz_posts INNER JOIN werdprezz_post2cat ON (werdprezz_posts.ID = werdprezz_post2cat.post_id) INNER JOIN ON (werdprezz_posts.ID = .post_id) WHERE post_date > 0 AND category_id <> 11 AND ID = 227 ORDER By post_date DESC

I don’t know MySQL/SQL syntax, but I’m betting it has something to do with those blocks.

Just my $0.02. Hope that helps (I’m working on trying to find how/why that text is generated).

I’m bumping this thread because I have the same questions … well, actually, a similar question because I want to be able to have anonymous posting while having the post published right away.
Suggestions or any other assistance is greatly appreciated. Thanks! ??

OOPS!! I hit “enter” too early. How about a description of my problem? ??
As you can see above, I’m having some SQL issues. It seems that no category is getting passed in to the SQL statements. I’ve got the latest WordPress (d/led yesterday, so it’s v1.0.2). I’ve currently got three categories, so I don’t know why it’s not picking them up. Any help would be GREATLY appreciated.
Thanks, and sorry for using two posts for this problem.
-J