PDA

View Full Version : Table userpromotion does not exist ??


Delilahs
05-19-2011, 06:39 PM
Invalid SQL:

SELECT COUNT(*) AS count, usergroupid
FROM userpromotion
GROUP BY usergroupid;

MySQL Error : Table 'admin_delilahs.userpromotion' doesn't exist
Error Number : 1146

Hi everyone, I get this error when I try to access the usergroup manager via acp.

Can anyone help ?

Thanks in advance :)

kh99
05-19-2011, 07:22 PM
It seems like you're missing the userpromotion table for some reason. You could check that, and if it's missing I suppose you could try recreating it. (The SQL to do it (with a little modification) is in install/mysql_schema.php).