Drop down Lists Not Saving

Hi Everyone

I just uploaded Suite CRm to a new webhost and did a backup of my SQL file then uploaded that and the custom folder.

It all looks and works perfectly except I cannot edit or create drop down lists.

From past posts I checked and I only have one language installed and cannot figure out what else it could be.

Any solutions?

Thanks

Princeps.

I didn’t solve the problem, but have a workaround where you just add them to the en_us.lang.php file (be careful not to add an extra bracket, the entire system will no load)

the filepath is:
htdocs\custom\include\language

Princeps

We are running into the same problem with SuiteCRM 7.10.7 and PHP 7.0. What versions of SuiteCRM and PHP are you using?

Hi

I am using

SuiteCRM Version 7.10.7

PHP Version 7.1.20

Princeps

Problem is worse than I first thought.

Studio is no longer saving any changes I make to the layouts…

Not sure how to accommodate this now…

Princeps

Hi

Going through it (assuming you are having the same problem as I am)

I think we have a permissions issue and we need to change them from 777 using the following.

sudo chmod -R 755 .

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

Unfortunately it comes up as missing operand for me, I am using bash and don’t know the correct programming language.

It might work for you though :smiley:

Princeps

Ok my solution above did not work for me. Anyone got anymore ideas?

Attempted to make a change in Studio and got the following error codes

Thu Aug 23 08:24:03 2018 [13238][2018b652-0b18-f6ef-d318-5b7d763f20cf][FATAL] Query Failed: select * from versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist
Thu Aug 23 08:24:08 2018 [11190][2018b652-0b18-f6ef-d318-5b7d763f20cf][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:24:42 2018 [8313][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:25:27 2018 [14462][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/editviewdefs.php
Thu Aug 23 08:25:27 2018 [14462][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/detailviewdefs.php
Thu Aug 23 08:25:32 2018 [14881][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:26:16 2018 [13238][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:26:27 2018 [14462][1][FATAL] Mysqli_query failed.
Thu Aug 23 08:26:27 2018 [14462][1][FATAL] Query Failed: DESCRIBE versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist
Thu Aug 23 08:26:27 2018 [14462][1][FATAL] Mysqli_query failed.
Thu Aug 23 08:26:27 2018 [14462][1][FATAL] Query Failed: SHOW INDEX FROM versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist
Thu Aug 23 08:26:27 2018 [14462][1][FATAL] Mysqli_query failed.
Thu Aug 23 08:26:27 2018 [14462][1][FATAL] Query Failed: select * from versions: MySQL error 1146: Table ‘suitecrmdata.versions’ doesn’t exist
Thu Aug 23 08:26:40 2018 [14881][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:36:14 2018 [6991][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:36:23 2018 [6958][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.
Thu Aug 23 08:36:28 2018 [6991][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not set
Thu Aug 23 08:36:54 2018 [6958][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/editviewdefs.php
Thu Aug 23 08:36:54 2018 [6958][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/detailviewdefs.php
Thu Aug 23 08:37:05 2018 [7023][1][FATAL] log call at: modules/Administration/index.tpl:54 - MY_FRAME is not se

I checked and this is no accounts

I made the following changes to the index.tpl file (modules/Administration/index.tpl) ast https://github.com/salesagility/SuiteCRM/pull/6097/files

this removed the MY_FRAME errors. Thats pgr!

But still encountering the same ones below

Thu Aug 23 08:48:10 2018 [8304][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/editviewdefs.php
Thu Aug 23 08:48:10 2018 [8304][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/detailviewdefs.php
Thu Aug 23 08:49:49 2018 [7701][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/modules/Accounts/metadata/editviewdefs.php
Thu Aug 23 08:49:49 2018 [7701][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/modules/Accounts/metadata/detailviewdefs.php
Thu Aug 23 08:49:54 2018 [8304][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/editviewdefs.php
Thu Aug 23 08:49:54 2018 [8304][1][FATAL] DeployedMetaDataImplementation: could not write new viewdef file custom/working/modules/Accounts/metadata/detailviewdefs.php

Trying to find a fix

I followed the instructions here because I use a bash server I was having difficulty setting permissions.

I went into my FTV client FileZilla and manually changed the file permissionsthrough the write function outlined here.

https://support.sugarcrm.com/Knowledge_Base/Platform_Management/Troubleshooting_Filesystem_Permissions/index.html

Mine was specifically here
https://support.sugarcrm.com/Knowledge_Base/Platform_Management/Required_File_System_Permissions_on_Linux/

Our permissions look good, so that isn’t our problem with the dropdown editor. Your workaround worked for now. It isn’t ideal, since I’d like to have it functioning properly. In the meantime, it will have to do.

For your permission issue, be sure that the webserver user is able to read and/or write to the proper directories. For a good overview on linux file permissions, check out https://www.linux.com/learn/understanding-linux-file-permissions.

1 Like

Princeps, don’t you have SSH access to your server?

Do you know which user name your web server is running under? That is a required setting, using the chown command to set the ownership of the files. Permissions don’t mean anything without reference to ownership and to the process trying to access the file.

1 Like

Hi PGR

I do have SSH access to my server, but I find the commands I use within it do not often work as it runs with BASH and the commands people have outlined run slightly differently. I need to modify the commands. I am doing my level best to work around for now and learning SSH commands so I can use it better.

Thank you for your help :smiley:

Princeps

Bash shouldn’t be a problem at all. Maybe your problem is when the commands need sudo (administrator) access. Do you have sudo access or is it a shared server?

What is your brand of Linux, and which web server are you running?

Hi PGR

I log in as root so I have admin access, it is a server made specifically to run Suite CRM The Linux version is CentOS 7.

I normally can get the webserver admin team to run the commands for me. Apparently I don’t need to use the sudo first element in the syntax. I think I have moved past most of the SSH level work by setting the file permissions through FileZilla. But I might need to revisit it later when I am done configuring the software and cleaning the data.

Princeps

It’s much better to set ownerships and permissions from a Bash shell than from Filezilla, believe me.

Is your Studio working fine already? Make sure your file ownerships are correct. The user given should match the user that your web server is running under.

Most of the times I have set permissions with FileZilla it just didn’t work! Pgr is right!

Try this (just for permissions):
https://github.com/amariussi/chperms

To be fair it wasn’t working until I set all the permissions to 777 but I put it in the to hard basket for a little bit. Is there a quick way to tell which user given is the one running the webserver?

This indicates precisely wrong ownership.

I asked you a few posts back which web server you were running, so I could help you determine which user it’s running under.

If it’s Apache, use this to find out:

ps -ef | egrep '(httpd|apache2|apache)' | grep -v `whoami` | grep -v root | head -n1 | awk '{print $1}'

I have the same problem and it doesn’t appear to be the file permissions. If I create a new dropdown field in Studio (or the Dropdown editor) and save it, it doesn’t save. I get no real insights from the error logs either. I’ve deleted the content of the log files (both suitecrm.log and apache2/error.log) but nothing is showing up at all. The screen prompts tell me that its completed successfully though.

Any other tips…?

I am running 7.11.1