sxmFinder.com

Notice (8): Undefined index: data [APP/Controller/ListingsController.php, line 469]

        else 
        {
            $this->request->query ['data'] = ltrim($this->request->query ['data']);

$actual_link = 'http://www.sxmfinder.com/listings?cat%5B%5D=discount-store'
$category_ids_array = []
$order = [
	'featured' => 'DESC',
	'payment_status' => 'DESC',
	'boop_count' => 'DESC',
	'user_id' => 'DESC'
]
$conditions = []
$loggedInUserInfo = []
$allfreeusersofcategory = []
$categorysearchflag = (int) 0
$searchcatnames = ''
$filters = [
	'sort_direction' => 'desc',
	'limit' => (int) 10
]
$sortableFields = [
	(int) 0 => 'Listings.payment_status',
	(int) 1 => 'boop_count',
	(int) 2 => 'Listings.created',
	(int) 3 => 'name',
	(int) 4 => 'featured',
	(int) 5 => 'listing_review_count',
	(int) 6 => 'rating_avg'
]
$category_ids = null
$sub_category_ids = null
$search_keyword = null
$search_location = null
$default_order = [
	'featured' => 'DESC',
	'payment_status' => 'DESC',
	'boop_count' => 'DESC',
	'user_id' => 'DESC'
]
$relavant_flag = true
$searchedcategoryid = ''
$exact_list = null
$exactmatch_list = null
$catidsarr = []
$list_conditions = []
$category_list1 = []
$list_conditions1 = []
$tag_condition1 = []
$completesdata = ''

App\Controller\ListingsController::index() - APP/Controller/ListingsController.php, line 469
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 410
Cake\Routing\Dispatcher::_invoke() - CORE/src/Routing/Dispatcher.php, line 114
Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 87
[main] - ROOT/webroot/index.php, line 37

Notice (8): Trying to get property of non-object [APP/Controller/ListingsController.php, line 522]

Code Context

            foreach($this->request->query ['cat'] as $cat){
                $catgry = $this->Categories->find()->where(['Categories.slug'=>$cat])->first();
                array_push($category_ids_array, $catgry->id);

$actual_link = 'http://www.sxmfinder.com/listings?cat%5B%5D=discount-store'
$category_ids_array = []
$order = [
	'featured' => 'DESC',
	'payment_status' => 'DESC',
	'boop_count' => 'DESC',
	'user_id' => 'DESC'
]
$conditions = []
$loggedInUserInfo = []
$allfreeusersofcategory = []
$categorysearchflag = (int) 0
$searchcatnames = ''
$filters = [
	'sort_direction' => 'desc',
	'limit' => (int) 10
]
$sortableFields = [
	(int) 0 => 'Listings.payment_status',
	(int) 1 => 'boop_count',
	(int) 2 => 'Listings.created',
	(int) 3 => 'name',
	(int) 4 => 'featured',
	(int) 5 => 'listing_review_count',
	(int) 6 => 'rating_avg'
]
$category_ids = null
$sub_category_ids = null
$search_keyword = [
	(int) 0 => ''
]
$search_location = null
$default_order = [
	'featured' => 'DESC',
	'payment_status' => 'DESC',
	'boop_count' => 'DESC',
	'user_id' => 'DESC'
]
$relavant_flag = true
$searchedcategoryid = ''
$exact_list = null
$exactmatch_list = null
$catidsarr = []
$list_conditions = []
$category_list1 = []
$list_conditions1 = []
$tag_condition1 = []
$completesdata = ''
$words = [
	(int) 0 => ''
]
$word = ''
$key = (int) 0
$cat = 'discount-store'
$catgry = null

App\Controller\ListingsController::index() - APP/Controller/ListingsController.php, line 522
Cake\Controller\Controller::invokeAction() - CORE/src/Controller/Controller.php, line 410
Cake\Routing\Dispatcher::_invoke() - CORE/src/Routing/Dispatcher.php, line 114
Cake\Routing\Dispatcher::dispatch() - CORE/src/Routing/Dispatcher.php, line 87
[main] - ROOT/webroot/index.php, line 37

Listings

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 ' Listings.categoryids)) AND (Listings.name like '% %' OR Listings.name like '%' ' at line 1

Error: The requested address '/listings?cat%5B0%5D=discount-store&data=' was not found on this server.