sql file run in phpmyadmin run time error
khetesh opened this issue · 0 comments
Error
SQL query:
CREATE FUNCTION lib_mysqludf_sys_info RETURNS string SONAME 'lib_mysqludf_sys.so';
MySQL said: Documentation
#1126 - Can't open shared library 'lib_mysqludf_sys.so' (errno: 126 The specified module could not be found.)
file name lib_mysqludf_sys.sql . how to solution in file .
I am trying to call push .php name by using mysql trigger.This is the code of mysql
CREATE TRIGGER push_Trigger
BEFORE INSERT ON tbl_push_notifications
FOR EACH ROW BEGIN
DECLARE cmd CHAR(255);
DECLARE result int(10);
SET cmd=CONCAT('http://107.180.100.93/api/push.php');
SET result = sys_exec(cmd);
END
i insert new entry time got error -
Error
SQL query:
INSERT INTO tbl_push_notifications
(id
, message_id
, from_user_id
, to_user_id
, message
, is_sent
, created_at
) VALUES
(11, 57, 'iloho_user_87@107.180.100.93/ilohoUser', 'iloho_user_88@107.180.100.93', 'Offline message', 0, '2016-07-03 03:23:04');
MySQL said: Documentation
#1305 - FUNCTION Eric_iloho_db.sys_exec does not exist .
please me
thanks