We have moved a website to another server where a newer MySQL version is installed (5.7.25). We have several complex views created to support channel feeds. Within several of those we receive error:
ORDER BY clause is not in SELECT list, references column '[login to view URL]' which is not in SELECT list; this is incompatible with DISTINCT
We need the views updated to revmove the DISTINCT call, or to add a viewid in serveral places, or to alter the view(s) to remove the requirement for DISTINCT where ORDER BY is used with TOP and LIMIT 1 to grab a single value on a LEFT JOIN query.
Work has to be done with teamviewer or anydesk on our workstation to have full root access to the database.
24 freelancers estão ofertando em média $21/hora para esse trabalho
Hello sir expert is here ready to fix this issues you have. Can you please give me opportunity. Looking forward an opportunity from your end. Regards Umair
Hi! I have understood the project and much sure to do this job, I am good in MySql and having good communication skills. Looking forward to your positive response. thanks.