Errors - Slingerie.com

SQLSTATE[42000]: Syntax error or access violation: 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 'AND `UserGroupPermission`.`allowed` = 1' at line 1

Error: An Internal Error Has Occurred.

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 459 → PDOStatement->execute(array)

        try {
            $query = $this->_connection->prepare($sql, $prepareOptions);
            $query->setFetchMode(PDO::FETCH_LAZY);
            if (!$query->execute($params)) {
                $this->_results = $query;

array()

CORE/Cake/Model/Datasource/DboSource.php line 425 → DboSource->_execute(string, array)

        $options += array('log' => $this->fullDebug);

        $t = microtime(true);
        $this->_result = $this->_execute($sql, $params);

'SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed`, `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`alias_name`, `UserGroup`.`allowRegistration`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `slingerie`.`user_group_permissions` AS `UserGroupPermission` LEFT JOIN `slingerie`.`user_groups` AS `UserGroup` ON (`UserGroupPermission`.`user_group_id` = `UserGroup`.`id`)  WHERE `UserGroupPermission`.`user_group_id` =  AND `UserGroupPermission`.`allowed` = 1'
array()

CORE/Cake/Model/Datasource/DboSource.php line 669 → DboSource->execute(string, array, array)

        if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
            return $cached;
        }
        if ($result = $this->execute($sql, array(), $params)) {
            $out = array();

'SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed`, `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`alias_name`, `UserGroup`.`allowRegistration`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `slingerie`.`user_group_permissions` AS `UserGroupPermission` LEFT JOIN `slingerie`.`user_groups` AS `UserGroup` ON (`UserGroupPermission`.`user_group_id` = `UserGroup`.`id`)  WHERE `UserGroupPermission`.`user_group_id` =  AND `UserGroupPermission`.`allowed` = 1'
array()
array()

CORE/Cake/Model/Datasource/DboSource.php line 1080 → DboSource->fetchAll(string, boolean)


        $query = trim($this->generateAssociationQuery($model, null, null, null, null, $queryData, false, $null));

        $resultSet = $this->fetchAll($query, $model->cacheQueries);

'SELECT `UserGroupPermission`.`id`, `UserGroupPermission`.`user_group_id`, `UserGroupPermission`.`controller`, `UserGroupPermission`.`action`, `UserGroupPermission`.`allowed`, `UserGroup`.`id`, `UserGroup`.`name`, `UserGroup`.`alias_name`, `UserGroup`.`allowRegistration`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `slingerie`.`user_group_permissions` AS `UserGroupPermission` LEFT JOIN `slingerie`.`user_groups` AS `UserGroup` ON (`UserGroupPermission`.`user_group_id` = `UserGroup`.`id`)  WHERE `UserGroupPermission`.`user_group_id` =  AND `UserGroupPermission`.`allowed` = 1'
false

CORE/Cake/Model/Model.php line 2630 → DboSource->read(UserGroupPermission, array)

            return null;
        }

        $results = $this->getDataSource()->read($this, $query);
        $this->resetAssociations();

object(UserGroupPermission) {
	belongsTo => array(
		[maximum depth reached]
	)
	useDbConfig => 'default'
	useTable => 'user_group_permissions'
	id => false
	data => array([maximum depth reached])
	schemaName => 'slingerie'
	table => 'user_group_permissions'
	primaryKey => 'id'
	validate => array([maximum depth reached])
	validationErrors => array([maximum depth reached])
	validationDomain => null
	tablePrefix => ''
	name => 'UserGroupPermission'
	alias => 'UserGroupPermission'
	tableToModel => array(
		[maximum depth reached]
	)
	cacheQueries => false
	hasOne => array([maximum depth reached])
	hasMany => array([maximum depth reached])
	hasAndBelongsToMany => array([maximum depth reached])
	actsAs => null
	Behaviors => object(BehaviorCollection) {}
	whitelist => array([maximum depth reached])
	cacheSources => true
	findQueryType => 'all'
	recursive => (int) 1
	order => null
	virtualFields => array([maximum depth reached])
	__backAssociation => array([maximum depth reached])
	__backInnerAssociation => array([maximum depth reached])
	__backOriginalAssociation => array([maximum depth reached])
	__backContainableAssociation => array([maximum depth reached])
	findMethods => array(
		[maximum depth reached]
	)
	UserGroup => object(UserGroup) {}
}
array(
	'conditions' => 'UserGroupPermission.user_group_id =  AND UserGroupPermission.allowed = 1',
	'fields' => null,
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true
)

APP/Plugin/Usermgmt/Model/UserGroup.php line 122 → Model->find(string, array)

        $cacheKey = 'rules_for_group_'.$userGroupID;
        $actions = Cache::read($cacheKey, 'UserMgmt');
        if ($actions === false) {
            $actions = $this->UserGroupPermission->find('all',array('conditions'=>'UserGroupPermission.user_group_id = '.$userGroupID.' AND UserGroupPermission.allowed = 1'));
            Cache::write($cacheKey, $actions, 'UserMgmt');

'all'
array(
	'conditions' => 'UserGroupPermission.user_group_id =  AND UserGroupPermission.allowed = 1'
)

APP/Plugin/Usermgmt/Model/UserGroup.php line 87 → UserGroup->getPermissions(boolean, boolean)

            return true;
        }

        $permissions = $this->getPermissions($userGroupID,$includeGuestPermission);
        $access =str_replace(' ','',ucwords(str_replace('_',' ',$controller))).'/'.$action;

false
false

APP/Plugin/Usermgmt/Controller/Component/UserAuthComponent.php line 89 → UserGroup->isUserGroupAccess(string, string, boolean)

                    $c->redirect(array('admin'=>false,'manager'=>false,'plugin'=>'usermgmt','controller'=>'users','action'=>'login'));
                }
            } else {
                if (!$userGroupModel->isUserGroupAccess($controller, $action, $this->getGroupId())) {
                    $c->log('permission: actionUrl-'.$actionUrl, LOG_DEBUG);

'brands'
'view'
false

APP/Controller/AppController.php line 90 → UserAuthComponent->beforeFilter(BrandsController)

    }

    private function userAuth(){
        $this->UserAuth->beforeFilter($this);
    }

object(BrandsController) {
	uses => array(
		[maximum depth reached]
	)
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Brands'
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Brands'
	layoutPath => null
	viewVars => array([maximum depth reached])
	view => 'view'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Brand'
	modelKey => 'brand'
	validationErrors => null
	Session => object(SessionComponent) {}
	Cookie => object(CookieComponent) {}
	RequestHandler => object(RequestHandlerComponent) {}
	UserAuth => object(UserAuthComponent) {}
}

APP/Controller/AppController.php line 55 → AppController->userAuth()

    public function beforeFilter(){
       $this->_setLanguage();
        //if (!isset($this->params["language"])) { $this->params["language"] = 'fr'; }
        $this->userAuth();
        //$this->layout = 'bootstrap';

[internal function] → AppController->beforeFilter(CakeEvent)
```
object(CakeEvent) {
	data => null
	result => null
}
```

CORE/Cake/Event/CakeEventManager.php line 246 → call_user_func(array, CakeEvent)

            if ($listener['passParams'] === true) {
                $result = call_user_func_array($listener['callable'], $event->data);
            } else {
                $result = call_user_func($listener['callable'], $event);
            }

array(
	(int) 0 => object(BrandsController) {},
	(int) 1 => 'beforeFilter'
)
object(CakeEvent) {
	data => null
	result => null
}

CORE/Cake/Controller/Controller.php line 669 → CakeEventManager->dispatch(CakeEvent)

 * @return void
 */
    public function startupProcess() {
        $this->getEventManager()->dispatch(new CakeEvent('Controller.initialize', $this));
        $this->getEventManager()->dispatch(new CakeEvent('Controller.startup', $this));

object(CakeEvent) {
	data => null
	result => null
}

CORE/Cake/Routing/Dispatcher.php line 183 → Controller->startupProcess()

 */
    protected function _invoke(Controller $controller, CakeRequest $request, CakeResponse $response) {
        $controller->constructClasses();
        $controller->startupProcess();

CORE/Cake/Routing/Dispatcher.php line 161 → Dispatcher->_invoke(BrandsController, CakeRequest, CakeResponse)

            ));
        }

        $response = $this->_invoke($controller, $request, $response);
        if (isset($request->params['return'])) {

object(BrandsController) {
	uses => array(
		[maximum depth reached]
	)
	helpers => array(
		[maximum depth reached]
	)
	components => array(
		[maximum depth reached]
	)
	name => 'Brands'
	request => object(CakeRequest) {}
	response => object(CakeResponse) {}
	viewPath => 'Brands'
	layoutPath => null
	viewVars => array([maximum depth reached])
	view => 'view'
	layout => 'default'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		[maximum depth reached]
	)
	scaffold => false
	methods => array(
		[maximum depth reached]
	)
	modelClass => 'Brand'
	modelKey => 'brand'
	validationErrors => null
	Session => object(SessionComponent) {}
	Cookie => object(CookieComponent) {}
	RequestHandler => object(RequestHandlerComponent) {}
	UserAuth => object(UserAuthComponent) {}
}
object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'es/brands/view/valetta'
	base => ''
	webroot => '/'
	here => '/es/brands/view/valetta'
}
object(CakeResponse) {
	
}

APP/webroot/index.php line 92 → Dispatcher->dispatch(CakeRequest, CakeResponse)

App::uses('Dispatcher', 'Routing');

$Dispatcher = new Dispatcher();
$Dispatcher->dispatch(new CakeRequest(), new CakeResponse(array('charset' => Configure::read('App.encoding'))));

object(CakeRequest) {
	params => array(
		[maximum depth reached]
	)
	data => array([maximum depth reached])
	query => array([maximum depth reached])
	url => 'es/brands/view/valetta'
	base => ''
	webroot => '/'
	here => '/es/brands/view/valetta'
}
object(CakeResponse) {
	
}