Problem with Hours_Diff Field Type [Solved]

[elviseras]

Hi, We have the following error when trying RK to show the calculation of time difference ...

Database Error: 1449 - The user specified as a definer ('root'@'127.0.0.1') does not exist
Query: select rukovoditel_hours_diff(e.field_540,e.field_541,'','','') as field_542 from app_entity_23 e where e.id=8
Page: /index.php?module=items/&action=save&id=8

I have already deleted 'start date' , 'end date' and 'hours difference' fields and I have created them again, but the error persists....

The funny thing is that this problem is only in the production server instance (Migrate from local wamp server). If I try this on the original test server instance there is no problem ... Can it be a permissions problem when migrating to the server in production?

Regards
elviseras

[support]

Looks like something wrong with db.
Open phpMyAdmin and goto Routines where you can find function rukovoditel_hours_diff
Remove it.
Then go to fields configuration and edit field with type Hours Diff. This function will create automatically again and should works ok I think.

[elviseras]

Thanks!! It works