Creating New Lists gives SQL error

[peterk900]

Hi,

I want to use Joomla 2.5 but whenever I create a new list based on an existing MySQL table I get an error when I try and display the list data. I'm using the latest 3.x.x version of Fabrik.
This is the error:
"Get Data You have an error in your SQL syntax - check the manual that corresponds to your MySQL server version for the right syntax near ' FROM tblClients Limit 0,10 AT Line 2 SQL = "SELECT SQL_CALC_FOUND_ROWS Distinct From 'tblClients' LIMIT 0,10 "

Repeating exactly the same process in Joomla 1.5 with the 1.5 version of Fabrik causes no error.

Can anyone suggest where to look - I'm very new to Fabrik.

Thanks

Peter

 

[troester]

Do you have any element belonging to your fabrik list tblClients?
Normally the SELECT should be
SELECT SQL_CALC_FOUND_ROWS Distinct xxx,yyy,.... From 'tblClients' LIMIT 0,10

On my site it's no problem to create a fabrik list pointing to an existing MySQL table (even if it's an additional connection to an external server).

 

[cheesegrits]

I just tested, no problems here.

Did the table you used have a single, integer, auto-inc Primary Key defined?

In your List settings, in the Data tab, has Fabrik correctly picked up the PK element to use?

-- hugh