http 500 error on the products page
0
I just install the script everything is ok, I have successfully added products:
I get this warning: This page isn’t working mywebsite.com is currently unable to handle this request.
HTTP ERROR 500 whenever I want to edit or view the product page I have already created.
I have checked all requirements, all of them are OK, also I have checked the documentation question about
500 everything ok Kindly helps me to solve this please.
Thanks
2
I have the solution to the problem:
This is for a MySQL update on the server. The application does not support the standard configuration of MySQL 5.7. To correct it, make the following change in the file system / database / drivers / mysqli / mysqli_driver.php, line 139:
if (isset($this->stricton)) {
if ($this->stricton) {
$this->_mysqli->options(MYSQLI_INIT_COMMAND, 'SET SESSION sql_mode = CONCAT(@@sql_mode, ",", "STRICT_ALL_TABLES")');
} else {
$this->_mysqli->options(
MYSQLI_INIT_COMMAND,
'SET SESSION sql_mode =
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
@@sql_mode,
"STRICT_ALL_TABLES,", ""),
",STRICT_ALL_TABLES", ""),
"STRICT_ALL_TABLES", ""),
"STRICT_TRANS_TABLES,", ""),
",STRICT_TRANS_TABLES", ""),
"STRICT_TRANS_TABLES", "")'
);
}
// Fix para MySQL 5.7
if (true) {
$this->_mysqli->options(
MYSQLI_INIT_COMMAND,
'SET SESSION sql_mode =
REPLACE(REPLACE(REPLACE(
@@sql_mode,
"ONLY_FULL_GROUP_BY,", ""),
",ONLY_FULL_GROUP_BY", ""),
"ONLY_FULL_GROUP_BY", "")'
);
}
// Fix para MySQL 5.7
}
0
Hello,
Please check server requirements from documentation.pdf and make sure your serve met them, specially MySQL only_full_group_by mode. It should be disabled.
Please check your server error logs and let me know the error details so that I can suggest.
You can enable app logs by changing the log_threshold to 1 in app/config/config.php and try to change/delete the cart time again to reproduce error. Last check the latest logs in the app/logs/ folder.
Thank you
0
Thanks for your reply, I am using a shared hosting service and they are not willing to disable "MySQL only_full_group_by mode. Kindly advise me on what my options are. Is there a way I can solve the problem without them. I am getting frustrated. Thanks
0
Hello,
No. This item is not compatible with MySQL only_full_group_by mode, it must me disabled.
I would recommend VPS (2GB RAM with SSD) from any cloud provider AWS, Vultr or Digitalocean. Both Vultr & DO give $100 for testing their services. AWS offers free-tier too.
0
Yes, changing the session mode would work too. Instead of modifying the framework file we can do it in My_Controller after parent construct line with $this->db->query(). Thank you very much for sharing this. I will add it in next update.
1
Dear Michael Alonzo, Thanks for your suggestion on how to solve the problem.
Mian Saleem, please I need your advice, should I implement what Michael suggested or wait for your update so as not to modify the framework file.
Thanks
1
You can follow @Michael Alonzo's instructions till next update so you don't have to wait. Thank you
1
@Michael Alonzo and @Mian Saleem
The problem is solved.
Thanks for your assistance
1
Michael Alonzo Thank you very much
0
hi there I keep getting this:
This page isn’t (my website) is currently unable to handle this request.
HTTP ERROR 500
I'm not really that technical or good with PHP.
Please help
Showing 1 to 10 of total 13 records
Instantly elevate your business, earn more money, attract more clients, and deliver exceptional digital experiences. Tecdiary is the leading independent provider of inventory & e-commerce solutions for digital experiences. What sets our solution apart for partners is our modular, flexible architecture and customizable licensing model. With Tecdiary, partners are free to build, customize, and extend the platform to create amazing digital experiences for your individual clients or to support your own packaged solution.
We use Cookies
We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.