By William Delhomme on Thursday, 20 September 2018
Posted in Technical Issues
Likes 0
Views 452
Votes 0
Hello,

I have the error "1054 Unknown column 'ordering' in 'order clause'" when i want to submit a new post.
I already fix the database.
It is a blank installation.

EasyBlog 3.2.9
Joomla 3.8.12

Thank you
Hey William,

Is it possible for you update your site backend and FTP access at http://stackideas.com/dashboard/site so we can better have a check?

May i know which version you upgrade from?
·
Thursday, 20 September 2018 17:23
·
0 Likes
·
0 Votes
·
0 Comments
·
It's done,

It is not an upgrade it is a new installation

Thank you
·
Thursday, 20 September 2018 19:51
·
0 Likes
·
0 Votes
·
0 Comments
·
Strange, I did tried in my locally for the Easyblog fresh installation, it seems work fine.

Actually you missing this `ordering` column under this table `#__easyblog_post_templates`, I already help you execute this following SQL query to add back this `ordering` column on your site, it should work fine now.


ALTER TABLE `#__easyblog_post_templates` ADD `ordering` tinyint(1) unsigned NOT NULL DEFAULT 0;
·
Thursday, 20 September 2018 22:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok it works,

Yes strange, i had no error message during installation
·
Thursday, 20 September 2018 22:18
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome, keep us update if you encounter another issue.

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding
·
Friday, 21 September 2018 09:59
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post