SecuritySuite - SuiteCRM and CE Teams

I would love to see this working in SuiteCRM Please advice. Problems that I faced is whenever I create a field, Module, Drop-down Value. i am receiving this error of "Failed to Retrieve data"

Its Our Partner who has made the License purchased.

SuiteCRM is version 6.5.16 of SugarCRM CE. It should fully work if you install that version of SecuritySuite.

An error like "Failed to Retrieve data" can mean a few things. Typically it is a file permissions error which means that you need to address that. Also check the browser console for any additional info, the network tab in the browser console, and the sugarcrm.log.

we have given full 777 permission. I was getting this error in sugarcrm log like.

Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table 'suitecrm.securitygroups_default' doesn't exist

But now this dose not seem to come. Is there anything we can get from this

Also i have double checked the versions for both its "Sugar Version 6.5.16 (Build 1082)" AND fort SecuritySuite its 6.5.16_SecuritySuite_Full-Edition

Cool Thanks. If its working fine with Other SuiteCRM then this is something wich I will have to look at my installation. dose the version of PHP matters

Let me Explore more on to this and see if there is any problems. We are developing in multiple instances is that going to matter if we are using the same license id. please suggest

This is the Error that I get When ever I Try to create a field.

Failed to load resource: the server responded with a status of 500 (Internal Server Error) http://sugar.popcornapps.com/suitecrm/index.php?to_pdf=1&sugar_body_only=1

If i Unistall this App and try then it dose not give me any error

Below is the Request Response Headers, But response body is empty

Query String Parametersview sourceview URL encoded to_pdf:1 sugar_body_only:1

Form Data module:ModuleBuilder action:SaveModule package:Pravin original_name:Test duplicate:0 to_pdf:1 name:Test label:Status has_tab:1

Response Headers Cache-Control:no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Connection:close Content-Length:0 Content-Type:text/html; charset=UTF-8 Date:Wed, 19 Mar 2014 17:44:05 GMT Expires:Thu, 19 Nov 1981 08:52:00 GMT Pragma:no-cache Server:Apache/2.2.3 (CentOS) Set-Cookie:ck_login_id_20=1; expires=Tue, 17-Jun-2014 17:44:05 GMT; path=/; domain=sugar.popcornapps.com Set-Cookie:ck_login_language_20=en_us; expires=Tue, 17-Jun-2014 17:44:05 GMT; path=/; domain=sugar.popcornapps.com Set-Cookie:sugar_user_theme=Suite7; expires=Thu, 19-Mar-2015 17:44:05 GMT X-Powered-By:PHP/5.4.25

also found this in sugar log. checked with SuiteCRM but they specific about their Security Suite Implementation. Thanks.

Tue Mar 11 09:46:21 2014 [5115][-none-][FATAL] Query Failed: (SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role FROM acl_actions INNER JOIN acl_roles_users ON acl_roles_users.user_id = '' AND acl_roles_users.deleted = 0 LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0 WHERE acl_actions.deleted=0 )

            UNION

            (SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
            FROM acl_actions 
            INNER JOIN securitygroups_users ON securitygroups_users.user_id = '' AND  securitygroups_users.deleted = 0
            INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
            LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
            WHERE acl_actions.deleted=0  )

            UNION 

            (SELECT acl_actions.*, 0 as access_override, -1 as user_role
            FROM acl_actions
            WHERE acl_actions.deleted = 0 )

Did you ever resolve the missing securitygroups_default table from one of the first replies to this case? There are probably just tables missing. Run through what I recommended so that those tables get added.

I Tried to replicate this.This error came when we installed the Extension, installation did not create a table in Mysql. but when i did the same with sugarcrm it worked by default. i may be missing some where on permissions. so what i did was is 1. Installed SuiteCRM Fresh Install 2. gave 777 permision to the root folder 3. Uploaded the package and installed it.

But still no luck. then decided to explore it with sugarcrm itself. suitecrm seems to be buggy for extensions

It looks like you were able to get everything installed and working. If not and you need more assistance feel free to reply here.

-Jason

Continuing with sugarcrm. it dose support suitecrm but we have given up. Thanks for the follow up.