By Chris Chase on Thursday, 07 March 2019
Posted in General Issues
Replies 12
Likes 0
Views 751
Votes 0
Hello

Joomla version 3.9.3
Easyblog version 5.0.44
PHP 7.1.26

when i try to upgrading Easyblog to 5.2.12 I am getting an error when adding or editing blog posts.
Error: 1054 Unknown column 'doctype' in 'where clause'

Frontend
Error: 1054 Unknown column 'version' in 'field list'
Hi there,

I would advice you to use staging/live site to update them. Can you provide us with your staging/test site access and phpmyadmin access so that we can further check this issues?
·
Friday, 08 March 2019 11:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello

I have added staging site credentials.
·
Wednesday, 27 March 2019 18:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Tried to create new post and edit seems to work fine as you can see below. By the way, i update your Easyblog to its latest version as well.

backend
New post creation
https://take.ms/biDkx

Edit post
https://take.ms/7jels

Frontend
new post creation
https://take.ms/lEkHt

Edit
https://take.ms/PEB15
·
Wednesday, 27 March 2019 18:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello

As i can see your screenshot, it's not our site, it's display usacomputerservices
but i have added credentials for this site http://novascotest.directivesites.com

please revert changes you have done on usacomputerservices, please let me know how did you find credentials of usacomputerservices.
·
Wednesday, 27 March 2019 20:37
·
0 Likes
·
0 Votes
·
0 Comments
·
We have removed that blog posts that you made to USA Computers, by the way you left autoposting enabled and pushed those blogs to our customers social media. I am more than a little upset that you not only tested the wrong website but the fact that you pushed those blogs to the live social media accounts for the wrong customer is a unacceptable.

I suggest you review this ticket in full and understand what we are asking for before moving forward.

TO CLARIFY:
1- We never asked you to test if blogs could be posted, we asked about a table issue when updating easyblog.
2- The website in question is http://novascotest.directivesites.com and the credentials provided in this ticket are for http://novascotest.directivesites.com

We did this at your request in this ticket:

11:31 AM Friday, 08 March 2019
Hi there,
I would advice you to use staging/live site to update them. Can you provide us with your staging/test site access and phpmyadmin access so that we can further check this issues?


Please do not do any work on any website besides http://novascotest.directivesites.com for this ticket.
·
Wednesday, 27 March 2019 21:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

I am sorry for confusion and sorry for any inconvenience caused. On your last replies, there are credentials for http://www.usacomputerservices.com/administrator as you can see here https://take.ms/lcTjT and i thought that those are your staging site.

By the way, i tried to access your staging site, it seems that given access are not valid as you can see here https://take.ms/8ivoU.

when i try to upgrading Easyblog to 5.2.12 I am getting an error when adding or editing blog posts.

I do create testing post because you have mentioned that you getting this error when adding or editing your blog post.
·
Thursday, 28 March 2019 09:46
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello

Please check once again test/staging site credentials
when we try to upgrading Easyblog to 5.2.12 then got the error (add and edit any blog post).
please disable auto posting before made any changes on the site
·
Thursday, 28 March 2019 14:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Seems like you are updating from 5.0 to 5.2 version and thus causing this issues. I have added missing columns as listed below on your table and it should works as it should now.

[gist type="php"]

#_ are change based on your table prefixes

ALTER TABLE `#__easyblog_post` ADD `version` varchar(10) default '';
ALTER TABLE `#__easyblog_post_templates` ADD `doctype` VARCHAR(255) NOT NULL DEFAULT 'ebd';
ALTER TABLE `#__easyblog_post` ADD `params` TEXT NOT NULL;
[/gist]
·
Thursday, 28 March 2019 15:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello

Frontend error: 1054 - Unknown column 'media' in 'field list'
url: http://novascotest.directivesites.com/blog
blog page is not working fine
·
Thursday, 28 March 2019 16:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

Added below sql on your end.

ALTER TABLE `#__easyblog_post` ADD `media` LONGTEXT NULL AFTER `image`
·
Thursday, 28 March 2019 16:39
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post