cqpbert Posted October 5 Share Posted October 5 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? Quote Link to comment Share on other sites More sharing options...
cqpbert Posted October 5 Author Share Posted October 5 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 Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 5 Share Posted October 5 Please mention the exact version of CubeCart where you see this happening. With CC656, I do not see this. Quote Link to comment Share on other sites More sharing options...
cqpbert Posted October 6 Author Share Posted October 6 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. Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 6 Share Posted October 6 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? Quote Link to comment Share on other sites More sharing options...
cqpbert Posted October 6 Author Share Posted October 6 Sorry Bsmither, I am having a brain fart and can't find where to enable debuging mode. Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 6 Share Posted October 6 In admin, Store Settings, Advanced tab. Quote Link to comment Share on other sites More sharing options...
cqpbert Posted October 6 Author Share Posted October 6 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. Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 6 Share Posted October 6 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. Quote Link to comment Share on other sites More sharing options...
cqpbert Posted October 7 Author Share Posted October 7 Maybe it is the "custom order status" plugin from Noodleman? Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 7 Share Posted October 7 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). Quote Link to comment Share on other sites More sharing options...
cqpbert Posted October 7 Author Share Posted October 7 Ok Thanks B Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.