Installation details:

mojoPortal Version 2.3.5.4 MSSQL

Microsoft Windows NT 6.1.7601 Service Pack 1

ASP.NET v2.0.50727 in 'Partial Trust'

Time zone: W. Europe Daylight Time

I all,

I've created a trigger on mp_Users table that insert a record in another table named myTable when a new user is inserted in mp_Users table.
The trigger works, but after inserting a new user (from admin panel in my website), the Member List is completely corrupted (duplicated users, admin user deleted...)

I create the same trigger in the last mojoportal version on my local pc, but the problem still there.

The trigger script is:
CREATE TRIGGER [dbo].[myTrigger] ON [dbo].[mp_Users]
FOR INSERT
AS
DECLARE @myID INT
DECLARE @myName NVARCHAR(50)
DECLARE @myMail NVARCHAR(50)
SELECT @myID =(SELECT UserID FROM INSERTED)
SELECT @myName =(SELECT Name FROM INSERTED)
SELECT @myMail =(SELECT Email FROM INSERTED)
INSERT INTO myTable (UserID, UserName, UserMail) VALUES (@myID, @myName, @myMail)

Please help.

Solved!
Changed from "FOR INSERT" to "AFTER INSERT" and put inside "BEGIN...END" the trigger actions.

This is the new trigger script:

ALTER TRIGGER [dbo].myTrigger ON [dbo].mp_Users

AFTER INSERT
AS
BEGIN
  DECLARE @myID INT
  DECLARE @myName NVARCHAR(50)
  DECLARE @myMail NVARCHAR(50)
  SELECT @myID =(SELECT UserID FROM INSERTED)
  SELECT @myName =(SELECT Name FROM INSERTED)
  SELECT @myMail =(SELECT Email FROM INSERTED)
  INSERT INTO [dbo].myTable (UserID, UserName, UserMail) VALUES (@myID, @myName, @myMail)
END