Code: Select all
Error Code(0): Error: Invalid default value for 'date_start'
Error No: 1067
ALTER TABLE `oc_coupon` ENGINE = `MyISAM` in E:\xampp\htdocs\rndml\system\library\db\mysqli.php on line 41Code: Select all
public function __construct($hostname, $username, $password, $database, $port = '3306') {
$this->connection = new \mysqli($hostname, $username, $password, $database, $port);
if ($this->connection->connect_error) {
throw new \Exception('Error: ' . $this->connection->connect_error . '<br />Error No: ' . $this->connection->connect_errno);
}
$this->connection->set_charset("utf8");
$this->connection->query("SET SQL_MODE = ''");
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");
}
Code: Select all
public function __construct($hostname, $username, $password, $database, $port = '3306') {
try {
$mysqli = @new \MySQLi($hostname, $username, $password, $database, $port);
} catch (mysqli_sql_exception $e) {
throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!');
}
if (!$mysqli->connect_errno) {
$this->connection = $mysqli;
$this->connection->report_mode = MYSQLI_REPORT_ERROR;
$this->connection->set_charset('utf8');
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");
} else {
throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!');
}
}
Code: Select all
public function connected() {
return $this->connection->ping();
}
public function __destruct() {
$this->connection->close();
}
Code: Select all
public function isConnected() {
if ($this->connection) {
return $this->connection->ping();
} else {
return false;
}
}
/**
* __destruct
*
* Closes the DB connection when this object is destroyed.
*
*/
public function __destruct() {
if ($this->connection) {
$this->connection->close();
$this->connection = '';
}
}
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Code: Select all
Error Code(0): Error: Invalid default value for 'date_start'
Error No: 1067
ALTER TABLE `oc_coupon` ENGINE = `MyISAM` in E:\xampp\htdocs\rndml\system\library\db\mysqli.php on line 47Code: Select all
<?php
namespace DB;
final class MySQLi {
private $connection;
public function __construct($hostname, $username, $password, $database, $port = '3306') {
try {
$mysqli = @new \MySQLi($hostname, $username, $password, $database, $port);
} catch (mysqli_sql_exception $e) {
throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!');
}
if (!$mysqli->connect_errno) {
$this->connection = $mysqli;
$this->connection->report_mode = MYSQLI_REPORT_ERROR;
$this->connection->set_charset('utf8');
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");
} else {
throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!');
}
}
public function query($sql) {
$query = $this->connection->query($sql);
if (!$this->connection->errno) {
if ($query instanceof \mysqli_result) {
$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;
$query->close();
return $result;
} else {
return true;
}
} else {
throw new \Exception('Error: ' . $this->connection->error . '<br />Error No: ' . $this->connection->errno . '<br />' . $sql);
}
}
public function escape($value) {
return $this->connection->real_escape_string($value);
}
public function countAffected() {
return $this->connection->affected_rows;
}
public function getLastId() {
return $this->connection->insert_id;
}
public function isConnected() {
if ($this->connection) {
return $this->connection->ping();
} else {
return false;
}
}
/**
* __destruct
*
* Closes the DB connection when this object is destroyed.
*
*/
public function __destruct() {
if ($this->connection) {
$this->connection->close();
$this->connection = '';
}
}
}
I tried with replacing mysqli.php from Opencart 3.0.3.6 it worked through the upgrade with no issues patching 10/10 , but it is missing 1 line from the mysqli.php that is in 3.0.3.7, i dont know if it is an issue ?straightlight wrote: ↑Sun Feb 07, 2021 12:20 amSee if the following modifications works:
1 - In your system/library/db/mysqli.php file,
find:
replace with:Code: Select all
public function __construct($hostname, $username, $password, $database, $port = '3306') { $this->connection = new \mysqli($hostname, $username, $password, $database, $port); if ($this->connection->connect_error) { throw new \Exception('Error: ' . $this->connection->connect_error . '<br />Error No: ' . $this->connection->connect_errno); } $this->connection->set_charset("utf8"); $this->connection->query("SET SQL_MODE = ''"); $this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'"); }
Then,Code: Select all
public function __construct($hostname, $username, $password, $database, $port = '3306') { try { $mysqli = @new \MySQLi($hostname, $username, $password, $database, $port); } catch (mysqli_sql_exception $e) { throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!'); } if (!$mysqli->connect_errno) { $this->connection = $mysqli; $this->connection->report_mode = MYSQLI_REPORT_ERROR; $this->connection->set_charset('utf8'); $this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'"); } else { throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!'); } }
find:
replace with:Code: Select all
public function connected() { return $this->connection->ping(); } public function __destruct() { $this->connection->close(); }
Then, revert your database changes from your backup and try again.Code: Select all
public function isConnected() { if ($this->connection) { return $this->connection->ping(); } else { return false; } } /** * __destruct * * Closes the DB connection when this object is destroyed. * */ public function __destruct() { if ($this->connection) { $this->connection->close(); $this->connection = ''; } }
Code: Select all
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
So it is ok to update without the following line in mysqli.php? I will not be missing anything in the DB after update?straightlight wrote: ↑Sun Feb 07, 2021 11:33 amGood to know. At least, this could be a workaround for users who fails the upgrade similar ways in the future.
Code: Select all
$this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");If it works as it is right now, I would simply suggest to leave that library file the way it is at this time unless your server leaves you the capability to upgrade to MySQL v8+.adelante25 wrote: ↑Sun Feb 07, 2021 4:29 pmhello everyone; I just managed to update it by deletin the line, ($this->connection->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION'");) and what should ı do now.. Should I install mysqli.php version 3.0.3.7 to the server?
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Got a burning question at 3 AM that even Google shrugs at? There’s a not-so-secret inbox that might just have your answer: khnaz35@gmail.com
Breathe in some nature while you're at it. It’s cheaper than therapy. 
Feel free to sling a bear my way via PayPal @ khnaz35@gmail.com
Vague. More information is needed. URL / Screenshot, error logs.adelante25 wrote: ↑Sun Feb 07, 2021 9:32 pmHi; add to cart does not work on product screen after upgrade.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
2021-01-17 21:20:59 - PHP Warning: fopen(/home/vipgiy/domains/vipgiy.com/storage/cache/cache.store.1610922058): failed to open stream: No such file or directory in /home/vipgiy/domains/vipgiy.com/public_html/system/library/cache/file.php on line 28straightlight wrote: ↑Sun Feb 07, 2021 9:40 pmVague. More information is needed. URL / Screenshot, error logs.adelante25 wrote: ↑Sun Feb 07, 2021 9:32 pmHi; add to cart does not work on product screen after upgrade.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Thank you for your interest, but I did what you said, but I still get no response when I click add to cart in the product details. does not give any error. It just doesn't work. It happened after 3.0.3.7 update.straightlight wrote: ↑Sun Feb 07, 2021 10:02 pmClear all files and sub-folders in your storage/cache folder with the exception of index.html file. Then, ensure your CHMOD folder permission settings are recursively set to 0755 from FTP (without error messages or frequent disconnections during the process). In addition, ensure not to be logged in into the admin while doing this process and that your browser cache is also cleared, browser closed then re-opened.
Use the Developers Kit (F12) and see the Console tab and the Network > XHR tab for errors or please post your URL.adelante25 wrote: ↑Sun Feb 07, 2021 10:11 pmThank you for your interest, but I did what you said, but I still get no response when I click add to cart in the product details. does not give any error. It just doesn't work. It happened after 3.0.3.7 update.straightlight wrote: ↑Sun Feb 07, 2021 10:02 pmClear all files and sub-folders in your storage/cache folder with the exception of index.html file. Then, ensure your CHMOD folder permission settings are recursively set to 0755 from FTP (without error messages or frequent disconnections during the process). In addition, ensure not to be logged in into the admin while doing this process and that your browser cache is also cleared, browser closed then re-opened.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
www.vipgiy.com my urlstraightlight wrote: ↑Sun Feb 07, 2021 10:13 pmUse the Developers Kit (F12) and see the Console tab and the Network > XHR tab for errors or please post your URL.adelante25 wrote: ↑Sun Feb 07, 2021 10:11 pmThank you for your interest, but I did what you said, but I still get no response when I click add to cart in the product details. does not give any error. It just doesn't work. It happened after 3.0.3.7 update.straightlight wrote: ↑Sun Feb 07, 2021 10:02 pmClear all files and sub-folders in your storage/cache folder with the exception of index.html file. Then, ensure your CHMOD folder permission settings are recursively set to 0755 from FTP (without error messages or frequent disconnections during the process). In addition, ensure not to be logged in into the admin while doing this process and that your browser cache is also cleared, browser closed then re-opened.
You have this error message from the top right on the common/home of the site which means something went wrong with the upgrade process with your language codes.Notice: Undefined index: en-gb in /home/vipgiy/domains/vipgiy.com/public_html/catalog/controller/startup/startup.php on line 117
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Code: Select all
Error Code(0): Error: Invalid default value for 'date_start'
Error No: 1067
ALTER TABLE `oc_coupon` ENGINE = `MyISAM`
Users browsing this forum: No registered users and 68 guests
