It puts the limit 1 on to make it efficient since only one row will be displayed until you add a repeat region. The repeat region will automatically add the appropriate LIMIT statement to reflect the number of rows you are displaying.
The error means there is a problem with your SQL statement syntax. If you open the rsobj.php file you can update the debug setting to: true and that will give you a better error.
What is the SQL statement you are using in your recordset?