CoastAMS
Forum Replies Created
-
Any luck on this?
Forum: Plugins
In reply to: [AddToAny Share Buttons] Icons not displaying correctlyI’m in the UK and having the same issue on all sites using this plugin.
Using Chrome it displays, but just a coloured square on all other browsers
Forum: Plugins
In reply to: [WP Favorite Posts] Thumbnails in widgetI figured it out..
just posting in case anyone else needs this:just add this line to widget code:
echo get_the_post_thumbnail( $o->post_id, thumbnail);
Forum: Fixing WordPress
In reply to: windows XP and very slow admin panelI’d just like to add – we have the same problem.
In the office where we are running 2 x XP machines and 2 x Windows 7 machines – WordPress is seriously slow! Case in point I’ve been trying to make a small edit to one of our blogs for over 30 minutes and I cannot get the page to load enough to do the edit. This is the same for all of our machines (and all browsers) at work.
We called our IT guy (Facebook does the same – but no other sites) – he could not find a solution.
At home on my Windows XP machine my WordPress sites are very fast, so I don’t think it’s XP.
Just as a side note, recently I’ve found that by adding https:// to the URL (if it has ssl) makes the site work normally! (ie fast)
Forum: Plugins
In reply to: [Exports and Reports] [Plugin: Exports and Reports] Help joining queriesI’ve managed to get the query working.
However although this works in the mySQL dashboard it doesn’t work in the plugin.
Is there anything else I need to/can do to make this work in the plugin?
SET SESSION SQL_BIG_SELECTS=1; SELECT post_title, regno.meta_value as regno, price.meta_value as price, color.meta_value as color, year.meta_value as year, mileage.meta_value as mileage, enginesize.meta_value as enginesize, doors.meta_value as doors, trans.meta_value as trans, fueltype.meta_value as fueltype, owners.meta_value as owners, body_type.meta_value as body_type FROM wp_posts LEFT JOIN wp_postmeta AS regno ON regno.post_id=ID AND regno.meta_key='regno_value' LEFT JOIN wp_postmeta AS price ON price.post_id=ID AND price.meta_key='price_value' LEFT JOIN wp_postmeta AS color ON color.post_id=ID AND color.meta_key='color_value' LEFT JOIN wp_postmeta AS year ON year.post_id=ID AND year.meta_key='year_value' LEFT JOIN wp_postmeta AS mileage ON mileage.post_id=ID AND mileage.meta_key='mileage_value' LEFT JOIN wp_postmeta AS enginesize ON enginesize.post_id=ID AND enginesize.meta_key='enginesize_value' LEFT JOIN wp_postmeta AS doors ON doors.post_id=ID AND doors.meta_key='doors_value' LEFT JOIN wp_postmeta AS trans ON trans.post_id=ID AND trans.meta_key='trans_value' LEFT JOIN wp_postmeta AS fueltype ON fueltype.post_id=ID AND fueltype.meta_key='fueltype_value' LEFT JOIN wp_postmeta AS owners ON owners.post_id=ID AND owners.meta_key='owners_value' LEFT JOIN wp_postmeta AS body_type ON body_type.post_id=ID AND body_type.meta_key='body_type_value' WHERE wp_posts.post_type = 'listing' AND post_status = 'publish' ORDER BY IDForum: Plugins
In reply to: [Exports and Reports] [Plugin: Exports and Reports] Help joining queriesThank you again – unfortunately that doesn’t appear to work just returns a ‘No items found’ message
Forum: Plugins
In reply to: [Exports and Reports] [Plugin: Exports and Reports] Help joining queriesThank you for getting back to me so quickly. That’s ALMOST it…
The only issue is it displays each meta key on a separate row – so each van is displayed 4 times (screenshot: http://twitpic.com/6rbdg8/full )
is there anyway to get it so that it displays the data in the same row?
eg:
post_title ¦ reg_no_value ¦ price_value ¦ color_value ¦ year_valuethanks