LIMIT 0,20::MySQL error 1064:

[gkeyes]

Query Failed:SELECT date_entered, name FROM notes ORDER BY created_by, date_entered; LIMIT 0,20::MySQL error 1064:

All of my reports are simple, but I keep getting this error no matter what I do.
I see this "might" be a bug, is this confirmed. Is there a work around for this?

I am using SugarCE 5d with the ZuckerReports 1.8

[ptemplin7]

Use your SQL tool to double check the table notes. Make sure those fields exist in the table.

My guess You deleted or added some fields along the line and it can't find one of them in that table.

What OS are you on?

Thanks Paris

[gkeyes]

You are correct, there was one of those pesky "one letter" off problems.

Thanks

[LOST-GUY]

Where did you repair this issue, within what file or is it a stored proc?

[ptemplin7]

Lost-Guy

This was a SQL fix. There was likely a name change and he needed to update the Zucker report call for the table. Use you SQL tools and display the table in question. Look at the query and check the column names against your call.

Good Luck, Paris