I have a version of aridatatables which I bought on 11 March 2011. Is this compatible with Joomla 1.5.25? It installed ok but the {$REQUEST } command in the SQL query is not being processed so I get an SQL error.

Hello,

It is compatible with Joomla! 1.5. Could you specify what SQL query do you use?

Regards,
ARI Soft

Query is
select id,bookingno,surname,carreg,depdt
from jos_bookings where
surname={$REQUEST: searchnamex}
order by id desc
limit 1000

Error:
500 - JDatabaseMySQL::query: 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 ': searchnamex} order by id desc limit 1000' at line 3 SQL=select id,bookingno,surname,carreg,depdt from jos_bookings where surname={$REQUEST: searchnamex} order by id desc limit 1000

I have confirmed that searchnamex is set up correctly and the query works ok if I replace the {$REQUEST} with something like "bloggs"

Remove space between {$REQUEST: and searchnamex. The query will look like:



Regards,
ARI Soft

I tried that, but error was exactly the same.

Could you provide a link to a page where we can see described problem and temporary access to your J! backend by email so we can investigate it?

Regards,
ARI Soft