Field Management SQL Errors

16 years 7 months ago #46012 by sbickhaus
Field Management SQL Errors was created by sbickhaus
When I select Field Manager I'm receiving the following SQL error messages.

What can I do to fix this?

Unknown column 't.useraccessgroupid' in 'where clause' SQL=SELECT COUNT(*) FROM jos_comprofiler_fields AS f, jos_comprofiler_tabs AS t WHERE (f.sys = 0) AND (f.tabid = t.tabid) AND (t.fields = 1) AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)DB function failed with error number 1054
Unknown column 't.useraccessgroupid' in 'where clause' SQL=SELECT f.fieldid, f.title, f.name, f.description, f.type, f.required, f.published, f.profile, f.ordering, f.registration, t.title AS 'tab', t.enabled AS 'tabenabled', t.pluginid AS 'pluginid', p.name AS pluginname, p.published AS pluginpublished FROM jos_comprofiler_fields AS f, jos_comprofiler_tabs AS t LEFT JOIN jos_comprofiler_plugin AS p ON p.id = t.pluginid WHERE (f.sys = 0) AND (f.tabid = t.tabid) AND (t.fields = 1) AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1) ORDER BY t.ordering, f.ordering LIMIT 0, 20

Post edited by: sbickhaus, at: 2007/09/18 01:15

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.270 seconds

Facebook Twitter LinkedIn