Running 1.7.1, default groups plugins. No other plugins should be touching the groups at all.
I can get to the step where you can create a group, but when I click the create button, it gives this error. Weird thing is that the group is created, meaning I can see it "groups I own", but when I click on it, it also throws this error.
The error I am receiving is as follows:
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 = 3889 and ( (1 = 1) and e.enabled='' at line 1
QUERY: SELECT * from grizwald_entities e join grizwald_objects_entity o on e.guid=o.guid where e.type='object' and e.subtype= and e.site_guid = 1 and e.container_guid = 3889 and ( (1 = 1) and e.enabled='yes') order by e.time_created desc limit 0, 1
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Cash@costelloc
Cash - 0 likes
- Cash@costelloc
Cash - 0 likes
- Grizwald@grizwald
Grizwald - 0 likes
- Cash@costelloc
Cash - 0 likes
- Grizwald@grizwald
Grizwald - 0 likes
You must log in to post replies.What plugins do you have turned on other than the ones distributed with Elgg?
The issue is this part of the query: e.subtype=
Has this happened with any other groups?
Looks like a bug that was fixed in Elgg 1.7.2: http://trac.elgg.org/changeset/6708/elgg/branches/1.7/engine/lib/group.php
What version of Elgg are you using?
1.7.1. I tried upgrading today but I've made so many changes to my pages that I couldn't just stick a new version on. Long story short, it broke everything. That's an issue for a different time. Any way I can solve this stupidity without updating?
The change is on the link that I posted. You would just have to edit that one file and make that minor change.
Ah! Thank you. I should have realized it was showing the change not just the affected block of code...Thankies!