Tue Sep 17 09:53:20 2019 [6276][10f8cae7-eefb-87db-7cf1-5d1bb7a9b6ab][ERROR] convert: Conversion of 17/09/2019 00:00 from Y-m-d H:i:s to d/m/Y H:i failed
Tue Sep 17 09:53:39 2019 [6276][10f8cae7-eefb-87db-7cf1-5d1bb7a9b6ab][ERROR] Unable to load related bean by id
What could be the problem?
My version of SuiteCRM is 7.11.7
The command should work if you are in the directory where php.exe is.
You can find out with
dir \php.exe /s/a
(this will take a couple of minutes to scan your entire disk, and might turn up more than one answer…)
If you get that information from phpinfo, you are getting the information of your Web server PHP. We need the other one now, from CLI PHP (command-line) which is what runs cron.
You could have told me before that the error was that “grep was not found”, instead of just saying the command didn’t work. That would have saved us some time.
Use just
php -i
and scroll through all the output until you find date.timezone.
I searched Google for this problem and it seems it’s an old bug. But I don’t think it has any consequences, maybe it’s safe to ignore. What are the actual problems (in functionality, not just log messages) that you are currently facing? Let’s focus on those.
I have 2 problems:
1. after I created the file “cron.bat” the schedulers doesn’t work
2. when I import the call from a csv file the data’s field are not imported correctly (my data dormat is 23/10/2010), for example the data in the csv file is
14/03/2019 and after the import in Suite the data is 03/02/2020 or if the data in the csv file is 01/03/2019 and after the import in Suite the data is 03/01/2020
(it doesn’t work both with custom field and standard field).
In the import wizard, step 2, click “View Import File Properties” and see if you can get the dates to import right.
About the error in the schedulers. Please try to isolate which specific scheduler job is breaking. You can do this by going in Admin / Schedulers and selectively disabling some jobs, and seeing which one is getting an error. Note the field “last ran successfully”, that should give you clues.
For the import I solved: you were right, in the import wizard, step 2, in "View Import File Properties there was a wrong data format.
For the schedulers I need to fix the reminders(both email and popup), if I go in the schedulers and I go to the jobs “Send Email Reminder” the field “last run succefully” shows “never”
Maybe you can find some one to help you locally - just get a batch file to run and call a PHP page. And maybe you can find some clues to the errors in your logs, or in Windows Event Viewer.
But for me, I’m sorry, but it is hard to help you like this, remotely, and without any information…
If in the cron.bat I call a PHP page it works, but soon i restore the correct file it doesn’t work with suitecrm’s schedeluers.
The only errors that are in the suitecrm.log are these:
No, I am not interested for now to use it. I have enabled it because i had an error in suitecrm.log that now that I have disabled the ElasticSearch it is appeared again.
The error is:
I update Suite to 7.11.8 but the error in log file still persist, I also check the lines of the file \SuiteCRM\lib\Search\ElasticSearch\HelasticSearchHooks.php as the link you shared and they are the same but I don’t know why the error still persist.
This are my lines: