On one website I'm still using Joomla 1.5.26 and ARI Smart Content 1.7.5 (I know, quite old set-up, but for various reasons I haven't updated that site in the past. I am now considering doing so. For that purpose I have created a mirror of the site and database on a localhost. I have Joomla 2.5.4 and ARI Smart Content 1.8.1. installed.

On the old site I am using the following sql query combined with the table sorter:

{arijtablesorter defaultSorting="1:ASC" zebra=1 notSortableCols="0,3"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="cb_profil" alias="Profil" width="10%"}
{arisqltablecolumn id="lastname" alias="Nachname"}
{arisqltablecolumn id="firstname" alias="Vorname"}
{arisqltablecolumn id="cb_wohnort" alias="Ort"}
{arisqltablecolumn id="cb_lizenznummer" alias="Lizenz"}
{arisqltablecolumn id="cb_fispunkteliste" alias="Resultate"}
{/arisqltablecolumn}
{/arisqltablecolumns}
{arisqltablequery}
SELECT cb_profil AS Profil, concat (lastname, ' ', firstname) AS Name, cb_wohnort AS Wohnort, cb_lizenznummer AS Lizenz, cb_fispunkteliste AS Resultate
FROM jos_comprofiler
WHERE (cb_lizenznummer NOT LIKE "") and (cb_lizenznummer NOT LIKE "keine FIS-Lizenz") and cb_fislizenzstatus1011 NOT LIKE "keine mehr"
ORDER BY lastname
{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}

This works perfectly on the old site. However, on the new installation it won't show anything (i.e. white page without any data). Is there anything I have to add because the format has changed since ARI Smart Content 1.7.5?

Solved this one. It had nothing to do with Ari Smart Content. There was an error in the database. Ari Smart Content works also on the new set-up - as usual! Still love that component! It really helps us a lot in presenting lists such as memberlists etc.