rbernabe's Replies | WordPress.org

Forum Replies Created

Viewing 11 replies - 1 through 11 (of 11 total)

Forum: Fixing WordPress
In reply to: custom select query w/ pagination

rbernabe
(@rbernabe)

17 years, 4 months ago

I’ve been searching for an answer for days. This is such a sigh of relief. Thanks to all!

Forum: Fixing WordPress
In reply to: Order categories by custom field
Thread Starter rbernabe
(@rbernabe)

17 years, 4 months ago
Update: I’ve gotten in touch with a friend of mine who knows his SQL pretty well. I turned on debugging on my MySQL server and gave him the query that was generated when displaying a specific category, as well as some table schemas. He gave me the following query:
```
SELECT SQL_CALC_FOUND_ROWS  wp_posts.*

FROM wp_posts
	INNER JOIN  wp_term_relationships
		ON (wp_posts.ID =  wp_term_relationships.object_id)
	INNER JOIN wp_term_taxonomy
		ON  (wp_term_relationships.term_taxonomy_id =  wp_term_taxonomy.term_taxonomy_id)

	LEFT OUTER JOIN wp_postmeta
		ON (wp_posts.ID = wp_postmeta.post_id AND
			wp_postmeta.meta_key = 'lastname')

WHERE 1=1
	AND  wp_term_taxonomy.taxonomy = 'category'
	AND wp_term_taxonomy.term_id IN  ('4')
	AND wp_posts.post_type = 'post'
	AND (wp_posts.post_status =  'publish' OR wp_posts.post_status = 'private')

GROUP BY wp_posts.ID

ORDER BY COALESCE(wp_postmeta.meta_value, post_title) ASC, post_title ASC

LIMIT 0, 10;
```
This seems to work fine. The question now is, where do I put this query so it gets run for the categories I want it to?

Thanks!
Rob
Forum: Fixing WordPress
In reply to: Custom Query for Specific Category
Thread Starter rbernabe
(@rbernabe)

17 years, 4 months ago
I apologize, I didn’t the proper chunk of code. I have a proper loop per the Docs:
```
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
 /* Blah */
<?php endwhile; //end one post ?>^M
<?php endif; ?>
```
But I still can’t get the query to work properly. Any ideas?

Thanks!
Forum: Fixing WordPress
In reply to: sort category posts by date asc
rbernabe
(@rbernabe)

17 years, 5 months ago
I’ve been trying this every which way, and it’s not working properly for me:
```
<?php query_posts($query_string.'&orderby=date&order=ASC'); ?>
    <?php if (have_posts()) : while (have_posts()) : the_post(); ?>
                <div id="post-<?php the_ID(); ?>" class="thumbnail">
<a href="<?php echo get_permalink() ?>" rel="bookmark" title="<?php the_title(); ?>"><h3 id="post-<?php t
he_ID(); ?>"><?php the_title(); ?></h3><img src="<?php echo get_post_meta($post->ID, "Thumbnail", true);
?>" alt="<?php the_title(); ?> <?php _e(''); ?>" /></a>
      <p><?php the_category(', ') ?></p>
</div>

    <?php endwhile; //end one post ?>
<?php endif; ?>
```
The results are still ordered by title alphabetically. Can you help?
Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 7 months ago

JuMi you are the man!! It worked for me!

Thanks a ton – I’ve been waiting so long for this to work.

Rob

Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 7 months ago

No UTF errors at all. I’ve even tried switching back to the default theme. No go. Im at a loss here…

Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 7 months ago

I just upgraded to WP 2.6.1, still having the same problem. It takes about 3 minutes to load the http://www.mydomain.com/xmlrpc.php?rsd URL in a browser. My other blog running 2.5.1 loads that URL quickly, and also can be loaded into the iPhone app.

Someone please help! I wanna start blogging with my iPhone already…

Thanks

Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 8 months ago

Joseph – can I just grab the traffic for you from the server side? I can quickly and easily do a tcpdump/tcpflow and get you the output.

Note however that I have already done this, and there’s nothing going on that I see awry. I see the initial request for the xmlrpc.php page come in from the iPhone, but no response from the server. I have a hunch that the xmlrpc.php page just takes too long to load (like Karen said it takes like 3 minutes for me as well via my browser on my MacBook), and the iPhone app times out in waiting.

Also note that my second blog (which I can add to my iPhone) is running 2.5.1 and the xmlrpc.php page loads instantly in the browser on my Mac.

Thanks

Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 8 months ago

English for me as well.

Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 8 months ago

I tried a couple more things without success:

1) disabled all plugins
2) changed to default theme

No go. I keep checking this thread with my fingers crossed 🙂

Forum: Fixing WordPress
In reply to: Iphone app not connecting

rbernabe
(@rbernabe)

17 years, 8 months ago

Im having the same exact problem with only one of my self-hosted blogs. My other blog (which is hosted on the same server) works fine. The only difference between the two is the wordpress version. The blog that works with the iPhone app is running on WP 2.5.1, while the non-working blog is on the latest 2.6.

Clearly can’t be anything with apache on my end…

I SO can’t wait to start blogging with this app, can’t wait to get this solved!

Update: Sorry, forgot to add that I also messed around a bit last night. I followed the new directions added to the FAQ page on iphone.wordpress.net regarding the XML-RPC stuff. I tried loading the URL located in the RSD meta tag per the instructions – http://example.com/xmlrpc?rsd. It takes like 20 seconds for it to load on my 2.6 install, while it loads instantly on my 2.5.1 install. So perhaps the iPhone app is timing out before the page is returned?

Viewing 11 replies - 1 through 11 (of 11 total)