Error on comment post K1.8.1
By Jordan Weinstein on Friday, 25 April 2014
Posted in Technical Issues
Replies 16
Likes 0
Views 1.2K
Votes 0
Hello,

On the latest Komento 1.8.1 pro release (and on the immediately previous version as well), I get an error popup on posting a reply.
Status:

200

Status Text:

OK

Response Text:



		

		

			Error displaying the error page: Unable to load renderer class: Unknown column 'unformattedDate' in 'field list' SQL=UPDATE `HIDDEN_komento_comments` SET `component`='com_k2',`cid`='1342',`comment`='Hello,\n\nSGLT2 inhibitors have not yet been approved for use in Canada. I expect 2-3 of them will be approved within the next 6 months.\n\nDr. HIDDEN',`name`='Dr. HIDDEN',`title`='',`email`='###@gmail.com',`url`='',`ip`='199.71.174.200',`created_by`='62',`created`='1 second ago',`modified_by`='0',`modified`='2014-04-25 14:01:18',`deleted_by`='0',`deleted`='0000-00-00 00:00:00',`flag`='0',`published`='1',`publish_up`='2014-04-25 14:01:18',`publish_down`='0000-00-00 00:00:00',`sticked`='0',`sent`='0',`parent_id`='719',`depth`='1',`lft`='12',`rgt`='13',`latitude`='43.654262',`longitude`='-79.38597500000003',`address`='Downtown, Toronto, ON, Canada',`params`='{\"social\":{\"stream\":null}}',`unformattedDate`='2014-04-25 14:01:18',`childs`='0',`componenttitle`='K2',`contenttitle`='SGLT2 Inhibition: Questions and answers for an emerging therapy',`pagelink`='http://HIDDEN.com/nephrology-presentations/item/1342-sglt2-inhibition-questions-and-answers-for-an-emerging-therapy',`permalink`='http://HIDDEN.com/nephrology-presentations/item/1342-sglt2-inhibition-questions-and-answers-for-an-emerging-therapy#kmt-723',`parentlink`='http://HIDDEN.com/nephrology-presentations/item/1342-sglt2-inhibition-questions-and-answers-for-an-emerging-therapy#kmt-719',`shortlink`='http://DOMAIN.com/nephrology-presentations/item/1342-sglt2-inhibition-questions-and-answers-for-an-emerging-therapy#kmt-723',`likes`='0',`liked`='0',`reported`='0',`processed`='1' WHERE `id`='723'


Any suggestions here?

Jordan
I solved it. For anyone facing the same problem, this is how I did it.


  1. First, created a localhost copy of my site.
  2. Emptied the contents of _komento_configs
  3. This solved the issue, indicating this was a Komento setting problem
  4. By trial and error, I was able to determine that the issue was related to Integration > Activities > Jomsocial. These were all set to yes because of my previous Jomsocial installation, which I uninstalled when I migrated to Easysocial! Disabling the Jomsocial activities solved


So for people migrating to to EasySocial and uninstalling Jomsocial be sure to disable your Jomsocial activity settings in Komento!

Jordan
Jordan Weinstein
·
Tuesday, 29 April 2014 01:51
·
0 Likes
·
0 Votes
·
0 Comments
·
On further testing, this seems to happen with replies to a comment rather than posting a new comment.
Jordan Weinstein
·
Friday, 25 April 2014 22:38
·
0 Likes
·
0 Votes
·
0 Comments
·
On even more testing, this happens for com_content and K2 integrations:
Status:

200

Status Text:

OK

Response Text:



		

		

			Error displaying the error page: Unable to load renderer class: Unknown column 'unformattedDate' in 'field list' SQL=UPDATE `HIDDEN_komento_comments` SET `component`='com_content',`cid`='1195',`comment`='We agree ',`name`='HIDDEN',`title`='',`email`='HIDDEN',`url`='',`ip`='199.71.174.200',`created_by`='62',`created`='1 second ago',`modified_by`='0',`modified`='2014-04-25 14:42:12',`deleted_by`='0',`deleted`='0000-00-00 00:00:00',`flag`='0',`published`='1',`publish_up`='2014-04-25 14:42:12',`publish_down`='0000-00-00 00:00:00',`sticked`='0',`sent`='0',`parent_id`='175',`depth`='1',`lft`='6',`rgt`='7',`latitude`='',`longitude`='',`address`='',`params`='{\"social\":{\"stream\":null}}',`unformattedDate`='2014-04-25 14:42:12',`childs`='0',`componenttitle`='Joomla Article',`contenttitle`='CSN Peritoneal Dialysis Guidelines 2011',`pagelink`='http://HIDDEN.com/nephrology-guidelines/peritoneal-dialysis',`permalink`='http://HIDDEN.com/nephrology-guidelines/peritoneal-dialysis#kmt-726',`parentlink`='http://HIDDEN.com/nephrology-guidelines/peritoneal-dialysis#kmt-175',`shortlink`='http://HIDDEN.com/nephrology-guidelines/peritoneal-dialysis#kmt-726',`likes`='0',`liked`='0',`reported`='0',`processed`='1' WHERE `id`='726'
Jordan Weinstein
·
Friday, 25 April 2014 22:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jordan,

Is it possible for you to provide us with the back end and FTP access to your site to check on this issue?
Mark
·
Saturday, 26 April 2014 00:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Info posted here. Thanks Mark.
Jordan Weinstein
·
Saturday, 26 April 2014 02:20
·
0 Likes
·
0 Votes
·
0 Comments
·
I just wanted to add that I tried restructuring the dB in the backend using the tool in Komento config and this did not help.
Jordan Weinstein
·
Saturday, 26 April 2014 19:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jordan,

I am really sorry for the delay of this reply as it is a weekend for us here. I have been trying to reproduce this issue on your site but can't seem to replicate this error. Is this only happening on specific pages? Can you please provide us with the link to the particular page?
Mark
·
Sunday, 27 April 2014 15:50
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

Please login and go to the page added to optional information below.

Add a reply to an existing comment (I guess a nested comment), not a new comment.
Jordan Weinstein
·
Sunday, 27 April 2014 18:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

The site provided above was also upgraded to Joomla 3.3RC. Though the error was happening before. Now after the upgrade, reply to an existing post creates an invalid token error and logs the user out.

The original error I indicated in the beginning of this question can be seen on the attached site, on a Joomla 3.2.3 site.
Jordan Weinstein
·
Sunday, 27 April 2014 19:09
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

Here is a screener of the nested reply (not new comment) error on Joomla 3.2.3 (error but user not logged out):

https://docs.google.com/file/d/0BzH-CvTKb30FRm1peHdiek9wcU0/edit

Here is a screener of the nested reply (not new comment) error on Joomla 3.3RC (error and user logged out):

https://docs.google.com/file/d/0BzH-CvTKb30FMkJ1R19Fd3JWVTA/edit?pli=1
Jordan Weinstein
·
Sunday, 27 April 2014 20:19
·
0 Likes
·
0 Votes
·
0 Comments
·
I hope I haven't stumped the Stackideas team. Because if so, this problem (a bad one) cannot be fixed
Jordan Weinstein
·
Monday, 28 April 2014 22:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jordan Weinstein,

I'm really sorry that delayed of this reply and make you inconvenience in this few day,
Actually we are still investigate on this issues, it seems like only happening in your site.
We will getting back to you as soon as possible.
Arlex Wong
·
Monday, 28 April 2014 23:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks so much.

I tried disabling every module and plugin yet it still happens. I wondered whether it was a combination of komento to settings that's doing it.

Jordan
Jordan Weinstein
·
Tuesday, 29 April 2014 00:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jordan Weinstein,

Thanks for sharing, may i know are you have applied some fixes in this site?
http://j33.xxx.xxx/nephrology-presentations/item/1342-sglt2-inhibition-questions-and-answers-for-an-emerging-therapy
Because when i tried to reply comment, but the issues still persists.

I have applied some fixes the sql issues in your site, but now remaining the "invalid token" issues when comment or reply comment once time, when you comment second time then hitting "Invalid token", that mean after you comment first time then automatically logged out.

Do you have having this issues in your live site? Please advise.
Arlex Wong
·
Tuesday, 29 April 2014 13:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

You were helping on a test site. I fixed the livesite. I also now fixed the test site above so you can verify. It works

J
Jordan Weinstein
·
Tuesday, 29 April 2014 17:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Jordan Weinstein ,

Great Glad to heard your issues resolved.
Arlex Wong
·
Tuesday, 29 April 2014 22:06
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post