This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

Hi, I got my blog working the way I want it to, with a sticky menu on the left and the full post on the right. https://eaware.ca/blog But my last 2 blog posts do not fully display, only an excerpt or preview is visible. And, when I click on any post's title link, I get an error. Like this one https://eaware.ca/blog/post/nowords Why is this happening, and what could have changed?

It seems that your MySQL database is missing a column called "embed_code".

I suggest you post the code from your blog post template page so I can see if there are errors with the code.

Did you build your own Blog plugin, or are you using the Rainlab Blog plugin?

I used the Rainlab blog, here is my blog page template:

<style type="text/css">
    * { box-sizing: border-box; } body {margin: 0;}
    *{box-sizing:border-box;}
    body{margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;background-repeat-x:repeat;background-repeat-y:repeat;background-position-x:0%;background-position-y:0%;background-attachment:scroll;background-size:auto;background-image:url("/storage/app/media/peachNimbus.jpg");}
    div.container{min-height:40px;}
    .navbar .navbar-nav .nav-link:hover{border-top-color:skyblue;border-top-style:outset;border-top-width:2px;border-right-color:skyblue;border-right-style:outset;border-right-width:2px;border-bottom-color:skyblue;border-bottom-style:outset;border-bottom-width:2px;border-left-color:skyblue;border-left-style:outset;border-left-width:2px;border-image-outset:0;border-image-repeat:stretch;border-image-slice:100%;border-image-source:none;border-image-width:1;color:rgb(0, 0, 0);}
    #imxv{width:92%;display:block;margin-top:8px;margin-right:auto;margin-bottom:auto;margin-left:auto;}
    .nav-item{text-align:center;font-weight:700;margin-top:0px;margin-right:5px;margin-bottom:0px;margin-left:0px;}
    .form-control.me-2{font-size:12px;}
    #ih8jbb{box-sizing:border-box;margin-top:0px;margin-bottom:0.5rem;font-weight:700;line-height:1.5;font-size:2rem;font-family:Helvetica;color:rgb(26, 26, 26);text-transform:none;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;letter-spacing:normal;text-indent:0px;white-space:normal;word-spacing:0px;-webkit-text-stroke-width:0px;text-decoration-thickness:initial;text-decoration-style:initial;text-decoration-color:initial;text-align:center;}
    #iaq4fq{box-sizing:border-box;}
    section{min-height:40px;}
    div.col{min-height:40px;}
    div.row{min-height:40px;}
    #i5ahqr{background-image:url("/storage/app/media/peachNimbus.jpg");}
    #in6og{margin-right:3rem;border:1px solid black;height:21rem;overflow:scroll;overflow-x:hidden;overflow-y:hidden;position:sticky;top:56px;border-radius:21px;border:1px solid rgba(0,0,0,0.59);box-shadow:0 0 5px 0 black, 0 0 5px 0 black;}
</style>

<div class="container"><img src="/storage/app/media/blogTor.jpg" id="imxv" /></div>
<div id="i5ahqr" class="container sticky-top">
    <div class="row">
        <div class="col-md-2">
        </div>
        <div class="col-md-8">
            <nav class="navbar navbar-expand-lg navbar-light">
                <div class="container-fluid">
                    <div id="navbarSupportedContent" class="collapse navbar-collapse">
                        <ul class="navbar-nav me-auto mb-2 mb-lg-0">
                            <li class="nav-item"><a href="https://eaware.ca" class="nav-link">Home</a></li>
                            <li class="nav-item"><a href="https://eaware.ca/about" class="nav-link">About</a></li>
                            <li class="nav-item"><a href="https://eaware.ca/services" class="nav-link">Services</a></li>
                            <li class="nav-item"><a href="https://eaware.ca/projects" class="nav-link">Projects</a></li>
                            <li class="nav-item"><a aria-current="page" href="https://eaware.ca/blog" class="nav-link active">Blog</a></li>
                            <li class="nav-item"><a href="https://eaware.ca/contact" class="nav-link">Contact</a></li>
                        </ul>
                        <form action="{{ 'search' | page }}" method="get">
                             <input name="q" type="text" placeholder="&nbsp;Search ..." autocomplete="off">
                             <button type="submit" class="btn-outline-success">&nbsp;?&nbsp;</button>
                        </form>
                    </div>
                </div>
            </nav>
        </div>
        <div class="col-md-2" style="padding-top:1rem; padding-bottom:1rem;">
            {% if user %}
               <a href="#" data-request="onLogout">Logout</a>
            {% else %}
               <a href="https://eaware.ca/login">Login or Register</a>
            {% endif %}
        </div>
    </div>
</div>
<br />
<div class="container">
    <h2 id="ih8jbb">Articles On Innovation and Creativity
        <br />
    </h2>
</div><br />
<div>
    <div class="row">
        <div class="col-md-1"></div>
        <div class="col-md-2" id="in6og">
            <ul class="navbar-nav me-auto mb-2 mb-lg-0">
                {% for post in posts %}
                <li class="nav-item"><a href="#{{ post.slug }}" class="nav-link">{{ post.title }}</a></li>
                {% endfor %}
            </ul>
        </div>
        <div class="col-md-8">
            {% partial 'posts' %}
        </div>
        <div class="col-md-1"></div>
    </div>
</div>
<br /><br />
<div class="container"><img style='display:block;margin:auto;' src="/storage/app/media/serviceBanner.jpg" /></div>
<br /><br />

Last updated

And here is that partial called posts

{% set posts = blogPosts.posts %}
<div class="post-list">
    {% for post in posts %}
        <div class="media">
            <div class="media-body">
                <h4 class="media-heading" id="{{ post.slug }}">
                    <a href="{{ post.url }}">{{ post.title }}</a>
                </h4>
                <p class="info">
                    Posted
                    {% if post.categories.count %} in {% endif %}
                    {% for category in post.categories %}
                        <a href="{{ category.url }}">{{ category.name }}</a>{% if not loop.last %}, {% endif %}
                    {% endfor %}
                    on {{ post.published_at|date('M d, Y') }}
                </p>
                {% if post.excerpt %}
                    <p class="excerpt">{{ post.excerpt }}</p>
                {% else %}
                    <div class="content">{{ post.content_html|raw }}</div>
                {% endif %}
            <hr /><br />
            </div>
        </div>
    {% else %}
        <div class="no-data">
            <p>{{ noPostsMessage }}</p>
        </div>
    {% endfor %}
</div>
{% if posts.lastPage > 1 %}
    <ul class="pagination">
        {% if posts.currentPage > 1 %}
            <li><a href="{{ this.page.baseFileName|page({ (pageParam): (posts.currentPage-1) }) }}">&larr; Prev</a></li>
        {% endif %}

        {% for page in 1..posts.lastPage %}
            <li class="{{ posts.currentPage == page ? 'active' : null }}">
                <a href="{{ this.page.baseFileName|page({ (pageParam): page }) }}">{{ page }}</a>
            </li>
        {% endfor %}

        {% if posts.lastPage > posts.currentPage %}
            <li><a href="{{ this.page.baseFileName|page({ (pageParam): (posts.currentPage+1) }) }}">Next &rarr;</a></li>
        {% endif %}
    </ul>
{% endif %}

Last updated

Hey dab69574,

Since last time I checked it seems you got your article pages working once more. What was your solution?

Was it something with the DB? I don't see any issues with your template code here.

It is working now, wow. Before I had a Forum component installed and I think that I sent my blog posts over there because I had this fantasy people would be interested in what I had to say. But that was showing errors so I removed it and did an upgrade as well as sync and migrate. Looks like it worked. Thanks for helping out!

It worked for a while then crashed again with this error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'powerblog_delta' in 'where clause' (SQL: select * from `rainlab_blog_posts` where `powerblog_delta` is null or `powerblog_delta` = )

I've tried installing and removing Power Blog using Artisan but no luck. Could it be that Power Blog reformatted my blog posts and made them go weird?

Okay, so using phpMyAdmin I added a nullable column called powerblog_delta to the end of rainlab_blog_posts, and my site came back up. Whew! But I still get this annoying message:

You must convert your posts into Power Blog posts in order to edit and access your posts

It looks like a have a zombie Power Blog plugin that I need to purge. Details at 11.

1-8 of 8

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.