Hi Kevin, just uploaded and enabled on my site running elgg1.7 and got the following when trying to use a poll from a group (seems to work ok everywhere else).

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and e.site_guid = 1 and e.container_guid = 433 and ( (1 = 1) and e.enabled='y' at line 1

QUERY: SELECT * from elggentities e join elggobjects_entity o on e.guid=o.guid where e.type='object' and e.subtype= and e.site_guid = 1 and e.container_guid = 433 and ( (1 = 1) and e.enabled='yes') order by e.time_created desc limit 0, 50

Hi Bob - is this when creating the poll or trying to view it?

Oh, and is this under Elgg 1.7.1 or the original Elgg 1.7? There were several core bugs fixed in 1.7.1.

I can't reproduce this under Elgg 1.7.1. I can create group polls and vote in them with no issues. Perhaps you have a problem with another plugin?

hi Kevin, I'm running the original 1.7, but i'll try turning some stuff off and report back ; )

Hi Kevin, I looked at all my plugins and thought that an upgrade to elgg 1.7.1 would be the simplest first step. So I’ve upgraded, and everything seems to be running OK now!

Nice job, you are a goliath amongst giants! ; )

Hi Bob,

Glad to hear that your problem seems to be resolved. There are still a few issues - eg. the poll user icon is too large and there are division-by-zero errors in the error log, so I'll be putting out another release in a couple of days.

Hi Kevin, I'll look forward to the up-dates. All the best ;-)

Hi Kevin,

You might like to know that Polls is incompatible with Flexgroupprofile under 1.7.1 - hangs when selecting group names. the problem goes away when flexgroupprofile is disabled.

Newbrie

Hi Kevin,

It appears that I get the same error Haplessbob, but using Elgg 1.7.1 on LAMP, Any clues on what I can do to fix this?

Newbrie

DatabaseException

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and e.site_guid = 1 and e.container_guid = 25 and ( (1 = 1) and e.enabled='ye' at line 1
QUERY: SELECT * from elggentities e join elggobjects_entity o on e.guid=o.guid where e.type='object' and e.subtype= and e.site_guid = 1 and e.container_guid = 25 and ( (1 = 1) and e.enabled='yes') order by e.time_created desc limit 0, 50
 

Newbrie - what does "hangs when selecting group names" mean? What do you do to cause the database error? In both cases I need more details to look at those things.

I get a similar DB error when clicking on Group Polls after installing.

RPGRealms - what version of Elgg are you running?

1.7.1

BRB I'll check any group related mods and see if that might be the problem.

Only group related plugin I was using other than groups itself was group river. Turned it off, still have the problem.

The problem is cropping up on line 31 of index.php

$polls = $page_owner->getObjects('poll',50,0);

Comment that out and it runs. Of course no polls are listed

What URL do you see this error at? I don't need your domain name, just the location within Elgg.

Ah, does this problem occur when you are not logged in?

In a public group, url is:

pg/polls/list/group:210

Haven't tried it while not logged in. Logged in as an administrator and getting the error.

OK, now I see the problem.

I think that should be:

$polls = $page_owner->getObjects('polls',50,0);

Not:

$polls = $page_owner->getObjects('poll',50,0);

oh wait.

Not true.

The plugin has been renamed to polls, but not the object. Still investigating.

Nope.

And are you sure it should be "polls", you have the subtype set as "poll" in start.

Lol you posted just before I did. Agreed :)