Page 1 of 1

Issue after new install

Posted: 19 Feb 2020, 05:24
by rmcdonald
Hi we installed a new instance and then uploaded a database backup and got the following error ?

Database Error: 1146 - Table 'unicloudco_ru886.app_users_login_log' doesn't exist
Query: insert into app_users_login_log (users_id, username, identifier, is_success, date_added) values ('1', 'rmcdonald', '47.72.34.15', '1', '1582075391')
Page: /index.php?module=users/login&action=login

Re: Issue after new install

Posted: 19 Feb 2020, 08:05
by support
Something was not right. The table app_users_login_log is not restored. Try restore database from phpmyadmin now.

Re: Issue after new install

Posted: 20 Feb 2020, 01:27
by rmcdonald
Thanks - I did the restore through PHP myadmin I am now able to login but now getting the following error

Database Error: 1305 - FUNCTION unicloudco_ru886.rukovoditel_days_diff does not exist
Query: select e.* ,rukovoditel_days_diff(e.field_557,1582147574,'1,7','','1') as field_655,rukovoditel_hours_diff(e.field_680,e.field_540,'','','') as field_1325 from app_entity_41 e where e.id>0 and (e.field_463 in (212) ) and e.parent_item_id in (select item_id from (select e.id as item_id , ( (select count(*) from app_entity_41 func100 where func100.id>0 and (func100.field_463 not in (277,232,271,182,212,112,188,297,213,187,216,171,166,169,167,303,302,301,170) ) and func100.parent_item_id=e.id ) ) as field_767 from app_entity_34 e where e.id>0 and e.parent_item_id in (select e.id from app_entity_57 e where e.id>0 and e.parent_item_id in (select e.id from app_entity_39 e where e.id>0 ))) as parent_entity_34 )
Page: /index.php?module=dashboard/

Re: Issue after new install

Posted: 21 Feb 2020, 01:13
by rmcdonald
Any thoughts on this one ?

Re: Issue after new install

Posted: 22 Feb 2020, 07:05
by support
If you did backup from phpmyadmin by default it excluded db function that required for some field types like hours diff, days diff, phone.

So just go to Entity fields and edit field Days Diff, Hours diff etc. and required functions will be created automatically again.

Let me know if it works ok now.

Re: Issue after new install

Posted: 22 Feb 2020, 13:29
by rmcdonald
Thanks that seems to have worked