The application has generated an error.
Exception Object
(
[message:protected] => The Query SELECT vra_location.ID AS ID, vra_location.internalID AS internalID, vra_location.coverimageID AS coverImageID, vra_location.name AS name, vra_location.type AS type, vra_location.description AS description, vra_location.description_source AS descriptionSource, vra_location.description_source_date AS descriptionSourceDate, vra_location.city AS city, vra_location.address1 AS address1, vra_location.address2 AS address2, vra_location.address3 AS address3, vra_location.county AS county, vra_location.country AS country, vra_location.postcode AS postcode, vra_location.website AS website, vra_location.umbrella_ID AS umbrellaID, vra_location.sectag AS HMSsecTag, vra_location.created_on AS HMSCreated, vra_location.last_updated AS HMSLastUpdated, vra_location.created_by AS HMSCreatedBy, vra_location.last_updated_by AS HMSLastUpdatedBy, vra_location.hits AS HMSHits FROM vra_location LEFT JOIN vra_locationxlocation ON vra_location.ID=vra_locationxlocation.vralocationID2 WHERE vra_location.ID IN (SELECT vra_locationxlocation.vralocationID1 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID2 = 25; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID1 = 25;) failed. Message: DB Error: syntax error
DebugInfo: SELECT vra_location.ID AS ID, vra_location.internalID AS internalID, vra_location.coverimageID AS coverImageID, vra_location.name AS name, vra_location.type AS type, vra_location.description AS description, vra_location.description_source AS descriptionSource, vra_location.description_source_date AS descriptionSourceDate, vra_location.city AS city, vra_location.address1 AS address1, vra_location.address2 AS address2, vra_location.address3 AS address3, vra_location.county AS county, vra_location.country AS country, vra_location.postcode AS postcode, vra_location.website AS website, vra_location.umbrella_ID AS umbrellaID, vra_location.sectag AS HMSsecTag, vra_location.created_on AS HMSCreated, vra_location.last_updated AS HMSLastUpdated, vra_location.created_by AS HMSCreatedBy, vra_location.last_updated_by AS HMSLastUpdatedBy, vra_location.hits AS HMSHits FROM vra_location LEFT JOIN vra_locationxlocation ON vra_location.ID=vra_locationxlocation.vralocationID2 WHERE vra_location.ID IN (SELECT vra_locationxlocation.vralocationID1 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID2 = 25; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID1 = 25;) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_l' at line 1]
UserInfo: SELECT vra_location.ID AS ID, vra_location.internalID AS internalID, vra_location.coverimageID AS coverImageID, vra_location.name AS name, vra_location.type AS type, vra_location.description AS description, vra_location.description_source AS descriptionSource, vra_location.description_source_date AS descriptionSourceDate, vra_location.city AS city, vra_location.address1 AS address1, vra_location.address2 AS address2, vra_location.address3 AS address3, vra_location.county AS county, vra_location.country AS country, vra_location.postcode AS postcode, vra_location.website AS website, vra_location.umbrella_ID AS umbrellaID, vra_location.sectag AS HMSsecTag, vra_location.created_on AS HMSCreated, vra_location.last_updated AS HMSLastUpdated, vra_location.created_by AS HMSCreatedBy, vra_location.last_updated_by AS HMSLastUpdatedBy, vra_location.hits AS HMSHits FROM vra_location LEFT JOIN vra_locationxlocation ON vra_location.ID=vra_locationxlocation.vralocationID2 WHERE vra_location.ID IN (SELECT vra_locationxlocation.vralocationID1 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID2 = 25; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID1 = 25;) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_l' at line 1]
[string:private] =>
[code:protected] => 0
[file:protected] => /var/www/adatabase2/adatabase/modules/hmsdb/class.hmsdb.php
[line:protected] => 207
[trace:private] => Array
(
[0] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/dataobject/class.dataobjectmanager.php
[line] => 855
[function] => query
[class] => hmsDB
[type] => ->
[args] => Array
(
[0] => SELECT vra_location.ID AS ID, vra_location.internalID AS internalID, vra_location.coverimageID AS coverImageID, vra_location.name AS name, vra_location.type AS type, vra_location.description AS description, vra_location.description_source AS descriptionSource, vra_location.description_source_date AS descriptionSourceDate, vra_location.city AS city, vra_location.address1 AS address1, vra_location.address2 AS address2, vra_location.address3 AS address3, vra_location.county AS county, vra_location.country AS country, vra_location.postcode AS postcode, vra_location.website AS website, vra_location.umbrella_ID AS umbrellaID, vra_location.sectag AS HMSsecTag, vra_location.created_on AS HMSCreated, vra_location.last_updated AS HMSLastUpdated, vra_location.created_by AS HMSCreatedBy, vra_location.last_updated_by AS HMSLastUpdatedBy, vra_location.hits AS HMSHits FROM vra_location LEFT JOIN vra_locationxlocation ON vra_location.ID=vra_locationxlocation.vralocationID2 WHERE vra_location.ID IN (SELECT vra_locationxlocation.vralocationID1 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID2 = 25; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID1 = 25;)
)
)
[1] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/dataobject/class.relatedobjectmanager.php
[line] => 576
[function] => runSQL
[class] => dataobjectmanager
[type] => ->
[args] => Array
(
[0] => Array
(
[title] => Related object query (m:m) vralocation for vralocation
[from] => vra_location
[select] => vra_location.ID AS ID, vra_location.internalID AS internalID, vra_location.coverimageID AS coverImageID, vra_location.name AS name, vra_location.type AS type, vra_location.description AS description, vra_location.description_source AS descriptionSource, vra_location.description_source_date AS descriptionSourceDate, vra_location.city AS city, vra_location.address1 AS address1, vra_location.address2 AS address2, vra_location.address3 AS address3, vra_location.county AS county, vra_location.country AS country, vra_location.postcode AS postcode, vra_location.website AS website, vra_location.umbrella_ID AS umbrellaID, vra_location.sectag AS HMSsecTag, vra_location.created_on AS HMSCreated, vra_location.last_updated AS HMSLastUpdated, vra_location.created_by AS HMSCreatedBy, vra_location.last_updated_by AS HMSLastUpdatedBy, vra_location.hits AS HMSHits
[where] => vra_location.ID IN (SELECT vra_locationxlocation.vralocationID1 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID2 = 25; UNION SELECT vra_locationxlocation.vralocationID2 AS vralocationID1 FROM vra_locationxlocation WHERE vra_locationxlocation.vralocationID1 = 25;)
[join] => Array
(
[0] => LEFT JOIN vra_locationxlocation ON vra_location.ID=vra_locationxlocation.vralocationID2
)
)
)
)
[2] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/dataobject/class.dataobject.php
[line] => 1731
[function] => populate
[class] => relatedobjectmanager
[type] => ->
[args] => Array
(
[0] => 1
[1] => Array
(
[0] => vra.vralocation::vra.vrawork
[1] => vra.vralocation::vra.vraagent
[2] => vra.vralocation::vra.vraevent
[3] => vra.vralocation::vra.vralocation
[4] => vra.vralocation::asset.archive
[5] => vra.vralocation::asset.image
)
[2] => 1
)
)
[3] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/dataobject/class.dataobject.php
[line] => 715
[function] => populateRelatedObjects
[class] => dataobject
[type] => ->
[args] => Array
(
[0] => 1
[1] => Array
(
[0] => vra.vralocation::vra.vrawork
[1] => vra.vralocation::vra.vraagent
[2] => vra.vralocation::vra.vraevent
[3] => vra.vralocation::vra.vralocation
[4] => vra.vralocation::asset.archive
[5] => vra.vralocation::asset.image
)
[2] => 1
)
)
[4] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/dataobject/class.dataobjectmanager.php
[line] => 642
[function] => populate
[class] => dataobject
[type] => ->
[args] => Array
(
[0] => 1
[1] => Array
(
[0] => vra.vralocation::vra.vrawork
[1] => vra.vralocation::vra.vraagent
[2] => vra.vralocation::vra.vraevent
[3] => vra.vralocation::vra.vralocation
[4] => vra.vralocation::asset.archive
[5] => vra.vralocation::asset.image
)
[2] => 1
)
)
[5] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/objectui/class.objectui.php
[line] => 98
[function] => genericGet
[class] => dataobjectmanager
[type] => ->
[args] => Array
(
[0] => vralocation
[1] => 25;
[2] => 1
[3] => Array
(
[0] => vra.vralocation::vra.vrawork
[1] => vra.vralocation::vra.vraagent
[2] => vra.vralocation::vra.vraevent
[3] => vra.vralocation::vra.vralocation
[4] => vra.vralocation::asset.archive
[5] => vra.vralocation::asset.image
)
[4] => 1
)
)
[6] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/objectui/inc.objectui.php
[line] => 23
[function] => __construct
[class] => objectui
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/modulemanager/class.modulemanager.php
[line] => 532
[args] => Array
(
[0] => /var/www/adatabase2/adatabase/modules/objectui/inc.objectui.php
)
[function] => require_once
)
[8] => Array
(
[file] => /var/www/adatabase2/adatabase/modules/modulemanager/class.modulemanager.php
[line] => 345
[function] => loadModule
[class] => moduleManager
[type] => ->
[args] => Array
(
[0] => objectui
[1] => objectui
[2] => objectui/inc.objectui.php
)
)
[9] => Array
(
[file] => /var/www/adatabase2/adatabase/public_html/index.php
[line] => 37
[function] => useModule
[class] => moduleManager
[type] => ->
[args] => Array
(
[0] => objectui
)
)
)
)
Array
(
[_files] => Array
(
[/var/www/adatabase2/adatabase/config/modules/config.ini] => 1227397428
[/var/www/adatabase2/adatabase/projects/adatabase/config/modules/default.ini] => 1227397428
[/var/www/adatabase2/adatabase/projects/adatabase/config/modules/modulemanager.ini] => 1227397428
[/var/www/adatabase2/adatabase/projects/adatabase/config/modules/logger.ini] => 1227397428
[/var/www/adatabase2/adatabase/projects/adatabase/config/modules/objectui.ini] => 1227397428
[/var/www/adatabase2/adatabase/config/modules/vra.ini] => 1227397428
[/var/www/adatabase2/adatabase/projects/adatabase/config/modules/asset.ini] => 1227397428
[/var/www/adatabase2/adatabase/projects/adatabase/config/modules/hmsdb.ini] => 1227397428
)
[rooturl] => http://archive.fact.co.uk/
[project] => adatabase
[user] =>
[default] => Array
(
[general] => Array
(
[name] => Default project name
[code] => default project code
[url] => home page url
)
[contact] => Array
(
[name] => Default contact name
[postion] => Default contact position
[postal] => Default postal address
[phone] => Default contact phone
[fax] => Default contact fax
[e-mail] => Default contact e-mail
)
[system] => Array
(
[os] => linux
[webserver] => apache
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[charset] => utf8
)
[classmap] => Array
(
[directory] => /tmp
[prefix] => HMS
)
[paths] => Array
(
[temp] =>
[cache] =>
[xls] =>
[webgraphics] =>
)
[apps] => Array
(
[ziptype] => gzip
[zipdir] =>
[imdir] =>
)
[config] => Array
(
[project] =>
[user] =>
)
)
[modulemanager] => Array
(
[default] => Array
(
[LoadModules] => login,trailmanager
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[installID] =>
[replicaID] =>
)
)
[logger] => Array
(
[general] => Array
(
[type] => file
[level] => 5
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[table] => log
[installID] =>
[replicaID] =>
)
[file] => Array
(
[filename] => /tmp/adatabase.log
[delimiter] =>
[eol] =>
)
)
[objectui] => Array
(
[allowedPatterns] => Array
(
[vra.vrawork] => vra.vrawork::vra.vraagent,vra.vraagent,vra.vraevent,asset.archive,asset.image,vra.vracollection,vra.vralocation,asset.video
[vra.vraagent] => vra.vrawork::vra.vraagent,vra.vraagent,vra.vraevent,vra.vralocation,asset.archive,asset.image
[vra.vraevent] => vra.vrawork::vra.vraagent,vra.vraagent,vra.vraevent,vra.vralocation,asset.archive,asset.image
[vra.vralocation] => vra.vrawork,vra.vraagent,vra.vraevent,vra.vralocation,asset.archive,asset.image
[vra.vracollection] => vra.vrawork,vra.vracollection
[asset.image] => vra.vrawork::vra.vraagent,vra.vraagent,vra.vraevent,vra.vralocation
[asset.archive] => vra.vrawork::vra.vraagent,vra.vraagent,vra.vraevent,vra.vralocation
[asset.video] => vra.vrawork::vra.vraagent
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[installID] =>
[replicaID] =>
)
)
[vra] => Array
(
[displaydate] => Array
(
[day] => j
month=F
year=Y
seperator=
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[installID] =>
[replicaID] =>
)
)
[objectconfigfiles] => Array
(
[vra] => /var/www/adatabase2/adatabase/projects/adatabase/config/objects/vra.xml
[asset] => /var/www/adatabase2/adatabase/projects/adatabase/config/objects/asset.xml
)
[asset] => Array
(
[exif] => Array
(
[extract] => 1
[tags] => IsColor,CCDWidth,ExposureTime,ApertureFNumber,Make,Model,ISOSpeedRatings,DateTime,ShutterSpeedValue,ApertureValue,BrightnessValue,ExposureBiasValue,Flash,FocalLength,Quality,COMMENT,UserComment,Copyright,Sharpness
)
[thumbnails] => Array
(
[path] => /var/www/assets/thumbnails/
[url] => http://archive.fact.co.uk/assets/thumbnails/
[format] => jpg
[quality] => 70
[size] => 125
)
[images] => Array
(
[path] => /var/www/assets/
)
[surrogates] => Array
(
[path] => /var/www/assets/surrogates/
[url] => http://archive.fact.co.uk/assets/surrogates/
[format] => jpg
[quality] => 70
[size] => 400
)
[video] => Array
(
[path] => /var/www/assets/flv/
[url] => http://archive.fact.co.uk/assets/flv/
[format] => flv
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[installID] =>
[replicaID] =>
)
)
[hmsdb] => Array
(
[connect] => Array
(
[phptype] => mysqli
[username] => webuser2
[password] => secureme
[hostspec] => 195.74.122.210
[database] => spatial_test
)
[options] => Array
(
[debug] => 5
[portability] => 0
)
[db] => Array
(
[dsn] => **DSN REMOVED**
[installID] =>
[replicaID] =>
)
)
)
Array
(
[default] => NULL
[modulemanager] => NULL
[logger] => NULL
[objectui] => NULL
[vra] => Array
(
[vrawork] => Array
(
[coretable] => vra_work
[tables] => Array
(
[vra_work] => Array
(
[ID] => ID
[internalID] => internalID
[coverImageID] => coverimageID
[type] => type
[title] => title
[relation] => relation
[copyright] => copyright
[source] => source
[state] => state
[stylePeriod] => styleperiod
[subject] => subject
[series] => series
[technique] => technique
[textReference] => text_ref
[storageLocation] => storage_loc
[storageLocationID] => storage_locID
[value] => value
[permanentLocation] => permanent_loc
[loanStatus] => loan_status
[loanLocation] => loan_loc
[loanDuration] => loan_dur
[materialDisplay] => materialdisplay
[measurementDisplay] => measurementdisplay
[dateDisplay] => datedisplay
[stateType] => state_type
[stateNum] => state_num
[stateCount] => state_count
[stateDisplay] => state_display
[stateDescription] => state_description
[framed] => framed
[purchasePrice] => purchase_price
[workCondition] => work_condition
[provenance] => provenance
[exhibitionHistory] => exhibition_history
[literature] => literature
[inHomepage] => in_homepage
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
)
[orbit] => Array
(
[ID] => Array
(
[label] => Work ID
)
[internalID] => Array
(
[label] => Internal Reference ID
)
[stylePeriod] => Array
(
[label] => Style Period
)
[textReference] => Array
(
[label] => Text Reference
)
[storageLocation] => Array
(
[label] => Storage Location
)
[storageLocationID] => Array
(
[label] => Storage Location ID
)
[value] => Array
(
[label] => Insurance Value/Currency/Date
)
[permanentLocation] => Array
(
[label] => Permanent Location
)
[loanStatus] => Array
(
[label] => Loan Status
)
[loanLocation] => Array
(
[label] => Loan Location
)
[loanDuration] => Array
(
[label] => Loan Duration
)
[dateDisplay] => Array
(
[label] => Date
)
[stateType] => Array
(
[label] => State Type
)
[stateNum] => Array
(
[label] => State Number
)
[stateCount] => Array
(
[label] => State Count
)
[stateDisplay] => Array
(
[label] => State Display
)
[stateDescription] => Array
(
[label] => State Description
)
[purchasePrice] => Array
(
[label] => Purchase Price/Currency/Date
)
[workCondition] => Array
(
[label] => Work Condition
)
[exhibitionHistory] => Array
(
[label] => Exhibition History
)
)
[primarykeys] => Array
(
[vra_work] => ID
)
[uniqueFields] => Array
(
[vra_work] => Array
(
[internalID] => 1
)
)
[secenable] => 1
[workflowenabled] => 1
[related] => Array
(
[vraworkdescription] => Array
(
[on] => vraworkID
[type] => 1:m
[as] => object
[module] => vra
[var] => relDescriptions
[cascade] => 1
)
[vrameasurement] => Array
(
[on] => vraworkID
[type] => 1:m
[skeleton] => 1
[as] => object
[module] => vra
[var] => relMeasurements
[cascade] => 1
)
[vramaterial] => Array
(
[on] => vraworkID
[type] => 1:m
[as] => object
[module] => vra
[var] => relMaterials
[cascade] => 1
)
[vrainscription] => Array
(
[on] => vraworkID
[type] => 1:m
[skeleton] => 1
[as] => object
[module] => vra
[var] => relInscriptions
[cascade] => 1
)
[vraworkdate] => Array
(
[on] => vraworkID
[type] => 1:m
[skeleton] => 1
[as] => object
[module] => vra
[var] => relDates
[cascade] => 1
)
[vraworkcomment] => Array
(
[on] => vraworkID
[type] => 1:m
[as] => object
[module] => vra
[var] => relComments
[cascade] => 1
)
[vraagent] => Array
(
[on] => vraworkID
[type] => m:m
[module] => vra
[var] => relAgents
[xlink] => vra_workxagent
[xlinkfields] => Array
(
[roleID] => vraroleID
)
[relatedfield] => vraagentID
)
[image] => Array
(
[on] => workID
[type] => m:m
[module] => asset
[var] => relImages
[xlink] => vra_workximage
[relatedfield] => assetID
)
[archive] => Array
(
[on] => workID
[type] => m:m
[module] => asset
[var] => relArchives
[xlink] => vra_workxarchive
[relatedfield] => assetID
)
[video] => Array
(
[on] => workID
[type] => m:m
[module] => asset
[var] => relVideos
[xlink] => vra_workxvideo
[relatedfield] => assetID
)
[vrawork] => Array
(
[on] => vraworkID1
[type] => m:m
[module] => vra
[var] => relWorks
[selfReferencing] => true
[xlink] => vra_workxwork
[xlinkfields] => Array
(
[relationID] => vrarelationID
)
[relatedfield] => vraworkID2
)
[vraevent] => Array
(
[on] => vraworkID
[type] => m:m
[module] => vra
[var] => relEvents
[limit] => 20
[xlink] => vra_workxevent
[relatedfield] => vraeventID
)
[vracollection] => Array
(
[on] => vraworkID
[type] => m:m
[module] => vra
[var] => relCollections
[limit] => 20
[xlink] => vra_workxcollection
[relatedfield] => vracollectionID
)
[vralocation] => Array
(
[on] => workID
[type] => m:m
[module] => vra
[var] => relLocations
[xlink] => vra_workxlocation
[relatedfield] => locationID
)
)
[lookup] => Array
(
[dropdown] => Array
(
[agentroleID] => SELECT ID AS 'key', label AS 'val' FROM dd_roletype ORDER BY label ASC
[workrelationID] => SELECT ID AS 'key', label AS 'val' FROM dd_work_relations ORDER BY label ASC
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => works
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
)
[vraworkdate] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_workdate] => Array
(
[ID] => ID
[workID] => vraworkID
[displayDate] => displaydate
[dateType] => datetype
[year] => year
[month] => month
[day] => day
)
)
[primarykeys] => Array
(
[vra_workdate] => ID
)
[foreignkeys] => Array
(
[vra_workdate] => vraworkID
)
[orbit] => Array
(
[dateType] => Array
(
[label] => Date Type
)
)
[lookup] => Array
(
[dropdown] => Array
(
[dateType_list] => SELECT ID AS 'key', label AS 'val' FROM dd_workdate_datetype ORDER BY ID ASC
[monthName_list] => SELECT ID AS 'key', label AS 'val' FROM dd_monthname_list ORDER BY ID ASC
[monthDay_list] => SELECT ID AS 'key', label AS 'val' FROM dd_monthday_list ORDER BY ID ASC
)
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
)
[coretable] => vra_workdate
)
[vraworkdescription] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_workdescription] => Array
(
[ID] => ID
[workID] => vraworkID
[description] => description
[source] => source
[sourceDate] => sourcedate
)
)
[primarykeys] => Array
(
[vra_workdescription] => ID
)
[foreignkeys] => Array
(
[vra_workdescription] => vraworkID
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
)
[coretable] => vra_workdescription
)
[vrainscription] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_inscription] => Array
(
[ID] => ID
[workID] => vraworkID
[text] => text
[author] => author
[position] => position
[type] => type
[inscription] => inscription
)
)
[primarykeys] => Array
(
[vra_inscription] => ID
)
[foreignkeys] => Array
(
[vra_inscription] => vraworkID
)
[orbit] => Array
(
[text] => Array
(
[label] => Inscription Text
)
)
[lookup] => Array
(
[dropdown] => Array
(
[texttype] => SELECT ID AS 'key', label AS 'val' FROM dd_workinscription_texttype ORDER BY ID ASC
)
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
)
[coretable] => vra_inscription
)
[vrameasurement] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_measurement] => Array
(
[ID] => ID
[workID] => vraworkID
[type] => type
[value] => value
[unit] => unit
[extent] => extent
[notes] => notes
)
)
[primarykeys] => Array
(
[vra_measurement] => ID
)
[foreignkeys] => Array
(
[vra_measurement] => vraworkID
)
[lookup] => Array
(
[dropdown] => Array
(
[type] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementtype ORDER BY sort_group DESC, label ASC
[unit] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit ORDER BY label ASC
[distance] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'distance' or dimension IS NULL ORDER BY sort_group DESC
[area] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'area' or dimension IS NULL ORDER BY sort_group DESC
[volume] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'volume' or dimension IS NULL ORDER BY sort_group DESC
[capacity] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'capacity' or dimension IS NULL ORDER BY sort_group DESC
[weight] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'weight' or dimension IS NULL ORDER BY sort_group DESC
[duration] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'duration' or dimension IS NULL ORDER BY sort_group DESC
[temperature] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'temperature' or dimension IS NULL ORDER BY sort_group DESC
[resolution] => SELECT ID AS 'key', label AS 'val' FROM dd_measurementunit WHERE dimension = 'resolution' or dimension IS NULL ORDER BY sort_group DESC
)
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
)
[coretable] => vra_measurement
)
[vramaterial] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_material] => Array
(
[ID] => ID
[workID] => vraworkID
[material] => material
[type] => type
[extent] => extent
[notes] => notes
)
)
[primarykeys] => Array
(
[vra_material] => ID
)
[foreignkeys] => Array
(
[vra_material] => vraworkID
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
)
[coretable] => vra_material
)
[vraworkcomment] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_workcomment] => Array
(
[ID] => ID
[workID] => vraworkID
[comment] => comment
[commentTime] => commented_on
[commentUser] => commented_by
[commentName] => commented_name
[commentIP] => commented_IP
)
)
[primarykeys] => Array
(
[vra_workcomment] => ID
)
[foreignkeys] => Array
(
[vra_workcomment] => vraworkID
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vrawork
[id] => Array
(
[attr] => workID
)
[edit] => 0
)
)
[coretable] => vra_workcomment
)
[vralocation] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_location] => Array
(
[ID] => ID
[internalID] => internalID
[coverImageID] => coverimageID
[name] => name
[type] => type
[description] => description
[descriptionSource] => description_source
[descriptionSourceDate] => description_source_date
[city] => city
[address1] => address1
[address2] => address2
[address3] => address3
[county] => county
[country] => country
[postcode] => postcode
[website] => website
[umbrellaID] => umbrella_ID
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
)
)
[orbit] => Array
(
[ID] => Array
(
[label] => Location ID
)
[internalID] => Array
(
[label] => Internal Reference ID
)
)
[primarykeys] => Array
(
[vra_location] => ID
)
[uniqueFields] => Array
(
[vra_location] => Array
(
[name] => 1
[city] => 1
)
)
[secenable] => 1
[related] => Array
(
[image] => Array
(
[on] => locationID
[type] => m:m
[module] => asset
[var] => relImages
[xlink] => vra_locationximage
[relatedfield] => assetID
)
[archive] => Array
(
[on] => locationID
[type] => m:m
[module] => asset
[var] => relArchives
[xlink] => vra_locationxarchive
[relatedfield] => assetID
)
[vralocation] => Array
(
[on] => vralocationID1
[type] => m:m
[module] => vra
[var] => relLocations
[selfReferencing] => true
[xlink] => vra_locationxlocation
[relatedfield] => vralocationID2
)
[vrawork] => Array
(
[on] => locationID
[type] => m:m
[module] => vra
[var] => relWorks
[xlink] => vra_workxlocation
[relatedfield] => workID
)
[vraagent] => Array
(
[on] => locationID
[type] => m:m
[module] => vra
[var] => relAgents
[xlink] => vra_agentxlocation
[relatedfield] => agentID
)
[vraevent] => Array
(
[on] => vralocationID
[type] => m:m
[module] => vra
[var] => relEvents
[xlink] => vra_eventxlocation
[relatedfield] => vraeventID
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => locations
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vralocation
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
[coretable] => vra_location
)
[vraevent] => Array
(
[coretable] => vra_event
[tables] => Array
(
[vra_event] => Array
(
[ID] => ID
[internalID] => internalID
[coverImageID] => coverimageID
[name] => name
[year] => year
[dateDisplay] => displaydate
[description] => description
[descriptionSource] => description_source
[descriptionSourceDate] => description_source_date
[eventType] => eventtype
[eventSubType] => eventsubtype
[umbrellaID] => umbrella_ID
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
)
[orbit] => Array
(
[ID] => Array
(
[label] => Event ID
)
[internalID] => Array
(
[label] => Internal Reference ID
)
[dateDisplay] => Array
(
[label] => Display Date
)
[eventType] => Array
(
[label] => Type
)
[eventSubType] => Array
(
[label] => Subtype
)
)
[primarykeys] => Array
(
[vra_event] => ID
)
[uniqueFields] => Array
(
[vra_event] => Array
(
[name] => 1
[year] => 1
)
)
[secenable] => 1
[workflowenabled] => 1
[related] => Array
(
[vraeventdate] => Array
(
[on] => vraeventID
[type] => 1:m
[skeleton] => 1
[as] => object
[module] => vra
[var] => relDates
[cascade] => 1
)
[vraevent] => Array
(
[on] => vraeventID1
[type] => m:m
[module] => vra
[var] => relEvents
[selfReferencing] => true
[xlink] => vra_eventxevent
[relatedfield] => vraeventID2
)
[vraagent] => Array
(
[on] => vraeventID
[type] => m:m
[module] => vra
[var] => relAgents
[limit] => 20
[xlink] => vra_agentxevent
[xlinkfields] => Array
(
[roleID] => vraroleID
)
[relatedfield] => vraagentID
)
[vrawork] => Array
(
[on] => vraeventID
[type] => m:m
[module] => vra
[var] => relWorks
[limit] => 20
[xlink] => vra_workxevent
[relatedfield] => vraworkID
)
[image] => Array
(
[on] => eventID
[type] => m:m
[module] => asset
[var] => relImages
[xlink] => vra_eventximage
[relatedfield] => assetID
)
[archive] => Array
(
[on] => eventID
[type] => m:m
[module] => asset
[var] => relArchives
[xlink] => vra_eventxarchive
[relatedfield] => assetID
)
[vralocation] => Array
(
[on] => vraeventID
[type] => m:m
[module] => vra
[var] => relLocations
[xlink] => vra_eventxlocation
[relatedfield] => vralocationID
)
)
[lookup] => Array
(
[dropdown] => Array
(
[roleID] => SELECT ID AS 'key', label AS 'val' FROM dd_roletype ORDER BY label ASC
[eventType] => SELECT ID AS 'key', label AS 'val' FROM dd_eventtype
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => events
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vraevent
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
)
[vraagent] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_agent] => Array
(
[ID] => ID
[internalID] => internalID
[coverImageID] => coverimageID
[webpage] => webpage
[culture] => culture
[countryOfOrigin] => countryoforigin
[nationality] => nationality
[description] => description
[descriptionSource] => description_source
[descriptionSourceDate] => description_source_date
[displayName] => displayname
[address] => address
[contact] => contact
[type] => type
[profile] => profile
[profileSource] => profile_source
[profileSourceDate] => profile_source_date
[attribution] => attribution
[gender] => gender
[role] => role
[umbrellaID] => umbrella_ID
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
)
[orbit] => Array
(
[ID] => Array
(
[label] => Agent ID
)
[internalID] => Array
(
[label] => Internal Reference ID
)
[displayName] => Array
(
[label] => Name
)
[contact] => Array
(
[label] => Contact Information
)
[profile] => Array
(
[label] => Personal Profile
)
[profileSource] => Array
(
[label] => Personal Profile Source
)
[profileSourceDate] => Array
(
[label] => Personal Profile Source Date
)
[attribution] => Array
(
[label] => Attributions
)
[role] => Array
(
[label] => Principal Occupation
)
)
[primarykeys] => Array
(
[vra_agent] => ID
)
[uniqueFields] => Array
(
[vra_agent] => Array
(
[internalID] => 1
[displayname] => 1
)
)
[secenable] => 1
[workflowenabled] => 1
[related] => Array
(
[vraagentdate] => Array
(
[on] => vraagentID
[type] => 1:m
[skeleton] => 1
[as] => object
[module] => vra
[var] => relDates
[cascade] => 1
)
[vraagentbiography] => Array
(
[on] => vraagentID
[type] => 1:m
[autocreate] => 1
[as] => object
[module] => vra
[var] => relBiographies
[cascade] => 1
)
[vrawork] => Array
(
[on] => vraagentID
[type] => m:m
[module] => vra
[var] => relWorks
[limit] => 20
[xlink] => vra_workxagent
[xlinkfields] => Array
(
[roleID] => vraroleID
)
[relatedfield] => vraworkID
)
[vraagent] => Array
(
[on] => vraagentID1
[type] => m:m
[module] => vra
[var] => relAgents
[selfReferencing] => true
[xlink] => vra_agentxagent
[xlinkfields] => Array
(
[relationID] => vrarelationID
)
[relatedfield] => vraagentID2
)
[image] => Array
(
[on] => agentID
[type] => m:m
[module] => asset
[var] => relImages
[xlink] => vra_agentximage
[relatedfield] => assetID
)
[archive] => Array
(
[on] => agentID
[type] => m:m
[module] => asset
[var] => relArchives
[xlink] => vra_agentxarchive
[relatedfield] => assetID
)
[vraevent] => Array
(
[on] => vraagentID
[type] => m:m
[module] => vra
[var] => relEvents
[limit] => 20
[xlink] => vra_agentxevent
[xlinkfields] => Array
(
[roleID] => vraroleID
)
[relatedfield] => vraeventID
)
[vralocation] => Array
(
[on] => agentID
[type] => m:m
[module] => vra
[var] => relLocations
[xlink] => vra_agentxlocation
[relatedfield] => locationID
)
)
[lookup] => Array
(
[dropdown] => Array
(
[roleID] => SELECT ID AS 'key', label AS 'val' FROM dd_roletype ORDER BY label ASC
[type] => SELECT ID AS 'key', value AS 'val' FROM dd_agenttype
[relationID] => SELECT ID AS 'key', label AS 'val' FROM dd_agent_relations ORDER BY label ASC
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => agents
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vraagent
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
[coretable] => vra_agent
)
[vraagentdate] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_agentdate] => Array
(
[ID] => ID
[agentID] => vraagentID
[displayDate] => displaydate
[dateType] => datetype
[year] => year
[month] => month
[day] => day
)
)
[primarykeys] => Array
(
[vra_agentdate] => ID
)
[foreignkeys] => Array
(
[vra_agentdate] => vraagentID
)
[orbit] => Array
(
[dateType] => Array
(
[label] => Type
)
)
[uniqueFields] => Array
(
[vra_agentdate] => Array
(
[datetype] => 1
[year] => 1
)
)
[lookup] => Array
(
[dropdown] => Array
(
[dateType_list] => SELECT ID AS 'key', label AS 'val' FROM dd_agentdate_datetype ORDER BY ID ASC
[monthName_list] => SELECT ID AS 'key', label AS 'val' FROM dd_monthname_list ORDER BY ID ASC
[monthDay_list] => SELECT ID AS 'key', label AS 'val' FROM dd_monthday_list ORDER BY ID ASC
)
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vraagent
[id] => Array
(
[attr] => agentID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vraagent
[id] => Array
(
[attr] => agentID
)
[edit] => 1
)
)
[coretable] => vra_agentdate
)
[vraagentbiography] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_agentbiography] => Array
(
[ID] => ID
[agentID] => vraagentID
[biography] => biography
[source] => source
[sourceDate] => sourcedate
)
)
[primarykeys] => Array
(
[vra_agentbiography] => ID
)
[foreignkeys] => Array
(
[vra_agentbiography] => vraagentID
)
[orbit] => Array
(
[source] => Array
(
[label] => Biography Source
)
[sourceDate] => Array
(
[label] => Biography Source Date
)
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vraagent
[id] => Array
(
[attr] => agentID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vraagent
[id] => Array
(
[attr] => agentID
)
[edit] => 1
)
)
[coretable] => vra_agentbiography
)
[vraeventdate] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[vra_eventdate] => Array
(
[ID] => ID
[eventID] => vraeventID
[displayDate] => displaydate
[year] => year
[month] => month
[day] => day
[dateType] => datetype
)
)
[primarykeys] => Array
(
[vra_eventdate] => ID
)
[orbit] => Array
(
[dateType] => Array
(
[label] => Type
)
)
[lookup] => Array
(
[dropdown] => Array
(
[dateType_list] => SELECT ID AS 'key', label AS 'val' FROM dd_eventdate_datetype ORDER BY ID ASC
[monthName_list] => SELECT ID AS 'key', label AS 'val' FROM dd_monthname_list ORDER BY ID ASC
[monthDay_list] => SELECT ID AS 'key', label AS 'val' FROM dd_monthday_list ORDER BY ID ASC
)
)
[redirect] => Array
(
[delete] => Array
(
[moduleName] => objectui
[type] => vra.vraevent
[id] => Array
(
[attr] => eventID
)
[edit] => 1
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vraevent
[id] => Array
(
[attr] => eventID
)
[edit] => 1
)
)
[coretable] => vra_eventdate
)
[vracollection] => Array
(
[coretable] => vra_collection
[tables] => Array
(
[vra_collection] => Array
(
[ID] => ID
[title] => title
[description] => description
[internalID] => internalID
[lastUpdated] => last_updated
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
)
[orbit] => Array
(
[ID] => Array
(
[label] => Collection ID
)
[internalID] => Array
(
[label] => Internal Reference ID
)
)
[primarykeys] => Array
(
[vra_collection] => ID
)
[secenable] => 1
[workflowenabled] => 1
[related] => Array
(
[vrawork] => Array
(
[on] => vracollectionID
[type] => m:m
[module] => vra
[var] => relWorks
[limit] => 1
[xlink] => vra_workxcollection
[relatedfield] => vraworkID
)
[vracollection] => Array
(
[on] => vracollectionID1
[type] => m:m
[module] => vra
[var] => relCollections
[selfReferencing] => true
[xlink] => vra_collectionxcollection
[xlinkfields] => Array
(
[masterID] => vracollectionID1
[pupilID] => vracollectionID2
)
[relatedfield] => vracollectionID2
)
)
[lookup] => Array
(
[dropdown] => Array
(
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => collections
)
[save] => Array
(
[moduleName] => objectui
[type] => vra.vracollection
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
)
[vraddagentrelation] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[dd_agent_relations] => Array
(
[ID] => ID
[term] => label
)
)
[datatypes] => Array
(
[dd_agent_relations] => Array
(
[ID] => numeric
[label] => string
)
)
[primarykeys] => Array
(
[dd_agent_relations] => ID
)
[redirect] => Array
(
[save] => Array
(
[moduleName] => lister
[type] => dd_agent_relations
)
[delete] => Array
(
[moduleName] => lister
[type] => dd_agent_relations
)
)
[coretable] => dd_agent_relations
)
[vraddworkrelation] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[dd_work_relations] => Array
(
[ID] => ID
[term] => label
)
)
[datatypes] => Array
(
[dd_work_relations] => Array
(
[ID] => numeric
[label] => string
)
)
[primarykeys] => Array
(
[dd_work_relations] => ID
)
[redirect] => Array
(
[save] => Array
(
[moduleName] => lister
[type] => dd_work_relations
)
[delete] => Array
(
[moduleName] => lister
[type] => dd_work_relations
)
)
[coretable] => dd_work_relations
)
[vraddroletype] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[dd_roletype] => Array
(
[ID] => ID
[term] => label
)
)
[datatypes] => Array
(
[dd_roletype] => Array
(
[ID] => numeric
[label] => string
)
)
[primarykeys] => Array
(
[dd_roletype] => ID
)
[redirect] => Array
(
[save] => Array
(
[moduleName] => lister
[type] => dd_roletypes
)
[delete] => Array
(
[moduleName] => lister
[type] => dd_roletypes
)
)
[coretable] => dd_roletype
)
[vraddworkdatetype] => Array
(
[secondarytables] => Array
(
)
[tables] => Array
(
[dd_workdate_datetype] => Array
(
[ID] => ID
[term] => label
)
)
[datatypes] => Array
(
[dd_workdate_datetype] => Array
(
[ID] => numeric
[label] => string
)
)
[primarykeys] => Array
(
[dd_workdate_datetype] => ID
)
[redirect] => Array
(
[save] => Array
(
[moduleName] => lister
[type] => dd_workdatetype
)
[delete] => Array
(
[moduleName] => lister
[type] => dd_workdatetype
)
)
[coretable] => dd_workdate_datetype
)
)
[asset] => Array
(
[asset] => Array
(
[coretable] => asset_core
[tables] => Array
(
[asset_core] => Array
(
[ID] => ID
[MD5] => MD5
[location] => location
[resource] => resource
[originalName] => originalname
[mime] => mimetype
[mTime] => mtime
[typeID] => typeID
[mediaTypeID] => mediatypeID
[size] => size
[description] => description
[source] => source
[sourceDate] => source_date
[name] => name
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
)
[primarykeys] => Array
(
[asset_core] => ID
)
[datatypes] => Array
(
[asset_core] => Array
(
[ID] => numeric
[MD5] => string
[location] => string
[resource] => string
[originalname] => string
[mimetype] => string
[mtime] => numeric
[typeID] => numeric
[mediatypeID] => numeric
[size] => numeric
)
)
[secenable] => 1
[workflowenabled] => 1
)
[archive] => Array
(
[coretable] => asset_core
[tables] => Array
(
[asset_core] => Array
(
[ID] => ID
[MD5] => MD5
[location] => location
[resource] => resource
[originalName] => originalname
[mime] => mimetype
[mTime] => mtime
[typeID] => typeID
[mediaTypeID] => mediatypeID
[size] => size
[description] => description
[source] => source
[sourceDate] => source_date
[name] => name
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
[asset_archive] => Array
(
[ID] => ID
[assetID] => assetID
[annotation] => annotation
)
)
[primarykeys] => Array
(
[asset_core] => ID
[asset_archive] => ID
)
[datatypes] => Array
(
[asset_core] => Array
(
[ID] => numeric
[MD5] => string
[location] => string
[resource] => string
[originalname] => string
[mimetype] => string
[mtime] => numeric
[typeID] => numeric
[mediatypeID] => numeric
[size] => numeric
)
[asset_archive] => Array
(
[ID] => numeric
[assetID] => numeric
)
)
[secenable] => 1
[workflowenabled] => 1
[secondarytables] => Array
(
[0] => asset_archive
)
[foreignkeys] => Array
(
[asset_archive] => assetID
)
[related] => Array
(
[vrawork] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => works
[xlink] => vra_workxarchive
[relatedfield] => workID
)
[vraagent] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => agents
[xlink] => vra_agentxarchive
[relatedfield] => agentID
)
[vraevent] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => events
[xlink] => vra_eventxarchive
[relatedfield] => eventID
)
[vralocation] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => locations
[xlink] => vra_locationxarchive
[relatedfield] => locationID
)
)
[lookup] => Array
(
[dropdown] => Array
(
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => archives
)
[save] => Array
(
[moduleName] => objectui
[type] => asset.archive
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
)
[image] => Array
(
[coretable] => asset_core
[tables] => Array
(
[asset_core] => Array
(
[ID] => ID
[MD5] => MD5
[location] => location
[resource] => resource
[originalName] => originalname
[mime] => mimetype
[mTime] => mtime
[typeID] => typeID
[mediaTypeID] => mediatypeID
[size] => size
[description] => description
[source] => source
[sourceDate] => source_date
[name] => name
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
[asset_image] => Array
(
[ID] => ID
[assetID] => assetID
[width] => width
[height] => height
[quality] => quality
[resx] => res_x
[resy] => res_y
[exif] => exif
[type] => type
[artist] => artist
[date] => date
)
)
[primarykeys] => Array
(
[asset_core] => ID
[asset_image] => ID
)
[datatypes] => Array
(
[asset_core] => Array
(
[ID] => numeric
[MD5] => string
[location] => string
[resource] => string
[originalname] => string
[mimetype] => string
[mtime] => numeric
[typeID] => numeric
[mediatypeID] => numeric
[size] => numeric
)
[asset_image] => Array
(
[ID] => numeric
[assetID] => numeric
[width] => numeric
[height] => numeric
[quality] => numeric
[res_x] => numeric
[res_y] => numeric
[exif] => bool
)
)
[secenable] => 1
[workflowenabled] => 1
[secondarytables] => Array
(
[0] => asset_image
)
[foreignkeys] => Array
(
[asset_image] => assetID
)
[related] => Array
(
[vrawork] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => works
[xlink] => vra_workximage
[relatedfield] => workID
)
[vraagent] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => agents
[xlink] => vra_agentximage
[relatedfield] => agentID
)
[vraevent] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => events
[xlink] => vra_eventximage
[relatedfield] => eventID
)
[vralocation] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => locations
[xlink] => vra_locationximage
[relatedfield] => locationID
)
)
[lookup] => Array
(
[dropdown] => Array
(
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => images
)
[save] => Array
(
[moduleName] => objectui
[type] => asset.image
[id] => Array
(
[attr] => ID
)
[edit] => 0
)
)
)
[video] => Array
(
[coretable] => asset_core
[tables] => Array
(
[asset_core] => Array
(
[ID] => ID
[MD5] => MD5
[location] => location
[resource] => resource
[originalName] => originalname
[mime] => mimetype
[mTime] => mtime
[typeID] => typeID
[mediaTypeID] => mediatypeID
[size] => size
[description] => description
[source] => source
[sourceDate] => source_date
[name] => name
[HMSsecTag] => sectag
[HMSCreated] => created_on
[HMSLastUpdated] => last_updated
[HMSCreatedBy] => created_by
[HMSLastUpdatedBy] => last_updated_by
[HMSHits] => hits
[HMSWFStage] => secwfstage
)
[asset_video] => Array
(
[ID] => ID
[assetID] => assetID
[videoCodec] => video_codec
[videoBitRate] => video_bitrate
[videoLength] => video_length
[videoHeight] => video_height
[videoWidth] => video_width
[audioCodec] => audio_codec
[audioBitRate] => audio_bitrate
)
)
[primarykeys] => Array
(
[asset_core] => ID
[asset_video] => ID
)
[datatypes] => Array
(
[asset_core] => Array
(
[ID] => numeric
[MD5] => string
[location] => string
[resource] => string
[originalname] => string
[mimetype] => string
[mtime] => numeric
[typeID] => numeric
[mediatypeID] => numeric
[size] => numeric
)
[asset_video] => Array
(
[ID] => numeric
[assetID] => numeric
)
)
[secenable] => 1
[workflowenabled] => 1
[secondarytables] => Array
(
[0] => asset_video
)
[foreignkeys] => Array
(
[asset_video] => assetID
)
[related] => Array
(
[vrawork] => Array
(
[on] => assetID
[type] => m:m
[module] => vra
[var] => works
[xlink] => vra_workxvideo
[relatedfield] => workID
)
)
[lookup] => Array
(
[dropdown] => Array
(
[HMSWFStage] => SELECT 1 AS 'key', 'Unpublished' AS 'val' UNION SELECT 2 AS 'key', 'Published' AS 'val'
)
)
[redirect] => Array
(
[delete] => Array
(
[reset] => 1
[moduleName] => lister
[type] => videos