UTA Office of Finance and Administration - ERROR: invalid entry in resource_item for HEADING and RESOURCE_NAME... RESOURCE

DEBUG: DB Query failed in... = Query Failed in Resource_Item::templateSourcePath():
select distinct SOURCE_PATH, RESOURCE_ID, resource_resource_map.id_resource_2, resource_resource_map.display_priority as sortPriority, resource_item.heading as sortName from resource_resource_map inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id where resource_resource_map.id_resource_1 in () and resource_resource_map.id_role = 9 and resource_item.id_visibility=10 and resource_item.id_resource_type= 14 and (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_resource_map.DATE_END_EFFECTIVE is null)) and (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_item.DATE_END_EFFECTIVE is null)) order by sortPriority desc, sortName
$newSqlString: select distinct SOURCE_PATH, RESOURCE_ID, resource_resource_map.id_resource_2, resource_resource_map.display_priority as sortPriority, resource_item.heading as sortName from resource_resource_map inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id where resource_resource_map.id_resource_1 in () and resource_resource_map.id_role = 9 and resource_item.id_visibility=10 and resource_item.id_resource_type= 14 and (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_resource_map.DATE_END_EFFECTIVE is null)) and (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_item.DATE_END_EFFECTIVE is null)) order by sortPriority desc, sortName

ORA-00936: missing expression

select distinct SOURCE_PATH, RESOURCE_ID,  resource_resource_map.id_resource_2,  resource_resource_map.display_priority as sortPriority,  resource_item.heading as sortName  from resource_resource_map  inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id  where resource_resource_map.id_resource_1 in ()  and resource_resource_map.id_role = 9 and resource_item.id_visibility=10 and resource_item.id_resource_type= 14 and  (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_resource_map.DATE_END_EFFECTIVE is null))  and  (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_item.DATE_END_EFFECTIVE is null))  order by sortPriority desc, sortName
                                                                                                                                                                                                                                                                                                                                                    ^

Template Not Found

UTA Office of Finance and Administration - ERROR: invalid entry in resource_item for HEADING and RESOURCE_NAME... RESOURCE_ID=
DEBUG: DB Query failed in... = Resource_Item::loadDepartmentID()
$newSqlString: select id_dept from dept_resource_map where ID_ROLE = 2 and ID_RESOURCE = and (DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (DATE_END_EFFECTIVE is null))

ORA-00936: missing expression

select id_dept from dept_resource_map where ID_ROLE = 2 and ID_RESOURCE =  and  (DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (DATE_END_EFFECTIVE is null)) 
                                                                                    ^

DEBUG: DB Query failed in... = Resource_Navigation::parentCatID()
$newSqlString: select distinct RESOURCE_ID, resource_resource_map.id_resource_1, resource_resource_map.display_priority as sortPriority, resource_item.heading as sortName from resource_resource_map inner join resource_item on resource_resource_map.id_resource_1 = resource_item.resource_id where resource_resource_map.id_resource_2 in () and resource_resource_map.id_role = 2 and resource_item.id_visibility=10 and resource_item.id_resource_type= 5 and (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_resource_map.DATE_END_EFFECTIVE is null)) and (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_item.DATE_END_EFFECTIVE is null)) order by sortPriority desc, sortName

ORA-00936: missing expression

select distinct RESOURCE_ID,  resource_resource_map.id_resource_1,  resource_resource_map.display_priority as sortPriority,  resource_item.heading as sortName  from resource_resource_map  inner join resource_item on resource_resource_map.id_resource_1 = resource_item.resource_id  where resource_resource_map.id_resource_2 in ()  and resource_resource_map.id_role = 2 and resource_item.id_visibility=10 and resource_item.id_resource_type= 5 and  (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_resource_map.DATE_END_EFFECTIVE is null))  and  (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_item.DATE_END_EFFECTIVE is null))  order by sortPriority desc, sortName
                                                                                                                                                                                                                                                                                                                                       ^

DEBUG: DB Query failed in... = /opt/www/policy.uta.edu/Includes/common_database.php
$newSqlString: select distinct RESOURCE_ID, resource_resource_map.id_resource_2, resource_resource_map.display_priority as sortPriority, resource_item.heading as sortName from resource_resource_map inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id where resource_resource_map.id_resource_1 in () and resource_resource_map.id_role = 2 and resource_item.id_visibility=10 and resource_item.id_resource_type= 21 and (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_resource_map.DATE_END_EFFECTIVE is null)) and (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_item.DATE_END_EFFECTIVE is null)) order by sortPriority desc, sortName

ORA-00936: missing expression

select distinct RESOURCE_ID,  resource_resource_map.id_resource_2,  resource_resource_map.display_priority as sortPriority,  resource_item.heading as sortName  from resource_resource_map  inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id  where resource_resource_map.id_resource_1 in ()  and resource_resource_map.id_role = 2 and resource_item.id_visibility=10 and resource_item.id_resource_type= 21 and  (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_resource_map.DATE_END_EFFECTIVE is null))  and  (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_item.DATE_END_EFFECTIVE is null))  order by sortPriority desc, sortName
                                                                                                                                                                                                                                                                                                                                       ^

DEBUG: DB Query failed in... = Resource_Item::loadAttributes()
$newSqlString: select ID_ATTRIBUTE, DISPLAY_PRIORITY from RESOURCE_ATTRIBUTE_MAP where ID_RESOURCE = and (DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (DATE_END_EFFECTIVE is null))

ORA-00936: missing expression

select ID_ATTRIBUTE, DISPLAY_PRIORITY from RESOURCE_ATTRIBUTE_MAP 
			where ID_RESOURCE =  and  (DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (DATE_END_EFFECTIVE is null)) 
                                                                                           ^

select ID_ATTRIBUTE, DISPLAY_PRIORITY from RESOURCE_ATTRIBUTE_MAP 
			where ID_RESOURCE =  and  (DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (DATE_END_EFFECTIVE is null)) 
                                                                                           ^

select ID_ATTRIBUTE, DISPLAY_PRIORITY from RESOURCE_ATTRIBUTE_MAP 
			where ID_RESOURCE =  and  (DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (DATE_END_EFFECTIVE is null)) 
                                                                                           ^

Faculty/Staff Calendar

AP/Travel Support Documentation Deadline

6/19/2009 5:00pm: Money Matters

Get Organized: Keys to Everyday Office Success (8)

6/25/2009 2:00pm: Training

ProCard Documents

6/25/2009 5:00pm: Money Matters

AP/Travel Support Documentation Deadline

6/26/2009 5:00pm: Money Matters

Powerful Presentation Skills (AP)

6/30/2009 9:00am: Training

Full Calendar...

DEBUG: DB Query failed in... = Resource_Item::deptsWithRelationship()
$newSqlString: select distinct RESOURCE_ID, resource_resource_map.id_resource_2, resource_resource_map.display_priority as sortPriority, resource_item.heading as sortName from resource_resource_map inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id where resource_resource_map.id_resource_1 in () and resource_resource_map.id_role = 26 and resource_item.id_visibility=10 and resource_item.id_resource_type= 5 and (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_resource_map.DATE_END_EFFECTIVE is null)) and (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp)) and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) or (resource_item.DATE_END_EFFECTIVE is null)) order by sortPriority desc, sortName

ORA-00936: missing expression

select distinct RESOURCE_ID,  resource_resource_map.id_resource_2,  resource_resource_map.display_priority as sortPriority,  resource_item.heading as sortName  from resource_resource_map  inner join resource_item on resource_resource_map.id_resource_2 = resource_item.resource_id  where resource_resource_map.id_resource_1 in ()  and resource_resource_map.id_role = 26 and resource_item.id_visibility=10 and resource_item.id_resource_type= 5 and  (resource_resource_map.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_resource_map.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_resource_map.DATE_END_EFFECTIVE is null))  and  (resource_item.DATE_START_EFFECTIVE <= cast(SYSDATE as timestamp))
			and (resource_item.DATE_END_EFFECTIVE > cast(SYSDATE as timestamp) 
			or (resource_item.DATE_END_EFFECTIVE is null))  order by sortPriority desc, sortName
                                                                                                                                                                                                                                                                                                                                       ^