Attempted to run a Prune Database program and got the following fatal error.
Anyone seen this before and know a fix. My workflow automates fine.
Tue Aug 28 14:50:37 2018 [FATAL] Query Failed: INSERT INTO tracker (monitor_id,user_id,module_name,item_id,item_summary,date_modified,action,session_id,visible ) VALUES ( ‘16e199f0-c025-4f13-2101-5b8561255b8b’,‘1’,‘Schedulers’,‘64732703-42d2-d2fb-c6ab-5b855b1588c0’,‘Prune Tracker Tables 2’,‘2018-08-28 14:50:37’,‘detailview’,‘2b1f63de5a250bafdd9797c92f23547d’,‘1’): MySQL error 1364: Field ‘id’ doesn’t have a default value
You shouldn’t change anything else, it is even strange that this table was not set correctly - as I said, the installer takes care of all of that.
You can simply change the Schedule of the Prune Tables job to run more frequently, for tests.
If the error doesn’t come up when the job runs, then this particular issue seems to be fixed. If you have another issue keeping the job from finishing successfully, you should have a different error there.
[root@server ~]# php -i | grep “’_’”
-bash: php: command not found
It does that all the time with commands, I then resheduled a job.
SuiteCRM.log - has no errors at the time the job failed, nothing at all for an hour before.
php_errors.log - I do not think I have one set up. My php.ini file states
; Log errors to specified file. PHP’s default behavior is to leave this value
;error_log = php_errors.log
; Log errors to syslog (Event Log on Windows).
;error_log = syslog
Prior to above.
I used whereis PHP and changed all the permissions on the stated folders to allow write access.
The user you need to be concerned about is not the user you’re using to login; it is your web server user. By giving files’ ownership to root you are making them invisible to SuiteCRM. So stay calm, follow instructions, let’s do one thing at a time… :ohmy:
I am getting really lost.The php.ini file is /etc/php.ini. The command didn’t I am having massive problems having my SSH respond to commands, it appears to use a different language! (Something simple takes forever)
Configuration File (php.ini) Path /etc
Loaded Configuration File /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
When I attempt to set file permissions I get invalid user for www-data
One of the reasons this seems complicated is because our communication is a bit chaotic; I would prefer if you would always pair up which command you gave, and what it answered. Even for the failed commands. The messages might mean something to me, even if they don’t mean much to you.
Another thing: don’t lose hope, this is actually a simple problem, only you (apparently) don’t have much experience as a sysadmin, and I have to make guesses and work from a distance, which makes things complicated.
But you simply have a bash shell that doesn’t have a properly set “path”, so it doesn’t find commands easily; and you need to set SuiteCRM permissions but first you have to find out some details about your system.
If “apache” is the user name your Web server is running under (and not just the brand of the server like you wrote: “The webserver name is apache”), then issue all these commands from the root of your SuiteCRM installation:
The company which is hosting my package kindly stepped in when I asked why the command above was not working. You had rightly pointed out it was a permissions issue. They fixed it and Cron so it now runs my scheduled jobs. (The web company is really awesome)
The issue has been resolved and I do not know what they did to fix it. I have asked them for the details so I can list them here in the forum, but they may not come back to me with the nitty gritty stuff. (for which I am sorry to anyone who reads this in future)
I will keep chasing them as I really want to know how to fix it.
Thank you for your help PGR do you have a email I can send the PHP info to?