Error when creating Leads manually - SuiteCRM 8.6.2

👨‍💻 Development Help
1

I have SuiteCRM Version 8.6.2 running on Debian 12.
I’m currently testing SuiteCRM with real data after migrating from Zoho.

When I imported data using the Leads layout, everything worked fine. However, now when I try to manually create a new Lead, I get the following error:

“There are validation errors, unable to perform action.”

I checked the log file located at /public/legacy/suitecrm.log, but there are no errors shown.

I’ve tried several solutions like repairing the database, clearing the cache, and checking permissions, but nothing seems to fix the issue.

Any ideas or suggestions would be greatly appreciated!

Captura de pantalla 2025-03-13 110812
Captura de pantalla 2025-03-13 1108121040×522 18.7 KB

Captura de pantalla 2025-03-13 111100
Captura de pantalla 2025-03-13 1111001104×513 18.7 KB

2

Check site_url in the config.php file.

Also, restart your services like web server and php.

3

I checked the config.php file and it looks like this:
‘site_url’ => ‘https://ocampoga.com.mx:8087/ocampocrm/public’

I restarted Apache2 and PHP, and I’m still getting that error.

4

Your web root should set still public folder.


DocumentRoot /var/www/html/suitecrm/public

<Directory /var/www/html/suitecrm/public>
    Options Indexes FollowSymLinks
    AllowOverride All
    Require all granted

sudo systemctl restart apache2

/var/www/html/suitecrm/public/legacy/.htaccess

Check it should have RewriteRoot set in the .htaccess file.

/legacy/

5

Captura de pantalla 2025-03-13 141058
yes I have it in

What am I looking for here? Excuse me.
/var/www/html/suitecrm/public/legacy/.htaccess

6

RewriteBase /legacy/

7

/var/www/html/ocmx/ocampocrm/public$ ls:

bundles dist extensions favicon.ico index.php install.php legacy robots.txt site.webmanifest

I don’t have that folder

8

In the legacy folder.

ls -la

.htaccess is a hidden file.

9

Okay, I’m in .htaccess.

I see the line you mentioned.

Captura de pantalla 2025-03-13 161137

10

Yes, does that help after changing it?

11

This is what it looks like: RewriteBase /legacy/

It still shows the error.

image
image997×340 13.5 KB

12

Manually it does not upload the Lead but if I upload it with the layout it does add it

13

That’s weird! Clear the symfony cache:

bin/console cache:clear
14

Sigo sin poder resolver el error.

Estoy en este punto. ¿Alguien podría orientarme o ayudarme?

Ruta: /var/www/html/ocmx/ocampocrm/public/legacy/suitecrm.log | grep -B 3 “parent_name)”

Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Mysqli_query failed.
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Query Failed: SELECT id , name parent_name): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Mysqli_query failed.
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Query Failed: SELECT id , name parent_name): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Mysqli_query failed.
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Query Failed: SELECT id , name parent_name): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Mysqli_query failed.
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Query Failed: SELECT id , name parent_name): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Mysqli_query failed.
Wed Mar 19 22:36:05 2025 [1085074][24de371a-1811-26cf-7ed0-66eb6637accb][FATAL] Query Failed: SELECT id , name parent_name): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1

15

Manually it does not upload the Lead but if I upload it with the layout it does add it

What do you mean by this? Are you uploading them using excel file or something?