Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: FILE:
mysql/procedures.sql

ERROR:
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 'DELETE FROM  yafnet.yaf_User WHERE UserID = i_UserID;
   END IF;
   END' at line 54

STATEMENT:
DROP PROCEDURE IF EXISTS yafnet.yaf_user_delete;
CREATE PROCEDURE yafnet.yaf_user_delete(i_UserID INT)
BEGIN
DECLARE ici_GuestUserID INT;
DECLARE ici_UserName VARCHAR(100);
DECLARE ici_GuestCount INT;

SELECT `Name` INTO ici_UserName FROM yafnet.yaf_User WHERE UserID=i_UserID;

SELECT
a.UserID INTO ici_GuestUserID
FROM
yafnet.yaf_User a
inner join yafnet.yaf_UserGroup b on b.UserID = a.UserID
inner join yafnet.yaf_Group c on b.GroupID = c.GroupID
WHERE
(c.Flags & 2)<>0 GROUP BY a.UserID LIMIT 1;

SELECT
COUNT(1) INTO  ici_GuestCount
FROM
yafnet.yaf_UserGroup a
join yafnet.yaf_Group b on b.GroupID=a.GroupID
WHERE
(b.Flags & 2)<>0;

   IF NOT (ici_GuestUserID=i_UserID AND ici_GuestCount=1) THEN


   UPDATE yafnet.yaf_Message SET UserName=ici_UserName,UserID=ici_GuestUserID WHERE UserID=i_UserID;
   UPDATE yafnet.yaf_Topic SET UserName=ici_UserName,UserID=ici_GuestUserID WHERE UserID=i_UserID;
   UPDATE yafnet.yaf_Topic SET LastUserName=ici_UserName,LastUserID=ici_GuestUserID WHERE LastUserID=i_UserID;
   UPDATE yafnet.yaf_Forum SET LastUserName=ici_UserName,LastUserID=ici_GuestUserID WHERE LastUserID=i_UserID;

   DELETE FROM yafnet.yaf_Active WHERE UserID=i_UserID;
   DELETE FROM yafnet.yaf_EventLog WHERE UserID=i_UserID ;
   DELETE FROM yafnet.yaf_UserPMessage WHERE UserID=i_UserID;

   IF NOT EXISTS(SELECT 1 FROM yafnet.yaf_PMessage WHERE FromUserID=i_UserID) THEN
   DELETE FROM yafnet.yaf_PMessage
   WHERE FromUserID=i_UserID;
   END IF;
   /*set messages as from guest so the User can be deleted*/
   UPDATE yafnet.yaf_PMessage
   SET FromUserID = ici_GuestUserID WHERE FromUserID = i_UserID;
   DELETE FROM yafnet.yaf_CheckEmail WHERE UserID = i_UserID;
   DELETE FROM yafnet.yaf_WatchTopic WHERE UserID = i_UserID;
   DELETE FROM yafnet.yaf_WatchForum WHERE UserID = i_UserID;
   DELETE FROM yafnet.yaf_UserGroup WHERE UserID = i_UserID;
   /*ABOT CHANGED
   Delete UserForums entries Too*/
   DELETE FROM  yafnet.yaf_UserForum WHERE UserID = i_UserID;
   DELETE FROM yafnet.yaf_IgnoredUser WHERE UserID = i_UserID OR IgnoredUserID = i_UserID
   /*END ABOT CHANGED 09.04.2004*/
   DELETE FROM  yafnet.yaf_User WHERE UserID = i_UserID;
   END IF;
   END;

Source Error:

Line 4757:                            {
Line 4758:                                trans.Rollback();
Line 4759:                                throw new Exception(String.Format("FILE:\n{0}\n\nERROR:\n{2}\n\nSTATEMENT:\n{1}", scriptFile, sql, x.Message));
Line 4760:                            }
Line 4761:                        }


Source File: D:\Users\Jacques\Documents\Downloaded .Net Code\YAF\yafdotnet\trunk\yafsrc\YAF.Classes\YAF.Classes.Data\DB.cs    Line: 4759

Stack Trace:

[Exception: FILE:
mysql/procedures.sql