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=" Search ..." autocomplete="off">
<button type="submit" class="btn-outline-success"> ? </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) }) }}">← 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 →</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 postsIt looks like a have a zombie Power Blog plugin that I need to purge. Details at 11.
1-8 of 8