Reports module not accessing field names in edit mode - represents as "undefined"

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:

  1. Versions of OS, PHP and SuiteCRM

  2. Is it your own server, or shared hosting? Do you have SSH access?

  3. Please post the contents at the bottom of the screen in Admin / Schedulers (the instructions about setting up cron jobs)

  4. Please post here the contents of this command given from your SuiteCRM root directory:

ls -al

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.

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 :slight_smile:

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-6

When 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.php

Could 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,

  • the chown
  • the two chmods
  • the Quick repair

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…