Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysql.php on line 6 Notice: Error: Table 'cybermobilephon.oc_setting' doesn't exist
Error No: 1146
SELECT * FROM oc_setting WHERE store_id = '0' in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysql.php on line 50
Error No: 1146
SELECT * FROM oc_setting WHERE store_id = '0' in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysql.php on line 50
in BOTH of your config.php files, change:
// DB
define('DB_DRIVER', 'mysql');
to:
// DB
define('DB_DRIVER', 'mysqli');
and that should do it.
Ernie
bigmax.ch/shop/
// DB
define('DB_DRIVER', 'mysql');
to:
// DB
define('DB_DRIVER', 'mysqli');
and that should do it.
Ernie
bigmax.ch/shop/
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
I fixed that error now I get - Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table 'cybermobilephon.oc_store' doesn't exist
Error No: 1146
SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://cybermobilephones.co.uk/'' in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php:41 Stack trace: #0 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/library/db.php(20): DBMySQLi->query('SELECT * FROM o...') #1 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/index.php(47): DB->query('SELECT * FROM o...') #2 {main} thrown in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php on line 41
Error No: 1146
SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://cybermobilephones.co.uk/'' in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php:41 Stack trace: #0 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/library/db.php(20): DBMySQLi->query('SELECT * FROM o...') #1 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/index.php(47): DB->query('SELECT * FROM o...') #2 {main} thrown in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php on line 41
Download a MySqli-Connector File and install it:
http://www.opencart.com/index.php?route ... rch=MySqli
Ernie
http://www.opencart.com/index.php?route ... rch=MySqli
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
COPY THIS:
AND SAVE IT, correctly, (as UTF-8 File without BOM ), by use of a DECENT File Editor, like NOTEPAD++,
and WITHOUT ANY SPACES, before or after anything (WHITESPACE), copied/pasted,
AS: mysqli.php FILE!
Then, place it in your /shop/system/database/ Directory!
---
Then, rewrite your BOTH config.php files from:
to:
and test it again.
Ernie
Code: Select all
<?php
final class DBMySQLi {
private $link;
public function __construct($hostname, $username, $password, $database) {
$this->link = new mysqli($hostname, $username, $password, $database);
if (mysqli_connect_error()) {
throw new ErrorException('Error: Could not make a database link (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
}
$this->link->set_charset("utf8");
}
public function query($sql) {
$query = $this->link->query($sql);
if (!$this->link->errno) {
if (isset($query->num_rows)) {
$data = array();
while ($row = $query->fetch_assoc()) {
$data[] = $row;
}
$result = new stdClass();
$result->num_rows = $query->num_rows;
$result->row = isset($data[0]) ? $data[0] : array();
$result->rows = $data;
unset($data);
$query->close();
return $result;
} else {
return true;
}
} else {
throw new ErrorException('Error: ' . $this->link->error . '<br />Error No: ' . $this->link->errno . '<br />' . $sql);
exit();
}
}
public function escape($value) {
return $this->link->real_escape_string($value);
}
public function countAffected() {
return $this->link->affected_rows;
}
public function getLastId() {
return $this->link->insert_id;
}
public function __destruct() {
$this->link->close();
}
}
?>
and WITHOUT ANY SPACES, before or after anything (WHITESPACE), copied/pasted,
AS: mysqli.php FILE!
Then, place it in your /shop/system/database/ Directory!
---
Then, rewrite your BOTH config.php files from:
Code: Select all
// DB
define('DB_DRIVER', 'mysql');
Code: Select all
// DB
define('DB_DRIVER', 'mysqli');
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
I now get this error:
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table 'cybermobilephon.oc_store' doesn't exist
Error No: 1146
SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://cybermobilephones.co.uk/'' in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php:42 Stack trace: #0 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/library/db.php(20): DBMySQLi->query('SELECT * FROM o...') #1 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/index.php(47): DB->query('SELECT * FROM o...') #2 {main} thrown in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php on line 42
Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table 'cybermobilephon.oc_store' doesn't exist
Error No: 1146
SELECT * FROM oc_store WHERE REPLACE(`url`, 'www.', '') = 'http://cybermobilephones.co.uk/'' in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php:42 Stack trace: #0 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/library/db.php(20): DBMySQLi->query('SELECT * FROM o...') #1 /customers/8/9/6/cybermobilephones.co.uk/httpd.www/index.php(47): DB->query('SELECT * FROM o...') #2 {main} thrown in /customers/8/9/6/cybermobilephones.co.uk/httpd.www/system/database/mysqli.php on line 42
Who is online
Users browsing this forum: No registered users and 4 guests