I'm very newbie to this but I try my best and I don't give up. Spirited told me that I have to put some effort and looking for the answers xD. So I'm trying now for many times Redux source and I get this error when I execute sql file in NavicatMySql. In the video he said that it should be executed without any errors. I tried all his versions of the source and I get the same error in MySql.. SQL] Query Nov_16_Backup start [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!=guildRank LIMIT 1; END' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned) BEGIN DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned) BEGIN SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name; END Finished with error
