Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Error on Blog Export #477

Closed
nozreh opened this issue Oct 10, 2019 · 3 comments
Closed

SQL Error on Blog Export #477

nozreh opened this issue Oct 10, 2019 · 3 comments
Assignees
Labels
Status: Completed Fix is completed and merged into the dev branch; remaining open until it has been merged into master Type: Bug Report that has been identified / verified as an issue requiring resolution
Milestone

Comments

@nozreh
Copy link

nozreh commented Oct 10, 2019

I was trying to export our existing blogs but I'm having issue right now

Octobercms Build: 458
Blog Plugin version: 1.3.4
Database: Postgres 9.6.12

"SQLSTATE[42703]: Undefined column: 7 ERROR: column "featured_images" does not exist LINE 1: select * from "system_files" where field = "featured_images"... ^ (SQL: select * from "system_files" where field = "featured_images" AND attachment_type = "RainLab\\Blog\\Models\\Post" and "system_files"."attachment_id" in (4, 6, 7, 8, 9, 10,) order by "sort_order" asc)" on line 664 of /vendor/laravel/framework/src/Illuminate/Database/Connection.php

@w20k w20k added Status: Review Needed Requires review from a maintainer or trusted community member Type: Unconfirmed Bug Report that hasn't been verified / reproduced by a maintainer or trusted community member yet labels Oct 10, 2019
@w20k
Copy link
Contributor

w20k commented Oct 10, 2019

Hm...worked for me, but without featured image link. Will try it under the Postgres as well.

Dummy example:

ID,Title,Content,"HTML Content",Excerpt,Slug,Categories,"Author Email","Featured Images","Created date","Updated date","Published date"
1,"First blog post","This is your first ever **blog post**! It might be a good idea to update this post with some more relevant content.

You can edit this content by selecting **Blog** from the administration back-end menu.

*Enjoy the good times!*","<p>This is your first ever <strong>blog post</strong>! It might be a good idea to update this post with some more relevant content.</p>
<p>You can edit this content by selecting <strong>Blog</strong> from the administration back-end menu.</p>
<p><em>Enjoy the good times!</em></p>","The first ever blog post is here. It might be a good idea to update this post with some more relevant content.",first-blog-post,Uncategorized,[email protected],,"2019-10-10 02:11:08","2019-10-10 02:11:44","2019-10-10 02:11:08"
2,erewrew,vxcvxcvzxcvdsfdsfdsaf,<p>vxcvxcvzxcvdsfdsfdsaf</p>,sdfsdfsdf,erewrew,Uncategorized,[email protected],,"2019-10-10 02:14:07","2019-10-10 02:14:07","2019-10-11 00:00:00"

@bennothommo bennothommo added Type: Bug Report that has been identified / verified as an issue requiring resolution and removed Status: Review Needed Requires review from a maintainer or trusted community member Type: Unconfirmed Bug Report that hasn't been verified / reproduced by a maintainer or trusted community member yet labels Oct 17, 2019
@bennothommo
Copy link
Contributor

bennothommo commented Oct 17, 2019

It's a confirmed bug - PostgreSQL treats lower-case strings inside double-quotes as column names.

@bennothommo bennothommo added this to the v1.3.5 milestone Oct 17, 2019
@bennothommo
Copy link
Contributor

Fixed by f4b16de - will be released with version 1.3.5 of the Blog plugin.

@bennothommo bennothommo added the Status: Completed Fix is completed and merged into the dev branch; remaining open until it has been merged into master label Oct 17, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Status: Completed Fix is completed and merged into the dev branch; remaining open until it has been merged into master Type: Bug Report that has been identified / verified as an issue requiring resolution
Projects
None yet
Development

No branches or pull requests

3 participants