Bug: Can't lock a poll
By arrowthemes on Friday, 27 January 2017
Posted in Technical Issues
Replies 5
Likes 0
Views 557
Votes 0
Whenever I try to lock a poll, I get an error in the browser console.

General error info: Failed to load resource: the server responded with a status of 500 ()

Browser console


500 (Unknown column 'locked' in 'field list' SQL=UPDATE `#__discuss_polls_question` SET `locked`='1' WHERE `post_id`='21764')


I just checked that table and there's no 'locked' column. I'm using the latest version.
Hello Joel,

I am really sorry for the delay of this reply as it is a weekend for us here. I can't seem to reproduce this errors on my local instance. Upon clicking on the Lock button for the polls, this is what I am seeing, http://take.ms/QF0F0

This is the table definition for #__discuss_polls_question, http://take.ms/noMqg

How did you upgrade EasyDiscuss on the site?
Mark
·
Saturday, 28 January 2017 00:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Mark,

I'm installing on a clean Joomla installation using the 'com_easydiscuss_full_pro_4.0.12_joomla.zip'
Once installed, I checked the #__discuss_polls_question table and there's no locked column.
arrowthemes
·
Saturday, 28 January 2017 02:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hm, looks like you are right! There's a bug with the query. Can you try running this and see if it works for you?

[gist]
ALTER TABLE `#__discuss_polls_questions` ADD COLUMN `locked` tinyint(1) UNSIGNED DEFAULT 0;
[/gist]
Mark
·
Saturday, 28 January 2017 15:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Yeah it works once I change the table to #__discuss_polls_question.
Thanks.
arrowthemes
·
Monday, 30 January 2017 02:31
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating us on this Joel, will get this fixed internally as well.
Mark
·
Monday, 30 January 2017 14:45
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post