7.10 Report fields header shows "undefined"

7.10 Report fields header shows “undefined”

can you attach a screenshot + version of operating system (server), browser, database & PHP versions.

thx

mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper
PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )
Apache/2.4.18 (Ubuntu)
Ubuntu 16.04 LTS

I don’t see any “undefined” in your screenshot… can you try it on the live demo and see if it works well there?

suitecrm.com/demo

Sorry, this Add File on this forum doesn’t seem to work well.

The file is uploaded correctly, I can look at your screenshot, I just don’t see any “undefined” labels in it…

You can upload files to
https://pastebin.com

and images to
https://pasteboard.co

This is the correct pic, the other one was from older post.
https://pasteboard.co/Hb7bxnv.png

Ok, I see now. I tried it on my test system, and on the live demo, and it works fine in both places.

Please try a few repairs from Admin / Repair (including any javascript stuff). If it doesn’t fix it, my advice would be to just ignore it, it might be a caching problem and it will fix itself.

However if you see "undefined"s in more places in the app, I would recommend (re-)checking your permissions.

Repair doesn’t fix it. It also showing on dialog pop windows, hard to choose what to click as all options undefined.
https://pasteboard.co/HbqjgcT.png

Should mention that this worked well before 7.10 on exact same environment.

Ok, let’s go check your permissions. Please remind me if we’ve already tried this on another thread, I can’t remember every one :slight_smile:

What are the instructions you get on the bottom of the Admin / schedulers screen? (That gives me the username your web server is using).

What do you get when you type this from your SuiteCRM root folder?

ls -al

(that gives me a quick glimpse of what your permissions are currently like)

/var/www/suitecrm$ ls -al
total 2560
drwxr-xr-x  21 www-data www-data   4096 Feb 19 18:32 .
drwxr-xr-x   7 root     root       4096 Feb 19 18:37 ..
-rw-r--r--   1 www-data www-data    411 Feb 19 18:32 bower.json
drwxrws---   2 www-data www-data   4096 Feb 19 18:32 build
drwxrwxr-x  16 www-data www-data   4096 Feb 19 18:18 cache
-rwxr-xr-x   1 www-data www-data   3587 Feb 19 18:32 campaign_tracker.php
-rw-r--r--   1 www-data www-data   3094 Feb 19 18:32 CODE_OF_CONDUCT.md
-rwxr-xr-x   1 www-data www-data   1027 Feb 19 18:32 composer.json
-rwxr-xr-x   1 www-data www-data 114330 Feb 19 18:32 composer.lock
-rwxrwxr-x   1 www-data www-data    797 Mar  4 13:48 config_override.php
-rwxr-xr-x   1 www-data www-data  11046 Feb 19 18:32 config.php
-rwxr-xr-x   1 www-data www-data  10120 Oct 26 18:09 config.php.org
-rwxr-xr-x   1 www-data www-data   5052 Jun 29  2017 cron.php
-rwxr-xr-x   1 www-data www-data   2446 Jun 29  2017 crossdomain.xml
drwxrwxr-x  10 www-data www-data   4096 Feb 19 18:32 custom
drwxrwxr-x   3 www-data www-data   4096 Jun 29  2017 data
-rwxr-xr-x   1 www-data www-data   2386 Feb 19 18:32 dictionary.php
-rwxr-xr-x   1 www-data www-data  12566 Feb 19 18:32 download.php
-rwxr-xr-x   1 www-data www-data   2390 Feb 19 18:32 emailmandelivery.php
-rwxr-xr-x   1 www-data www-data   4918 Feb 19 18:32 export.php
-rwxr-xr-x   1 www-data www-data 967627 Jun 29  2017 files.md5
-rw-r--r--   1 www-data www-data   1689 Feb 19 18:32 .gitignore
-rwxr-xr-x   1 www-data www-data   2808 Feb 19 18:32 HandleAjaxCall.php
-rw-r--r--   1 www-data www-data   1405 Aug  2  2017 .htaccess
-rwxr-xr-x   1 www-data www-data   2367 Feb 19 18:32 ical_server.php
drwxr-xr-x  58 www-data www-data   4096 Feb 19 18:32 include
-rwxr-xr-x   1 www-data www-data   2374 Feb 19 18:32 index.php
drwxr-xr-x   6 www-data www-data   4096 Feb 19 18:32 install
-rw-r--r--   1 www-data www-data  19881 Aug  2  2017 install.log
-rwxr-xr-x   1 www-data www-data  31893 Feb 19 18:32 install.php
-rwxr-xr-x   1 www-data www-data   2275 Feb 19 18:32 json_server.php
drwxr-xr-x   3 www-data www-data   4096 Jun 29  2017 jssource
drwxrws---   7 www-data www-data   4096 Feb 19 18:32 lib
-rwxr-xr-x   1 www-data www-data  34539 Jun 29  2017 LICENSE.txt
-rwxr-xr-x   1 www-data www-data   2313 Jun 29  2017 log_file_restricted.html
-rwxr-xr-x   1 www-data www-data   2376 Jun 29  2017 maintenance.php
drwxr-xr-x   2 www-data www-data   4096 Feb 19 18:32 metadata
drwxr-xr-x   3 www-data www-data   4096 Jun 29  2017 ModuleInstall
drwxrwxr-x 119 www-data www-data   4096 Feb 19 18:32 modules
-rwxr-xr-x   1 www-data www-data   2886 Feb 19 18:32 pdf.php
-rwxr-xr-x   1 www-data www-data    304 Feb 19 18:32 php_version.php
drwxrws---   2 www-data www-data   4096 Nov 28 16:47 public
-rwxr-xr-x   1 www-data www-data   3837 Feb 19 18:32 README.md
-rwxr-xr-x   1 www-data www-data     73 Jun 29  2017 robots.txt
-rwxr-xr-x   1 www-data www-data   3588 Jun 29  2017 run_job.php
drwxr-xr-x  12 www-data www-data   4096 Feb 19 18:32 service
drwxr-xr-x   2 www-data www-data   4096 Jun 29  2017 soap
-rwxr-xr-x   1 www-data www-data   4088 Feb 19 18:32 soap.php
-rw-r--r--   1 www-data www-data 123980 Aug  2  2017 sugarcrm.log
-rwxr-xr-x   1 www-data www-data   5327 Jun 29  2017 SugarSecurity.php
-rwxr-xr-x   1 www-data www-data    154 Feb 19 18:32 sugar_version.json
-rwxr-xr-x   1 www-data www-data   2296 Feb 19 18:32 sugar_version.php
-rw-r--r--   1 www-data www-data 125129 Mar 11 15:34 suitecrm.log
-rwxr-xr-x   1 www-data www-data    168 Feb 19 18:32 suitecrm_version.php
drwxrwxr-x   6 www-data www-data   4096 Jun 29  2017 themes
-rwxr-xr-x   1 www-data www-data    839 Feb 19 18:32 .travis.yml
-rwxr-xr-x   1 www-data www-data   5839 Feb 19 18:32 TreeData.php
-rwxr-xr-x   1 www-data www-data 910426 Feb 19 18:32 upgradeWizard.log
drwxrwxr-x   4 www-data www-data   4096 Feb 26 19:27 upload
-rwxr-xr-x   1 www-data www-data   2248 Feb 19 18:32 vcal_server.php
-rwxr-xr-x   1 www-data www-data   2976 Feb 19 18:32 vCard.php
drwxrws---  18 www-data www-data   4096 Feb 19 18:32 vendor
drwxr-xr-x   2 www-data www-data   4096 Jun 29  2017 XTemplate
drwxr-xr-x   8 www-data www-data   4096 Feb 19 18:32 Zend

I am intrigued by your case, your permissions seem just fine, but you do have a very broken system :frowning:

What do you get when you do this command:

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

This will tell me which user your Apache server is running under.

Also, check what you have in your default_permissions in config.php , and try a few of the Javascript repairs in Admin / Repair.

ps -ef | egrep ‘(httpd|apache2|apache)’ | grep -v whoami | grep -v root | head -n1 | awk ‘{print $1}’
www-data

grep default_permissions config.php
‘default_permissions’ =>

Tried rebuild and repair

Don’t just try “Quick Repair and Rebuild”, try the other Repairs.

Ant that grep doesn’t show anything about default_permissions, you need to edit the file and grab that part of the array, it spans several lines.

‘default_permissions’ =>
array (
‘dir_mode’ => 1528,
‘file_mode’ => 493,
‘user’ => ‘’,
‘group’ => ‘’,
),

Try this


'default_permissions' =>
    array (
       'dir_mode' => 02775,
       'file_mode' => 0755,
       'user' => 'www-data',
       'group' => 'www-data',
), 

then delete “cache/themes” folder (it will get recreated)

No change after doing all of that.

Then I am really sorry, but I am running out of ideas to help you. Normally this is really simple but there is something in your system that doesn’t work right. Could be some special .htaccess file, some peculiar security configuration in your web server, some strange customization. I don’t know.

The only way forward from here would be to use a debugger and see exactly where the code is breaking.