Fatal error on installation

[smintiens]

Im getting the following error when running the install.php file. I've gotten this error using a sql user with grant all as well as root.

Creating core tables... OK — coaches OK — teams OK — players OK — memberships OK — players_skills OK — races OK — leagues OK — divisions OK — tours OK — matches OK — match_data OK — texts OK — game_data_players OK — game_data_stars OK — game_data_skills OK — mv_players OK — mv_teams OK — mv_coaches OK — mv_races OK — mv_es_players OK — mv_es_teams OK — mv_es_coaches OK — mv_es_races OK — match_data_es Creating module tables... OK — wanted OK — hof OK — prizes OK — log OK — conferences OK — conference_teams OK — league_prefs OK — cemetery OK — famousteams Other tasks... OK — Synchronize game data with database OK — applied table indexes

FATAL ERROR: One or more OBBLM MySQL functions/procedures could not be created. This error is most likely due to your database user NOT having the "CREATE ROUTINE" privilege. Some web hosts are willing to help you work around this problem by running this install/upgrade script for you. If not, you will have to find another web host allowing "CREATE ROUTINE".

MySQL error (errno 1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT game_data_players.ma, game_data_players.s' at line 45

The function/procedure SQL code that failed was: CREATE PROCEDURE getPlayerDProps( IN pid MEDIUMINT SIGNED, OUT inj_ma TINYINT UNSIGNED, OUT inj_av TINYINT UNSIGNED, OUT inj_ag TINYINT UNSIGNED, OUT inj_st TINYINT UNSIGNED, OUT inj_ni TINYINT UNSIGNED, OUT ma TINYINT UNSIGNED, OUT av TINYINT UNSIGNED, OUT ag TINYINT UNSIGNED, OUT st TINYINT UNSIGNED, OUT ma_ua TINYINT SIGNED, OUT av_ua TINYINT SIGNED, OUT ag_ua TINYINT SIGNED, OUT st_ua TINYINT SIGNED, OUT value MEDIUMINT SIGNED, OUT status TINYINT UNSIGNED, OUT date_died DATETIME ) NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE ach_ma,ach_st,ach_ag,ach_av, def_ma,def_st,def_ag,def_av TINYINT UNSIGNED DEFAULT 0; DECLARE cnt_skills_norm, cnt_skills_doub TINYINT UNSIGNED; DECLARE extra_val MEDIUMINT SIGNED; DECLARE f_pos_id SMALLINT UNSIGNED; SELECT players.f_pos_id, players.extra_val, players.ach_ma, players.ach_st, players.ach_ag, players.ach_av INTO f_pos_id, extra_val, ach_ma, ach_st, ach_ag, ach_av FROM players WHERE player_id = pid; SET cnt_skills_norm = (SELECT COUNT() FROM players_skills WHERE f_pid = pid AND type = "N"); SET cnt_skills_doub = (SELECT COUNT() FROM players_skills WHERE f_pid = pid AND type = "D"); SELECT IFNULL(SUM(IF(inj = 3, 1, 0) + IF(agn1 = 3, 1, 0) + IF(agn2 = 3, 1, 0)), 0), IFNULL(SUM(IF(inj = 4, 1, 0) + IF(agn1 = 4, 1, 0) + IF(agn2 = 4, 1, 0)), 0), IFNULL(SUM(IF(inj = 5, 1, 0) + IF(agn1 = 5, 1, 0) + IF(agn2 = 5, 1, 0)), 0), IFNULL(SUM(IF(inj = 6, 1, 0) + IF(agn1 = 6, 1, 0) + IF(agn2 = 6, 1, 0)), 0), IFNULL(SUM(IF(inj = 7, 1, 0) + IF(agn1 = 7, 1, 0) + IF(agn2 = 7, 1, 0)), 0) INTO inj_ni,inj_ma,inj_av,inj_ag,inj_st FROM match_data WHERE f_player_id = pid; SET value = (SELECT cost FROM game_data_players WHERE game_data_players.pos_id = f_pos_id) + (ach_ma + ach_av) 30000 + ach_ag 40000 + ach_st 50000 + cnt_skills_norm 20000 + cnt_skills_doub 30000 + extra_val - inj_ma - inj_av - inj_ag - inj_st * ; SELECT game_data_players.ma, game_data_players.st, game_data_players.ag, game_data_players.av INTO def_ma,def_st,def_ag,def_av FROM game_data_players WHERE game_data_players.pos_id = f_pos_id; SET ma_ua = CONVERT(ach_ma + def_ma,SIGNED) - CONVERT(inj_ma,SIGNED); SET st_ua = CONVERT(ach_st + def_st,SIGNED) - CONVERT(inj_st,SIGNED); SET ag_ua = CONVERT(ach_ag + def_ag,SIGNED) - CONVERT(inj_ag,SIGNED); SET av_ua = CONVERT(ach_av + def_av,SIGNED) - CONVERT(inj_av,SIGNED); SET ma = calcEffectiveChr(def_ma, ma_ua); SET st = calcEffectiveChr(def_st, st_ua); SET ag = calcEffectiveChr(def_ag, ag_ua); SET av = calcEffectiveChr(def_av, av_ua); SET status = getPlayerStatus(pid, -1); IF status = 8 THEN SET date_died = (SELECT date_played FROM matches, match_data WHERE f_match_id = match_id AND f_player_id = pid AND inj = 8); ELSE SET date_died = NULL; END IF; END

[smintiens]

I got this error when trying to install after git cloning the working repo. When I installed from the 1.0 release, it installed without problems. Potential SQL error in the current working version though.

[kirreen]

I get the same error, and using 1.0 fixed it.

[Halfnir]

Got the same error when installing current branch on XAMPP with default PHP Verion (5.6.28)

found the following in the documentation: https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html After adding the following line found in above documentation to the "my.ini" file, installation worked fine. log-bin-trust-function-creators=1 But i think it would be better to rewise above mentioned SQL procedure.

Before that I also got a fatal error due to a PHP execution timeout, had to change the following value in php.ini from 30 to higher value (e.g. 120).

; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time=120

I think install.php should use the http://php.net/manual/de/function.set-time-limit.php command to extend the timelimit. Same for the upgrade procedure after the first login the root user.

[mfranchetti]

Possible bug in current development code - needs to be checked.

[Indigogyre]

Hello,

PHP version 5.3 mySql version 5.6 Unix hosting platform.

I checked with my hosting company and they verified that I should have the proper access required to run this. I've installed an older version in the past and that is up and running. This was to be a completely new install.

I downloaded the naflm 1.0 install and the following error was generated.

FATAL ERROR: One or more OBBLM MySQL functions/procedures could not be created. This error is most likely due to your database user NOT having the "CREATE ROUTINE" privilege. Some web hosts are willing to help you work around this problem by running this install/upgrade script for you. If not, you will have to find another web host allowing "CREATE ROUTINE".

MySQL error (errno 1419): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

The function/procedure SQL code that failed was: CREATE FUNCTION getPlayerStatus(pid MEDIUMINT SIGNED, mid MEDIUMINT SIGNED) RETURNS TINYINT UNSIGNED NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE status TINYINT UNSIGNED DEFAULT NULL; IF !EXISTS(SELECT f_match_id FROM match_data WHERE f_player_id = pid LIMIT 1) THEN RETURN 1; END IF; IF mid = -1 OR EXISTS(SELECT match_id FROM matches WHERE match_id = mid AND date_played IS NULL) THEN SELECT inj INTO status FROM match_data, matches WHERE f_player_id = pid AND match_id = f_match_id AND date_played IS NOT NULL ORDER BY date_played DESC LIMIT 1; ELSE SELECT inj INTO status FROM match_data, matches WHERE match_data.f_player_id = pid AND matches.match_id = match_data.f_match_id AND matches.date_played IS NOT NULL AND matches.date_played < (SELECT date_played FROM matches WHERE matches.match_id = mid) ORDER BY date_played DESC LIMIT 1; END IF; RETURN IF(status IS NULL, 1, status); END

Can anyone help?

[thefloppy1]

Did you give the database user the create permissions? Or all the permissions as that is easier.

Cheers

On Sun., 18 Nov. 2018, 3:42 pm Indigogyre <notifications@github.com wrote:

Hello,

PHP version 5.3 mySql version 5.6 Unix hosting platform.

I checked with my hosting company and they verified that I should have the proper access required to run this. I've installed an older version in the past and that is up and running. This was to be a completely new install.

I downloaded the naflm 1.0 install and the following error was generated.

FATAL ERROR: One or more OBBLM MySQL functions/procedures could not be created. This error is most likely due to your database user NOT having the "CREATE ROUTINE" privilege. Some web hosts are willing to help you work around this problem by running this install/upgrade script for you. If not, you will have to find another web host allowing "CREATE ROUTINE".

MySQL error (errno 1419): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

The function/procedure SQL code that failed was: CREATE FUNCTION getPlayerStatus(pid MEDIUMINT SIGNED, mid MEDIUMINT SIGNED) RETURNS TINYINT UNSIGNED NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE status TINYINT UNSIGNED DEFAULT NULL; IF !EXISTS(SELECT f_match_id FROM match_data WHERE f_player_id = pid LIMIT 1) THEN RETURN 1; END IF; IF mid = -1 OR EXISTS(SELECT match_id FROM matches WHERE match_id = mid AND date_played IS NULL) THEN SELECT inj INTO status FROM match_data, matches WHERE f_player_id = pid AND match_id = f_match_id AND date_played IS NOT NULL ORDER BY date_played DESC LIMIT 1; ELSE SELECT inj INTO status FROM match_data, matches WHERE match_data.f_player_id = pid AND matches.match_id = match_data.f_match_id AND matches.date_played IS NOT NULL AND matches.date_played < (SELECT date_played FROM matches WHERE matches.match_id = mid) ORDER BY date_played DESC LIMIT 1; END IF; RETURN IF(status IS NULL, 1, status); END

Can anyone help?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/TheNAF/naflm/issues/184#issuecomment-439667341, or mute the thread https://github.com/notifications/unsubscribe-auth/APXWhnqkTIKm5OCDsQQpgD0lKcYDHGazks5uwOUqgaJpZM4LISj0 .

[Indigogyre]

My account has the following permissions which are enough to create everything to my knowledge.

"GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON Database.* TO 'User'@'%' WITH GRANT OPTION"

Thanks.