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 '' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "DESCRIBE " $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 '' 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::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 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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203
Query: DESCRIBE
Warning (2): Invalid argument supplied for foreach() [CORE/cake/libs/model/datasources/dbo/dbo_mysql.php, line 451]
$model = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = NULL User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_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 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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613
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 = false DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$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 '' at line 1" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 0 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::$results = false DboMysql::$map = array DboMysql::$__booleans = array $model = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $alias = "User" $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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422
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 = false DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$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 '' at line 1" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 0 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::$results = false DboMysql::$map = array DboMysql::$__booleans = array $model = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $alias = "User" $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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422
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 = false DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$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 '' at line 1" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 0 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::$results = false DboMysql::$map = array DboMysql::$__booleans = array $model = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $alias = "User" $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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422
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 = false DboMysql::$__sqlOps = array DboMysql::$connected = true DboMysql::$fullDebug = false DboMysql::$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 '' at line 1" DboMysql::$affected = NULL DboMysql::$numRows = NULL DboMysql::$took = 0 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::$results = false DboMysql::$map = array DboMysql::$__booleans = array $model = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $alias = "User" $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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422
Warning (2): array_merge() [function.array-merge]: Argument #1 is not an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1135]
$model = Group Group::$name = "Group" Group::$validate = array Group::$actsAs = array Group::$hasMany = array Group::$language_id = NULL Group::$useDbConfig = "default" Group::$useTable = "groups" Group::$displayField = "name" Group::$id = false Group::$data = array Group::$table = "groups" Group::$primaryKey = "id" Group::$_schema = array Group::$validationErrors = array Group::$tablePrefix = "" Group::$alias = "Group" Group::$tableToModel = array Group::$logTransactions = false Group::$transactional = false Group::$cacheQueries = false Group::$belongsTo = array Group::$hasOne = array Group::$hasAndBelongsToMany = array Group::$Behaviors = BehaviorCollection object Group::$whitelist = array Group::$cacheSources = true Group::$findQueryType = "all" Group::$recursive = 1 Group::$order = NULL Group::$__exists = NULL Group::$__associationKeys = array Group::$__associations = array Group::$__backAssociation = array Group::$__insertID = NULL Group::$__numRows = NULL Group::$__affectedRows = NULL Group::$_findMethods = array Group::$_log = NULL Group::$User = User object $linkModel = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $type = "hasMany" $association = "User" $assocData = array( "className" => "User", "foreignKey" => "group_id", "dependent" => true, "conditions" => array(), "fields" => false, "order" => array(), "limit" => null, "offset" => array(), "exclusive" => "", "finderQuery" => "", "counterQuery" => "", "joins" => array(), "group" => array() ) $queryData = array( "conditions" => array(), "fields" => array( "`Group`.`id`", "`Group`.`created`", "`Group`.`access`", "`Group`.`modified`", "`Group`.`deleted_date`", "`Group`.`deleted`", "`Group`.`name`", "`Group`.`description`", "`Group`.`parent_id`", "`Group`.`lft`", "`Group`.`rght`", "`Group`.`created_by`", "`Group`.`modified_by`", "`Group`.`id`" ), "joins" => array(), "limit" => array(), "offset" => array(), "order" => array( null ), "page" => 1, "group" => array(), "callbacks" => true ) $external = false $resultSet = null $alias = "User" $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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422 AppController::beforeRender() - APP/app_controller.php, line 50
Warning (2): array_unique() [function.array-unique]: The argument should be an array [CORE/cake/libs/model/datasources/dbo_source.php, line 1139]
$model = Group Group::$name = "Group" Group::$validate = array Group::$actsAs = array Group::$hasMany = array Group::$language_id = NULL Group::$useDbConfig = "default" Group::$useTable = "groups" Group::$displayField = "name" Group::$id = false Group::$data = array Group::$table = "groups" Group::$primaryKey = "id" Group::$_schema = array Group::$validationErrors = array Group::$tablePrefix = "" Group::$alias = "Group" Group::$tableToModel = array Group::$logTransactions = false Group::$transactional = false Group::$cacheQueries = false Group::$belongsTo = array Group::$hasOne = array Group::$hasAndBelongsToMany = array Group::$Behaviors = BehaviorCollection object Group::$whitelist = array Group::$cacheSources = true Group::$findQueryType = "all" Group::$recursive = 1 Group::$order = NULL Group::$__exists = NULL Group::$__associationKeys = array Group::$__associations = array Group::$__backAssociation = array Group::$__insertID = NULL Group::$__numRows = NULL Group::$__affectedRows = NULL Group::$_findMethods = array Group::$_log = NULL Group::$User = User object $linkModel = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $type = "hasMany" $association = "User" $assocData = array( "className" => "User", "foreignKey" => "group_id", "dependent" => true, "conditions" => array(), "fields" => null, "order" => array(), "limit" => null, "offset" => array(), "exclusive" => "", "finderQuery" => "", "counterQuery" => "", "joins" => array(), "group" => array() ) $queryData = array( "conditions" => array(), "fields" => array( "`Group`.`id`", "`Group`.`created`", "`Group`.`access`", "`Group`.`modified`", "`Group`.`deleted_date`", "`Group`.`deleted`", "`Group`.`name`", "`Group`.`description`", "`Group`.`parent_id`", "`Group`.`lft`", "`Group`.`rght`", "`Group`.`created_by`", "`Group`.`modified_by`", "`Group`.`id`" ), "joins" => array(), "limit" => array(), "offset" => array(), "order" => array( null ), "page" => 1, "group" => array(), "callbacks" => true ) $external = false $resultSet = null $alias = "User" $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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422 AppController::beforeRender() - APP/app_controller.php, line 50
Query: DESCRIBE
Warning (2): join() [function.join]: Invalid arguments passed [CORE/cake/libs/model/datasources/dbo_source.php, line 1273]
$query = array( "offset" => null, "joins" => array(), "conditions" => array( "User.group_id" => array() ), "fields" => false, "table" => "", "alias" => "User", "order" => array(), "limit" => null, "group" => null ) $model = Group Group::$name = "Group" Group::$validate = array Group::$actsAs = array Group::$hasMany = array Group::$language_id = NULL Group::$useDbConfig = "default" Group::$useTable = "groups" Group::$displayField = "name" Group::$id = false Group::$data = array Group::$table = "groups" Group::$primaryKey = "id" Group::$_schema = array Group::$validationErrors = array Group::$tablePrefix = "" Group::$alias = "Group" Group::$tableToModel = array Group::$logTransactions = false Group::$transactional = false Group::$cacheQueries = false Group::$belongsTo = array Group::$hasOne = array Group::$hasAndBelongsToMany = array Group::$Behaviors = BehaviorCollection object Group::$whitelist = array Group::$cacheSources = true Group::$findQueryType = "all" Group::$recursive = 1 Group::$order = NULL Group::$__exists = NULL Group::$__associationKeys = array Group::$__associations = array Group::$__backAssociation = array Group::$__insertID = NULL Group::$__numRows = NULL Group::$__affectedRows = NULL Group::$_findMethods = array Group::$_log = NULL Group::$User = User 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 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422
Query: DESCRIBE
Query: DESCRIBE
Query: DESCRIBE
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 AS `User` WHERE `User`.`group_id` IN (1, 2, 4, 5)' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT FROM AS `User` WHERE `User`.`group_id` IN (1, 2, 4, 5) " $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 AS `User` WHERE `User`.`group_id` IN (1, 2, 4, 5)' 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::fetchAssociated() - CORE/cake/libs/model/datasources/dbo_source.php, line 901 DboSource::queryAssociation() - CORE/cake/libs/model/datasources/dbo_source.php, line 765 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 679 Model::find() - CORE/cake/libs/model/model.php, line 1988 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140
Query: SELECT FROM AS `User` WHERE `User`.`group_id` IN (1, 2, 4, 5)
Warning (2): Invalid argument supplied for foreach() [CORE/cake/libs/model/datasources/dbo_source.php, line 918]
$resultSet = array( array( "Group" => array() ), array( "Group" => array() ), array( "Group" => array() ), array( "Group" => array() ) ) $merge = false $association = "User" $model = Group Group::$name = "Group" Group::$validate = array Group::$actsAs = array Group::$hasMany = array Group::$language_id = NULL Group::$useDbConfig = "default" Group::$useTable = "groups" Group::$displayField = "name" Group::$id = false Group::$data = array Group::$table = "groups" Group::$primaryKey = "id" Group::$_schema = array Group::$validationErrors = array Group::$tablePrefix = "" Group::$alias = "Group" Group::$tableToModel = array Group::$logTransactions = false Group::$transactional = false Group::$cacheQueries = false Group::$belongsTo = array Group::$hasOne = array Group::$hasAndBelongsToMany = array Group::$Behaviors = BehaviorCollection object Group::$whitelist = array Group::$cacheSources = true Group::$findQueryType = "all" Group::$recursive = 1 Group::$order = NULL Group::$__exists = NULL Group::$__associationKeys = array Group::$__associations = array Group::$__backAssociation = array Group::$__insertID = NULL Group::$__numRows = NULL Group::$__affectedRows = NULL Group::$_findMethods = array Group::$_log = NULL Group::$User = User object $linkModel = User User::$name = "User" User::$actsAs = array User::$validate = array User::$belongsTo = array User::$language_id = NULL User::$useDbConfig = "default" User::$useTable = "users" User::$displayField = NULL User::$id = false User::$data = array User::$table = false User::$primaryKey = "id" User::$_schema = false User::$validationErrors = array User::$tablePrefix = "" User::$alias = "User" User::$tableToModel = array User::$logTransactions = false User::$transactional = false User::$cacheQueries = false User::$hasOne = array User::$hasMany = array User::$hasAndBelongsToMany = array User::$Behaviors = BehaviorCollection object User::$whitelist = array User::$cacheSources = true User::$findQueryType = NULL User::$recursive = 1 User::$order = NULL User::$__exists = NULL User::$__associationKeys = array User::$__associations = array User::$__backAssociation = array User::$__insertID = NULL User::$__numRows = NULL User::$__affectedRows = NULL User::$_findMethods = array User::$_log = NULL $value = array( "Group" => array( "id" => "1", "created" => "0000-00-00 00:00:00", "access" => "9", "modified" => "0000-00-00 00:00:00", "deleted_date" => "0000-00-00 00:00:00", "deleted" => "0", "name" => "Administration", "description" => "Our first all-powerful group.", "parent_id" => "0", "lft" => "3", "rght" => "2", "created_by" => "0", "modified_by" => "0" ) ) $i = 0 $count = 0 $merged = array( "User" => array() )
$count = 0;$merged[$association] = array();foreach ($merge as $j => $data) {
DboSource::__mergeHasMany() - CORE/cake/libs/model/datasources/dbo_source.php, line 918 DboSource::queryAssociation() - CORE/cake/libs/model/datasources/dbo_source.php, line 787 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 679 Model::find() - CORE/cake/libs/model/model.php, line 1988 AppController::beforeRender() - APP/app_controller.php, line 51 Controller::render() - CORE/cake/libs/controller/controller.php, line 760 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 373 ErrorHandler::missingTable() - CORE/cake/libs/error.php, line 224 Object::dispatchMethod() - CORE/cake/libs/object.php, line 118 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 118 Object::cakeError() - CORE/cake/libs/object.php, line 203 Model::setSource() - CORE/cake/libs/model/model.php, line 751 Model::__construct() - CORE/cake/libs/model/model.php, line 414 ClassRegistry::init() - CORE/cake/libs/class_registry.php, line 140 Model::__constructLinkedModel() - CORE/cake/libs/model/model.php, line 641 Model::__createLinks() - CORE/cake/libs/model/model.php, line 613 Model::__construct() - CORE/cake/libs/model/model.php, line 422 AppController::beforeRender() - APP/app_controller.php, line 50








