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

dab69574
dab69574

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?

CatkinFox
CatkinFox

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?

dab69574
dab69574

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

dab69574
dab69574

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

CatkinFox
CatkinFox

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.

dab69574
dab69574

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!

dab69574
dab69574

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?

dab69574
dab69574

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.