1146 - Table 'zonezex_ruko487.app_users_alerts' doesn't exist
Posted: 24 Jun 2018, 13:08
Hello Rukovoditel,
After upgrading from version 2.01 to version 2.2.1 I get an error message: 1146 - Table 'zonezex_ruko487.app_users_alerts' doesn't exist upon login.
Full message:
Database Error: 1146 - Table 'zonezex_ruko487.app_users_alerts' doesn't exist
Query: select * from app_users_alerts ua where ua.is_active=1 and ((length(ua.users_groups)=0 and length(ua.assigned_to)=0) or (find_in_set(0,ua.users_groups) or find_in_set(20,ua.assigned_to)) ) and ((FROM_UNIXTIME(ua.start_date,'%Y-%m-%d')<=date_format(now(),'%Y-%m-%d') or ua.start_date=0) and (FROM_UNIXTIME(ua.end_date,'%Y-%m-%d')>=date_format(now(),'%Y-%m-%d') or ua.end_date=0)) and (ua.location='dashboard' or ua.location='all') and ua.id not in (select uav.alerts_id from app_users_alerts_viewed uav where uav.users_id='20') order by ua.id desc
Page: /r/index.php?module=dashboard/
Any recommendation to solve this?
Thanks and regards,
Bas
After upgrading from version 2.01 to version 2.2.1 I get an error message: 1146 - Table 'zonezex_ruko487.app_users_alerts' doesn't exist upon login.
Full message:
Database Error: 1146 - Table 'zonezex_ruko487.app_users_alerts' doesn't exist
Query: select * from app_users_alerts ua where ua.is_active=1 and ((length(ua.users_groups)=0 and length(ua.assigned_to)=0) or (find_in_set(0,ua.users_groups) or find_in_set(20,ua.assigned_to)) ) and ((FROM_UNIXTIME(ua.start_date,'%Y-%m-%d')<=date_format(now(),'%Y-%m-%d') or ua.start_date=0) and (FROM_UNIXTIME(ua.end_date,'%Y-%m-%d')>=date_format(now(),'%Y-%m-%d') or ua.end_date=0)) and (ua.location='dashboard' or ua.location='all') and ua.id not in (select uav.alerts_id from app_users_alerts_viewed uav where uav.users_id='20') order by ua.id desc
Page: /r/index.php?module=dashboard/
Any recommendation to solve this?
Thanks and regards,
Bas