Table 'enxrkpuk_ps2.2ps2_ed_cat_oos' doesn't existSELECT picking_days AS add_picking_days FROM 2ps2_ed_cat_oos WHERE id_category = 50 AND id_shop = 1 LIMIT 1
at line 791 in file classes/db/Db.php
786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }
420. $this->result = $this->_query($sql);
421. }
422. }
423.
424. if (_PS_DEBUG_SQL_) {
425. $this->displayError($sql);
426. }
427.
428. return $this->result;
429. }
430.
Argument [0] SELECT picking_days AS add_picking_days FROM 2ps2_ed_cat_oos WHERE id_category = 50 AND id_shop = 1 LIMIT 1
685. $this->last_cached = true;
686. return $result;
687. }
688. }
689.
690. $this->result = $this->query($sql);
691. if (!$this->result) {
692. $result = false;
693. } else {
694. $result = $this->nextRow($this->result);
695. }
Argument [0] SELECT picking_days AS add_picking_days FROM 2ps2_ed_cat_oos WHERE id_category = 50 AND id_shop = 1 LIMIT 1
331. if ($type == '') {
332. $type = 'delay AS oos_add_days, picking_days AS add_picking_days';
333. }
334. $sql = 'SELECT '.pSQL($type).' FROM '._DB_PREFIX_.'ed_cat_oos WHERE id_category = '.(int)$dp->id_category_default.' AND id_shop = '.(int)$dp->id_shop;
335. //$sql = 'SELECT '.pSQL($data_type).' FROM '._DB_PREFIX_.'ed_cat_oos WHERE '.pSQL($data_type).' > 0 AND id_category = '.(int)$dp->id_product.' AND id_shop = '.(int)$dp->id_shop;
336. $results = DB::getInstance()->getRow(pSQL($sql));
337. if ($results != false && count($results) > 0) {
338. return
339. array(
340. 'oos_add_days' => isset($results['oos_add_days']) ? $results['oos_add_days'] : 0,
341. 'add_picking_days' => isset($results['add_picking_days']) ? $results['add_picking_days'] : 0,
Argument [0] SELECT picking_days AS add_picking_days FROM 2ps2_ed_cat_oos WHERE id_category = 50 AND id_shop = 1 LIMIT 1
377. {
378. return self::getCatAdditional($dp, 'delay AS oos_add_days');
379. }
380. public static function getCatPicking($dp)
381. {
382. return self::getCatAdditional($dp, 'picking_days AS add_picking_days');
383. }
384. public static function getSupplierOOS($dp)
385. {
386. return self::getAdditionalOOS($dp, 'supplier');
387. }
Argument [0] DeliveryProduct Object ( [id_product] => 1009 [id_product_attribute] => 0 [id_default_attribute] => [id_category_default] => 50 [id_manufacturer] => 0 [id_supplier] => 0 [id_shop] => 1 [isOOS] => [canOOS] => [oos_add_days] => [picking_days] => [add_picking_days] => [is_release] => [release_date] => [is_virtual] => 0 [available_date] => [has_combi] => [quantity] => 1 [quantity_wanted] => 1 ) Argument [1] picking_days AS add_picking_days
230. break;
231. }
232. $flist = array_merge($flist, array('getProductAdditional', 'getCombiAdditional'));
233. while (($item = array_pop($flist))) {
234. if (count($flist) >= 1) {
235. $tmp = self::{$item}($dps[0]);
236. } else {
237. $tmp = self::{$item}();
238. }
239. if ($days == false) {
240. $days = $tmp;
Argument [0] DeliveryProduct Object ( [id_product] => 1009 [id_product_attribute] => 0 [id_default_attribute] => [id_category_default] => 50 [id_manufacturer] => 0 [id_supplier] => 0 [id_shop] => 1 [isOOS] => [canOOS] => [oos_add_days] => [picking_days] => [add_picking_days] => [is_release] => [release_date] => [is_virtual] => 0 [available_date] => [has_combi] => [quantity] => 1 [quantity_wanted] => 1 )
1780. }
1781. if (!empty($dp) && count($dp) > 0) {
1782. // Set up the OOS and Picking days
1783. /*$dp = DeliveryProduct::getOOSDays($dp);
1784. $dp = DeliveryProduct::getPickingDays($dp);*/
1785. $dp = DeliveryProduct::getProductAdditionalDays($dp);
1786. return $dp;
1787. } else {
1788. return false;
1789. }
1790. }
Argument [0] Array ( [0] => DeliveryProduct Object ( [id_product] => 1009 [id_product_attribute] => 0 [id_default_attribute] => [id_category_default] => 50 [id_manufacturer] => 0 [id_supplier] => 0 [id_shop] => 1 [isOOS] => [canOOS] => [oos_add_days] => [picking_days] => [add_picking_days] => [is_release] => [release_date] => [is_virtual] => 0 [available_date] => [has_combi] => [quantity] => 1 [quantity_wanted] => 1 ) )
1701. }
1702. $dh = new DeliveryHelper();
1703. /*if ($this->is_17 && $params['id_product_attribute'] != 0) {
1704.
1705. }*/
1706. $dps = $this->preProcessProducts($prod, $id_product, $id_product_attribute, $idcat, $this->context->shop->id, $quantity_wanted, $disable_quantity_check, $quantity);
1707. if ($dps !== false) {
1708. if ($this->debug_mode) {
1709. $this->debugVar($dps, 'DP (after pre process)');
1710. }
1711. if (count($dps) == 1) {
Argument [0] Product Object ( [tax_name] => [tax_rate] => [id_manufacturer] => 0 [id_supplier] => 0 [id_category_default] => 50 [id_shop_default] => 1 [manufacturer_name] => [supplier_name] => [name] => Array ( [1] => CAM lettino da campeggio: DAILY PLUS col. 260 orso luna [2] => CAM lettino da campeggio: DAILY PLUS ) [description] => Array ( [1] => INFORMAZIONI DI UTILIZZO da 0 a 36 mesi DESCRIZIONE- Con fasciatoio - Kit doppia altezza - Capottina con peluches removibili - Giocose serigrafie - Zanzariera - Ampia tasca portaoggetti - Finestra con zip - 2 ruote con freno - Materassino in tinta - Borsa da viaggio- Chiusura compatta DIMENSIONI E PESI Aperto: L 128,5 - P 73 - H 117 cm Chiuso: L 22,5 - P 21 - H 79 cm Kg 11,7 SICUREZZA - Riferimento normativa europea: EN 716-1/2 - Test impatto dinamico sulla base per verificare la resistenza del fondo - Test stabilità laterale, frontale e posteriore per evitare il rischio di ribaltamento del prodotto con il bambino al suo interno - Test del morso - Test anti intrappolamento della catenella / ciuccio - Materiali completamente atossici ed esenti da ftalati (direttiva 2005/84/CE) [2] => ) [description_short] => Array ( [1] => Pratico lettino con fasciatoio e borsa da viaggio inclusiDisponibile in diversi coloriVariante colore 260 [2] => ) [quantity] => 0 [minimal_quantity] => 1 [available_now] => Array ( [1] => [2] => ) [available_later] => Array ( [1] => [2] => ) [price] => 104.918033 [specificPrice] => 0 [additional_shipping_cost] => 0.00 [wholesale_price] => 0.000000 [on_sale] => 0 [online_only] => 0 [unity] => [unit_price] => [unit_price_ratio] => 0.000000 [ecotax] => 0.000000 [reference] => L113 [supplier_reference] => [location] => [width] => 0.000000 [height] => 0.000000 [depth] => 0.000000 [weight] => 0.000000 [ean13] => 8005549251137 [upc] => [link_rewrite] => Array ( [1] => cam-lettino-da-campeggio-daily-plus [2] => cam-lettino-da-campeggio-daily-plus ) [meta_description] => Array ( [1] => [2] => ) [meta_keywords] => Array ( [1] => [2] => ) [meta_title] => Array ( [1] => [2] => ) [quantity_discount] => 0 [customizable] => 0 [new] => [uploadable_files] => 0 [text_fields] => 0 [active] => 1 [redirect_type] => 404 [id_product_redirected] => 0 [available_for_order] => 1 [available_date] => 0000-00-00 [condition] => new [show_price] => 1 [indexed] => 1 [visibility] => both [date_add] => 2022-02-03 15:34:52 [date_upd] => 2023-01-24 22:42:22 [tags] => [base_price] => [id_tax_rules_group] => 1 [id_color_default] => 0 [advanced_stock_management] => 0 [out_of_stock] => 2 [depends_on_stock] => [isFullyLoaded] => [cache_is_pack] => 0 [cache_has_attachments] => 0 [is_virtual] => 0 [id_pack_product_attribute] => [cache_default_attribute] => 0 [category] => [pack_stock_type] => 3 [webserviceParameters:protected] => Array ( [objectMethods] => Array ( [add] => addWs [update] => updateWs ) [objectNodeNames] => products [fields] => Array ( [id_manufacturer] => Array ( [xlink_resource] => manufacturers ) [id_supplier] => Array ( [xlink_resource] => suppliers ) [id_category_default] => Array ( [xlink_resource] => categories ) [new] => Array ( ) [cache_default_attribute] => Array ( ) [id_default_image] => Array ( [getter] => getCoverWs [setter] => setCoverWs [xlink_resource] => Array ( [resourceName] => images [subResourceName] => products ) ) [id_default_combination] => Array ( [getter] => getWsDefaultCombination [setter] => setWsDefaultCombination [xlink_resource] => Array ( [resourceName] => combinations ) ) [id_tax_rules_group] => Array ( [xlink_resource] => Array ( [resourceName] => tax_rule_groups ) ) [position_in_category] => Array ( [getter] => getWsPositionInCategory [setter] => setWsPositionInCategory ) [manufacturer_name] => Array ( [getter] => getWsManufacturerName [setter] => ) [quantity] => Array ( [getter] => [setter] => ) [type] => Array ( [getter] => getWsType [setter] => setWsType ) ) [associations] => Array ( [categories] => Array ( [resource] => category [fields] => Array ( [id] => Array ( [required] => 1 ) ) ) [images] => Array ( [resource] => image [fields] => Array ( [id] => Array ( ) ) ) [combinations] => Array ( [resource] => combination [fields] => Array ( [id] => Array ( [required] => 1 ) ) ) [product_option_values] => Array ( [resource] => product_option_value [fields] => Array ( [id] => Array ( [required] => 1 ) ) ) [product_features] => Array ( [resource] => product_feature [fields] => Array ( [id] => Array ( [required] => 1 ) [id_feature_value] => Array ( [required] => 1 [xlink_resource] => product_feature_values ) ) ) [tags] => Array ( [resource] => tag [fields] => Array ( [id] => Array ( [required] => 1 ) ) ) [stock_availables] => Array ( [resource] => stock_available [fields] => Array ( [id] => Array ( [required] => 1 ) [id_product_attribute] => Array ( [required] => 1 ) ) [setter] => ) [accessories] => Array ( [resource] => product [api] => products [fields] => Array ( [id] => Array ( [required] => 1 [xlink_resource] => product ) ) ) [product_bundle] => Array ( [resource] => product [api] => products [fields] => Array ( [id] => Array ( [required] => 1 ) [quantity] => Array ( ) ) ) ) ) [id] => 1009 [id_lang:protected] => [id_shop:protected] => 1 [id_shop_list] => [get_shop_from_context:protected] => 1 [table:protected] => product [identifier:protected] => id_product [fieldsRequired:protected] => Array ( [0] => price ) [fieldsSize:protected] => Array ( [reference] => 32 [supplier_reference] => 32 [location] => 64 [ean13] => 13 [upc] => 12 ) [fieldsValidate:protected] => Array ( [id_shop_default] => isUnsignedId [id_manufacturer] => isUnsignedId [id_supplier] => isUnsignedId [reference] => isReference [supplier_reference] => isReference [location] => isReference [width] => isUnsignedFloat [height] => isUnsignedFloat [depth] => isUnsignedFloat [weight] => isUnsignedFloat [quantity_discount] => isBool [ean13] => isEan13 [upc] => isUpc [cache_is_pack] => isBool [cache_has_attachments] => isBool [is_virtual] => isBool [id_category_default] => isUnsignedId [id_tax_rules_group] => isUnsignedId [on_sale] => isBool [online_only] => isBool [ecotax] => isPrice [minimal_quantity] => isUnsignedInt [price] => isPrice [wholesale_price] => isPrice [unity] => isString [additional_shipping_cost] => isPrice [customizable] => isUnsignedInt [text_fields] => isUnsignedInt [uploadable_files] => isUnsignedInt [active] => isBool [redirect_type] => isString [id_product_redirected] => isUnsignedId [available_for_order] => isBool [available_date] => isDateFormat [condition] => isGenericName [show_price] => isBool [indexed] => isBool [visibility] => isProductVisibility [advanced_stock_management] => isBool [date_add] => isDate [date_upd] => isDate [pack_stock_type] => isUnsignedInt ) [fieldsRequiredLang:protected] => Array ( [0] => link_rewrite [1] => name ) [fieldsSizeLang:protected] => Array ( [meta_description] => 255 [meta_keywords] => 255 [meta_title] => 128 [link_rewrite] => 128 [name] => 128 [available_now] => 255 [available_later] => 255 ) [fieldsValidateLang:protected] => Array ( [meta_description] => isGenericName [meta_keywords] => isGenericName [meta_title] => isGenericName [link_rewrite] => isLinkRewrite [name] => isCatalogName [description] => isCleanHtml [description_short] => isCleanHtml [available_now] => isGenericName [available_later] => IsGenericName ) [tables:protected] => Array ( ) [image_dir:protected] => [image_format:protected] => jpg [def:protected] => Array ( [table] => product [primary] => id_product [multilang] => 1 [multilang_shop] => 1 [fields] => Array ( [id_shop_default] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_manufacturer] => Array ( [type] => 1 [validate] => isUnsignedId ) [id_supplier] => Array ( [type] => 1 [validate] => isUnsignedId ) [reference] => Array ( [type] => 3 [validate] => isReference [size] => 32 ) [supplier_reference] => Array ( [type] => 3 [validate] => isReference [size] => 32 ) [location] => Array ( [type] => 3 [validate] => isReference [size] => 64 ) [width] => Array ( [type] => 4 [validate] => isUnsignedFloat ) [height] => Array ( [type] => 4 [validate] => isUnsignedFloat ) [depth] => Array ( [type] => 4 [validate] => isUnsignedFloat ) [weight] => Array ( [type] => 4 [validate] => isUnsignedFloat ) [quantity_discount] => Array ( [type] => 2 [validate] => isBool ) [ean13] => Array ( [type] => 3 [validate] => isEan13 [size] => 13 ) [upc] => Array ( [type] => 3 [validate] => isUpc [size] => 12 ) [cache_is_pack] => Array ( [type] => 2 [validate] => isBool ) [cache_has_attachments] => Array ( [type] => 2 [validate] => isBool ) [is_virtual] => Array ( [type] => 2 [validate] => isBool ) [id_category_default] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedId ) [id_tax_rules_group] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedId ) [on_sale] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [online_only] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [ecotax] => Array ( [type] => 4 [shop] => 1 [validate] => isPrice ) [minimal_quantity] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedInt ) [price] => Array ( [type] => 4 [shop] => 1 [validate] => isPrice [required] => 1 ) [wholesale_price] => Array ( [type] => 4 [shop] => 1 [validate] => isPrice ) [unity] => Array ( [type] => 3 [shop] => 1 [validate] => isString ) [unit_price_ratio] => Array ( [type] => 4 [shop] => 1 ) [additional_shipping_cost] => Array ( [type] => 4 [shop] => 1 [validate] => isPrice ) [customizable] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedInt ) [text_fields] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedInt ) [uploadable_files] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedInt ) [active] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [redirect_type] => Array ( [type] => 3 [shop] => 1 [validate] => isString ) [id_product_redirected] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedId ) [available_for_order] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [available_date] => Array ( [type] => 5 [shop] => 1 [validate] => isDateFormat ) [condition] => Array ( [type] => 3 [shop] => 1 [validate] => isGenericName [values] => Array ( [0] => new [1] => used [2] => refurbished ) [default] => new ) [show_price] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [indexed] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [visibility] => Array ( [type] => 3 [shop] => 1 [validate] => isProductVisibility [values] => Array ( [0] => both [1] => catalog [2] => search [3] => none ) [default] => both ) [cache_default_attribute] => Array ( [type] => 1 [shop] => 1 ) [advanced_stock_management] => Array ( [type] => 2 [shop] => 1 [validate] => isBool ) [date_add] => Array ( [type] => 5 [shop] => 1 [validate] => isDate ) [date_upd] => Array ( [type] => 5 [shop] => 1 [validate] => isDate ) [pack_stock_type] => Array ( [type] => 1 [shop] => 1 [validate] => isUnsignedInt ) [meta_description] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 255 ) [meta_keywords] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 255 ) [meta_title] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 128 ) [link_rewrite] => Array ( [type] => 3 [lang] => 1 [validate] => isLinkRewrite [required] => 1 [size] => 128 [ws_modifier] => Array ( [http_method] => 2 [modifier] => modifierWsLinkRewrite ) ) [name] => Array ( [type] => 3 [lang] => 1 [validate] => isCatalogName [required] => 1 [size] => 128 ) [description] => Array ( [type] => 6 [lang] => 1 [validate] => isCleanHtml ) [description_short] => Array ( [type] => 6 [lang] => 1 [validate] => isCleanHtml ) [available_now] => Array ( [type] => 3 [lang] => 1 [validate] => isGenericName [size] => 255 ) [available_later] => Array ( [type] => 3 [lang] => 1 [validate] => IsGenericName [size] => 255 ) ) [associations] => Array ( [manufacturer] => Array ( [type] => 1 ) [supplier] => Array ( [type] => 1 ) [default_category] => Array ( [type] => 1 [field] => id_category_default [object] => Category ) [tax_rules_group] => Array ( [type] => 1 ) [categories] => Array ( [type] => 2 [field] => id_category [object] => Category [association] => category_product ) [stock_availables] => Array ( [type] => 2 [field] => id_stock_available [object] => StockAvailable [association] => stock_availables ) [l] => Array ( [type] => 2 [field] => id_product [foreign_field] => id_product ) ) [classname] => Product ) [update_fields:protected] => [force_id] => ) Argument [1] 1009 Argument [2] 0 Argument [3] 50 Argument [4] 1 Argument [5] 1 Argument [6] Argument [7] 1
2901. }
2902.
2903. public function hookDisplayRightColumnProduct($params)
2904. {
2905. if (Configuration::get('ED_LOCATION') == 1) {
2906. return $this->showEstimatedDelivery($params);
2907. }
2908. }
2909. public function hookDisplayLeftColumnProduct($params)
2910. {
2911. if (Configuration::get('ED_LOCATION') == 2) {
Argument [0]
586. }
587. }
588.
589. // Immediately return the result if we do not log performances
590. if (!Module::$_log_modules_perfs) {
591. return $module->{$method}($params);
592. }
593.
594. // Store time and memory before and after hook call and save the result in the database
595. $time_start = microtime(true);
596. $memory_start = memory_get_usage(true);
Argument [0]
541. Tools::waitUntilFileIsModified($moduleInstance->push_filename, $moduleInstance->push_time_limit);
542. }
543.
544. // Call hook method
545. if ($hook_callable) {
546. $display = Hook::coreCallHook($moduleInstance, 'hook'.$hook_name, $hook_args);
547. } elseif ($hook_retro_callable) {
548. $display = Hook::coreCallHook($moduleInstance, 'hook'.$retro_hook_name, $hook_args);
549. }
550.
551. // Live edit
Argument [0] Argument [1] hookdisplayRightColumnProduct Argument [2]
270. 'features' => $this->product->getFrontFeatures($this->context->language->id),
271. 'attachments' => (($this->product->cache_has_attachments) ? $this->product->getAttachments($this->context->language->id) : array()),
272. 'allow_oosp' => $this->product->isAvailableWhenOutOfStock((int)$this->product->out_of_stock),
273. 'last_qties' => (int)Configuration::get('PS_LAST_QTIES'),
274. 'HOOK_EXTRA_LEFT' => Hook::exec('displayLeftColumnProduct'),
275. 'HOOK_EXTRA_RIGHT' => Hook::exec('displayRightColumnProduct'),
276. 'HOOK_PRODUCT_OOS' => Hook::exec('actionProductOutOfStock', array('product' => $this->product)),
277. 'HOOK_PRODUCT_ACTIONS' => Hook::exec('displayProductButtons', array('product' => $this->product)),
278. 'HOOK_PRODUCT_TAB' => Hook::exec('displayProductTab', array('product' => $this->product)),
279. 'HOOK_PRODUCT_TAB_CONTENT' => Hook::exec('displayProductTabContent', array('product' => $this->product)),
280. 'HOOK_PRODUCT_CONTENT' => Hook::exec('displayProductContent', array('product' => $this->product)),
Argument [0] displayRightColumnProduct
184. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
185. $this->initHeader();
186. }
187.
188. if ($this->viewAccess()) {
189. $this->initContent();
190. } else {
191. $this->errors[] = Tools::displayError('Access denied.');
192. }
193.
194. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
362. if (isset($params_hook_action_dispatcher)) {
363. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
364. }
365.
366. // Running controller
367. $controller->run();
368. } catch (PrestaShopException $e) {
369. $e->displayMessage();
370. }
371. }
372.
23. * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
24. * International Registered Trademark & Property of PrestaShop SA
25. */
26.
27. require(dirname(__FILE__).'/config/config.inc.php');
28. Dispatcher::getInstance()->dispatch();