Question 1

How to remove the 'Missing required field:' prefix from custom validation messages in SuiteCRM?

Accepted Answer

Edit jssource/src_files/include/javascript/sugar_3.js. In the 'callback' case of the validate function, replace:
add_error_style(formname, validate[formname][i][nameIndex], requiredTxt + " " + validate[formname][i][msgIndex]);
with:
add_error_style(formname, validate[formname][i][nameIndex], validate[formname][i][msgIndex]);
This removes the unwanted prefix. After editing, rebuild the JS files (e.g., via Admin > Repair > Quick Repair and Rebuild).

Question 2

How to fix MySQL error 1250 'Table cannot be used in global ORDER clause' in SuiteCRM subpanels?

Accepted Answer

This error appears after a MySQL update that disallows table prefixes in the ORDER BY clause of subqueries. Workaround: Sort the subpanel by a different column (e.g., click a column header that avoids the error). Permanent fix: Edit the subpanel query definition to remove the table name from the ORDER BY. For example, change `ORDER BY contacts.last_name` to `ORDER BY last_name`. This modification must be applied to all affected subpanel definitions across SuiteCRM modules. For SuiteCRM 7.12.x and later, track the official patch for a systematic fix.

Question 3

How to fix 'Cannot write to $GLOBALS' fatal error during SuiteCRM installation on PHP 8.1?

Accepted Answer

In SuiteCRM up to version 7.12.4, 8.2.4, and earlier, the installation script install/performSetup.php directly assigns to $GLOBALS (around line 715), causing a fatal error in PHP 8.1. Edit the file and replace the assignment with individual $GLOBALS['key'] = value statements or global declarations. A community patch is available at https://github.com/JanSiero/SuiteCRM/commit/94825c73fae2cf817f05b2e698f7e390ae6778d5. After applying the fix, the installation should proceed normally.

Question 4

Why does SuiteCRM 8.1 on Nginx download index.php instead of executing it?

Accepted Answer

This happens because Nginx is not correctly passing PHP files to PHP-FPM for the root path. Ensure your Nginx configuration has these location blocks:

```nginx
# Root site (SuiteCRM 8 frontend)
location / {
    try_files $uri /index.php$is_args$args;
}

location /legacy/ {
    # Legacy path (SuiteCRM 7 backend)
}

# Pass PHP files to PHP-FPM
location ~ \.php$ {
    fastcgi_pass unix:/var/run/php/php8.2-fpm.sock;  # adjust PHP version
    fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    include fastcgi_params;
    fastcgi_index index.php;
}
```
Also make sure the `cgi.fix_pathinfo` is set to `0` in your php.ini, and that the PHP-FPM socket file has correct permissions. If the issue persists, check that the `index` directive includes `index.php` and that the `try_files` line properly falls back to `index.php`.

SuiteCRM

Core Features

What It Can't Do

Use Cases

Tags

Getting Started

Similar Projects