Need to auto populate value based on the value of related field? For this requirement Auto Populate is the perfect solution. The advanced configuration tools allow you to clearly define what should happen whenever a related field value changes.
#5306 - SQL error with 7.14
I am getting:
[FATAL] Query Failed: DELETE FROM vi_autopopulate_calculate_fields where and autopopulatefields_id='83499548-4593-b19f-230c-661e93ef6840': MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and autopopulatefields_id='83499548-4593-b19f-230c-661e93ef6840'' at line 1
when creating a new automation and nothing works.
Stephenmorton
7 months ago
Hello,
Apologize the problem you're facing.
Can you please tell us your PHP Version. Also we'll check your issue from our end and update you
Regards,
Variance Infotech PVT LTD
7 months ago
Hello, I have the following:
PHP 8.1.27 (cli) (built: Apr 11 2024 21:34:26) (NTS) mysql Ver 8.0.36-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu)) SuiteCRM version 7.14.3
7 months ago
Hello,
Thank you for sharing the information.
I've uploaded new package on SuiteCRM Store. Can you please download the updated package according to SuiteCRM Version from SuiteCRM Store.
After downloading, Uninstall the previous package from the SuiteCRM and Install updated Package.
Regards, Variance Infotech PVT LTD
7 months ago
Your fix appears to have restored the functionality, thank you very much for the quick support.
This error popped up during installation, I don't know if it has any relevance:
Wed Apr 17 12:06:00 2024 [85908][98f76a3d-73d8-bd37-8ec5-60d19ca12424][FATAL] Mysqli_query failed. Wed Apr 17 12:06:00 2024 [85908][98f76a3d-73d8-bd37-8ec5-60d19ca12424][FATAL] Query Failed: SELECT * FROM vi_autopopulatefields: MySQL error 1146: Table 'suitecrm.vi_autopopulatefields' doesn't exist
7 months ago
Ok.
Thank you for sharing the details.
Installation completed successfully?
Regards,
Variance Infotech PVT LTD
7 months ago
Yes, the installation was successful and I could create a new autofill task.
7 months ago
Ok.
Please let us know if you face any issue for the autofill task.
Regards,
Variance Infotech PVT LTD