Database Trigger error message
The problem is that the database user doesn't have some higher level privileges required for CiviCRM. Ask your ISP support or database administrator to run the following commands for you as the root MySQL user:

-- Assuming a database called "civicrm" and a user called "civicrm_user" 
-- and a MySQL version of 5.1.6+

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, 
    CREATE TEMPORARY TABLES, 
    LOCK TABLES, TRIGGER, CREATE ROUTINE, ALTER ROUTINE ON civicrm.* 
    TO 'civicrm_user'@'localhost' IDENTIFIED BY 'realpasswordhere';

For more details see:
http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+MySQL+Permission+Requirements