BO
Asked
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
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
- MSAnsweredHello,
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 - BOAnsweredThanks 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
- MSAnsweredHello,
**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](https://www.vultr.com/?ref=7969937) or [Digitalocean](https://m.do.co/c/aef972fe9fb4). Both Vultr & DO give $100 for testing their services. AWS offers free-tier too. - MAAnsweredI 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:
```php
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
}
``` - MSAnsweredYes, 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.
- BOAnsweredDear 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 - MSAnsweredYou can follow [@Michael Alonzo](/u/alonzogt)'s instructions till next update so you don't have to wait. Thank you
- BOAnswered@Michael Alonzo and @Mian Saleem
The problem is solved.
Thanks for your assistance - MSAnswered**[Michael Alonzo](/u/alonzogt)** Thank you very much
- TMAnsweredhi 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 - Login to Reply