ARI Soft - Server Side Pagination not working

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show 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.

more...
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.

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Server Side Pagination not working

(1 viewing) (1) Guest

Page: 12

TOPIC: Server Side Pagination not working

Forum Tools

#54524

Server Side Pagination not working 8 Years, 11 Months ago

Karma: 0

Everything works great until I enable this feature.

Here is the query:

SELECT warpfact_joom856.jxn_users.name AS Tech, RoutineEntry.Date,Sites.Name AS Site,Routines.Name AS Routine FROM Routines INNER JOIN RoutineEntry ON RoutineEntry.Routines_ID = Routines.ID INNER JOIN Sites ON RoutineEntry.Sites_ID = Sites.ID INNER JOIN warpfact_joom856.jxn_users ON warpfact_joom856.jxn_users.id = RoutineEntry.Tech_ID WHERE Sites.Market_ID = {$REQUEST:market} ORDER BY RoutineEntry.Date DESC

With server side pagination enabled this, "LIMIT 0,1" is added to the end of the query and I get no results.

BrianCoulter

Last Edit: 2015/05/13 14:44 By BrianCoulter.

The administrator has disabled public write access.

#54529

Re:Server Side Pagination not working 8 Years, 11 Months ago	Karma: 748
Hello, Could you send a link to a page where the problem occurs? You can send it by email. Regards, ARI Soft

admin

The administrator has disabled public write access.

#54530

Re:Server Side Pagination not working 8 Years, 11 Months ago	Karma: 0
admin wrote: Hello, Could you send a link to a page where the problem occurs? You can send it by email. Regards, ARI Soft The email has been sent with the subject "Server Side Pagination not working \| ARI Data Tables forum".

BrianCoulter

Last Edit: 2015/05/14 13:21 By BrianCoulter.

The administrator has disabled public write access.

#54531

Re:Server Side Pagination not working 8 Years, 11 Months ago	Karma: 748
Check your mail please. Regards, ARI Soft

admin

The administrator has disabled public write access.

#56552

Re:Server Side Pagination not working 8 Years, 4 Months ago	Karma: 0
Several months later and my db table is getting so big that it loads very slow. I created a view to simplify my query and with server side pagination on I still get no data in my table. The new query: SELECT Tech, Date, Site, Routine FROM view_routines WHERE Market_ID = {$REQUEST:market}

BrianCoulter

The administrator has disabled public write access.

#56554

Re:Server Side Pagination not working 8 Years, 4 Months ago

Karma: 0

BrianCoulter wrote:
Several months later and my db table is getting so big that it loads very slow. I created a view to simplify my query and with server side pagination on I still get no data in my table.

The new query:

SELECT Tech, Date, Site, Routine
FROM view_routines WHERE Market_ID = {$REQUEST:market}

Never mind, I hacked the Aridatatable code to get it to accept session variables in the module sql query.

My new query:

SELECT Tech, Date, Site, Routine
FROM view_routines WHERE Market_ID = {$SESSION:market}.

It works like a charm!

BrianCoulter

Last Edit: 2015/12/21 03:07 By BrianCoulter.

The administrator has disabled public write access.

Page: 12

Useful Links