Issue: DB-Error creating group

Issue Tools
- View Changes

February 23, 2010 5:56 AM

hollosch

Senior Member

DB-Error creating group

Creating an new social group with "wiki group pages allowed" an db-error comes:

Code:

Invalid SQL:

		SELECT groupid
		FROM vb3_socialgroupmember AS sg
		INNER JOIN vb3_vault_group AS vg ON (vg.groupid = sg.groupid)
		WHERE sg.groupid != 32
			AND sg.userid = 2
			AND sg.type = 'member'
		LIMIT 1;

MySQL-Fehler  : Column 'groupid' in field list is ambiguous
Fehler-Nr.    : 1052
Fehler-Zeit   : Tuesday, 23.02.2010 @ 11:53:37
Datum         : Tuesday, 23.02.2010 @ 11:53:37
Skript        : http://www.wollmilchsau.org/forum/group.php?do=docreate
Referrer      : http://www.wollmilchsau.org/forum/group.php?do=create
IP-Adresse    : 78.43.55.112
Benutzername  : hollosch
Klassenname   : vB_Database
MySQL-Version : 5.0.67-1~ui40+2

Issue Details

Issue Number 1166

Issue Type Bug

Project VaultWiki 3.x Series

Category Social Groups

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 3.0.0 Beta 4

Fixed Version 3.0.0 Beta 4

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 23, 2010 1:49 PM

pegasus

VaultWiki Team

Fixed in the current ZIP. In vault/special_plugins_group.php, find:

Code:

		SELECT groupid
		FROM " . TABLE_PREFIX . "socialgroupmember AS sg

Replace with:

Code:

		SELECT sg.groupid
		FROM " . TABLE_PREFIX . "socialgroupmember AS sg

February 23, 2010 5:14 PM

hollosch

Senior Member

Now, after the fix, it's not possible to create group wiki pages....

Reply
February 23, 2010 5:30 PM

pegasus

VaultWiki Team

Make sure that the group still has the option checked. Also, make sure that the forum you want to put the group pages in has group pages enabled (in the Forum Manager). It's also possible that the members of the group were not added to the correct usergroup when the group was created. If this is the case, try toggling the group page option from the Edit group form to rebuild the permissions.

Reply
February 23, 2010 5:45 PM

hollosch

Senior Member

This issue note was made as an issue.

Ok, now it works. thanks

Reply

+ Reply

All times are GMT -4. The time now is 12:25 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: DB-Error creating group

Issue Tools