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 'LIMIT 1' at line 1select GROUP_CONCAT(id_group) from ps_customer_group WHERE id_customer = LIMIT 1
at line 727 in file classes/db/Db.php
722. if ($webservice_call && $errno) {
723. $dbg = debug_backtrace();
724. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
725. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
726. if ($sql) {
727. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
728. }
729.
730. throw new PrestaShopDatabaseException($this->getMsgError());
731. }
732. }
358. $this->result = $this->_query($sql);
359. }
360. }
361.
362. if (_PS_DEBUG_SQL_) {
363. $this->displayError($sql);
364. }
365.
366. return $this->result;
367. }
368.
Argument [0] select GROUP_CONCAT(id_group) from ps_customer_group WHERE id_customer = LIMIT 1
625. $this->last_cached = true;
626. return $result;
627. }
628. }
629.
630. $this->result = $this->query($sql);
631. if (!$this->result) {
632. $result = false;
633. } else {
634. $result = $this->nextRow($this->result);
635. }
Argument [0] select GROUP_CONCAT(id_group) from ps_customer_group WHERE id_customer = LIMIT 1
657. {
658. if ($sql instanceof DbQuery) {
659. $sql = $sql->build();
660. }
661.
662. if (!$result = $this->getRow($sql, $use_cache)) {
663. return false;
664. }
665.
666. return array_shift($result);
667. }
Argument [0] select GROUP_CONCAT(id_group) from ps_customer_group WHERE id_customer = LIMIT 1 Argument [1] 1
321. /* The date is not taken into account for the cache, but this is for the better because it keeps the consistency for the whole script.
322. The price must not change between the top and the bottom of the page */
323.
324. $key = ((int)$id_product.'-'.(int)$id_shop.'-'.(int)$id_currency.'-'.(int)$id_country.'-'.(int)$id_group.'-'.(int)$quantity.'-'.(int)$id_product_attribute.'-'.(int)$id_cart.'-'.(int)$id_customer.'-'.(int)$real_quantity);
325. $sql = 'select GROUP_CONCAT(id_group) from ps_customer_group WHERE id_customer = '.$id_customer;
326. $groups = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql);
327. $grpquery = ' (0,'.$groups.') ';
328. if($groups == null){
329. $grpquery = ' (0) ';
330. }
331.
Argument [0] select GROUP_CONCAT(id_group) from ps_customer_group WHERE id_customer =
3130. $id_group,
3131. $quantity,
3132. $id_product_attribute,
3133. $id_customer,
3134. $id_cart,
3135. $real_quantity
3136. );
3137.
3138. if($_SERVER['REMOTE_ADDR'] == '49.36.65.132' ) {
3139. // print_r($specific_price);
3140. // die();
Argument [0] 20123 Argument [1] 1 Argument [2] 1 Argument [3] 15 Argument [4] 1 Argument [5] 1 Argument [6] 0 Argument [7] Argument [8] Argument [9] 0
3054. $specific_price_output,
3055. $use_group_reduction,
3056. $id_customer,
3057. $use_customer_price,
3058. $id_cart,
3059. $cart_quantity
3060. );
3061.
3062. return $return;
3063. }
3064.
Argument [0] 1 Argument [1] 20123 Argument [2] 0 Argument [3] 15 Argument [4] 0 Argument [5] 0 Argument [6] 1 Argument [7] 1 Argument [8] 1 Argument [9] Argument [10] 2 Argument [11] Argument [12] 1 Argument [13] 1 Argument [14] Argument [15] 1 Argument [16] Argument [17] 1 Argument [18] Argument [19] 0
4633.
4634. $row['price_tax_exc'] = Product::getPriceStatic(
4635. (int)$row['id_product'],
4636. false,
4637. $id_product_attribute,
4638. (self::$_taxCalculationMethod == PS_TAX_EXC ? 2 : 6)
4639. );
4640.
4641. if (self::$_taxCalculationMethod == PS_TAX_EXC) {
4642. $row['price_tax_exc'] = Tools::ps_round($row['price_tax_exc'], 2);
4643. $row['price'] = Product::getPriceStatic(
Argument [0] 20123 Argument [1] Argument [2] Argument [3] 2
9541.
9542.
9543.
9544. foreach ($result as &$rowData) : // NJ
9545.
9546. if ($row = Product::getProductBasicProperties( (int)$rowData['id_product'] , $id_shop, $id_lang, $context)) {
9547.
9548. $results_array[] = $row;
9549.
9550. }
9551.
Argument [0] 20123 Argument [1] 1 Argument [2] 5 Argument [3]
9161.
9162. $params['nbProducts'] = $this->getCategoryProducts(null, null, null, $this->context->controller->orderBy, $this->context->controller->orderWay, true);
9163.
9164. $this->context->controller->pagination((int)$params['nbProducts']);
9165.
9166. $params['catProducts'] = $this->getCategoryProducts((int)$this->context->language->id, (int)$this->context->controller->p, (int)$this->context->controller->n, $this->context->controller->orderBy, $this->context->controller->orderWay);
9167.
9168. }
9169.
9170. }
9171.
Argument [0] 5 Argument [1] 3 Argument [2] 12 Argument [3] name Argument [4] ASC
512. }
513. }
514.
515. // Immediately return the result if we do not log performances
516. if (!Module::$_log_modules_perfs) {
517. return $module->{$method}($params);
518. }
519.
520. // Store time and memory before and after hook call and save the result in the database
521. $time_start = microtime(true);
522. $memory_start = memory_get_usage(true);
Argument [0]
467. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
468. }
469.
470. // Call hook method
471. if ($hook_callable) {
472. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
473. } elseif ($hook_retro_callable) {
474. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
475. }
476.
477. // Live edit
Argument [0] Argument [1] hookactionProductListOverride Argument [2]
182.
183. $hook_executed = false;
184. Hook::exec('actionProductListOverride', array(
185. 'nbProducts' => &$this->nbProducts,
186. 'catProducts' => &$this->cat_products,
187. 'hookExecuted' => &$hook_executed,
188. ));
189.
190. // The hook was not executed, standard working
191. if (!$hook_executed) {
192. $this->context->smarty->assign('categoryNameComplement', '');
Argument [0] actionProductListOverride Argument [1]
105. // Product sort must be called before assignProductList()
106. $this->productSort();
107.
108. //$this->assignScenes();
109. //$this->assignSubcategories();
110. $this->assignProductList();
111.
112. $pCatId = $this->getMainCategoryId($this->category->id_category , $this->category->level_depth);
113. $pCatData = new Category($pCatId, $this->context->language->id);
114.
115. $catpageTitle = ($pCatData->name) ? $pCatData->name.' - '.$this->category->name : $this->category->name;
151. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
152. $this->initHeader();
153. }
154.
155. if ($this->viewAccess()) {
156. $this->initContent();
157. } else {
158. $this->errors[] = Tools::displayError('Access denied.');
159. }
160.
161. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
381. if (isset($params_hook_action_dispatcher)) {
382. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
383. }
384.
385. // Running controller
386. $controller->run();
387.
388. } catch (PrestaShopException $e) {
389. $e->displayMessage();
390. }
391. }
1. <?php
2.
3. require(dirname(__FILE__).'/config/config.inc.php');
4. Dispatcher::getInstance()->dispatch();