More than 25 listings in dashboard unsettled order

[cqpbert]

In dashboard unsettled orders, I want to list more than 25 orders on 1 page. Right now if I pick something else in the dropdown, the screen flashes like it reloaded but still only 25 listings.

Is this a bug or a setting I don't have set?

[cqpbert]

Update, if I have more than the show 25 in the dropdown, I loose the actions at the bottom. I mean the label is still there, but no options are available

[bsmither]

Please mention the exact version of CubeCart where you see this happening.

With CC656, I do not see this.

 

[cqpbert]

looks like I am on 6.5.4

Let me upgrade and see if it goes away. I guess I was mistaken thinking the hosted option with maintenance took care of keeping my cart up to date.

Upgraded to 6.5.6.

Now when I set it to more than 25, I still have the action dropdown box. But still only 25 listings.

[bsmither]

In the Dashboard, the Unsettled Orders tab has a red circle with a number in it. Is this more than 25? I would assume so.

Please enable CubeCart's debug mode. (Be sure to have your IP address in the next text entry field -- www.showmyip.com.)

From the 'per page' dropdown, select 100. The page will auto reload.

The browser will want to display a popup window. Let it do so. You may need to reload the page if the popup has what looks like the same content as the main window.

Scroll to the database queries section. At about query number 41, look for:

SELECT * FROM `CubeCart_order_summary` WHERE `status` IN (1,2) OR `dashboard` = 1 ORDER BY `dashboard` DESC, `order_date` ASC LIMIT 100 OFFSET 0;

Is the LIMIT 100 present?

[cqpbert]

Sorry Bsmither, I am having a brain fart and can't find where to enable debuging mode.

[bsmither]

In admin, Store Settings, Advanced tab.

[cqpbert]

It looks like the limit did not change to 100

Hack: 1728210645.55840 --- Duration: 1628 µs [NOT CACHED]
SELECT * FROM `CubeCart_order_summary` WHERE status IN (1,2,13,10,11,14) OR `dashboard` = 1 ORDER BY `dashboard` DESC, `order_date` ASC LIMIT 25 OFFSET 0;

And yes, right now the little red circle is at 73 in the unsettled orders tab.

 

[bsmither]

From this query, I see that there is a plugin (or hard code edits) that either makes a new query with custom order statuses, or creates an array with custom order statuses that is supplied to the existing $GLOBALS['db']->select() statement.

Please let us know what this plugin might be.

 

[cqpbert]

Maybe it is the "custom order status" plugin from Noodleman?

[bsmither]

The Custom Order Status plugin uses the admin.dashboard.unsettled_orders hook. (It's encoded, so I cannot determine what this hook code actually does. But the query shown suggests the hook code created that query.)

In the list of queries shown in CubeCart's debug window, was there a similar query just a few queries above the one you found? A query that has WHERE `status` IN (1,2) ?

Please contact Noodleman to determine if there is anything that would need to be done about the Github issue #3231 (implemented 19 Apr 2023 on CC652), versus the latest version of the plugin (v1.0.6 on 8 Feb 2018).

 

[cqpbert]

Ok Thanks B