Unknown DB Error when I try to update a user profile in Joomla 2.5.24

[jckinsey]

I was getting this error on a GoDaddy Account, so I moved the site to my hosting servers at GreenGeeks. I am still getting the error, along with a different issue in the backend.
1st issue - I have a username and I tell it to create a Personal Contribution Page.  In order to do so, I have to set up a "donor" profile which means I need to update my user profile in the frontend.  I can fill out the fields (address, phone#, etc.) and when I click Submit, I get the "We are unable to display this information..." "Unknown DB Error".  I turned on Debugging and got these details:

 Sorry but we are not able to provide this at the moment.
DB Error: unknown error
Error Details
Database Error Code: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), 1419
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

Code: [Select]

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
    CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
    [type] => DB_Error
    [user_info] =>
    CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
    CREATE FUNCTION civicrm_strip_non_numeric(input VARCHAR(255) CHARACTER SET utf8)
      RETURNS VARCHAR(255) CHARACTER SET utf8
      DETERMINISTIC
      NO SQL
    BEGIN
      DECLARE output   VARCHAR(255) CHARACTER SET utf8 DEFAULT '';
      DECLARE iterator INT          DEFAULT 1;
      WHILE iterator < (LENGTH(input) + 1) DO
        IF SUBSTRING(input, iterator, 1) IN ('0', '1', '2', '3', '4', '5', '6', '7', '8', '9') THEN
          SET output = CONCAT(output, SUBSTRING(input, iterator, 1));
        END IF;
        SET iterator = iterator + 1;
      END WHILE;
      RETURN output;
    END [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]"]
)


My DB User has full priveliges in the database, so I am not sure what it is asking for.

Issue #2 - I am getting is a blank white screen in the admin panel.  I log in, and go to Extensions>Civicrm and it loads then vanishes with no error messages. 

Any ideas would be greatly appreciated.  I need to launch the site yesterday.

[Hershel]

My DB User has full priveliges in the database, so I am not sure what it is asking for.

Well if this is shared hosting, then that's probably not precisely correct. Did you ask your host about this?

Also, is logging enabled? Can you disable it?

[jckinsey]

I was finally able to upgrade Civicrm to 4.46 and that fixed the fronend issues with updating the user.
However, I still get a blank white screen in the admin backend.  It shows the Dashboard and then goes white.  Any ideas?

[jckinsey]

No idea why, but when the domain transfer fnally took affect, the blank white page finally disappeared.  If it comes back, I will repost, but for now - problem solved.