Issue after new install

Post Reply
rmcdonald
Investor
Investor
Posts: 417
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud
Contact:

Issue after new install

Post 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
User avatar
support
Site Admin
Posts: 6147
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Issue after new install

Post by support »

Something was not right. The table app_users_login_log is not restored. Try restore database from phpmyadmin now.
rmcdonald
Investor
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

Post 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/
rmcdonald
Investor
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

Post by rmcdonald »

Any thoughts on this one ?
User avatar
support
Site Admin
Posts: 6147
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Issue after new install

Post 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.
rmcdonald
Investor
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

Post by rmcdonald »

Thanks that seems to have worked
Post Reply