sammyb

Hi,

I am having the same issue. Neither the shortcode or the php is working for me.

If you managed to solve this issue would you mind posting the solution here please?

Thanks,
Sam

Add this to your theme’s functions.php

function show_all_thumbs() {
    global $post;
    $post = get_post($post);

/* image code */
$images =& get_children( 'post_type=attachment&post_mime_type=image&output=ARRAY_N&orderby=menu_order&order=ASC&post_parent='.$post->post_parent);
if($images){
foreach( $images as $imageID => $imagePost ){

unset($the_b_img);
$the_b_img = wp_get_attachment_image($imageID, 'thumbnail', false);
$thumblist .= '<a href="'.get_attachment_link($imageID).'">'.$the_b_img.'</a>';

}
}
return $thumblist;
}

Then in your template file:

echo show_all_thumbs();

Hope this helps 😉

I agree – couldn’t get it to work as the admin was not clear

I tried the fix – but didn’t seem to work for me – anyone else tried it?

To add unique to the hash columnof the wpo_campaign_posts table in phpmyadmin:

1) select the wp_campaigns_post table from the list of tables in the left sidebar

2) select ‘structure’ from the tabs along the top

3) you will see the 4 table rows – ‘hash’ is the fourth row – click on the little ‘U’ (for Unique key) icon in the hash row.

4) If it throws an error because you already have duplicate ‘hash’ entries in your wp_campaigns_post table then you will need to empty the table first. (there is no harm in emptying this table.

you could run the feed through the translate tool on yahoo pipes.

Hi Erfo

‘max_allowed_packet’ is a mySQL setting and has nothing to do with .htaccess. it defines the maximum size of any data packet that can be written to a single field in your mysql databse.

the rewrite_rules refered to in the error are a row in the wp_options table of the wordpress database. WordPress uses these rules to generate the ‘pretty permalinks’ when using a custom permalink structure such as /%category%/%postname%.

When you create a new page in wordpress extra rules are added to the array of rewrite rules in your database. More pages = more rewrite_rules

what is happening here is that the number of rewrite rules created by your site is larger than the max_allowed_packet size as set in the mysql configuration on your server.

Here’s some info on how to increase the max_allowed_packet:
http://www.liferay.com/web/guest/community/forums/-/message_boards/message/124969

The only other solution is to reduce the number of pages on your site… not a great option really

Sam

This rewrite_rules issue still seems to persist in 2.9.2

On most default mysql setups the max_allowed_packet variable is set to 1MB.

If you are using a custom permalink structure, such as /%category%/%postname% there is a limit to how many pages you can create before the rewrite_rules option exceeds the 1MB limit.

If rewrite_rules does get bigger than the limit set in max_allowed_packet it will not be written to the wp_options table. This causes wordpress to compile the rewrite_rules on every page load resulting in literally thousands of database queries per page load… enough to bring any server to its knees…

A quick fix is to increase the max_allowed_packet size. However, if the rewrite_rules option can just grow and grow as you add more wordpress pages it is only a matter of time before it starts showing up in the slow query logs too…

the trac is still open
http://core.trac.wordpress.org/ticket/8958