5 replies to this topic

[dcs]

Okie Dokie...I finally have my environment modified and my set-up complete. I have been poking around in the application all day and everything was working great. I loaded the "test" data so that I could get a feel for the application with real data. I added a user (so that I could have someone else review) and logged out. Now, when I go to the login screen and enter the credentials I get nothing...Nada. The login button seems to be disabled. How weird is that? I turned on debugging and I am not getting anything returned as an error. Any thoughts? This is the third install...I kind of don't want to have to do it again if we can avoid it. Thanks in advance!

[dcs]

All righty then... I cleared the cache and now I am getting an error:

RedBean_Exception_SQL

SQLSTATE[HY000]: General error: 1418 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)


So, I have log_bin_trust_function_creators turned on...Is there something else I need to do?

Below is the StackTrace:
#0

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/redbean/rb.php(1563): RedBean_Driver_PDO->Execute("# returns null if the permitable is not a group. cre...", array()) #1

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/redbean/rb.php(7810): RedBean_Adapter_DBAdapter->exec("# returns null if the permitable is not a group. cre...", array()) #2

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/redbean/rb.php(7898): {closure}("# returns null if the permitable is not a group. cre...", array()) #3

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/redbean/rb.php(7811): R::secureExec(Closure, null, "# returns null if the permitable is not a group. cre...", array()) #4

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/protected/modules/zurmo/utils/ZurmoDatabaseCompatibilityUtil.php(1537): R::exec("# returns null if the permitable is not a group. cre...") #5

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/protected/modules/zurmo/utils/ZurmoDatabaseCompatibilityUtil.php(1520): ZurmoDatabaseCompatibilityUtil::createStoredFunctionsAndProcedures() #6

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/protected/modules/zurmo/utils/PermissionsCache.php(228): ZurmoDatabaseCompatibilityUtil::callProcedureWithoutOuts("clear_cache_all_actual_permissions()") #7

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/protected/modules/zurmo/utils/ForgetAllCacheUtil.php(38): PermissionsCache::forgetAll() #8

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/protected/modules/zurmo/components/BeginRequestBehavior.php(272): ForgetAllCacheUtil::forgetAllCaches() #9

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/yii/framework/base/CComponent.php(559): BeginRequestBehavior->handleClearCache(CEvent) #10

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/yii/framework/base/CApplication.php(189): CComponent->raiseEvent("onBeginRequest", CEvent) #11

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/yii/framework/base/CApplication.php(161): CApplication->onBeginRequest(CEvent) #12

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/protected/extensions/zurmoinc/framework/components/WebApplication.php(42): CApplication->run() #13

+ /var/www/vhosts/info/directconnectsolutions/purl/CRM/app/index.php(56): WebApplication->run()

[Ivica]

I dont know which values you setup in database, but you need to have following settings in you mysql my.cnf file(or my.ini on Windows):

max_allowed_packet      = 16M
thread_stack            = 512K
optimizer-search-depth = 0
max_sp_recursion_depth = 100
log_bin=0

Last line of code is reason for your error, but for any case you can setup other required values too.

[dcs]

hmmm... I have modified my my.cnf file with the above values and restarted the MySQL service. I am no longer getting any debug errors...but the login is still non-responsive. Everything looks good, the debugger is returning comments and no errors. I enter my "super" username and password and the login button seems not to work, nothing. It just sits there without a response. Any idea on how to debug this issue? Further suggestions?

[Jason]

You should look at the ajax response in the browser. I am sure some error must be occuring since logging in first uses ajax.

[Ivica]

Also you should turn-on debugging, in config/debug.php, and post message back here, so we can help you.