[AScherff]

Hi,

i have these database error when a user try to upload a new version of the download:

Datenbankfehler in vBulletin 3.6.7:

Invalid SQL:
SELECT title, usergroup.usergroupid, username, userid
			   FROM knxusergroup, knxuser
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid;

MySQL-Fehler : Unknown table 'usergroup' in field list

The error comes because the Table-Prefix is not all set

The right SQL Statement must be:

SELECT title, knxusergroup.usergroupid, username, userid
			   FROM knxusergroup, knxuser
                           WHERE ecdownloadpermissions & 1024 AND  knxusergroup.usergroupid = knxuser.usergroupid;

so how can i fix that?

Thanks

Alfred