• Resolved dblinks

    (@dblinks)


    If I remove this “Definer” error during import, will it break the plugin on the new site I’m moving the DB to? Or, is there another workaround. I don’t want to fiddle with the SED on my server for this obstacle. Thanks for a great plugin !!!

    --
    -- Functions
    --
    CREATE DEFINER=wp_kqdlq@% FUNCTION mca_fn_realmedialibrary_childs (rootId INT, _useTempChildTableForCheck BOOLEAN) RETURNS VARCHAR(1000) CHARSET utf8 COLLATE utf8_general_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 mca_realmedialibrary WHERE FIND_IN_SET(parent,sTempChd) > 0;
            		ELSE
            		    SELECT GROUP_CONCAT(id) INTO sTempChd FROM mca_realmedialibrary_tmp WHERE FIND_IN_SET(parent,sTempChd) > 0;
            		END IF;
            	END WHILE;
            	RETURN sTemp;
            END;

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB (mysql) Import Failure’ is closed to new replies.