SQL error when viewing prospects

Everything about the STHS Web Portal - Open Source Version / Tout ce qui touché le STHS WebPortal – Open Source
New in Town / Le Ptit Nouveau
Posts: 10
Joined: Mon Jan 08, 2018 9:38 pm

SQL error when viewing prospects

Post by Kirk » Wed Mar 07, 2018 9:19 pm

getting the following error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY draftpicks.Year, draftpicks.Round' at line 1

anybody know how to fix


The Accomplished One / L'Accompli
Posts: 60
Joined: Thu Jul 17, 2014 4:48 pm

Re: SQL error when viewing prospects

Post by psycosis » Fri Mar 09, 2018 10:52 am

So I had this problem at first and when I started digging into the code I was able to get the longer message that I posted in my thread... still trying to figure it out... there must be something stupid misplaced somewhere...