Why is Suite accessing language files and other errors / warnings

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi guys,
Having recently installed SuiteCRM 7.2.2 on a godaddy.com domain, I have a series or errors & warnings in the log file. Whilst I know these are not fatal and errors per say which will have a detrimental impact on the site, can someone please explain why the following errors / warnings are showing up and how they can be resolved -

Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Found language file: en_us.lang.php
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Found extended language file: en_us.lang.ext.php
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Found custom language file: en_us.lang.php
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query Execution Time:0.000244140625
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query:SELECT category, name, value FROM config
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query Execution Time:0.00477886199951
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = ‘system’
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query Execution Time:0.0055251121521
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = ‘a574400d-e6b1-e075-236b-560dc581b223’
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query Execution Time:0.00490784645081
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Found language file: en_us.lang.php
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Found extended language file: en_us.lang.ext.php
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Found custom language file: en_us.lang.php
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1
Tue 20 Oct 2015 12:49:01 PM UTC [207032][-none-][INFO] Query Execution Time:0.00996899604797
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query:SELECT contents FROM user_preferences WHERE assigned_user_id=‘1’ AND category = ‘global’ AND deleted = 0
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.000370025634766
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query:SELECT id, first_name, last_name, user_name from users WHERE 1=1 ORDER BY first_name, last_name ASC
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.000416040420532
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = ‘1’ and u1.deleted=0
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.00805401802063
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted
FROM email_addresses ea LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = ‘Users’
AND ear.bean_id = ‘1’
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.00835704803467
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query:SELECT id FROM job_queue WHERE status=‘running’ AND date_modified <= ‘2015-10-19 12:49:01’
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.00204992294312
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query: SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod FROM schedulers LEFT JOIN users jt0 ON jt0.id=schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON schedulers.modified_user_id=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 where (schedulers.status=‘Active’ AND NOT EXISTS(SELECT id FROM job_queue WHERE scheduler_id=schedulers.id AND status!=‘done’)) AND schedulers.deleted=0
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.00714111328125
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] -----> Scheduler found [ 0 ] ACTIVE jobs
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Get One: |SELECT id FROM job_queue WHERE execute_time <= ‘2015-10-20 12:49:01’ AND status = ‘queued’ ORDER BY date_entered ASC|
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query:SELECT id FROM job_queue WHERE execute_time <= ‘2015-10-20 12:49:01’ AND status = ‘queued’ ORDER BY date_entered ASC LIMIT 0,1
Tue 20 Oct 2015 12:49:01 PM UTC [207032][1][INFO] Query Execution Time:0.00552988052368

NB. I have turned off all the default schedulers which come preinstalled with SuiteCRM and have not used the Workflow module.

Your help, as always, if appreciated.

Ray.

2

Hi raygrey,

From what I can gather here, due to the use of the [INFO] tag, It looks to me like these aren’t errors. It’s just PHP outputting, step by step, what is happening when it performs actions.

I suppose its main use would be for debugging, you can see what steps have completed up until the point where an error actually occurs.

Nothing to worry about!

If you’d like your log file to only log Fatal errors, you can change it in Admin > System Settings.
Change the Log level to"Fatal"

3

Yeah. the site seems to be working fine, so I’ll just change the log settings as per your recommendations… thanks