Re: [Semediawiki-user] HaloACL: bad sql

[John M. <jmc...@hy...>]

Thomas,
I am still having problems after changing all the FROM & WHERE clauses to
reference the correct 'user' table name. Needed to do so several places in 2
files (StorageSQL & AjaxConnector).

When I try to 'save' the first user group I am creating, Firebug shows a POST
response which says "Please save groupsettings first." When I then save
groupsettings, there appears to be no problem (and special:HaloACL reports that
the groupsettings have been saved). But then when I save the group itself, I
STILL receive "Please save groupsettings first."

fwiw, I do NOT see these error messages displayed by special:HaloACL... I can
only see them under firebug... which will surely be unsatisfying to my users.

Please advise, and thanks.


>-----Original Message-----
>From: John McClure [mailto:jmc...@hy...]
>Sent: Wednesday, March 03, 2010 12:40 PM
>To: sem...@li...
>Subject: HaloACL: bad sql
>
>
>Trying to add my first user group, I've encountered the SQL error
>below. It appears that the FROM clause is not prepending the wiki's
>tables' prefix (which is _V1_)
>
>Internal Error
>A database error has occurred
>Query: SELECT DISTINCT user_id, group_id, group_name<br />
>	FROM user<br />
>	LEFT JOIN  `_V1_halo_acl_group_members` ON
>`_V1_halo_acl_group_members`.child_id = user.user_id
>	LEFT JOIN `_V1_halo_acl_groups` ON
>`_V1_halo_acl_groups`.group_id = `_V1_halo_acl_group_members`.parent_group_id
>	WHERE user.user_id = 5
>Error: 1146 Table 'hoyt_wiki.user' doesn't exist (localhost)