Adding items to dropdown--"an error has occurred"

I’m trying to add some items to the account_type_dom dropdown. When I try to save the change I keep getting a cryptic message “An error has occurred” without any indication of what the error is. For example, I add ‘Vendor’ to Item Name and also to Display Label. It shows up nicely in the list of items, but then won’t save.

How can I find out what the error is or what I’m doing wrong?

Thanks.

Hi there,

Have you checked your sugarcrm.log for any errors? What permissions are set on your SuiteCRM instance?

Thanks,

Will.

Nothing seems to be happening in sugarcrm.log since 14:25 this aft, when there are over 100 lines. I’ve gone in and tried to add a dropdown item again just now (17:30 EST) with the same error result but nothing new shows in the log file.

This happens regardless which administrator is logged in and on different boxes. We’ve tried setting all permissions to 777 and experimenting with different owner:group settings. The problem also happens on a different suitecrm installation on the same server (different virtual URL), but there is just makes believe it has saved but doesn’t really.

Here are the last lines in the sugarcrm.log:

Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] ModuleBuilderController:
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][DEBUG] Performing action: action_savedropdown MODULE: ModuleBuilder
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found language file: en_us.lang.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found language file: es_es.lang.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found extended language file: en_us.lang.ext.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found extended language file: es_es.lang.ext.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found custom language file: es_es.lang.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Successful write to: custom/include/language/es_es.lang.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found language file: en_us.lang.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][WARN] Image Поиск.gif not found
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][WARN] Image Поиск.gif not found
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found language file: ru_ru.lang.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][INFO] Found extended language file: en_us.lang.ext.php
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][DEBUG] Hook called: ::server_round_trip
Fri Mar 7 14:25:48 2014 [1743][1f6696cf-5b99-e7fc-5ddd-5318e466179e][DEBUG] Calling MySQLi::disconnect()

Hi there,

After setting permissions, did you perform a Quick Repair & rebuild via Admin -> Repair? Can you edit other drop downs in Studio?

Thanks,

Will.

Just for fun I changed the entire directory to 777. Then did Quick Repair and Rebuild. Then tried to modify the account type dropdown and the industry dropdown. Both still had same result: When I tried to save, got “An error occurred.” The same kind of sugarcrm.log I submitted earlier.

Peculiar: why the “successful write” to the file " custom/include/language/es_es.lang.php"?? Why not to the en_us file? Is this where the problem lies?

Here are the last 16 lines of the sugarcrm.log file:

Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Query Execution Time:0.00022196769714355
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] ModuleBuilderController:
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][DEBUG] Performing action: action_savedropdown MODULE: ModuleBuilder
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found language file:
en_us.lang.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found language file:
es_es.lang.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found extended
language file: en_us.lang.ext.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found extended
language file: es_es.lang.ext.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found custom
language file: es_es.lang.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Successful write to:
custom/include/language/es_es.lang.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found language file:
en_us.lang.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][WARN] Image ???.gif not
found
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][WARN] Image ???.gif not
found
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found language file:
ru_ru.lang.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][INFO] Found extended
language file: en_us.lang.ext.php
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][DEBUG] Hook
called: ::server_round_trip
Mon Mar 10 11:05:25 2014 [20889][348e117c-09ec-764f-1f74-5318e4d650a0][DEBUG] Calling
MySQLi::disconnect()

Will,

We are in the middle of a corporate commitment choice to move to SuiteCRM for hosting. We have a current customer ready to import to our prior choice so we need to resolve these issues quickly to move forward.

We intend to purchase paid support from Sales Agility. Should I be following this forum approach to resolve these remaining issues so we can commit and move forward or do we need to purchase support to just get our trial working?

Thanks!

Hi there,

Studio issues such as layouts not saving are usually due to permissions. Although you may have already set 777 permissions, please try the following:

sudo chown -R www-data:www-data .

sudo chmod -R 755 .

sudo chmod -R 775 cache custom modules themes data upload config_override.php

If you are running CentOS, the owner:group will be apache:apache and other OS/flavours may differ.

Also, what happens when you press Ctrl_Shift+K(Firefox)/Ctrl+Shift+J(Chrome) and then try to save the layout?

Thanks,

Will.

Will wrote: “Also, what happens when you press Ctrl_Shift+K(Firefox)/Ctrl+Shift+J(Chrome) and then try to save the layout?”
Do you mean to the the CTRL_Shift+K after ‘adding’ the new field to the dropdown and then to do ‘save’ at that point?

We’re running a ClearOS on an Amazon EC2 ClearOS AMI. We have installed Atmail, and Atmail changed the apache user to atmail and we’ve got the group set for ‘allusers’.

We tried chmod -R apache:apache and chown -R 755 and then chown -R 775 for the listed directories and file.
Went into suitecrm.cyberacc.net and got this error:
Warning: require_once(cache/dashlets/dashlets.php): failed to open stream: No such file or directory in /var/www/virtual/suitecrm.cyberacc.net/custom/modules/Home/index.php on line 51

Restarted the webserver at clear1 and still got the error message re dashlets.php. (The first time this error has appeared. ??? Checking the path, that dashlet is not there.)

Then changed ownership to ‘atmail:apache’, redid the permissions sets and restarted the web browser. Was able to log in without the ‘dashlet.php’ error but still get the same “An error has occurred” message. ‘tail’ gives the same output again.

Hi there,

Yes, press Ctrl+Shift+K then follow the steps to add the item and see if any errors are logged in the console.

Thanks,

Will.

Lots of errors initially,but they nearly all look like css errors. Nothing new was added to the list during the effort to add the dropdown item to account_type_dom. I’m attaching the results.

I’m still suspicious that the sugarcrm.log shows a successful write to the Spanish language file but not to the English language file.

Thanks.

Hey Will, (and Eric)

Bill Vasu and myself (Brian Porter) connected with Greg yesterday on the phone and he indicated that Matt? Was going to look into the drop down editor issue and should be able to resolve indicating that “studio” was quite robust.

Please keep us updated on progress. New customer is interested in utilizing suitecrm by weekend as am I.

Thanks

I observed here

http://shop.blueonyx.it/news/tag/sugarcrm/

that in SugarCRM release 6.5.16 under Fixed Issues is listed

Attempting to add a dropdown via the Dropdown Editor results in an error.

Perhaps this will assist you in isolating the issue.

Thanks!

Bug report is here

https://web.sugarcrm.com/support/issues/19da5726-8153-3946-0851-51cccac27218

In /var/www/virtual/suitecrm.cyberacc.net/modules/ModuleBuilder/tpls/MBModule/dropdown.tpl

I see at the end

{/literal}

Is this the required fix?

This is not likely the issue, and SuiteCRM 7.0.1/7.0.2 is based on SugarCRM 6.5.16 so will contain that fix, but if that is the issue you are experiencing I Would ensure that display_errors is set to off in the php.ini

The other thing I would try, if you have not done so already to to try disable all other languages other than the one you are using and see if that makes a difference, you can do this in Admin->languages

other than I would be interested to know the detail of you set-up especially which version of PHP you are using?

“disable all other languages other than the one you are using and see if that makes a difference, you can do this in Admin->languages”

That seems to have done it.

Is that a bug? Is there something in the setup instructions about doing this that we missed?

Thanks.