OpenCart Community

Code: Select all

Warning: mysqli::set_charset(): Error executing query in /***/shop/system/library/db/mysqli.php on line 13

Code: Select all

$this->connection->set_charset("utf8");

Code: Select all

$this->connection->set_charset("");

Code: Select all

Warning: mysqli::set_charset(): Error executing query in /hermes/bosnaweb19a/b2220/ipg.***/shop/system/library/db/mysqli.php on line 13
Fatal error: Uncaught Exception: Error: User 'yanbootshop' has exceeded the 'max_questions' resource (current value: 75000)<br />Error No: 1226<br />SELECT value FROM cho_setting WHERE `code` = 'config' AND `key` = 'config_timezone' in /hermes/bosnaweb19a/b2220/ipg.***/shop/system/library/db/mysqli.php:40 Stack trace: #0 /hermes/bosnaweb19a/b2220/ipg.***/shop/system/storage/modification/system/library/db.php(33): DB\MySQLi->query('SELECT value FR...') #1 /hermes/bosnaweb19a/b2220/ipg.***/shop/system/framework.php(80): DB->__construct('mysqli', '***.ipag...', 'yanbootshop', 'kGz=8m7_PKc5bK_...', 'opencart19', '3306') #2 /hermes/bosnaweb19a/b2220/ipg.***/shop/system/startup.php(104): require_once('/hermes/bosnawe...') #3 /hermes/bosnaweb19a/b2220/ipg.***/shop/index.php(19): start('catalog') #4 {main} thrown in /hermes/bosnaweb19a/b2220/ipg.***/shop/system/library/db/mysqli.php on line 40

Code: Select all

// SEO
// cache seo keywords in constant by one query in startup
define('USE_SEO_CACHE', true);
// additionally, store the seo keywords cache in file (might actually slow things down, reading cache file vs query)
define('USE_SEO_CACHE_FILE', false);

Code: Select all

		// OpenBay Pro
		$this->registry->set('openbay', new Openbay($this->registry));

Code: Select all

		// SEO CACHE if seo urls enabled and seo cache enabled
		if ($this->config->get('config_seo_url') && USE_SEO_CACHE) {
			$pairs = false;
			// define cache storage by store and language
			$seo_pair_cache_file = 'seo.'.$this->config->get('config_store_id').'.'.$this->config->get('config_language_id');
			// read cache storage if enabled
			if (USE_SEO_CACHE_FILE) $pairs = $this->cache->get($seo_pair_cache_file);
			// if no storage or no storage enabled fetch all seo query/keyword pairs for store and language
			if (!$pairs) {
				$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "' order by keyword ASC ");
				$pairs = array();
				// build query/keyword pairs
				foreach ($query->rows as $row) $pairs[$row['query']] = $row['keyword'];
				// store the pairs in file if enabled
				if (USE_SEO_CACHE_FILE) $this->cache->set($seo_pair_cache_file, $pairs);
				// free memory
				unset ($query);
			}
			// define the pair constant
			define('SEO_PAIRS', $pairs);
			// free memory
			unset($pairs);
		}
		

Code: Select all

		foreach ($data as $key => $value) {
			if (isset($data['route'])) {
				if (($data['route'] == 'product/product' && $key == 'product_id') || (($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') || ($data['route'] == 'information/information' && $key == 'information_id')) {
					$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");

					if ($query->num_rows && $query->row['keyword']) {
						$url .= '/' . $query->row['keyword'];

						unset($data[$key]);
					}
				} elseif ($key == 'path') {
					$categories = explode('_', $value);

					foreach ($categories as $category) {
						$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = 'category_id=" . (int)$category . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");

						if ($query->num_rows && $query->row['keyword']) {
							$url .= '/' . $query->row['keyword'];
						} else {
							$url = '';

							break;
						}
					}

					unset($data[$key]);
				}
			}
		}

Code: Select all

		foreach ($data as $key => $value) {
			if (isset($data['route'])) {
				if (($data['route'] == 'product/product' && $key == 'product_id') || (($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') || ($data['route'] == 'information/information' && $key == 'information_id')) {
					if (USE_SEO_CACHE && SEO_PAIRS) {
						if (isset(SEO_PAIRS[$key . '=' . $value])) {
							$url .= '/' . SEO_PAIRS[$key . '=' . $value];
							unset($data[$key]);
						}
					} else {
						$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
						if ($query->num_rows && $query->row['keyword']) {
							$url .= '/' . $query->row['keyword'];
							unset($data[$key]);
						}
					}
				} elseif ($key == 'path') {
					$categories = explode('_', $value);
					foreach ($categories as $category) {
						if (USE_SEO_CACHE && SEO_PAIRS) {
							if (isset(SEO_PAIRS['category_id=' . $category])) {
								$url .= '/' . SEO_PAIRS['category_id=' . $category];
								unset($data[$key]);
							} else {
								$url = '';
								break;
							}
						} else {
							$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = 'category_id=" . (int)$category . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
							if ($query->num_rows && $query->row['keyword']) {
								$url .= '/' . $query->row['keyword'];
							} else {
								$url = '';
								break;
							}
						}
					}
					unset($data[$key]);
				}
			}
		}

Code: Select all

Warning: Constants may only evaluate to scalar values in D:\xampp56\htdocs\shop\catalog\controller\startup\startup.php on line 219
Fatal error: Cannot use isset() on the result of an expression (you can use "null !== expression" instead) in D:\xampp56\htdocs\shop\catalog\controller\startup\seo_url.php on line 88

Code: Select all

define('SEO_PAIRS', $pairs);

Code: Select all

if (isset(SEO_PAIRS[$key . '=' . $value])) {