Table 'dbs12666294.ozyj_category' doesn't exist<br /><br /><pre>SELECT *
FROM `ozyj_category` a
LEFT JOIN `ozyj_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ozyj_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1</pre>
at line 769 in file classes/db/Db.php
764. if ($webservice_call && $errno) {
765. $dbg = debug_backtrace();
766. WebserviceRequest::getInstance()->setError(500, '[SQL Error] ' . $this->getMsgError() . '. From ' . (isset($dbg[3]['class']) ? $dbg[3]['class'] : '') . '->' . $dbg[3]['function'] . '() Query was : ' . $sql, 97);
767. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
768. if ($sql) {
769. throw new PrestaShopDatabaseException($this->getMsgError() . '<br /><br /><pre>' . $sql . '</pre>');
770. }
771.
772. throw new PrestaShopDatabaseException($this->getMsgError());
773. }
774. }
380. $this->result = $this->_query($sql);
381. }
382. }
383.
384. if (_PS_DEBUG_SQL_) {
385. $this->displayError($sql);
386. }
387.
388. return $this->result;
389. }
390.
658.
659. return $result;
660. }
661. }
662.
663. $this->result = $this->query($sql);
664. if (!$this->result) {
665. $result = false;
666. } else {
667. $result = $this->nextRow($this->result);
668. }
70. // Get shop informations
71. if (Shop::isTableAssociated($entity_defs['table'])) {
72. $sql->leftJoin($entity_defs['table'] . '_shop', 'c', 'a.`' . bqSQL($entity_defs['primary']) . '` = c.`' . bqSQL($entity_defs['primary']) . '` AND c.`id_shop` = ' . (int) $id_shop);
73. }
74.
75. if ($object_datas = Db::getInstance()->getRow($sql)) {
76. if (!$id_lang && isset($entity_defs['multilang']) && $entity_defs['multilang']) {
77. $sql = 'SELECT *
78. FROM `' . bqSQL(_DB_PREFIX_ . $entity_defs['table']) . '_lang`
79. WHERE `' . bqSQL($entity_defs['primary']) . '` = ' . (int) $id
80. . (($id_shop && $entity->isLangMultishop()) ? ' AND `id_shop` = ' . (int) $id_shop : '');
259. $this->id_shop = Context::getContext()->shop->id;
260. }
261.
262. if ($id) {
263. $entity_mapper = ServiceLocator::get('\\PrestaShop\\PrestaShop\\Adapter\\EntityMapper');
264. $entity_mapper->load($id, $id_lang, $this, $this->def, $this->id_shop, self::$cache_objects);
265. }
266. }
267.
268. protected function trans($id, array $parameters = array(), $domain = null, $locale = null)
269. {
145. * @param null $idLang
146. * @param null $idShop
147. */
148. public function __construct($idCategory = null, $idLang = null, $idShop = null)
149. {
150. parent::__construct($idCategory, $idLang, $idShop);
151. $this->image_dir = _PS_CAT_IMG_DIR_;
152. $this->id_image = ($this->id && file_exists($this->image_dir . (int) $this->id . '.jpg')) ? (int) $this->id : false;
153. if (defined('PS_INSTALLATION_IN_PROGRESS')) {
154. $this->doNotRegenerateNTree = true;
155. }
80. public function init()
81. {
82. $id_category = (int) Tools::getValue('id_category');
83. $this->category = new Category(
84. $id_category,
85. $this->context->language->id
86. );
87.
88. if (!Validate::isLoadedObject($this->category) || !$this->category->active) {
89. Tools::redirect('index.php?controller=404');
90. }
268. /**
269. * Starts the controller process (this method should not be overridden!).
270. */
271. public function run()
272. {
273. $this->init();
274. if ($this->checkAccess()) {
275. // setMedia MUST be called before postProcess
276. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) {
277. $this->setMedia();
278. }
510. if (isset($params_hook_action_dispatcher)) {
511. Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
512. }
513.
514. // Running controller
515. $controller->run();
516.
517. // Execute hook dispatcher after
518. if (isset($params_hook_action_dispatcher)) {
519. Hook::exec('actionDispatcherAfter', $params_hook_action_dispatcher);
520. }
23. * @license https://opensource.org/licenses/OSL-3.0 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();