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
Issue after new install
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Issue after new install
Something was not right. The table app_users_login_log is not restored. Try restore database from phpmyadmin now.
-
- Investor
- Posts: 417
- Joined: 19 Dec 2018, 02:33
- Name: Robert McDonald
- Location: Auckland, New Zealand
- Company Name: Unicloud
- Contact:
Re: Issue after new install
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/
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/
-
- Investor
- Posts: 417
- Joined: 19 Dec 2018, 02:33
- Name: Robert McDonald
- Location: Auckland, New Zealand
- Company Name: Unicloud
- Contact:
Re: Issue after new install
Any thoughts on this one ?
- support
- Site Admin
- Posts: 6215
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Issue after new install
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.
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.
-
- Investor
- Posts: 417
- Joined: 19 Dec 2018, 02:33
- Name: Robert McDonald
- Location: Auckland, New Zealand
- Company Name: Unicloud
- Contact:
Re: Issue after new install
Thanks that seems to have worked