I've a module instance with my custom select and with table type = html
All working fine

Now i choose Ari Data Table as table type and untouch my custom select, the frontend page crash with this error:

ERROR: 1064

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 'LIMIT 0,1' at line 18 SQL=SELECT `taf1r_ticketmaster_orders`.`ordercode` , `taf1r_ticketmaster_orders`.`orderdate` , `taf1r_ticketmaster_clients`.`firstname` , `taf1r_ticketmaster_clients`.`name` , `taf1r_ticketmaster_clients`.`emailaddress` , `taf1r_ticketmaster_tickets`.`ticketname` , `taf1r_ticketmaster_orders`.`paid` , `taf1r_ticketmaster_orders`.`pdfsent` , `taf1r_ticketmaster_orders`.`scanned` FROM `JM_vsp`.`taf1r_ticketmaster_orders` LEFT JOIN `JM_vsp`.`taf1r_ticketmaster_clients` ON (`taf1r_ticketmaster_orders`.`userid` = `taf1r_ticketmaster_clients`.`userid`) LEFT JOIN `JM_vsp`.`taf1r_ticketmaster_events` ON (`taf1r_ticketmaster_orders`.`eventid` = `taf1r_ticketmaster_events`.`eventid`) LEFT JOIN `JM_vsp`.`taf1r_ticketmaster_tickets` ON (`taf1r_ticketmaster_orders`.`ticketid` = `taf1r_ticketmaster_tickets`.`ticketid`); LIMIT 0,1

my custom select is:
SELECT
`taf1r_ticketmaster_orders`.`ordercode`
, `taf1r_ticketmaster_orders`.`orderdate`
, `taf1r_ticketmaster_clients`.`firstname`
, `taf1r_ticketmaster_clients`.`name`
, `taf1r_ticketmaster_clients`.`emailaddress`
, `taf1r_ticketmaster_tickets`.`ticketname`
, `taf1r_ticketmaster_orders`.`paid`
, `taf1r_ticketmaster_orders`.`pdfsent`
, `taf1r_ticketmaster_orders`.`scanned`
FROM
`JM_vsp`.`taf1r_ticketmaster_orders`
LEFT JOIN `JM_vsp`.`taf1r_ticketmaster_clients`
ON (`taf1r_ticketmaster_orders`.`userid` = `taf1r_ticketmaster_clients`.`userid`)
LEFT JOIN `JM_vsp`.`taf1r_ticketmaster_events`
ON (`taf1r_ticketmaster_orders`.`eventid` = `taf1r_ticketmaster_events`.`eventid`)
LEFT JOIN `JM_vsp`.`taf1r_ticketmaster_tickets`
ON (`taf1r_ticketmaster_orders`.`ticketid` = `taf1r_ticketmaster_tickets`.`ticketid`);

what's wrong ?

thanks for help

Remove ; symbol at the end of the query.

Regards,
ARI Soft

ok, without symbol ; the page display an empty grid

i've tried table type = ARI Tiny Table and work fine but without pagination, i always see all records..

If "Server side pagination" parameter is enabled, try to disable it.

Regards,
ARI Soft

with server side pagination = NO :

table type = ARI Tiny Table -> i see records but without pagination
table type = ARI Data Table -> i see records but without pagination



Are you sure this latest version it JM 3.3.3 compatible ?

The extension is compatible with J! 1.5, 1.6, 1.7, 2.5 and 3.x including the latest 3.3.3 version.

Could you send a link to a page where we can see the problem and screenshot(s) of module settings page by email?

Regards,
ARI Soft