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?

PHP variables
(1 viewing) (1) Guest
Go to bottomPage: 1234567
TOPIC: PHP variables
*
#62659
Re:PHP variables 6 Years, 8 Months ago Karma: 760
Could you also grant a temporary access to your J! backend? Please send credentials by email.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#62676
Re:PHP variables 6 Years, 8 Months ago Karma: 760
It seems this problem with complex fields in SELECT query. The extension parses query when server side pagination is used, not all complex variants are supported. You can create a view in the database and then select data from the view.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#62677
Re:PHP variables 6 Years, 8 Months ago Karma: 5
Thank you, I've confirmed server side pagination does work with
custom variables using a less complex query.

The previous version of ARI data tables was able to parse the same
query without difficulty. Would ARI Smart Content module be able to handle
more complex queries?
The administrator has disabled public write access.
 
#62684
Re:PHP variables 6 Years, 8 Months ago Karma: 5
It appears server side pagination does not work if 'UTC_TIMESTAMP()' is included in the SELECT query.
The module is able to parse 'UTC_TIMESTAMP()' if server side pagination is set to "No"

I defined 'UTC_TIMESTAMP' as a variable in the class.datatables file and now the table will load using server side pagination.
Last Edit: 2018/03/06 03:01 By trevor_stp.
The administrator has disabled public write access.
 
Go to topPage: 1234567