Polls - Accessing Polls from the menubar I get a 1054 error message
By Randall McCallum on Friday, 11 November 2016
Posted in Technical Issues
Replies 3
Likes 0
Views 174
Votes 0
When I try to access Polls from the menubar, I get this error message:

1054
UNKNOWN COLUMN 'STATE' IN 'WHERE CLAUSE' SQL=SELECT COUNT(1) FROM `#__SOCIAL_POLLS_USERS` WHERE `POLL_ID`='1' AND `STATE`='1'

An error has occurred while processing your request.

You may not be able to visit this page because of:

an out-of-date bookmark/favourite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page

Not sure why this is coming up now.

Randall
Hey there,

It seems like missing `state` columns from this table `#__SOCIAL_POLLS_USERS` then causing this issue.

We already help you added back this columns from your database, you should able to access now.

But I realised one of the polls created from RC version right? It seems like this old data is not able to access now, can I have the permission to delete your existing polls data?
Arlex Wong
·
Friday, 11 November 2016 18:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Go ahead Arlex,

And thank you so much for fixing this issue.

Randall
Randall McCallum
·
Saturday, 12 November 2016 05:07
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome, I already help you deleted those polls item from database, can you give it a check again?
Arlex Wong
·
Saturday, 12 November 2016 14:43
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post