SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: '1'
at line 135 in file vendor/phenyxdigitale/digitalcore/src/classes/db/DbPDO.php
130. * @since 1.9.1.0
131. * @version 1.8.1.0 Initial version
132. */
133. protected function _query($sql) {
134.
135. return isset($this->link) ? $this->link->query($sql) : null;
136. }
137.
138. /**
139. * Returns the next row from the result set.
140. *
130. * @since 1.9.1.0
131. * @version 1.8.1.0 Initial version
132. */
133. protected function _query($sql) {
134.
135. return isset($this->link) ? $this->link->query($sql) : null;
136. }
137.
138. /**
139. * Returns the next row from the result set.
140. *
530.
531. if ($sql instanceof DbQuery) {
532. $sql = $sql->build();
533. }
534.
535. $this->result = $this->_query($sql);
536.
537. if (!$this->result && $this->getNumberError() == 2006) {
538.
539. if ($this->connect()) {
540. $this->result = $this->_query($sql);
870. }
871.
872. return $this->execute($sql, $useCache);
873. }
874.
875. $this->result = $this->query($sql);
876.
877. if (!$this->result) {
878. $result = false;
879. } else {
880.
658. if (!static::isFeatureActive()) {
659. return [];
660. }
661.
662. $queryExtra = static::computeExtraConditions(null, null, $idCustomer, null, $beginning, $ending);
663. $results = Db::getInstance(_EPH_USE_SQL_SLAVE_)->executeS(
664. (new DbQuery())
665. ->select('`id_product`, `id_product_attribute`')
666. ->from('specific_price')
667. ->where('`id_currency` ' . static::formatIntInQuery(0, $idCurrency))
668. ->where('`id_country` ' . static::formatIntInQuery(0, $idCountry))
2440. $idCountry = ($ids && $ids['id_country'])
2441.
2442. ? (int) $ids['id_country']
2443. : (int) Configuration::get('EPH_COUNTRY_DEFAULT');
2444.
2445. return SpecificPrice::getProductIdByDate(
2446. $context->company->id,
2447. $context->currency->id,
2448. $idCountry,
2449. $context->user->id_default_group,
2450. $beginning,
2501. if (!Validate::isOrderBy($orderBy) || !Validate::isOrderWay($orderWay)) {
2502. die(Tools::displayError());
2503. }
2504.
2505. $currentDate = date('Y-m-d H:i:00');
2506. $idsProduct = static::_getProductIdByDate((!$beginning ? $currentDate : $beginning), (!$ending ? $currentDate : $ending), $context);
2507.
2508. $tabIdProduct = [];
2509.
2510. foreach ($idsProduct as $product) {
2511.
37. public function initContent() {
38.
39. parent::initContent();
40.
41. $this->productSort();
42. $nbProducts = Product::getPricesDrop($this->context->language->id, null, null, true);
43. $this->pagination($nbProducts);
44.
45. $products = Product::getPricesDrop($this->context->language->id, (int) $this->p - 1, (int) $this->n, false, $this->orderBy, $this->orderWay);
46. $this->addColorsToProductList($products);
47.
724. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
725. $this->initHeader();
726. }
727.
728. if ($this->viewAccess()) {
729. $this->initContent();
730. } else {
731. $this->errors[] = Tools::displayError('Access denied.');
732. }
733.
734. if (!$this->content_only && ($this->display_footer || (isset($this->className) && $this->className))) {
282.
283. if ($debug) {
284. header('X-ephenyx-PageCache: MISS');
285. }
286.
287. return parent::run();
288. }
289.
290. if ($debug) {
291. header('X-ephenyx-PageCache: HIT');
292. }
675. try {
676. // Loading controller
677. $controller = PhenyxController::getController($controllerClass);
678.
679. // Running controller
680. $controller->run();
681. } catch (PhenyxException $e) {
682. $e->displayMessage();
683. }
684.
685. }
1. <?php
2.
3. require(dirname(__FILE__).'/app/config.inc.php');
4. Performer::getInstance()->dispatch();