Table 'dotproject.dotp_user_access_log' doesn't exist

[abhishek_datta]

Hi,

After installing dot project 2.1.5, when I am clicking on User Admin, it is showing:
C:\wamp\www\dotproject\classes\query.class.php(628 ): query failed(SELECT user_access_log_id, (unix_timestamp(now()) - unix_timestamp(date_time_in))/3600 as hours, (unix_timestamp(now()) - unix_timestamp(date_time_last_action))/3600 as idle, if (isnull(date_time_out) or date_time_out ='0000-00-00 00:00:00','1','0') as online FROM (`dotp_user_access_log` as ual) WHERE user_id =3 ORDER BY user_access_log_id DESC) - error was: Table 'dotproject.dotp_user_access_log' doesn't exist

ERROR: C:\wamp\www\dotproject\classes\query.class.php(628 ): query failed(SELECT user_access_log_id, (unix_timestamp(now()) - unix_timestamp(date_time_in))/3600 as hours, (unix_timestamp(now()) - unix_timestamp(date_time_last_action))/3600 as idle, if (isnull(date_time_out) or date_time_out ='0000-00-00 00:00:00','1','0') as online FROM (`dotp_user_access_log` as ual) WHERE user_id =3 ORDER BY user_access_log_id DESC) - error was: Table 'dotproject.dotp_user_access_log' doesn't exist
Backtrace:
0 C:\wamp\www\dotproject\classes\query.class.php:628 dprint('C:\\wamp\\www\\dotproject\\classes\\query. class.php',628,0,'query failed(SELECT user_access_log_id, (unix_timestamp(now()) - unix_timestamp(date_time_in))/3600 as hours, (unix_timestamp(now()) - unix_timestamp(date_time_last_action))/3600 as idle, if (isnull(date_time_out) or date_time_out =\'0000-00-00 00:00:00\',\'1\',\'0\') as online FROM (`dotp_user_access_log` as ual) WHERE user_id =3 ORDER BY user_access_log_id DESC) - error was: Table \'dotproject.dotp_user_access_log\' doesn\'t exist')
1 C:\wamp\www\dotproject\classes\query.class.php:650 exec(2)
2 C:\wamp\www\dotproject\modules\admin\vw_usr.php:81 loadList()
3 C:\wamp\www\dotproject\modules\admin\vw_active_usr .php:42 require('C:\\wamp\\www\\dotproject\\modules\\admin \\vw_usr.php')
4 C:\wamp\www\dotproject\style\default\overrides.php :95 require('C:\\wamp\\www\\dotproject\\modules\\admin \\vw_active_usr.php')
5 C:\wamp\www\dotproject\modules\admin\index.php:124 show('

Table 'dotproject.dotp_user_access_log' doesn't exist

Can anybody give the structure of dotp_user_access_log table ?

Thanks
Abhishek Datta

[Karen]

All the table structures / sql used when the system is installed are in the dotproject.sql file in the /db directory - that's probably the easiest way to get the structure.

[abhishek_datta]

Thanks a lot. It helps me solving the issue.:D