Recent Changes - Search:



edit SideBar

V2 /


1.1 : Error during Initialization

The following text appears when setting up the database for the first time:

 Caused By: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its
 declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Answer: MySQL? 5.1 changed a requirement for stored procedures. The quick solution is to change the global setting:

 set GLOBAL log_bin_trust_function_creators=1

1.2 : Cannot log in after initialization

Various MySQL? installations use different hash formats for the login passwords. Make sure the admin password in 'reg_master' is set to the proper password() format

1.3 : A PropertyDAO? error happens after initial install

Part of the installation process is setting up the default properties for an event. There is a known bug that occasionally one property isn't set up right on the very first startup. The error message is:


The way to fix this is to log into the MySQL? database instance for this event and change one column value:

 update config_properties set prop_scope='Global' where prop_name='Administrator' ;
Edit - History - Print - Recent Changes - Search
Page last modified on February 20, 2011, at 01:28 PM