SQL Error : Incorrect syntax near the keyword 'select'.

**unclebuck** · 2011-10-20, 02:36 PM

I am getting the following error when I try and move to the next page of 20 records in SugarCRM 6.2.3 with MSSWL. Anyone have any ideas what this could be caused by?

**SaintAnthony** · 2011-10-20, 07:28 PM

Does it refer you to look at the log, and if so, what does the log say?

**eggsurplus** · 2011-10-21, 02:17 AM

Try sorting on a different column and see if you can then go to the next page. May be an issue with a specific column. Seen that happen for relate columns or other tricky data in the past.

**unclebuck** · 2011-10-21, 02:13 PM

I think I figured it out. I have a custom field I added for Products/Services its a multi-select field. When I remove the field from the display in the list view the error goes away. Will have to do some checking to see how it affects other fields when added to the list view display.
Thanks for your response!