Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

SQL statement doesn't show up in edit module
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: SQL statement doesn't show up in edit module
#55983
SQL statement doesn't show up in edit module 8 Years, 5 Months ago Karma: 1
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
The administrator has disabled public write access.
 
#55984
Re:SQL statement doesn't show up in edit module 8 Years, 5 Months ago Karma: 746
Hello,

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

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57756
Re:SQL statement doesn't show up in edit module 7 Years, 10 Months ago Karma: 0
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.
The administrator has disabled public write access.
 
#57757
Re:SQL statement doesn't show up in edit module 7 Years, 10 Months ago Karma: 746
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
The administrator has disabled public write access.
 
#57758
Re:SQL statement doesn't show up in edit module 7 Years, 10 Months ago Karma: 0
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.
The administrator has disabled public write access.
 
Go to topPage: 1