related domain
hi sir i have some issue of the hosting. my pos.closetor.com domain database not work properly .
8 Replies
When I go to pos.closetor.com, I see a login screen, which makes me think the database is working. Could you please share specifics about why you think it's not working? I don't have any login credentials for your site, nor do I have access to the Linode itself. Hopefully, this has recovered. If it hasn't, people would need tangible information from you to assist: Asking Better Questions
this is my database errors .
1) #1055 - Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_inventory.lenders.lender_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
2) Some errors have been detected on the server!
this is incompatible with sql_mode=only_full_group_by
This looks like a configuration incompatibility between your application and the database server (MySQL, MariaDB.)
From https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html:
These modes were added to the default SQL mode in MySQL 5.7: The ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES modes were added in MySQL 5.7.5.
As it looks like your application is incompatible with this mode, you need to either fix the SQL generated by the application, or configure your MySQL server to not have ONLY_FULL_GROUP_BY in its sql_mode configuration parameter.
I already put :
1) set sql_mode = "";
2) set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
3) set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
4) SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
on my database but 1055 error is still working.
we also get these error
Some errors have been detected on the server!
Please look at the bottom of this window.
I am done these problem thanks
hi sir kindly resolve this error.
Error 520 Ray ID: 68b6dd18e89f4d51 • 2021-09-08 08:40:08 UTC
Web server is returning an unknown error
@ehtishamMashkoor I was able to locate the error message you got on Cloudflare's website. There are some useful troubleshooting steps at the link below.
Error 520: web server returns an unknown error
Hope this helps!