Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql file run in phpmyadmin run time error #15

Open
khetesh opened this issue Jul 13, 2016 · 0 comments
Open

sql file run in phpmyadmin run time error #15

khetesh opened this issue Jul 13, 2016 · 0 comments

Comments

@khetesh
Copy link

khetesh commented Jul 13, 2016

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant