Forum

Thread tagged as: Question, Runway, Blog

Upgrading to Blog 5.0 - 11,147 Posts

Hi There,

I have upgraded to Perch Blog 5.0, but what I didn't realise is the client has over 11,000 articles to update.

Is there a quicker way of updating this instead of waiting for this - https://goo.gl/p27DvR to cycle through.

Just thought I would ask :-)

Thanks
Fishtank Creative

Fishtank Creative 2 points

  • 5 years ago
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

By the time I wrote an alternative, the update would have already finished. It should only take a few minutes.
Fishtank Creative

Fishtank Creative 2 points

5 years ago

Its taken nearly two days and still cant access the blog
Fishtank Creative

Fishtank Creative 2 points

5 years ago

I've tried the force update on the blog app but not sure if it was the right process
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

Really? Is it ticking through? It should do 10 and then reload. Each reload should take about a second.
Fishtank Creative

Fishtank Creative 2 points

5 years ago

Yes its ticking through slowly, currently on Page 159 of about 714. But we are expecting a high spike of traffic at 2pm as its Wigan Warriors squad announcement.

Just wondering is there anything I can do to make this quicker or stop it (Without Reverting back) so they can access the blog at least.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

It really should only take a few minutes. If it's being that slow, that indicates perhaps that something else isn't right with the setup.
Fishtank Creative

Fishtank Creative 2 points

5 years ago

A lot of articles have been imported from an old system. But not sure if that would be the case. How do I investigate if there is a problem with the blog app.

You are right I updated to the latest version of Perch itself and it took seconds, the same didn't apply for blog.

Here is my DR if that helps

PERCH INFORMATION

Perch Runway: 2.8.29
Production mode: Development (10)
Installed apps: content (2.8.29), assets (2.8.29), categories (2.8.29), perch_blog (5.0), perch_forms (1.8.3), perch_gallery (2.8.6)
DB driver: PDO
DB tables: perch2_backup_plans (0), perch2_backup_resources (0), perch2_backup_runs (0), perch2_blog_authors (16), perch2_blog_comments (0), perch2_blog_index (330367), perch2_blog_posts (11147), perch2_blog_posts_to_tags (4107), perch2_blog_sections (1), perch2_blog_tags (862), perch2_blogs (1), perch2_categories (19), perch2_category_counts (10), perch2_category_sets (2), perch2_collection_index (406), perch2_collection_items (98), perch2_collection_revisions (30), perch2_collections (2), perch2_content_index (33376), perch2_content_items (3657), perch2_content_regions (262), perch2_forms (25), perch2_forms_responses (3969), perch2_gallery_albums (51), perch2_gallery_image_versions (8760), perch2_gallery_images (876), perch2_kraken_jobs (0), perch2_navigation (0), perch2_navigation_pages (1), perch2_page_routes (54), perch2_page_templates (88), perch2_pages (156), perch2_resource_log (21918), perch2_resource_tags (340), perch2_resources (9074), perch2_resources_to_tags (973), perch2_scheduled_tasks (1), perch2_settings (42), perch2_twitter_scheduled_tweets (0), perch2_twitter_settings (1), perch2_twitter_tweets (399), perch2_user_passwords (2), perch2_user_privileges (45), perch2_user_role_privileges (15), perch2_user_roles (2), perch2_users (18)
Users: 18
App runtimes:
<?php
    $apps_list = array(
        'content',
        'categories',
        'perch_blog',
        'ftc_html_helper',
        'ftc_sport_radar',
        'perch_gallery',
        'perch_forms',
        'ftc_kaltura',
    );
Scheduled tasks for perch_blog: delete_spam_comments (1440 mins)
Editor plug-ins: markitup
H1: a50a5f1a9e21640f780c3ac298e08d5d
L1: 36a56a90021366a6d13248c6cf9b2c78
F1: 2edba60ed1f613d6dd804feb202456a2
headerColour: #a91b32
content_singlePageEdit: 0
helpURL:
siteURL: /
hideBranding: 1
content_collapseList: 1
lang: en-gb
update_2.7.2: done
headerScheme: dark
latest_version: 2.8.15
on_sale_version: 2.8.29
dashboard: 0
hide_pwd_reset: 0
content_hideNonEditableRegions: 0
content_frontend_edit: 1
logoPath: /admin/resources/wigan_logo_smaller.png
perch_blog_update: 5.0
perch_blog_post_url: /news/{postSlug}
update_2.7.4: done
perch_blog_slug_format: %Y-%m-%d-{postTitle}
perch_blog_akismet_key: 9b661c5390d1
perch_blog_max_spam_days: 1
perch_blog_comment_notify: 0
update_2.7.10: done
perch_twitter_update: 3.5
update_2.8.4: done
perch_gallery_update: 2.8.5
perch_gallery_bucket_mode: dynamic
perch_gallery_bucket: gallery
perch_gallery_basicUpload: 0
update_runway_2.8.8: done
update_runway_2.8.10: done
update_runway_2.8.11: done
update_runway_2.8.12: done
update_runway_2.8.13: done
update_runway_2.8.17: done
update_runway_2.8.21: done
update_runway_2.8.29: done
PERCH_DEVELOPMENT: 10
PERCH_STAGING: 50
PERCH_PRODUCTION: 100
PERCH_SITEPATH: /var/www/html/wiganwar/staging/public_html
PERCH_SCHEDULE_SECRET: HNa1wYd6qg2mEsBS
PERCH_DB_USERNAME: wiganwar_runway
PERCH_DB_SERVER: 87.117.230.251
PERCH_DB_DATABASE: wiganwar_runway
PERCH_DB_PREFIX: perch2_
PERCH_PRODUCTION_MODE: 10
PERCH_EMAIL_FROM: chris@fishtankcreative.co.uk
PERCH_EMAIL_FROM_NAME: Chris Gorrod
PERCH_LOGINPATH: /admin
PERCH_PATH: /var/www/html/wiganwar/staging/public_html/admin
PERCH_CORE: /var/www/html/wiganwar/staging/public_html/admin/core
PERCH_RESFILEPATH: /var/www/html/wiganwar/staging/public_html/admin/resources
PERCH_RESPATH: /admin/resources
PERCH_HTML5: 1
PERCH_TZ: Europe/London
PERCH_CLEAN_RESOURCES:
PERCH_RUNWAY: 1
PERCH_ERROR_MODE: DIE
PERCH_DATE_LONG: %d %B %Y
PERCH_DATE_SHORT: %d %b %Y
PERCH_TIME_SHORT: %H:%M
PERCH_TIME_LONG: %H:%M:%S
PERCH_RUNWAY_ROUTED:
PERCH_STRONG_PASSWORDS:
PERCH_DEBUG:
PERCH_PREVIEW_ARG: preview
PERCH_TEMPLATE_PATH: /var/www/html/wiganwar/staging/public_html/admin/templates
PERCH_DEFAULT_DOC: index.php
PERCH_DEFAULT_EXT: .php
PERCH_RWD:
PERCH_HTML_ENTITIES:
PERCH_SSL:
PERCH_STRIPSLASHES:
PERCH_PROGRESSIVE_FLUSH: 1
PERCH_PARANOID:
PERCH_FORCE_SECURE_COOKIES:
PERCH_PASSWORD_MIN_LENGTH: 6
PERCH_MAX_FAILED_LOGINS: 10
PERCH_AUTH_LOCKOUT_DURATION: 1 HOUR
PERCH_VERIFY_UPLOADS:
PERCH_AUTH_PLUGIN:
PERCH_DB_CHARSET: utf8
PERCH_DB_PORT:
PERCH_DB_SOCKET:
PERCH_SESSION_TIMEOUT_MINS: 20
HOSTING SETTINGS

PHP: 5.6.17
Zend: 2.6.0
OS: Linux
SAPI: apache2handler
Safe mode: not detected
MySQL client: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
MySQL server: 5.5.46-log
Free disk space: 26.73 GB
Extensions: Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, bcmath, imap, pspell, snmp, tidy, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, exif, mcrypt, mysqlnd, PDO, Phar, posix, shmop, SimpleXML, soap, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlwriter, xsl, mysql, mysqli, pdo_mysql, pdo_sqlite, wddx, xmlreader, json, memcache, zip, mhash, ionCube Loader, Zend OPcache
GD: Yes
ImageMagick: No
PHP max upload size: 64M
PHP max form post size: 64M
PHP memory limit: 128M
Total max uploadable file size: 64M
Resource folder writeable: Yes
Session timeout: 24 minutes
Native JSON: Yes
Filter functions: Yes
Transliteration functions: No
HTTP_HOST: www.wiganwarriors.com
HTTP_UPGRADE_INSECURE_REQUESTS: 1
HTTP_USER_AGENT: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.24 Safari/537.36
HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_REFERER: https://www.wiganwarriors.com/admin/core/settings/diagnostics/
HTTP_ACCEPT_ENCODING: gzip, deflate, sdch
HTTP_ACCEPT_LANGUAGE: en-US,en;q=0.8,fr;q=0.6
HTTP_COOKIE: WW:CookiePolicy=Cookies%20Accepted; cb-enabled=accepted; __utma=162974906.427009140.1447850982.1449651686.1449651686.1; __utmz=162974906.1449651686.1.1.utmcsr=tv.wiganwarriors.com|utmccn=(referral)|utmcmd=referral|utmcct=/; _ga=GA1.2.427009140.1447850982; cmsa=1; PHPSESSID=45mf1b29ft4hp6jrqn98b05rm6
HTTP_X_FORWARDED_PORT: 80
HTTP_X_FORWARDED_FOR: 81.105.76.171
HTTP_CONNECTION: close
PATH: /sbin:/usr/sbin:/bin:/usr/bin
SERVER_SIGNATURE: <address>Apache/2.2.15 (CentOS) Server at www.wiganwarriors.com Port 80</address>
SERVER_SOFTWARE: Apache/2.2.15 (CentOS)
SERVER_NAME: www.wiganwarriors.com
SERVER_ADDR: 87.117.252.219
SERVER_PORT: 80
REMOTE_ADDR: 87.117.230.251
DOCUMENT_ROOT: /var/www/html/wiganwar/staging/public_html/
SERVER_ADMIN: bwftechs@bwf.co
SCRIPT_FILENAME: /var/www/html/wiganwar/staging/public_html/admin/core/settings/diagnostics/index.php
REMOTE_PORT: 47259
GATEWAY_INTERFACE: CGI/1.1
SERVER_PROTOCOL: HTTP/1.1
REQUEST_METHOD: GET
QUERY_STRING: extended
REQUEST_URI: /admin/core/settings/diagnostics/?extended
SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
PHP_SELF: /admin/core/settings/diagnostics/index.php
REQUEST_TIME_FLOAT: 1465396556.479
REQUEST_TIME: 1465396556

My Post.php page is the following

<?php
    perch_blog_check_preview();
    $title = perch_blog_post_field(perch_get('s'), 'postTitle', true) .' | News';

    // Include the header. You can find this in tempates/layouts/global
    perch_layout('global/header', [
            'title'=> $title
    ]);

        perch_blog_categories(array(
            'template' => 'category_page_nav.html',
        ));



        $result = perch_blog_custom(array(
            'filter' => 'postSlug',
            'match' => 'eq',
            'value' => perch_get('s'),
            'skip-template' => true,
            'return-html'   => true,
        ));

        echo $result['html'];

        $urlMatch = perch_get('matchID');
        echo $urlMatch;

?>

</div>

<?php

            $blog_album = perch_blog_post_field(perch_get('s'), 'album', true);
            perch_gallery_album($blog_album, array(
                'template'=>'match_album_news.html'
            ));

?>

<div class="container  block-content  block-content--notop">

    <div class="section  section-small  clearfix">
        <h2 class="lone-title  h2  secondary  align-left">Recent News & Media</h2>

    <?php

    $currentDate = date("Y-m-d");
    $rangeDate = date("Y-m-d", strtotime("-5 days"));


    perch_blog_custom(array(
        'filter' => 'postDateTime',
        'match' => 'eqbetween',
        'value' => $rangeDate.','.$currentDate,
        'sort-order'=> 'DESC',
        'sort'=>'postDateTime',
        'count'=> 4,
        'template'=> 'blog/related_posts.html'
    ));

    ?>

</div>

</div>

<?php
    // Include the footer. You can find this in tempates/layouts/global
    perch_layout('global/footer');
?>

My Post.html template is the following

<perch:if exists="big-image">
    <div class="innerHero  skew-bottom  skew-bottom--z">

        <div class="innerHero--cover">
            <img src="<perch:blog id="big-image" type="image" width="2000" height="1160" label="Large Banner Image" help="Dont forget to compress your images - https://tinypng.com/" order="6" crop="true" bucket="news" />" alt="<perch:blog id="postTitle" type="text" label="Title" required="true" size="xl autowidth" order="1" />" style="margin-top: -<perch:blog id="big-image-pos" type="select" order="7" label="Position of Large Banner"
options="5, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24" allowempty="false" required="true" />%;" />
        </div>

    </div>

    <div class="container  block-content  block-content--notop">

        <article class="section-small  section--notop  article-text--layout  article-content">

<perch:else />

            <div class="container  block-content  block-content--straight">
                <article class="section-small  article-text--layout  article-content">
</perch:if>


    <ul class="breadcrumbs">
        <li><a href="/">Home</a> <span>.</span></li>
        <li><a href="/news/">News</a> <span>.</span></li>
        <li><perch:blog id="postTitle" type="text" label="Title" required="true" size="xl autowidth" order="1" /></li>
    </ul>

    <h1 class="h1">
        <a href="<perch:blog id="postURL" type="hidden" />" rel="bookmark" class="secondary">
            <perch:blog id="postTitle" type="text" label="Title" required="true" size="xl autowidth" order="1" />
        </a>
    </h1>

    <div class="article-text--meta">
        <div class="pw-widget pw-counter-horizontal">
            <a class="pw-button-facebook pw-look-native"></a>
            <a class="pw-button-twitter pw-look-native"></a>
        </div>
        <script src="https://i.po.st/static/v3/post-widget.js#publisherKey=t46dgv848ld2hs9pqp4d&retina=true" type="text/javascript"></script>

        <time class="h4  h4__reg  secondary" datetime="<perch:blog id="postDateTime" type="date" label="Date" time="true" format="Y-m-d H:i:s" divider-before="Meta information" />">
            <perch:blog id="postDateTime" type="date" time="true" format="%B %e, %G, %H:%M%p" />
        </time>

        <a href="https://twitter.com/WiganWarriorsRL" class="twitter-follow-button  " data-show-count="false">Follow @WiganWarriorsRL</a>

        <script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0],p=/^https:/.test(d.location)?'http':'https';if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src=p+'://platform.twitter.com/widgets.js';fjs.parentNode.insertBefore(js,fjs);}}(document, 'script', 'twitter-wjs');</script>

        <perch:categories id="categories" set="blog" label="Categories" display-as="checkboxes" suppress="true">
            <a href="/news/category/<perch:category id="catSlug" type="slug" />" class="p-category">
                <perch:category id="catTitle" type="text" />
            </a>
        </perch:categories>

    </div>

    <perch:if exists="kalturaId">

        <div class="embed-container">
            <iframe src="https://cdnapi.kaltura.com/p/1257361/sp/125736100/embedIframeJs/uiconf_id/19646841/partner_id/1257361?iframeembed=true&playerId=kaltura_player_<perch:blog id="perch_item_index" type="hidden" />&entry_id=<perch:blog id="kalturaId" type="text" label="Kaltura Video ID" order="8" help="Unique IDs are located in your Kaltura platform account" />&flashvars[streamerType]=auto" allowfullscreen webkitallowfullscreen mozAllowFullScreen frameborder="0"></iframe>
        </div>

    <perch:else />

        <perch:if exists="big-image">
            <perch:else />
                <perch:if exists="image">
                    <p>
                        <img src="<perch:blog id="image" type="image" width="795" help="Dont forget to compress your images - https://tinypng.com/" label="Image" bucket="news" order="5" />" alt="<perch:blog id="postTitle" />" />
                    </p>
                </perch:if>
        </perch:if>

    </perch:if>

    <perch:blog id="postDescHTML" type="textarea" label="Post" order="4" editor="markitup" markdown="true" size="autowidth" help="If you want to use blocks ignore this textarea and use the options below" />

    <perch:blocks order="5" divider-before="Article Blocks - More Control of your layout">

            <perch:block type="text" label="Text">
                <perch:blog id="text" type="textarea" markdown="true" editor="markitup" size="s" label="Text" />
            </perch:block>

            <perch:block type="pullquote" label="Pull quote">
                <blockquote>
                      <perch:blog id="quote" type="textarea" markdown="true" size="xs" label="Quote" />
                      <cite>&mdash; <perch:blog id="cite" type="smarttext" label="By" /></cite>
                </blockquote>
            </perch:block>

            <perch:block type="inlinequote" label="Inline quote">
                <blockquote class="article-content__quote-inline  <perch:blog id="class" type="select" options="Pull left|left,Pull right|right" label="Alignment" order="2" />">
                      <perch:blog id="quote" type="textarea" markdown="true" size="xs" label="Quote" />
                      <cite class="article-content__cite"><perch:blog id="cite" type="smarttext" label="By" /></cite>
                </blockquote>
            </perch:block>

            <perch:block type="image" label="Big image">
                <figure class="article-content__image  article-content__image-full">
                  <img src="<perch:blog id="image_block" type="image" width="1600" label="Image" />" class="img-responsive" />
                  <figcaption class="h4  h4__reg  article-content__image-caption"><perch:blog id="caption" type="smarttext" label="Caption" /></figcaption>
                </figure>
            </perch:block>

            <perch:block type="inlineimage" label="Inline image">
                <figure class="article-content__image-inline <perch:blog id="class" type="select" options="Pull left|left,Pull right|right" label="Alignment" order="2" />">
                    <img src="<perch:blog id="image_block" type="image" width="360" density="2" label="Image" order="1" />" class="img-responsive" />
                </figure>
            </perch:block>


            <perch:block type="TextRegion" label="Text and inline image">
                <div class="image-text-region clearfix">
                    <h2><perch:blog id="heading" type="text" label="Heading" html="false" encode="false" /></h2>
                    <figure class="article-content__image-inline <perch:blog id="class" type="select" options="Pull left|left,Pull right|right" label="Alignment" order="2" />">
                        <img src="<perch:blog id="image_block" type="image" width="360" density="2" label="Image" order="1" />" class="img-responsive" />
                    </figure>
                    <perch:blog id="text" type="textarea" markdown="true" editor="markitup" size="s" label="Text" />
                </div>
            </perch:block>

    </perch:blocks>

    <perch:blog id="album" type="albumlist" label="Gallery Album" suppress="true" />

<perch:blog id="excerpt" type="textarea" label="Excerpt" markdown="true" order="3" suppress="true" size="s" />

<perch:blog id="image" type="image" width="120" height="65" crop="true" bucket="news" suppress="true" />
<perch:blog id="image" type="image" width="544" height="290" crop="true" bucket="news" suppress="true" />
<perch:blog id="image" type="image" width="194" height="104" crop="true" bucket="news" suppress="true" />
<perch:blog id="image" type="image" width="177" height="91" crop="true" bucket="news" suppress="true" />
<perch:blog id="image" type="image" width="715" height="382" crop="true" bucket="news" suppress="true" />
<perch:blog id="matchId" type="text" label="Match IDs" order="7" suppress="true" help="Separate with commas, Leigh Centurions (a) - 237331
Salford Red Devils (a) - 237333
Catalans Dragons (h) - 237075
Huddersfield Giants (a) - 237077
Brisbane Broncos (h) - 237315
Salford Red Devils (h) - 237078
Hull FC (a) - 237057
Leeds Rhinos (h) - 237081
Widnes Vikings (h) - 237083
St Helens (a) - 237085
Hull KR (h) - 237086
Warrington Wolves (h) - 237031
Wakefield Trinity Wildcats (a) - 236996
Castleford Tigers (h) - 237089
Huddersfield Giants (h) - 237090
Warrington Wolves (a) - 237026
Hull FC (h) - 237064
Leeds Rhinos (mw) - 237094
Castleford Tigers (a) - 237096
Salford Red Devils (a) - 237097
Hull KR (a) - 237098
Widnes Vikings (a) - 237100
Catalans Dragons (a) - 237101
Wakefield Trinity Wildcats (h) - 237032
Leeds Rhinos (a) - 237103
St Helens (h) - 237104" />


<perch:blog id="homepage_title" type="text" label="Homepage Title" order="8" help="If this article is the main article you need to enter the title here so you can control the lenght" divider-before="Homepage Articles Configuration" suppress="true" />

<perch:blog id="aligned" type="select" label="Position on Homepage" order="9" options="Left Aligned|left, Right Aligned|right" allowempty="false" required="true" suppress="true" />

</article>

Any help would be great on this.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

How long did it take in staging?
Fishtank Creative

Fishtank Creative 2 points

5 years ago

We did it live on the server, I updated Perch and went through quick with no issues, so just thought to myself while i'm here I might as well update the blog big mistake.

So I have left the post updating overnight (from 7pm until 7:30am next morning + plus still running) its 6370 out of 11,000.

The server is a cluster with 1 DB server so I can think that this could be an issue.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

How long does each page load take?
Fishtank Creative

Fishtank Creative 2 points

5 years ago

Roughly 1.5 / 2 minutes
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

On a healthy system it should take a second or two at most.

Are the numbers incrementing logically? There's not a chance the process is also being run from another node in the cluster is there?

If you're doing this directly on a live server without testing it first, I'm not sure there's much I can do to practically help. A good step in future would be to test updates in your staging environment to make sure they're going to work for your configuration before putting them live. This advice is also included in the update notes:

We always advocate updating your staging or development copy of the site and testing the changes first. We do not recommend updating a live site without checking everything’s going to work first.
Fishtank Creative

Fishtank Creative 2 points

5 years ago

Hi Drew,

Thanks for your help on this and your points are noted.

The update process has now completed. One thing I noticed When I ran the update the query string went up to page 1147 so if its 10 posts per page that's 11470 posts.

Well now that the update has completed I went back into the blog and noticed there is only 744 pages (See here - https://goo.gl/reEXiN) which is 7440 posts.

Can't understand why it would go up to over 11,000 posts.

Any ideas?

Thanks Barry
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

It's 15 per page, so 15 * 744 = 11160. It may be also processing deleted posts which might account for the rest.
Fishtank Creative

Fishtank Creative 2 points

5 years ago

11160, Thats the amount of posts that were in the system. But the update went up to page 1116 (According to the query string) so the update must have been processing 10 posts per page.

I will have to look at some other problems that it might be.

This is what our hosting company have said:

There is indeed duplicates in the database, however I do not believe the issue is cluster related because of the timestamps on the some of the duplicates:

SELECT postDateTime, postTitle from perch2_blog_posts where postTitle='Blakes Blog';
+---------------------+--------------+
| postDateTime        | postTitle    |
+---------------------+--------------+
| 2013-01-31 00:00:00 | Blakes Blog  |
| 2013-02-12 00:00:00 | Blakes Blog  |
| 2013-03-12 00:00:00 | Blakes Blog  |
| 2013-03-26 00:00:00 | Blakes Blog  |
| 2013-07-17 00:00:00 | Blakes Blog  |
| 2014-03-05 00:00:00 | Blakes Blog  |
| 2014-03-19 00:00:00 | Blakes Blog  |
| 2014-04-01 00:00:00 | Blakes Blog  |
| 2014-04-29 00:00:00 | Blakes Blog  |
| 2014-05-14 00:00:00 | Blakes Blog  |
| 2014-06-16 00:00:00 | Blakes Blog  |
| 2014-07-01 00:00:00 | Blakes Blog  |
+---------------------+--------------+

Here is a full list of the duplicate posts in this one table and the number of times they are duplicated:

SELECT postTitle, COUNT(*) c FROM perch2_blog_posts GROUP BY postTitle HAVING c > 1 ORDER BY c;
See below

count:  postTitle
2:      Cup Hospitality Still Available
2:      Cricket POSTPONED
2:      Ticket and Travel For Leeds 
2:      Final Chance to Use Scrum Ticket 
2:      Rovers Ticket and Travel Information
2:      Warriors 18's Defeated
2:      18's and 20's Action This Weekend
2:      18's Defeat Saints
2:      Lotto Agent Required
2:      Grand Final Ticket Details
2:      It's a BIG Night Out
2:      Maguire Names Squad To Face Saints 
2:      Wigan Win At Wakefield
2:      Wigan v Huddersfield highlights
2:      Maguire Names Cup Squad
2:      Cup Hospitality
2:      18's Defeat Giants
2:      Wigan Win In Wales
2:      Cup Stats
2:      18's Game Postponed
2:      Warriors Trio In England Squad
2:      Festival of Rugby A Huge Success
2:      Grand Final Sell Out
2:      Wish the Boys Good Luck
2:      Work with the Warriors
2:      Madge on Derby Win
2:      Warriors Charity Signing Event
2:      Maguire On Crusaders Win
2:      Double Success For Scholarship
2:      E-Bay Items Up For Grabs
2:      Cup Details Confirmed
2:      Maguire On Catalans
2:      Fathers Day Gifts at Warriors World
2:      Match Stats
2:      Madge on Saints 
2:      Wigan Back To Winning Ways
2:      South Stand Sold Out
2:      WCC Ticket Update
2:      Warriors To Hold Pre-Season Dinner
2:      Warriors World Opening Hours
2:      Lockers Ready For New Campaign
2:      Warriors Charity Ebay Auction
2:      20's Defeat Saints
2:      Community Foundation Race Night
2:      Warriors World Closed Sunday
2:      Huddersfield Ticket Update
2:      Wigan Defeat Wildcats
2:      Maguire On Giant Win
2:      Warriors Support Never Watch Alone Initiative
2:      Noble and Morgan Name Squads
2:      VIDEO: Chairman On Fans Forum
2:      Warriors Winning Wednesday
2:      Replica Shirts Reduced
2:      How The Play-Offs Work
2:      Playoff Ticket Information
2:      Playoff Ticket Update
2:      Wigan Progress In The Play-Offs
2:      Semi Final Ticket News
2:      Wigan Warriors Official Statement
2:      Reserves and Academy Win Again
2:      Warrington Ticket News
2:      Derby Tickets Selling Fast
2:      Wigan Defeated by Tigers
2:      Noble Pleased with Victory
2:      Service Area Dinner
2:      Wigan Get Back To Winning Ways
2:      Lotto Collector Required
2:      Saints Tickets Selling Well
2:      Reserves Win, Academy Lose
2:      The Big One
2:      England Defeat France
2:      Warriors Extend Season Ticket Renewal Deadline
2:      Six Warriors in England Academy
2:      All Inclusive Family Ticket Deadline
2:      Never Watch Alone
2:      Past Players Association Dinner
2:      Maguire Pleased with Defence
2:      Easter Hospitality
2:      20's Game Postponed
2:      Maguire On Wakefield Win
2:      Maguire On Salford Win
2:      Cup Ticket Update
2:      All Inclusive Ticket for a Great Family Night Out
2:      Warriors Launch New Group Ticket Packages
2:      Warriors World Sunday Super Saver
2:      Past Players Association Meeting
2:      Merry Christmas
2:      Sunday Super Saver At Warriors World 
2:      Maguire Names Strong Squad
2:      Warriors February Half Term Coaching Camps 
2:      Warriors World Season Countdown 
2:      Warriors Week 
2:      Warriors Roadshow Success
2:      Have Your Say
2:      VIDEO: Maguire Previews Quins
2:      Silverwood In Charge
2:      Warriors World - Sunday Opening
2:      Warriors Golf Day
2:      Warriors Name Derby Squad
2:      Warriors Under 19's Defeated
2:      Wane on Semi-Final Win
2:      Shaun Previews Catalan Clash
2:      Last Chance to Use Scrum Ticket
2:      Warriors at Wigan Xmas Lights Switch On
2:      Wane Happy
2:      Hawks Looking forward to Wigan Trip
2:      Shaun Previews Cup Clash
2:      Dual Reg Round Up
2:      Warriors in Dual Reg Action
2:      Shaun Reflects on Leeds Defeat
2:      Warriors Under 19's Defeat Bulls
2:      Community Stadium Re-Named
2:      More to Come
2:      Pay on the Gate Tonight
2:      Shaun Previews Salford Clash
2:      Wane Pleased with Win
2:      Good Luck Latics
2:      Win VIP Tickets to Magic Weekend with IRN-BRU!
2:      Under 19's Fixture Change
2:      Under 19's Game Cancelled
2:      Widnes Highlights and Reaction
2:      Bring a Friend for a Fiver
2:      Catalans Tour
2:      Same Again
2:      No Excuses
2:      19s Postponed
2:      Dramatic Fashion
2:      Learning Curve
2:      Coach Education
2:      Retro Match of the Week
2:      More Than The Game
2:      Last Chance Hospitality
2:      General Sale
2:      Sports College Open Day
2:      Wane Names Unchanged Squad
2:      Warriors Lead the way in Embedding the Pathway
2:      Vote for Your Coral Try of the Month
2:      Another Great Friday
2:      Coral Betting Preview: Wigan v Hull KR
2:      London Calling
2:      Max's Day Out
2:      Derby Tickets
2:      Captain's Camp
2:      19's Game Postponed
2:      State of Mind
2:      First Utility Fanorak
2:      Warriors 20's Defeated
2:      Widnes Ticket News
2:      Wane on Widnes
2:      Lockers Latest Blog
2:      New Podcast Out Now
2:      Wigan Defeat Broncos
2:      Wane On Win
2:      Salford Ticket Information
2:      Young Warriors Defeat Scorpions
2:      Warriors Announce Squad
2:      South Stand Sells Out
2:      Salford Game Moved
2:      Website Update
2:      Wigan Defeat Reds
2:      Wigan Defeat Bulls
2:      20's To Face Wildcats In Play-Offs
2:      Wigan Name Semi-Final Squad
2:      Season Review - Part Three
2:      Season Review - Part Four
2:      Captains Blog
2:      Wane Names Squad 
2:      Chairman On RL Extra Tonight
2:      Shaun Previews Derby Clash
2:      Warriors Lotto Rollover
2:      Spread The Cost of Your Membership
2:      Warrior Girl Auditions Tonight
2:      Rads in America Part 2
2:      Bitcon on Florida
2:      LIVE WEBCHAT
2:      Warriors Name Salford Squad
2:      Wigan TV FREE Trial
2:      Highlights Now Available
2:      Clubcall on Sunday
2:      Wolves Ticket Update 
2:      Congratulations Bradley
2:      Hull FC Ticket Information
2:      Wane on Wakefield
2:      Cup Date Confirmed
2:      Richards Sidelined
2:      Warriors Name Squad to face Giants
2:      Warriors Roadshow Returns To Grand Arcade
2:      Roadshow Success
2:      Broncos Ticket News
2:      Wane on Wakefield Win
2:      An Awesome Night of Entertainment
2:      Semi Final Ticket Update
2:      Junior Academy Championship Grand Final
2:      Christmas Opening Hours
2:      Free Delivery on Warriors World Orders
2:      Quins Ticket News
2:      Ticket Update
2:      Wigan Tame The Wildcats
2:      Warriors Celebrate Rugby Camp Success
2:      Warriors Smash Season Ticket Record
2:      engage Super League Round 10 Round Up
2:      Behind the Sticks - Week 9
2:      engage Super League Round 9 Round Up
2:      engage Super League Round 8 Round Up
2:      Carnegie Challenge Cup Draw
2:      Academy Game OFF
2:      Game ON Tonight
2:      Season Tickets On Sale NOW
2:      Noble Names 20 Man Squad
2:      Behind the Sticks - Week 27
2:      Bet on Sport with totesport
2:      Wigan Defeat Catalans
2:      Warriors Name 18 Man Squad
2:      Game Night Information
2:      Behind The Sticks Round 18
2:      engage Super League Round 12 Round Up 
2:      Double Academy Success
2:      Behind the Sticks - Week 15
2:      engage Super League Family of the Year Competition
2:      The Quins Captainís Club
2:      Ian Millward Interview
2:      Warriors Defeat Vikings
2:      Challenge Cup Hospitality
2:      Giant Run for Max
2:      Millennium Magic Round Up
2:      Warriors Name Same 20
2:      engage Super League Round 5 Round Up
2:      Warrior Girls Support Beach Babe Competition
2:      Noble Names 20 For Quins Trip
2:      Senior Academy Result
2:      Warriors Announce 20 Man Squad
2:      Warriors Launch Half Season Ticket
2:      Leeds Rhinos Ticket Information
2:      Behind the Sticks - Week 23
2:      Warriors Launch Player Cards
2:      Mixed Weekend For Academy
2:      Behind the Sticks - Week 20
2:      Warrington Wolves Ticket Information
2:      Academy Kick Off Change
2:      Fielden on Warriors TV
2:      engage Super League Round 18 Round Up
2:      Behind the Sticks - Week 19
2:      Wigan Defeated by Leeds Rhinos
2:      Warriors Appoint New Community Development Manager
2:      Season Tickets Now on General Sale
2:      Cheltenham Festival Round-up
2:      Website Information
2:      Hock in the Dock
2:      Lotto Agents Wanted
2:      Brave Warriors Suffer Derby Defeat
2:      Coach Travel to Huddersfield
2:      Warriors Half Term Rugby Camps
2:      Walk Wonders for Macmillan Cancer Support...
2:      Catalans Kick Off Change
2:      Warriors Christmas Draw
2:      Junior Academy Cancelled
2:      Season Tickets Now on Sale
2:      Fixtures Released Monday
2:      Warriors Light Up Wigan
2:      Saturday Night Fever at the JJB
2:      New Podcast Available
2:      Noble Reflects on Saints Defeat
2:      Bailey's Blog - 10th June
2:      VIDEO: Wane on Reserve Season
2:      Bulls Eye
2:      Reserves and Academy both Win
2:      Reserve and Academy Games This Weekend
2:      More Catalans Shirts Up For Auction
2:      Warriors Defeat the Wolves
2:      Noble Names Strong Squad
2:      Reserve and Academy Action
2:      Warriors Get Back To Winning Ways
2:      Powergen Challenge Cup Draw
2:      We laid down a marker today - Peet
2:      Behind the Sticks - Cup Preview
2:      Noble Names 19 Man Squad for Cup Clash
2:      Academy in Action Tonight
2:      Noble Looks Ahead to Saints Clash
2:      Behind The Sticks - Week 2
2:      Rocky Knows What to Expect
2:      Warriors Return To Training
2:      Leeds Win Grand Final
2:      Warriors Win Grand Final
2:      Riversiders End of Season Presentation Dinner
2:      VIDEO: Noble Previews Hull FC Clash
2:      Fans Forum - SOLD OUT
2:      Under 16's in Action Tomorrow
2:      Bailey's Blog - 22nd July
2:      Warriors to Host Fans Forum
2:      Mossop Feeling Great
2:      Warriors End Away Day Blues
2:      Ticket Office Closure
2:      Behind the Sticks
2:      Half Season Tickets Still Available
2:      Bailey's Blog - 15th April
2:      VIDEO: Noble Thoughts
2:      Derby Day Ticket Update
2:      The Ian Millward Column
2:      Warriors Fans Snap Up Playoff Tickets
2:      Behind the Sticks - Semi Final Preview
2:      Warriors Lose to Giants
2:      Warriors Week in the Wigan Evening Post
2:      Playoff Podcast Now Available
2:      Vote for your Phone-A-Loan Player of the Month
2:      The Clock is Ticking...
2:      Noble Reflects On Cup Loss
2:      Young Warriors Earn Rep Honours
2:      Warriors Lose to Rhinos
2:      Behind The Sticks - Week 10
2:      Itís a Great Night Out @ the JJB
2:      Wigan Warriors Salary Cap Hearing
2:      Girls War of the Roses
2:      Challenge Cup Round Up
2:      The Early Bird Catches the Worm
2:      Check Your Tickets
2:      Saints Away is now ALL TICKET
2:      Golden Gamble Not Claimed
2:      Noble Proud Despite Defeat
2:      Warriors Announce 18-man Squad
3:      Coach Education Evening
3:      Behind the Sticks - Week 14
3:      Behind The Sticks - Week 22
3:      Player Development Days
3:      Catalans with the Warriors
3:      Rhinos Ticket News
3:      Free Postage at Warriors World
3:      Warriors Defeated by Rhinos
3:      Warrior Girls Race For Life
3:      Under 19s Game Postponed
3:      October Rugby Camp
3:      Behind The Sticks - Week 21
3:      Challenge Cup Ticket Details
3:      engage Super League Round 3 Round Up
3:      Behind The Sticks - Week 3
3:      Noble on Warriors TV
3:      Wane on Magic Win 
3:      Spread the Word
3:      Behind The Sticks - Week 12
3:      Wane On Cup Clash
3:      International MATTers
3:      Wigan Warriors Coach Education Evening
3:      St George's Blog
3:      Behind The Sticks - Week 6
3:      Caught In Action
3:      Warriors Roadshow This Saturday
3:      Latest Podcast Available
3:      Catalans Ticket Update
3:      Noble Reflects On Salford Win
3:      Warrior Workouts
3:      20's Win, 18's Defeated
3:      Maguire On Cup Win
3:      Wigan Defeat Hull KR
3:      Saints SOLD OUT
3:      Carnegie Challenge Cup Round Up
3:      Maguire Pleased with Win
3:      Warriors Sign Up Youngsters
3:      Another Lotto Winner
3:      Reserve Game Postponed
3:      Another Lotto £1000 Winner
3:      Grand Final Hospitality
3:      Maguire Happy With Win 
3:      Working With the Warriors
3:      Lotto Canvassers Required
3:      Reserve and Academy Action this Weekend
3:      Double Success for Reserves and Academy
3:      Warriors Visit Derian House
3:      Fan Day Success
3:      Reserve and Academy Action This Week
3:      Ticket Office Closed Saturday
3:      Warriors Defeated by Giants
3:      Its A Great Night Out
3:      Behind the Sticks - Week 25
3:      Warriors Name Squad To Face Rhinos
3:      New Wallpapers Now Available
3:      Warriors Visit Rainbow Ward
3:      Wane On Injuries
3:      engage Super League Playoff Round Up
3:      Giants Ticket News
3:      Warriors Name Squad
3:      engage Super League Review
3:      Warriors to Switch On Lights
3:      Warriors Remain Unbeaten In Nines
3:      Season Review Podcast Now Available
4:      Hull KR Ticket Update
4:      Challenge Cup Draw
4:      Sunday Super Saver
4:      Behind The Sticks - Week 4
4:      Maguire Disappointed
4:      Important Matchday Information
4:      Warriors Name Unchanged Squad
4:      Warriors Back In Training
4:      Leuluai Named in Kiwi Squad
4:      Warriors Launch Half Season Tickets
4:      Behind The Sticks - Week 8
4:      Ticket Office Open Saturday
4:      Warriors World - Sunday Super Saver
4:      Behind The Sticks - Week 5
4:      Warriors Injury Update
4:      £10,000 Lotto Winner
4:      Playoff Ticket News
4:      Saturday Stats
4:      New Podcast
4:      Warriors And Rhinos Name Squads
4:      Warriors Name Cup Squad
4:      Stat Attack
4:      Merry Christmas from Wigan Warriors
4:      Behind The Sticks - Week 26
4:      Monday Stats
4:      Place Your Bets
4:      Wane On Wigan Win
4:      Wane Delighted With Win
4:      Flower Power
4:      Behind the Sticks - Week 24
5:      SLS Preview
5:      Maguire Delighted With Win
5:      Does It Matty to You
5:      Hoff the Record
5:      Behind The Sticks - Week 11
5:      Injury Update
5:      Rads Down Under
5:      Wane Thrilled With Win
5:      Latest Ticket News
5:      Noble's Notes
5:      Behind The Sticks - Week 7
6:      Coral Betting Preview
6:      Rads in America
6:      Noble Names 19 Man Squad
6:      Retro Match
6:      Blake's Blog
6:      Loan & Dual Reg Round Up
6:      Employment Opportunity
6:      Super League Round Up
7:      Loan and Dual Registration Round Up
7:      Noble Thoughts
7:      Loan and Dual Reg Roundup
7:      Clubb Man
8:      Maguire Names Squad
8:      Sunday Stats
8:      Latest Podcast Now Available
11:     Bailey's Blog
11:     Frontline Fair Play League
12:     Blakes Blog
12:     It's a Great Night Out
13:     Hospitality Update
14:     Warriors Name 19 Man Squad 
15:     Friday Stats
16:     Betting Blog
20:     Wigan TV... FREE!
24:     With Regret
32:     New Podcast Now Available
42:     engage Super League Round Up
47:     Super League Show Preview
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

I'm not fully clear on what problem you're currently experiencing. What are you trying to fix?
Fishtank Creative

Fishtank Creative 2 points

5 years ago

I'm just trying to figure out why this update took over 24 hours to update.
Drew McLellan

Drew McLellan 2638 points
Perch Support

5 years ago

Have you now run it locally to get your dev systems up to date?