Warning (512): SQL Error: 1030: Got error 28 from storage engine [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "DESCRIBE `properties`" $error = "1030: Got error 28 from storage engine" $out = null
$out = null;if ($error) {trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 336 DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 220 DboMysql::describe() - CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 449 Model::schema() - CORE/cake/libs/model/model.php, line 900 Model::setSource() - CORE/cake/libs/model/model.php, line 757 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Controller::loadModel() - CORE/cake/libs/controller/controller.php, line 507 Controller::constructClasses() - CORE/cake/libs/controller/controller.php, line 461 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Query: DESCRIBE `properties`
Warning (2): Invalid argument supplied for foreach() [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 451]
$model = Property Property::$name = "Property" Property::$order = "created DESC" Property::$hasMany = array Property::$validate = array Property::$useDbConfig = "default" Property::$useTable = "properties" Property::$displayField = NULL Property::$id = NULL Property::$data = array Property::$table = "properties" Property::$primaryKey = "id" Property::$_schema = NULL Property::$validationErrors = array Property::$tablePrefix = "" Property::$alias = "Property" Property::$tableToModel = array Property::$logTransactions = false Property::$transactional = false Property::$cacheQueries = false Property::$belongsTo = array Property::$hasOne = array Property::$hasAndBelongsToMany = array Property::$actsAs = NULL Property::$Behaviors = BehaviorCollection object Property::$whitelist = array Property::$cacheSources = true Property::$findQueryType = NULL Property::$recursive = 1 Property::$__exists = NULL Property::$__associationKeys = array Property::$__associations = array Property::$__backAssociation = array Property::$__insertID = NULL Property::$__numRows = NULL Property::$__affectedRows = NULL Property::$_findMethods = array Property::$_log = NULL $cache = null $fields = false $cols = false
$cols = $this->query('DESCRIBE ' . $this->fullTableName($model));foreach ($cols as $column) {
DboMysql::describe() - CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 451 Model::schema() - CORE/cake/libs/model/model.php, line 900 Model::setSource() - CORE/cake/libs/model/model.php, line 757 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Controller::loadModel() - CORE/cake/libs/controller/controller.php, line 507 Controller::constructClasses() - CORE/cake/libs/controller/controller.php, line 461 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Query: DESCRIBE `properties`
Query: DESCRIBE `properties`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `webnodes`
Query: DESCRIBE `webnodes`
Query: DESCRIBE `webnodes`
Query: DESCRIBE `webnodes`
Query: DESCRIBE `pages`
Query: DESCRIBE `pages`
Query: DESCRIBE `pages`
Query: DESCRIBE `pages`
Query: DESCRIBE `property_units`
Warning (2): array_keys() [function.array-keys]: The first argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1671]
$this = DboMysql DboMysql::$description = "MySQL DBO Driver" DboMysql::$_baseConfig = array DboMysql::$startQuote = "`" DboMysql::$endQuote = "`" DboMysql::$_useAlias = true DboMysql::$_commands = array DboMysql::$columns = array DboMysql::$index = array DboMysql::$alias = "AS " DboMysql::$fieldCache = array DboMysql::$__bypass = true DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$error = "1030: Got error 28 from storage engine" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 1 DboMysql::$_result = false DboMysql::$_queriesCnt = 0 DboMysql::$_queriesTime = NULL DboMysql::$_queriesLog = array DboMysql::$_queriesLogMax = 200 DboMysql::$_queryCache = array DboMysql::$__descriptions = array DboMysql::$_sources = array DboMysql::$connection = resource DboMysql::$config = array DboMysql::$configKeyName = "default" DboMysql::$_transactionStarted = false DboMysql::$cacheSources = true DboMysql::$_log = NULL DboMysql::$__booleans = array $model = AppModel AppModel::$useDbConfig = "default" AppModel::$useTable = "property_units" AppModel::$displayField = false AppModel::$id = false AppModel::$data = array AppModel::$table = "property_units" AppModel::$primaryKey = "id" AppModel::$_schema = false AppModel::$validate = array AppModel::$validationErrors = array AppModel::$tablePrefix = "" AppModel::$name = "PropertyUnit" AppModel::$alias = "PropertyUnit" AppModel::$tableToModel = array AppModel::$logTransactions = false AppModel::$transactional = false AppModel::$cacheQueries = false AppModel::$belongsTo = array AppModel::$hasOne = array AppModel::$hasMany = array AppModel::$hasAndBelongsToMany = array AppModel::$actsAs = NULL AppModel::$Behaviors = BehaviorCollection object AppModel::$whitelist = array AppModel::$cacheSources = true AppModel::$findQueryType = NULL AppModel::$recursive = 1 AppModel::$order = NULL AppModel::$__exists = NULL AppModel::$__associationKeys = array AppModel::$__associations = array AppModel::$__backAssociation = array AppModel::$__insertID = NULL AppModel::$__numRows = NULL AppModel::$__affectedRows = NULL AppModel::$_findMethods = array AppModel::$_log = NULL $alias = "PropertyUnit" $fields = array() $quote = true
array_keys - [internal], line ?? DboSource::fields() - CORE/cake/libs/model/datasources/dbo_source.php, line 1671 DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1133 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Warning (2): array_filter() [function.array-filter]: The first argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1675]
$this = DboMysql DboMysql::$description = "MySQL DBO Driver" DboMysql::$_baseConfig = array DboMysql::$startQuote = "`" DboMysql::$endQuote = "`" DboMysql::$_useAlias = true DboMysql::$_commands = array DboMysql::$columns = array DboMysql::$index = array DboMysql::$alias = "AS " DboMysql::$fieldCache = array DboMysql::$__bypass = true DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$error = "1030: Got error 28 from storage engine" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 1 DboMysql::$_result = false DboMysql::$_queriesCnt = 0 DboMysql::$_queriesTime = NULL DboMysql::$_queriesLog = array DboMysql::$_queriesLogMax = 200 DboMysql::$_queryCache = array DboMysql::$__descriptions = array DboMysql::$_sources = array DboMysql::$connection = resource DboMysql::$config = array DboMysql::$configKeyName = "default" DboMysql::$_transactionStarted = false DboMysql::$cacheSources = true DboMysql::$_log = NULL DboMysql::$__booleans = array $model = AppModel AppModel::$useDbConfig = "default" AppModel::$useTable = "property_units" AppModel::$displayField = false AppModel::$id = false AppModel::$data = array AppModel::$table = "property_units" AppModel::$primaryKey = "id" AppModel::$_schema = false AppModel::$validate = array AppModel::$validationErrors = array AppModel::$tablePrefix = "" AppModel::$name = "PropertyUnit" AppModel::$alias = "PropertyUnit" AppModel::$tableToModel = array AppModel::$logTransactions = false AppModel::$transactional = false AppModel::$cacheQueries = false AppModel::$belongsTo = array AppModel::$hasOne = array AppModel::$hasMany = array AppModel::$hasAndBelongsToMany = array AppModel::$actsAs = NULL AppModel::$Behaviors = BehaviorCollection object AppModel::$whitelist = array AppModel::$cacheSources = true AppModel::$findQueryType = NULL AppModel::$recursive = 1 AppModel::$order = NULL AppModel::$__exists = NULL AppModel::$__associationKeys = array AppModel::$__associations = array AppModel::$__backAssociation = array AppModel::$__insertID = NULL AppModel::$__numRows = NULL AppModel::$__affectedRows = NULL AppModel::$_findMethods = array AppModel::$_log = NULL $alias = "PropertyUnit" $fields = null $quote = true
array_filter - [internal], line ?? DboSource::fields() - CORE/cake/libs/model/datasources/dbo_source.php, line 1675 DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1133 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Warning (2): array_values() [function.array-values]: The argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1675]
$this = DboMysql DboMysql::$description = "MySQL DBO Driver" DboMysql::$_baseConfig = array DboMysql::$startQuote = "`" DboMysql::$endQuote = "`" DboMysql::$_useAlias = true DboMysql::$_commands = array DboMysql::$columns = array DboMysql::$index = array DboMysql::$alias = "AS " DboMysql::$fieldCache = array DboMysql::$__bypass = true DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$error = "1030: Got error 28 from storage engine" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 1 DboMysql::$_result = false DboMysql::$_queriesCnt = 0 DboMysql::$_queriesTime = NULL DboMysql::$_queriesLog = array DboMysql::$_queriesLogMax = 200 DboMysql::$_queryCache = array DboMysql::$__descriptions = array DboMysql::$_sources = array DboMysql::$connection = resource DboMysql::$config = array DboMysql::$configKeyName = "default" DboMysql::$_transactionStarted = false DboMysql::$cacheSources = true DboMysql::$_log = NULL DboMysql::$__booleans = array $model = AppModel AppModel::$useDbConfig = "default" AppModel::$useTable = "property_units" AppModel::$displayField = false AppModel::$id = false AppModel::$data = array AppModel::$table = "property_units" AppModel::$primaryKey = "id" AppModel::$_schema = false AppModel::$validate = array AppModel::$validationErrors = array AppModel::$tablePrefix = "" AppModel::$name = "PropertyUnit" AppModel::$alias = "PropertyUnit" AppModel::$tableToModel = array AppModel::$logTransactions = false AppModel::$transactional = false AppModel::$cacheQueries = false AppModel::$belongsTo = array AppModel::$hasOne = array AppModel::$hasMany = array AppModel::$hasAndBelongsToMany = array AppModel::$actsAs = NULL AppModel::$Behaviors = BehaviorCollection object AppModel::$whitelist = array AppModel::$cacheSources = true AppModel::$findQueryType = NULL AppModel::$recursive = 1 AppModel::$order = NULL AppModel::$__exists = NULL AppModel::$__associationKeys = array AppModel::$__associations = array AppModel::$__backAssociation = array AppModel::$__insertID = NULL AppModel::$__numRows = NULL AppModel::$__affectedRows = NULL AppModel::$_findMethods = array AppModel::$_log = NULL $alias = "PropertyUnit" $fields = null $quote = true
array_values - [internal], line ?? DboSource::fields() - CORE/cake/libs/model/datasources/dbo_source.php, line 1675 DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1133 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Warning (2): array_unique() [function.array-unique]: The argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1737]
$this = DboMysql DboMysql::$description = "MySQL DBO Driver" DboMysql::$_baseConfig = array DboMysql::$startQuote = "`" DboMysql::$endQuote = "`" DboMysql::$_useAlias = true DboMysql::$_commands = array DboMysql::$columns = array DboMysql::$index = array DboMysql::$alias = "AS " DboMysql::$fieldCache = array DboMysql::$__bypass = true DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$error = "1030: Got error 28 from storage engine" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 1 DboMysql::$_result = false DboMysql::$_queriesCnt = 0 DboMysql::$_queriesTime = NULL DboMysql::$_queriesLog = array DboMysql::$_queriesLogMax = 200 DboMysql::$_queryCache = array DboMysql::$__descriptions = array DboMysql::$_sources = array DboMysql::$connection = resource DboMysql::$config = array DboMysql::$configKeyName = "default" DboMysql::$_transactionStarted = false DboMysql::$cacheSources = true DboMysql::$_log = NULL DboMysql::$__booleans = array $model = AppModel AppModel::$useDbConfig = "default" AppModel::$useTable = "property_units" AppModel::$displayField = false AppModel::$id = false AppModel::$data = array AppModel::$table = "property_units" AppModel::$primaryKey = "id" AppModel::$_schema = false AppModel::$validate = array AppModel::$validationErrors = array AppModel::$tablePrefix = "" AppModel::$name = "PropertyUnit" AppModel::$alias = "PropertyUnit" AppModel::$tableToModel = array AppModel::$logTransactions = false AppModel::$transactional = false AppModel::$cacheQueries = false AppModel::$belongsTo = array AppModel::$hasOne = array AppModel::$hasMany = array AppModel::$hasAndBelongsToMany = array AppModel::$actsAs = NULL AppModel::$Behaviors = BehaviorCollection object AppModel::$whitelist = array AppModel::$cacheSources = true AppModel::$findQueryType = NULL AppModel::$recursive = 1 AppModel::$order = NULL AppModel::$__exists = NULL AppModel::$__associationKeys = array AppModel::$__associations = array AppModel::$__backAssociation = array AppModel::$__insertID = NULL AppModel::$__numRows = NULL AppModel::$__affectedRows = NULL AppModel::$_findMethods = array AppModel::$_log = NULL $alias = "PropertyUnit" $fields = null $quote = true $count = 0
array_unique - [internal], line ?? DboSource::fields() - CORE/cake/libs/model/datasources/dbo_source.php, line 1737 DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1133 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Warning (2): array_merge() [function.array-merge]: Argument #1 is not an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1135]
$model = Property Property::$name = "Property" Property::$order = "created DESC" Property::$hasMany = array Property::$validate = array Property::$useDbConfig = "default" Property::$useTable = "properties" Property::$displayField = false Property::$id = false Property::$data = array Property::$table = "properties" Property::$primaryKey = "id" Property::$_schema = false Property::$validationErrors = array Property::$tablePrefix = "" Property::$alias = "Property" Property::$tableToModel = array Property::$logTransactions = false Property::$transactional = false Property::$cacheQueries = false Property::$belongsTo = array Property::$hasOne = array Property::$hasAndBelongsToMany = array Property::$actsAs = NULL Property::$Behaviors = BehaviorCollection object Property::$whitelist = array Property::$cacheSources = true Property::$findQueryType = "count" Property::$recursive = 1 Property::$__exists = NULL Property::$__associationKeys = array Property::$__associations = array Property::$__backAssociation = array Property::$__insertID = NULL Property::$__numRows = NULL Property::$__affectedRows = NULL Property::$_findMethods = array Property::$_log = NULL Property::$PropertyUnit = AppModel object $linkModel = AppModel AppModel::$useDbConfig = "default" AppModel::$useTable = "property_units" AppModel::$displayField = false AppModel::$id = false AppModel::$data = array AppModel::$table = "property_units" AppModel::$primaryKey = "id" AppModel::$_schema = false AppModel::$validate = array AppModel::$validationErrors = array AppModel::$tablePrefix = "" AppModel::$name = "PropertyUnit" AppModel::$alias = "PropertyUnit" AppModel::$tableToModel = array AppModel::$logTransactions = false AppModel::$transactional = false AppModel::$cacheQueries = false AppModel::$belongsTo = array AppModel::$hasOne = array AppModel::$hasMany = array AppModel::$hasAndBelongsToMany = array AppModel::$actsAs = NULL AppModel::$Behaviors = BehaviorCollection object AppModel::$whitelist = array AppModel::$cacheSources = true AppModel::$findQueryType = NULL AppModel::$recursive = 1 AppModel::$order = NULL AppModel::$__exists = NULL AppModel::$__associationKeys = array AppModel::$__associations = array AppModel::$__backAssociation = array AppModel::$__insertID = NULL AppModel::$__numRows = NULL AppModel::$__affectedRows = NULL AppModel::$_findMethods = array AppModel::$_log = NULL $type = "hasMany" $association = "PropertyUnit" $assocData = array( "className" => "PropertyUnit", "order" => "PropertyUnit.unit_number +0 ASC", "dependant" => true, "foreignKey" => "property_id", "conditions" => array(), "fields" => false, "limit" => null, "offset" => array(), "dependent" => "", "exclusive" => "", "finderQuery" => "", "counterQuery" => "", "joins" => array(), "group" => array() ) $queryData = array( "conditions" => "Property.region_nw = 1", "fields" => array( "COUNT(*) AS `count`" ), "joins" => array(), "limit" => array(), "offset" => array(), "order" => array( false ), "page" => 1, "group" => array(), "callbacks" => true ) $external = false $resultSet = null $match = false $match1 = 0 $alias = "PropertyUnit" $self = false $fields = array()
array_merge - [internal], line ?? DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1135 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Warning (2): array_unique() [function.array-unique]: The argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1139]
$model = Property Property::$name = "Property" Property::$order = "created DESC" Property::$hasMany = array Property::$validate = array Property::$useDbConfig = "default" Property::$useTable = "properties" Property::$displayField = false Property::$id = false Property::$data = array Property::$table = "properties" Property::$primaryKey = "id" Property::$_schema = false Property::$validationErrors = array Property::$tablePrefix = "" Property::$alias = "Property" Property::$tableToModel = array Property::$logTransactions = false Property::$transactional = false Property::$cacheQueries = false Property::$belongsTo = array Property::$hasOne = array Property::$hasAndBelongsToMany = array Property::$actsAs = NULL Property::$Behaviors = BehaviorCollection object Property::$whitelist = array Property::$cacheSources = true Property::$findQueryType = "count" Property::$recursive = 1 Property::$__exists = NULL Property::$__associationKeys = array Property::$__associations = array Property::$__backAssociation = array Property::$__insertID = NULL Property::$__numRows = NULL Property::$__affectedRows = NULL Property::$_findMethods = array Property::$_log = NULL Property::$PropertyUnit = AppModel object $linkModel = AppModel AppModel::$useDbConfig = "default" AppModel::$useTable = "property_units" AppModel::$displayField = false AppModel::$id = false AppModel::$data = array AppModel::$table = "property_units" AppModel::$primaryKey = "id" AppModel::$_schema = false AppModel::$validate = array AppModel::$validationErrors = array AppModel::$tablePrefix = "" AppModel::$name = "PropertyUnit" AppModel::$alias = "PropertyUnit" AppModel::$tableToModel = array AppModel::$logTransactions = false AppModel::$transactional = false AppModel::$cacheQueries = false AppModel::$belongsTo = array AppModel::$hasOne = array AppModel::$hasMany = array AppModel::$hasAndBelongsToMany = array AppModel::$actsAs = NULL AppModel::$Behaviors = BehaviorCollection object AppModel::$whitelist = array AppModel::$cacheSources = true AppModel::$findQueryType = NULL AppModel::$recursive = 1 AppModel::$order = NULL AppModel::$__exists = NULL AppModel::$__associationKeys = array AppModel::$__associations = array AppModel::$__backAssociation = array AppModel::$__insertID = NULL AppModel::$__numRows = NULL AppModel::$__affectedRows = NULL AppModel::$_findMethods = array AppModel::$_log = NULL $type = "hasMany" $association = "PropertyUnit" $assocData = array( "className" => "PropertyUnit", "order" => "PropertyUnit.unit_number +0 ASC", "dependant" => true, "foreignKey" => "property_id", "conditions" => array(), "fields" => null, "limit" => null, "offset" => array(), "dependent" => "", "exclusive" => "", "finderQuery" => "", "counterQuery" => "", "joins" => array(), "group" => array() ) $queryData = array( "conditions" => "Property.region_nw = 1", "fields" => array( "COUNT(*) AS `count`" ), "joins" => array(), "limit" => array(), "offset" => array(), "order" => array( false ), "page" => 1, "group" => array(), "callbacks" => true ) $external = false $resultSet = null $match = false $match1 = 0 $alias = "PropertyUnit" $self = false $fields = array()
array_unique - [internal], line ?? DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1139 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Warning (2): join() [function.join]: Bad arguments. [CORE/cake/libs/model/datasources/dbo_source.php, line 1273]
$query = array( "offset" => null, "joins" => array(), "conditions" => array( "PropertyUnit.property_id" => array() ), "fields" => false, "table" => "`property_units`", "alias" => "PropertyUnit", "order" => "PropertyUnit.unit_number +0 ASC", "limit" => null, "group" => null ) $model = Property Property::$name = "Property" Property::$order = "created DESC" Property::$hasMany = array Property::$validate = array Property::$useDbConfig = "default" Property::$useTable = "properties" Property::$displayField = false Property::$id = false Property::$data = array Property::$table = "properties" Property::$primaryKey = "id" Property::$_schema = false Property::$validationErrors = array Property::$tablePrefix = "" Property::$alias = "Property" Property::$tableToModel = array Property::$logTransactions = false Property::$transactional = false Property::$cacheQueries = false Property::$belongsTo = array Property::$hasOne = array Property::$hasAndBelongsToMany = array Property::$actsAs = NULL Property::$Behaviors = BehaviorCollection object Property::$whitelist = array Property::$cacheSources = true Property::$findQueryType = "count" Property::$recursive = 1 Property::$__exists = NULL Property::$__associationKeys = array Property::$__associations = array Property::$__backAssociation = array Property::$__insertID = NULL Property::$__numRows = NULL Property::$__affectedRows = NULL Property::$_findMethods = array Property::$_log = NULL Property::$PropertyUnit = AppModel object
join - [internal], line ?? DboSource::buildStatement() - CORE/cake/libs/model/datasources/dbo_source.php, line 1273 DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1185 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 644 Model::find() - CORE/cake/libs/model/model.php, line 1988 PropertiesController::_node_hook() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 17 PCMSAppController::beforeFilter() - APP/plugins/pcms/pcms_app_controller.php, line 135 PCMSCGPropertiesAppController::beforeFilter() - APP/plugins/pcms_cg_properties/pcms_cg_properties_app_controller.php, line 5 PropertiesController::beforeFilter() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 11 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 209 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Query: DESCRIBE `property_units`
Query: DESCRIBE `properties`
Warning (2): array_unique() [function.array-unique]: The argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1060]
$model = Property Property::$name = "Property" Property::$order = "created DESC" Property::$hasMany = array Property::$validate = array Property::$useDbConfig = "default" Property::$useTable = "properties" Property::$displayField = false Property::$id = false Property::$data = array Property::$table = "properties" Property::$primaryKey = "id" Property::$_schema = false Property::$validationErrors = array Property::$tablePrefix = "" Property::$alias = "Property" Property::$tableToModel = array Property::$logTransactions = false Property::$transactional = false Property::$cacheQueries = false Property::$belongsTo = array Property::$hasOne = array Property::$hasAndBelongsToMany = array Property::$actsAs = NULL Property::$Behaviors = BehaviorCollection object Property::$whitelist = array Property::$cacheSources = true Property::$findQueryType = "first" Property::$recursive = 1 Property::$__exists = NULL Property::$__associationKeys = array Property::$__associations = array Property::$__backAssociation = array Property::$__insertID = NULL Property::$__numRows = NULL Property::$__affectedRows = NULL Property::$_findMethods = array Property::$_log = NULL Property::$PropertyUnit = AppModel object $linkModel = null $type = null $association = null $assocData = array( "conditions" => array(), "fields" => array(), "joins" => array(), "order" => array(), "limit" => array(), "offset" => array(), "group" => array() ) $queryData = array( "conditions" => array( "Property.id" => "30" ), "fields" => false, "joins" => array(), "limit" => 1, "offset" => array(), "order" => array( "created DESC" ), "page" => 1, "group" => array(), "callbacks" => true, "recursive" => null ) $external = false $resultSet = null
array_unique - [internal], line ?? DboSource::generateAssociationQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 1060 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 651 Model::find() - CORE/cake/libs/model/model.php, line 1988 DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 282 Model::call__() - CORE/cake/libs/model/model.php, line 441 Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 52 Property::findById() - [internal], line ?? PropertiesController::view() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 74 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Query: DESCRIBE `properties`
Warning (512): SQL Error: 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 'FROM `properties` AS `Property` WHERE `Property`.`id` = '30' ORDER BY `creat' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT FROM `properties` AS `Property` WHERE `Property`.`id` = '30' ORDER BY `created` DESC LIMIT 1" $error = "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 'FROM `properties` AS `Property` WHERE `Property`.`id` = '30' ORDER BY `creat' at line 1" $out = null
$out = null;if ($error) {trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 525 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 336 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 653 Model::find() - CORE/cake/libs/model/model.php, line 1988 DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 282 Model::call__() - CORE/cake/libs/model/model.php, line 441 Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 52 Property::findById() - [internal], line ?? PropertiesController::view() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 74 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Query: SELECT FROM `properties` AS `Property` WHERE `Property`.`id` = '30' ORDER BY `created` DESC LIMIT 1
Warning (2): Invalid argument supplied for foreach() [APP/plugins/pcms_cg_properties/models/property.php, line 33]
$results = false
function afterFind($results) {foreach ($results as $key => $val) {
Property::afterFind() - APP/plugins/pcms_cg_properties/models/property.php, line 33 Model::__filterResults() - CORE/cake/libs/model/model.php, line 2234 Model::find() - CORE/cake/libs/model/model.php, line 1993 DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 282 Model::call__() - CORE/cake/libs/model/model.php, line 441 Overloadable::__call() - CORE/cake/libs/overloadable_php5.php, line 52 Property::findById() - [internal], line ?? PropertiesController::view() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 74 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83
Warning (2): Cannot modify header information - headers already sent by (output started at /srv/chancerygate.com/public/htdocs/cake/basics.php:109) [CORE/cake/libs/controller/controller.php, line 644]
$status = "Location: http://www.chancerygate.com/"
header - [internal], line ?? Controller::header() - CORE/cake/libs/controller/controller.php, line 644 Controller::redirect() - CORE/cake/libs/controller/controller.php, line 625 PropertiesController::view() - APP/plugins/pcms_cg_properties/controllers/properties_controller.php, line 75 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 83