Export SQL error

Resolved wireinet
(@wireinet)

2 years, 8 months ago

HellO! This very usefull plugin gets me error where i try export database to dump. See the screenshot:
https://disk.yandex.ru/i/qwT8hgyg4hdhdw
also, I put this as text:

CREATE DEFINER=CURRENT_USER FUNCTION wp_fn_realmedialibrary_childs (rootId INT, _useTempChildTableForCheck BOOLEAN) RETURNS VARCHAR(1000) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci READS SQL DATA SQL SECURITY INVOKER BEGIN
DECLARE sTemp VARCHAR(1000);
DECLARE sTempChd VARCHAR(1000);
SET sTemp = ‘$’;
SET sTempChd = CAST(rootId AS CHAR);
SET SESSION group_concat_max_len = 100000;
WHILE sTempChd IS NOT NULL DO
SET sTemp = CONCAT(sTemp,’,’,sTempChd);
IF _useTempChildTableForCheck IS NULL OR _useTempChildTableForCheck = false THEN
SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0;
ELSE
SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary_tmp WHERE FIND_IN_SET(parent,sTempChd) > 0;
END IF;
END WHILE;
RETURN sTemp;
END

The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

Thread Starter

(@wireinet)

HellO! This very usefull plugin gets me error where i try export database to dump. See the screenshot:
https://disk.yandex.ru/i/qwT8hgyg4hdhdw
also, I put this as text:

--
-- Функции
--
CREATE DEFINER=root@% FUNCTION wp_fn_realmedialibrary_childs (rootId INT, _useTempChildTableForCheck BOOLEAN) RETURNS VARCHAR(1000) CHARSET utf8mb4 COLLATE utf8mb4_unicode_ci READS SQL DATA SQL SECURITY INVOKER BEGIN
        	DECLARE sTemp VARCHAR(1000);
        	DECLARE sTempChd VARCHAR(1000);
        	SET sTemp = '$';
        	SET sTempChd = CAST(rootId AS CHAR);
		    SET SESSION group_concat_max_len = 100000;
        	WHILE sTempChd IS NOT NULL DO
        		SET sTemp = CONCAT(sTemp,',',sTempChd);
        		IF _useTempChildTableForCheck IS NULL OR _useTempChildTableForCheck = false THEN
        		    SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0;
        		ELSE
        		    SELECT GROUP_CONCAT(id) INTO sTempChd FROM wp_realmedialibrary_tmp WHERE FIND_IN_SET(parent,sTempChd) > 0;
        		END IF;
        	END WHILE;
        	RETURN sTemp;
        END

Plugin Contributor

Matthias Günter

(@mguenter)

2 years, 8 months ago

Hey @wireinet !

Thanks for your message. Please check out this help article about the Real Media Library database dump: https://devowl.io/knowledge-base/real-media-library-sql-dump-import-failed-due-to-function-procedure/

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Export SQL error’ is closed to new replies.