Hi,
I am using the "ARI Smart Content" to display records from a database table in some articles.
The problem is when the table rows become more than 200. Then i get a blank page in the URL containing this article (no output from the server).
I have noticed that when i set a limit (lower than 200 records) in the MySQL query, the page and table inside the article appears correctly.
The code i use inside the article is:
Code: |
{arijtablesorter paging="true" pageSize="15" pageList="15,10"}
{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="arapof" alias="xxx1"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="enagon" alias="xxx2"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="enagomenos" alias="xxx3"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="denagontos" alias="xxx4"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="denagomenou" alias="xxx5"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="fysiypoth" alias="xxx6"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="eisigitis" alias="xxx7"}
{arisqltablecolumn headerClassName="tablegenhead" className="tablegencell" cellPadding="2px" id="grammateas" alias="xxx8"}
{/arisqltablecolumns}
{arisqltablequery}SELECT xxx1, xxx2, xxx3 ,xxx4 ,xxx5 ,xxx6 ,xxx7 ,xxx8 FROM #__mytable WHERE jos_mytable.xxx3=14 ORDER BY jos_mytable.xxx1 DESC{/arisqltablequery}
{/arisqltable}
{/arijtablesorter}
|
I couldn't find any solution... Is this a setting, a memory limit problem or what?
p.s. I upgrated to the latest version of the "ARI Smart Content" plugin (v1.7.4) but the problem remains...
Thank you