|
When: 2008-11-21 13:43:05 (MST)
Script: /data/web_content/production/include/db.php:119
Message: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at end of input at character 70parameter: dbConnection
value: Resource id #14 | parameter: sql
value: select hr.companyid, hr.name from hrCompanies hr where hr.companyid= | parameter: debug
value: 0 | parameter: profile
value: 0 |
|
|
|
When: 2008-11-21 13:43:05 (MST)
Script: /data/web_content/production/include/db.php:149
Message: pg_fetch_row() expects parameter 1 to be resource, boolean givenparameter: dbQuery
value: | parameter: row
value: 0 |
|
|
|
When: 2008-11-21 13:43:05 (MST)
Script: /data/web_content/production/include/db.php:119
Message: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at end of input at character 46parameter: dbConnection
value: Resource id #14 | parameter: sql
value: select name from hrCompanies where companyid= | parameter: debug
value: 0 | parameter: profile
value: 0 |
|
|
|
When: 2008-11-21 13:43:05 (MST)
Script: /data/web_content/production/include/db.php:149
Message: pg_fetch_row() expects parameter 1 to be resource, boolean givenparameter: dbQuery
value: | parameter: row
value: 0 |
|
|
|
When: 2008-11-21 13:43:05 (MST)
Script: /data/web_content/production/include/db.php:119
Message: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at or near "and" at character 510parameter: dbConnection
value: Resource id #14 | parameter: sql
value: select jp.jobid, jp.title,i.title, jp.city ||', '|| jp.province ||', ' || jp.country as location, jp.startdate, jp.enddate, jps.jobstatcounter, jps2.jobstatcounter from jobpostings jp join industry i on i.industryid=jp.industry left outer join jobpostingstats jps on jps.jobid=jp.jobid and jps.jobstattype=1000 left outer join ( select jobid, sum(jobstatcounter) as jobstatcounter from jobpostingstats where jobstattype in (1001,1002,1003) group by jobid ) jps2 on jps2.jobid=jp.jobid where jp.companyid = and jp.startdate <= '2008-11-21 23:59:59' and jp.enddate >= '2008-11-21 00:00:00' order by jp.startdate | parameter: debug
value: 0 | parameter: profile
value: 0 |
|
|
| There is no jobs posted between 2008-11-21 00:00:00 and 2008-11-21 23:59:59 |
|
|
