Site upgraded from Joomla 2.5 to Joomla 3.3.6
Aridatable modules were created on the Joomla 2.5 site
Now, when you load up an Aridatabase module to edit it, the SQL statement is empty.

The sql statement is still recorded in the Modules table (which I have backed up) and the modules work all right, eg: http://www.eggsa.org/sarecords/index.php/stellenbosch-ngk/baptisms-1788-to-1815 but the sql is not loaded up to the form when editing a module.

I went to edit one but have not tried to do anything more other than install the latest version (1-15-2) of Aridatatables which has made no difference.

Hope you can help,

Richard
----
PHP Built On Linux server.combraxis.net 2.6.32-431.29.2.el6.x86_64 #1 SMP Tue Sep 9 21:36:05 UTC 2014 x86_64
Database Version 5.5.45-cll
Database Collation latin1_swedish_ci
PHP Version 5.4.42
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Hello,

Could you provide a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft

Please post the fix to these form questions as....

....I have the same problem. Just downloaded the ARI Data Tables extension, selected the Joomla DB option, enter a simple query in the sql box:

SELECT *
FROM `xxx_community_featured`

and the box is cleared after i press "Save"

Also, I get the following error when refreshing my site:

>If difficulties persist, please contact the System Administrator of this site and report the error below.
>
>SQL=

Bottom line is it seems the module settings for the SQL statement are not being saved.

Hello,

Check that "System - ARI Extensions" plugin is installed and enabled. If it doesn't help, could you provide a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft

Well....here is my "fix"....and I really don't know how I fixed it for sure but this is what I did:

When I had the problem I had the Jquery Themes turned OFF because I have enough jquery (2) loaded already and I had the module "Published".


1) I unpublished the module to get my site back on line. My site was back working fine.
2) I turn jquery Themes ON
3) to make sure my sql injection and other security software wasn't preventing me from entering a sql query I entered some plain text into the SQL box
4) I saved the module setting and THIS TIME the text stayed in the sql box.
5) I changed the text to they same, very simple sql test query (select * from....) and saved it again....THIS TIME the query saved.
6) I published the module and it performed as expected.
7) I tested by entering query text with the module published and not and jquery on and off....Everything work fine as it should now.

While working now....it had fail to save the query text 8 - 10 times is a row as I tried different configurations. Really not sure what I could have done that actually fixed it but if you have the same problem you can try the above for what it's worth.