Database query on new user data insertion not working

[imedic]

With the help of a friend I manage to upload a querry (that I was intending to post it for others to use) that when a new user ID is created (a new registered user) some data will be inserted in another table that will subscribe that user to a newsletter (php list integrated with vb with another script).
Querry is:

DELIMITER $$
CREATE TRIGGER adaugareAutomata BEFORE INSERT ON `vbuser`
  FOR EACH ROW BEGIN
       INSERT INTO phplist_listuser(userid,listid,entered,modified) VALUES(NEW.userid,1,now(),now());
      INSERT INTO phplist_listuser(userid,listid,entered,modified) VALUES(NEW.userid,2,now(),now());
  END $$
DELIMITER ;

Unfortunately that has crashed registration of new users from forum ( I receive a DB error, not a specific one, just serious database problem).

If someone can contribute it would be appreciated. At least where too look.

In order for this to work you would need phplist installed in same database and a bridge script (unfortunately not available anymore).

[Trevor Hannant]

You should post over at www.vbulletin.org for assistance with custom coding

[imedic]

Found it: instead of:

BEFORE INSERT ON `vbuser`

you need
AFTER INSERT ON `vbuser`

Thank you for advice