DB Error in PHP Migration

Any critical bugs will be fixed within 24-48 hours.
Post Reply
User avatar
elviseras
Sponsor
Sponsor
Posts: 486
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

DB Error in PHP Migration

Post by elviseras »

Dear Sergey,
We have tried to update our RK testing platform (WAMP Server) to a new version with PHP v7 (For new versión 2.7.1 testing before upgrade our production servers), but when we importing BBDD from phpMyAdmin we have the following error:
Error
SQL Query:
--
-- Functions
--
CREATE DEFINER=`root`@`127.0.0.1` FUNCTION `rukovoditel_days_diff` (`start_date` INT, `end_date` INT, `exclude_days` VARCHAR(64), `exclude_last_day` TINYINT(1), `exclude_holidays` TINYINT(1)) RETURNS INT(11) BEGIN
DECLARE days_diff INT;

MySQL says:
#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)


Later, when trying to access the platform, the following error appears on a blank page:
Database Error: 1146 - Table 'rukotest.app_fields' doesn't exist
Query: select * from app_fields where is_heading=1
Page: /rukotest/index.php?module=users/login
Any ideas??

Thanks in advance

User avatar
elviseras
Sponsor
Sponsor
Posts: 486
Joined: 08 Feb 2017, 03:16
Name: Elvix Sampedro
Location: Galicia - Spain
Company Name: novaTEK

Re: DB Error in PHP Migration

Post by elviseras »

Hi, Sergey... can you help me ?

regards

User avatar
support
Site Admin
Posts: 3422
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: DB Error in PHP Migration

Post by support »

Do backup under app and then restore it under app too.
See https://docs.rukovoditel.net/index.php?p=7

Post Reply