SuiteCRM 7.9.6 on 1and1 hosting environment
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.
Thanks,
Lee
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).
Thanks for the reply. I’ve attached screenshots as requested below:
https://pasteboard.co/GVWxEIU.png
https://pasteboard.co/GVWy9wz.png
Also - this “undefined” issue is showing up in multiple locations in the application, not just here.
If it’s happening in more places it’s 99% likely you simply haven’t configured your Linux permissions correctly.
Please give me some details on your system:
Versions of OS, PHP and SuiteCRM
Is it your own server, or shared hosting? Do you have SSH access?
Please post the contents at the bottom of the screen in Admin / Schedulers (the instructions about setting up cron jobs)
Please post here the contents of this command given from your SuiteCRM root directory:
ls -alThis 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.
THanks,
Lee
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?
Thanks again for the reply.
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.
SSH is 3000 times more powerful 
Just go into it (via CPanel or Putty) and type this command given in your SuiteCRM root folder:
ls -al /homepages/38/d677808517/htdocs/SuiteCRM7-9-6When you paste the results here, put it inside the forum’s “code” tags so it gets displayed correctly. Thanks.
(uiserver):u88988678:~/SuiteCRM7-9-6$ ls -al
total 3868
drwxr-xr-x 18 u88988678 ftpusers 4096 Oct 9 18:55 .
drwx---r-t 6 u88988678 ftpusers 110 Oct 9 10:30 ..
drwxr-xr-x 2 u88988678 ftpusers 73 Oct 9 10:40 .github
-rw----r-- 1 u88988678 ftpusers 1373 Oct 9 18:55 .htaccess
-rwxr-xr-x 1 u88988678 ftpusers 3094 Oct 9 10:40 CODE_OF_CONDUCT.md
-rwxr-xr-x 1 u88988678 ftpusers 2811 Oct 9 10:40 HandleAjaxCall.php
-rwxr-xr-x 1 u88988678 ftpusers 34539 Oct 9 10:40 LICENSE.txt
drwxr-xr-x 3 u88988678 ftpusers 118 Oct 9 10:40 ModuleInstall
-rwxr-xr-x 1 u88988678 ftpusers 3735 Oct 9 10:40 README.md
-rwxr-xr-x 1 u88988678 ftpusers 5327 Oct 9 10:40 SugarSecurity.php
-rwxr-xr-x 1 u88988678 ftpusers 5843 Oct 9 10:40 TreeData.php
drwxr-xr-x 2 u88988678 ftpusers 47 Oct 9 10:40 XTemplate
drwxr-xr-x 8 u88988678 ftpusers 4096 Oct 9 10:41 Zend
drwxrwxr-x 14 u88988678 ftpusers 4096 Oct 9 18:56 cache
-rwxr-xr-x 1 u88988678 ftpusers 3590 Oct 9 10:40 campaign_tracker.php
-rwxr-xr-x 1 u88988678 ftpusers 462 Oct 9 10:40 composer.json
-rwxr-xr-x 1 u88988678 ftpusers 17908 Oct 9 10:40 composer.lock
-rwxr-xr-x 1 u88988678 ftpusers 10141 Oct 9 18:55 config.php
-rwxrwxr-x 1 u88988678 ftpusers 328 Oct 29 19:33 config_override.php
-rwxr-xr-x 1 u88988678 ftpusers 5052 Oct 9 10:40 cron.php
-rwxr-xr-x 1 u88988678 ftpusers 2446 Oct 9 10:40 crossdomain.xml
drwxrwxr-x 8 u88988678 ftpusers 145 Oct 29 19:33 custom
drwxrwxr-x 3 u88988678 ftpusers 123 Oct 9 10:43 data
-rwxr-xr-x 1 u88988678 ftpusers 2388 Oct 9 10:40 dictionary.php
-rwxr-xr-x 1 u88988678 ftpusers 12541 Oct 9 10:40 download.php
-rwxr-xr-x 1 u88988678 ftpusers 2392 Oct 9 10:40 emailmandelivery.php
-rwxr-xr-x 1 u88988678 ftpusers 4912 Oct 9 10:40 export.php
-rwxr-xr-x 1 u88988678 ftpusers 967627 Oct 9 10:40 files.md5
-rwxr-xr-x 1 u88988678 ftpusers 2367 Oct 9 10:40 ical_server.php
drwxr-xr-x 58 u88988678 ftpusers 4096 Oct 9 10:45 include
-rwxr-xr-x 1 u88988678 ftpusers 2374 Oct 9 10:40 index.php
drwxr-xr-x 6 u88988678 ftpusers 4096 Oct 9 18:55 install
-rw----r-- 1 u88988678 ftpusers 18276 Oct 9 18:55 install.log
-rwxr-xr-x 1 u88988678 ftpusers 31896 Oct 9 10:40 install.php
-rwxr-xr-x 1 u88988678 ftpusers 2275 Oct 9 10:40 json_server.php
drwxr-xr-x 3 u88988678 ftpusers 147 Oct 9 11:03 jssource
-rwxr-xr-x 1 u88988678 ftpusers 2313 Oct 9 10:40 log_file_restricted.html
-rwxr-xr-x 1 u88988678 ftpusers 2376 Oct 9 10:40 maintenance.php
drwxr-xr-x 2 u88988678 ftpusers 4096 Oct 9 11:08 metadata
drwxrwxr-x 112 u88988678 ftpusers 4096 Oct 9 11:18 modules
-rwxr-xr-x 1 u88988678 ftpusers 2890 Oct 9 10:40 pdf.php
-rwxr-xr-x 1 u88988678 ftpusers 304 Oct 9 10:40 php_version.php
-rwxr-xr-x 1 u88988678 ftpusers 73 Oct 9 10:40 robots.txt
-rwxr-xr-x 1 u88988678 ftpusers 3588 Oct 9 10:40 run_job.php
drwxr-xr-x 12 u88988678 ftpusers 4096 Oct 9 11:27 service
drwxr-xr-x 2 u88988678 ftpusers 4096 Oct 9 11:27 soap
-rwxr-xr-x 1 u88988678 ftpusers 4091 Oct 9 10:40 soap.php
-rwxr-xr-x 1 u88988678 ftpusers 154 Oct 9 10:40 sugar_version.json
-rwxr-xr-x 1 u88988678 ftpusers 2296 Oct 9 10:40 sugar_version.php
-rw----r-- 1 u88988678 ftpusers 124770 Oct 9 18:55 sugarcrm.log
-rw----r-- 1 u88988678 ftpusers 2537110 Dec 1 13:36 suitecrm.log
-rwxr-xr-x 1 u88988678 ftpusers 169 Oct 9 10:40 suitecrm_version.php
drwxrwxr-x 6 u88988678 ftpusers 79 Oct 9 11:28 themes
drwxrwxr-x 4 u88988678 ftpusers 4096 Nov 13 16:15 upload
-rwxr-xr-x 1 u88988678 ftpusers 2980 Oct 9 10:40 vCard.php
-rwxr-xr-x 1 u88988678 ftpusers 2248 Oct 9 10:40 vcal_server.php
(uiserver):u88988678:~/SuiteCRM7-9-6$ Hopefully this is right. Not used SSH before.
Ok, so now in that same directory give these three commands:
chown -R u88988678:ftpusers .
chmod -R 755 .
chmod -R 775 cache custom modules themes data upload config_override.php
Note that two of those commands end with a space followed by a dot " ."
Now go into Admin / Repair and do a Quick Repair and Rebuild. Check if your system is better now.
If not, please upgrade to 7.9.7 and check again.
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.phpCould you take a look at this and see if there is anything obvious I am missing please?
Thanks,
Lee
Well, you just have to adapt the username since it’s different there.
So use this chown instead:
chown -R u84238348:ftpusers .Did that. Hasn’t worked. I don’t understand why. Everything is the same!
Try doing it all in the correct sequence,
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…