I’m working on reports and when I try to define conditions and other parameters I am getting the field names missing and replaced by the word “Unassigned”. I’d really like to fix this as I’ve stumbled my way through it so far, but our reporting requirements are becoming more stringent and it would help tremendously.
Is this the only place where you have “Unassigeds” coming up?
This is typically ownership/permissions errors, but if it’s only in one place it could be something else.
Please post a screenshot also. Use https://pasteboard.co/ to post, if the forums doesn’t allow attachments for you (there is a bug affecting some people).
This installation runs on a 1and1.com shared hosting environment running linux, which I do not know if I have SSH access to. I’ve only used Filezilla with it before. I don’t know which specific distribution it is. It is running using PHP 7.0. SuiteCRM version is 7.9.6
Admin > Schedulers text is: "To Setup Crontab
In order to run SuiteCRM Schedulers, edit your web server user’s crontab file with this command:
sudo crontab -e -u u88988678
… and add the following line to the crontab file:
cd /homepages/38/d677808517/htdocs/SuiteCRM7-9-6; php -f cron.php > /dev/null 2>&1 "
I don’t know how to execute that command from the SuiteCRM root directory. I’m not even sure if I can run any commands directly in this environment . This is surpassing my technical competency clearly. Any help very much appreciated.
You probably have a CPanel to manage your hosting account. If you see a “SSH” icon there, good. If not, we’re more limited in what we can do.
You might be able to set permissions and ownerships from that CPanel’s File Manager. First, can you see file ownership and permissions displayed there, somewhere?
I do have SSH access through my 1and1 interface, but I typically change file and folder permissions through Filezilla. Will that work? I’m really not familiar with SSH access through PuTTY or similar.
Thank you for this. It worked great and that installation is now working fine with the “undefined” labels replaced with their appropriate labels.
I have a second installation for another project and it has exactly the same structure. 1and1 hosting, same version, same php version etc. It was exhibiting the same behavior with “undefined” elements in multiple places, so I tried the same steps on it and it didn’t work. I’ve pasted the ls -lahp output below:
drwxr-xr-x 18 u84238348 ftpusers 4.0K Sep 11 15:27 ./
drwx---r-t 17 u84238348 ftpusers 4.0K Oct 9 12:51 ../
-rwxr-xr-x 1 u84238348 ftpusers 1.4K May 22 2017 .htaccess
drwxr-xr-x 3 u84238348 ftpusers 32 Aug 18 15:44 C:/
-rwxr-xr-x 1 u84238348 ftpusers 2.8K May 22 2017 HandleAjaxCall.php
-rwxr-xr-x 1 u84238348 ftpusers 34K May 22 2017 LICENSE.txt
drwxr-xr-x 3 u84238348 ftpusers 118 May 22 2017 ModuleInstall/
-rwxr-xr-x 1 u84238348 ftpusers 2.6K May 22 2017 README.md
-rwxr-xr-x 1 u84238348 ftpusers 5.3K May 22 2017 SugarSecurity.php
-rwxr-xr-x 1 u84238348 ftpusers 5.8K May 22 2017 TreeData.php
drwxr-xr-x 2 u84238348 ftpusers 47 May 22 2017 XTemplate/
drwxr-xr-x 8 u84238348 ftpusers 4.0K May 22 2017 Zend/
drwxrwxr-x 15 u84238348 ftpusers 4.0K Sep 11 15:27 cache/
-rwxr-xr-x 1 u84238348 ftpusers 3.6K May 22 2017 campaign_tracker.php
-rwxr-xr-x 1 u84238348 ftpusers 462 May 22 2017 composer.json
-rwxr-xr-x 1 u84238348 ftpusers 18K May 22 2017 composer.lock
-rwxr-xr-x 1 u84238348 ftpusers 11K Jul 25 08:56 config.php
-rwxrwxr-x 1 u84238348 ftpusers 2.8K Oct 5 21:01 config_override.php
-rwxr-xr-x 1 u84238348 ftpusers 5.0K May 22 2017 cron.php
-rwxr-xr-x 1 u84238348 ftpusers 2.4K May 22 2017 crossdomain.xml
drwxrwxr-x 8 u84238348 ftpusers 146 Sep 11 17:31 custom/
drwxrwxr-x 3 u84238348 ftpusers 123 May 22 2017 data/
-rwxr-xr-x 1 u84238348 ftpusers 2.4K May 22 2017 dictionary.php
-rwxr-xr-x 1 u84238348 ftpusers 13K May 22 2017 download.php
-rwxr-xr-x 1 u84238348 ftpusers 2.4K May 22 2017 emailmandelivery.php
-rwxr-xr-x 1 u84238348 ftpusers 4.8K May 22 2017 export.php
-rwxr-xr-x 1 u84238348 ftpusers 945K May 22 2017 files.md5
-rwxr-xr-x 1 u84238348 ftpusers 2.4K May 22 2017 ical_server.php
drwxr-xr-x 56 u84238348 ftpusers 4.0K May 22 2017 include/
-rwxr-xr-x 1 u84238348 ftpusers 2.4K May 22 2017 index.php
drwxr-xr-x 6 u84238348 ftpusers 4.0K May 22 2017 install/
-rwxr-xr-x 1 u84238348 ftpusers 18K May 22 2017 install.log
-rwxr-xr-x 1 u84238348 ftpusers 30K May 22 2017 install.php
-rwxr-xr-x 1 u84238348 ftpusers 14K May 22 2017 json_server.php
drwxr-xr-x 3 u84238348 ftpusers 147 May 22 2017 jssource/
-rwxr-xr-x 1 u84238348 ftpusers 2.3K May 22 2017 log_file_restricted.html
-rwxr-xr-x 1 u84238348 ftpusers 2.4K May 22 2017 maintenance.php
drwxr-xr-x 2 u84238348 ftpusers 4.0K May 22 2017 metadata/
drwxrwxr-x 112 u84238348 ftpusers 4.0K May 22 2017 modules/
-rwxr-xr-x 1 u84238348 ftpusers 2.9K May 22 2017 pdf.php
-rwxr-xr-x 1 u84238348 ftpusers 73 May 22 2017 robots.txt
-rwxr-xr-x 1 u84238348 ftpusers 3.6K May 22 2017 run_job.php
drwxr-xr-x 11 u84238348 ftpusers 143 May 22 2017 service/
drwxr-xr-x 2 u84238348 ftpusers 4.0K May 22 2017 soap/
-rwxr-xr-x 1 u84238348 ftpusers 4.0K May 22 2017 soap.php
-rwxr-xr-x 1 u84238348 ftpusers 154 May 22 2017 sugar_version.json
-rwxr-xr-x 1 u84238348 ftpusers 2.3K May 22 2017 sugar_version.php
-rwxr-xr-x 1 u84238348 ftpusers 122K May 22 2017 sugarcrm.log
-rwxr-xr-x 1 u84238348 ftpusers 8.2M Oct 6 13:24 suitecrm.log
-rwxr-xr-x 1 u84238348 ftpusers 168 May 22 2017 suitecrm_version.php
-rwxr-xr-x 1 u84238348 ftpusers 957 May 22 2017 testinstall.php
drwxrwxr-x 6 u84238348 ftpusers 79 May 22 2017 themes/
-rwxr-xr-x 1 u84238348 ftpusers 2.3K Sep 11 15:27 upgradeWizard.log
drwxrwxr-x 3 u84238348 ftpusers 144 Aug 17 14:14 upload/
-rwxr-xr-x 1 u84238348 ftpusers 3.0K May 22 2017 vCard.php
-rwxr-xr-x 1 u84238348 ftpusers 2.7K May 22 2017 vcal_server.php
Could you take a look at this and see if there is anything obvious I am missing please?
You can also try a few other repairs that mention cache or Javascript or JS.
Then try on a different computer, and on a different browser - you might have some stuff stuck in some cache somewhere… if so, this should clear itself out eventually…