sarapepors
دوشنبه 27 خرداد 1392, 11:58 صبح
سلام
وقتی میخوام در phpmyAdmin ایمپورت انجام بدم در سرور خطای 1227 رو دریافت میکنم
CREATE DEFINER = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) `root`@`localhost` PROCEDURE `AddNumberVisit` ( numVisit INT, id INT, tblName VARCHAR( 50 ) ) BEGIN IF (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcontrol-flow-functions.html%23function_if&token=00303f5d3c3d2dda563e4d58e0303cf4) tblName = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) 'tbl_advertisement' THEN UPDATE (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fupdate.html&token=00303f5d3c3d2dda563e4d58e0303cf4) tbl_advertisement SET (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fset.html&token=00303f5d3c3d2dda563e4d58e0303cf4) number_visit = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) numVisit WHERE advertisement_id = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) id;
ELSEIF tblName = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) 'tbl_tourism' THEN UPDATE (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fupdate.html&token=00303f5d3c3d2dda563e4d58e0303cf4) tbl_tourism SET (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fset.html&token=00303f5d3c3d2dda563e4d58e0303cf4) number_visit = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) numVisit WHERE tourism_id = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) id;
END IF (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcontrol-flow-functions.html%23function_if&token=00303f5d3c3d2dda563e4d58e0303cf4) ;
END$$ MySQL said: <img title="Documentation" alt="Documentation" class="yiv1461862518icon yiv1461862518ic_b_help"> (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Ferror-messages-server.html&token=00303f5d3c3d2dda563e4d58e0303cf4)
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
این هم متن خطاست میشه راهنماییم کنید
متشکرم
وقتی میخوام در phpmyAdmin ایمپورت انجام بدم در سرور خطای 1227 رو دریافت میکنم
CREATE DEFINER = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) `root`@`localhost` PROCEDURE `AddNumberVisit` ( numVisit INT, id INT, tblName VARCHAR( 50 ) ) BEGIN IF (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcontrol-flow-functions.html%23function_if&token=00303f5d3c3d2dda563e4d58e0303cf4) tblName = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) 'tbl_advertisement' THEN UPDATE (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fupdate.html&token=00303f5d3c3d2dda563e4d58e0303cf4) tbl_advertisement SET (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fset.html&token=00303f5d3c3d2dda563e4d58e0303cf4) number_visit = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) numVisit WHERE advertisement_id = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) id;
ELSEIF tblName = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) 'tbl_tourism' THEN UPDATE (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fupdate.html&token=00303f5d3c3d2dda563e4d58e0303cf4) tbl_tourism SET (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fset.html&token=00303f5d3c3d2dda563e4d58e0303cf4) number_visit = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) numVisit WHERE tourism_id = (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcomparison-operators.html%23operator_equal&token=00303f5d3c3d2dda563e4d58e0303cf4) id;
END IF (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Fcontrol-flow-functions.html%23function_if&token=00303f5d3c3d2dda563e4d58e0303cf4) ;
END$$ MySQL said: <img title="Documentation" alt="Documentation" class="yiv1461862518icon yiv1461862518ic_b_help"> (http://5.144.130.33:2082/cpsess6650714514/3rdparty/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Fref man%2F5.5%2Fen%2Ferror-messages-server.html&token=00303f5d3c3d2dda563e4d58e0303cf4)
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
این هم متن خطاست میشه راهنماییم کنید
متشکرم