Career Solutions

Application Log
Timestamp Level Category Message
04:21:26.385169 trace system.CModule
Loading "log" application component
in /var/www/html/careerbd/index.php (15)
04:21:26.385276 trace system.CModule
Loading "request" application component
in /var/www/html/careerbd/index.php (15)
04:21:26.385338 trace system.CModule
Loading "urlManager" application component
in /var/www/html/careerbd/protected/components/HttpRequest.php (11)
in /var/www/html/careerbd/index.php (15)
04:21:26.385668 trace system.CModule
Loading "themeManager" application component
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.385811 trace system.db.ar.CActiveRecord
Category.findByPk()
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.385835 trace system.CModule
Loading "db" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.385878 trace system.db.CDbConnection
Opening DB connection
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.386358 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_category`
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.386826 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_category`
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.386981 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_category` `t` WHERE `t`.`id`=11 LIMIT 1
in /var/www/html/careerbd/protected/views/preferable/view.php (13)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387171 trace system.CModule
Loading "user" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387217 trace system.CModule
Loading "session" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387315 trace system.db.CDbCommand
Executing SQL: DELETE FROM `yii_sessions` WHERE expire<:expire. Bound with
:expire=1537654886
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387552 trace system.db.CDbCommand
Querying SQL: SELECT `data`
FROM `yii_sessions`
WHERE expire>:expire AND id=:id. Bound with :expire=1537654886,
:id='l3ahmk6ukru846g9fnrp7g0601'
in /var/www/html/careerbd/protected/views/preferable/view.php (15)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387742 trace system.CModule
Loading "widgetFactory" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387850 trace system.db.ar.CActiveRecord
JobAgent.count()
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.387918 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_job_agent`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.388439 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_job_agent`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.388708 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobseeker`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.389240 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobseeker`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.389463 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_jobseeker_seeting`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.389827 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_jobseeker_seeting`
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.389941 trace system.db.ar.CActiveRecord
JobAgent.count() eagerly
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.390072 trace system.db.CDbCommand
Querying SQL: SELECT COUNT(*) FROM (SELECT DISTINCT `t`.`id` AS `t0_c0`,
`t`.`jobseeker_id` AS `t0_c1`, `t`.`agent_name` AS `t0_c2`,
`t`.`agent_desc` AS `t0_c3`, `t`.`keyword` AS `t0_c4`, `t`.`category_id` AS
`t0_c5`, `t`.`position_level` AS `t0_c6`, `t`.`employment_type` AS `t0_c7`,
`t`.`salary_min` AS `t0_c8`, `t`.`salary_max` AS `t0_c9`,
`t`.`is_apply_online` AS `t0_c10`, `t`.`is_apply_by_email` AS `t0_c11`,
`t`.`is_apply_hardcopy` AS `t0_c12`, `jobseeker`.`id` AS `t1_c0`,
`jobseeker`.`primary_email` AS `t1_c1`, `jobseeker`.`password` AS `t1_c2`,
`jobseeker`.`first_name` AS `t1_c3`, `jobseeker`.`last_name` AS `t1_c4`,
`jobseeker`.`student_id` AS `t1_c5`, `jobseeker`.`faculty` AS `t1_c6`,
`jobseeker`.`father_name` AS `t1_c7`, `jobseeker`.`mother_name` AS `t1_c8`,
`jobseeker`.`date_of_birth` AS `t1_c9`, `jobseeker`.`gender` AS `t1_c10`,
`jobseeker`.`marital_status` AS `t1_c11`, `jobseeker`.`photo_upload_date`
AS `t1_c12`, `jobseeker`.`photopath` AS `t1_c13`, `jobseeker`.`status` AS
`t1_c14`, `jobseeker`.`token` AS `t1_c15`, `jobseeker`.`create_date` AS
`t1_c16`, `setting`.`id` AS `t2_c0`, `setting`.`jobseeker_id` AS `t2_c1`,
`setting`.`privacy` AS `t2_c2` FROM `jb_job_agent` `t`  LEFT OUTER JOIN
`jb_jobseeker` `jobseeker` ON (`t`.`jobseeker_id`=`jobseeker`.`id`)  LEFT
OUTER JOIN `jb_jobseeker_seeting` `setting` ON
(`setting`.`jobseeker_id`=`jobseeker`.`id`)  WHERE (jobseeker.status=1 AND
setting.privacy=1 AND category_id =11 ) GROUP BY t.jobseeker_id) sq
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.414446 trace system.db.ar.CActiveRecord
JobAgent.findAll()
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.414676 trace system.db.CDbCommand
Querying SQL: SELECT DISTINCT `t`.`id` AS `t0_c0`, `t`.`jobseeker_id` AS
`t0_c1`, `t`.`agent_name` AS `t0_c2`, `t`.`agent_desc` AS `t0_c3`,
`t`.`keyword` AS `t0_c4`, `t`.`category_id` AS `t0_c5`,
`t`.`position_level` AS `t0_c6`, `t`.`employment_type` AS `t0_c7`,
`t`.`salary_min` AS `t0_c8`, `t`.`salary_max` AS `t0_c9`,
`t`.`is_apply_online` AS `t0_c10`, `t`.`is_apply_by_email` AS `t0_c11`,
`t`.`is_apply_hardcopy` AS `t0_c12`, `jobseeker`.`id` AS `t1_c0`,
`jobseeker`.`primary_email` AS `t1_c1`, `jobseeker`.`password` AS `t1_c2`,
`jobseeker`.`first_name` AS `t1_c3`, `jobseeker`.`last_name` AS `t1_c4`,
`jobseeker`.`student_id` AS `t1_c5`, `jobseeker`.`faculty` AS `t1_c6`,
`jobseeker`.`father_name` AS `t1_c7`, `jobseeker`.`mother_name` AS `t1_c8`,
`jobseeker`.`date_of_birth` AS `t1_c9`, `jobseeker`.`gender` AS `t1_c10`,
`jobseeker`.`marital_status` AS `t1_c11`, `jobseeker`.`photo_upload_date`
AS `t1_c12`, `jobseeker`.`photopath` AS `t1_c13`, `jobseeker`.`status` AS
`t1_c14`, `jobseeker`.`token` AS `t1_c15`, `jobseeker`.`create_date` AS
`t1_c16`, `setting`.`id` AS `t2_c0`, `setting`.`jobseeker_id` AS `t2_c1`,
`setting`.`privacy` AS `t2_c2` FROM `jb_job_agent` `t`  LEFT OUTER JOIN
`jb_jobseeker` `jobseeker` ON (`t`.`jobseeker_id`=`jobseeker`.`id`)  LEFT
OUTER JOIN `jb_jobseeker_seeting` `setting` ON
(`setting`.`jobseeker_id`=`jobseeker`.`id`)  WHERE (jobseeker.status=1 AND
setting.privacy=1 AND category_id =11 ) GROUP BY t.jobseeker_id LIMIT 12
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.432209 trace system.CModule
Loading "assetManager" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.432322 trace system.CModule
Loading "clientScript" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.432568 trace system.CModule
Loading "easyImage" application component
in /var/www/html/careerbd/protected/views/preferable/_view.php (16)
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
04:21:26.433235 trace system.CModule
Loading "coreMessages" application component
in /var/www/html/careerbd/protected/views/preferable/view.php (22)
in /var/www/html/careerbd/protected/controllers/PreferableController.php
(36)
in /var/www/html/careerbd/index.php (15)
04:21:26.433926 trace system.db.ar.CActiveRecord
JbTraining.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
04:21:26.433983 trace system.db.CDbCommand
Querying SQL: SHOW FULL COLUMNS FROM `jb_training`
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
04:21:26.434799 trace system.db.CDbCommand
Querying SQL: SHOW CREATE TABLE `jb_training`
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
04:21:26.435024 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE published=1 AND
feature_training=0 ORDER BY id DESC LIMIT 5
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (138)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
04:21:26.435642 trace system.db.ar.CActiveRecord
JbTraining.findAll()
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (157)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)
04:21:26.435687 trace system.db.CDbCommand
Querying SQL: SELECT * FROM `jb_training` `t` WHERE published=1 AND
feature_training=1 ORDER BY id DESC LIMIT 5
in /var/www/html/careerbd/themes/eusiajb/views/layouts/tpl_footer.php (157)
in /var/www/html/careerbd/themes/abound/views/layouts/tpl_footer.php (58)
in /var/www/html/careerbd/themes/abound/views/layouts/main.php (194)