PeteW1959 Posted January 14, 2014 Share Posted January 14, 2014 If I search orders, I only get one page of results regardless of how many should be returned. The 'Total:' at the bottom right of the screen is blank. I have tried with all sorts of search criteria, and the result is always only one page full. Link to comment Share on other sites More sharing options...
bsmither Posted January 14, 2014 Share Posted January 14, 2014 CC525 has some changes to the code that is supposed to fix missing and erroneous pagination and Total results. Please remind us of the exact version of CubeCart you are running (admin, Dashboard, Store Info tab). Link to comment Share on other sites More sharing options...
PeteW1959 Posted January 14, 2014 Author Share Posted January 14, 2014 I am running 5.2.4. I have tried to upgrade but despite several attempts the upgrade leaves me with too many errors. Link to comment Share on other sites More sharing options...
PeteW1959 Posted January 15, 2014 Author Share Posted January 15, 2014 OK, I have managed to upgrade to 5.2.5 after 3 attempts. Each time I ran the upgrade the process told me it was already upgraded, even though the warning on the Dashboard said it wasn't. Anyway, the warning is gone, and the Store Overview is reporting 5.2.5. However the problem isn't fixed. This is becoming urgent now as I have cancelled orders that should be marked as Processing and I need to deal with them (see my post on Payment Gateways). Link to comment Share on other sites More sharing options...
Al Brookbanks Posted January 15, 2014 Share Posted January 15, 2014 This issue keeps raising its head and we are currently waiting on a customer to send us FTP access via a support ticket to see if we can fix this. It doesn't seem to affect all stores and we don't know if its an issue with a specific MySQL version or some other variable. You should find that if you refresh the page it works. This is the last beg report open prior to 5.2.6 release. Link to comment Share on other sites More sharing options...
PeteW1959 Posted January 15, 2014 Author Share Posted January 15, 2014 Refreshing the page just returns me to the dashboard! I can give you FTP access; how do I go about it? Link to comment Share on other sites More sharing options...
PeteW1959 Posted February 1, 2014 Author Share Posted February 1, 2014 What do I have to do to get any response on this? I asked a question in my previous post that no one has bothered to answer in nearly 3 weeks. Have just upgraded to 5.2.7, and this is still an issue for me. I am quite happy to give FTP access, but the 'Get Support' link on my Dashboard does nothing, just refreshes the main Dashboard page. This is getting VERY annoying now; I have an issue, I want it fixed, I am prepared to help you, but you don't seem to want to help me. Very poor customer service. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted February 1, 2014 Share Posted February 1, 2014 Hello Peter, this forum is for customer to customer support. Occasionally myself and my staff will check in here between coding development and helping customers who use the official technical support channel. If this is an important issue and you require dedicated staff support you need to login to your customer area and click "Get Support" to raise a ticket. As far as we are aware and from our testing this issue has been resolved in 5.2.7. Link to comment Share on other sites More sharing options...
PeteW1959 Posted February 1, 2014 Author Share Posted February 1, 2014 You have clearly not read my last post. This forum is the only way I can get any support. The 'Get Support' link does not work, so I cannot raise a ticket. Perhaps I should raise a ticket for that issue....oh, wait a minute! Link to comment Share on other sites More sharing options...
Al Brookbanks Posted February 1, 2014 Share Posted February 1, 2014 Strange there are no known issues with it and the typical steady flow of tickets are coming in. Sorry about this. Maybe try a different browser. Link to comment Share on other sites More sharing options...
PeteW1959 Posted February 1, 2014 Author Share Posted February 1, 2014 Just tried in IE and it is working. Am sending a ticket now. My usual browser is Firefox (26.0), and this is a new computer with a completely fresh install of OS and Firefox, so it isn't connected to any settings I have. I have had the same problem on at least 2 other computers running Firefox. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted February 1, 2014 Share Posted February 1, 2014 Thanks and I'm sorry about this we will make some tests with Firefox. Link to comment Share on other sites More sharing options...
bsmither Posted February 1, 2014 Share Posted February 1, 2014 If the edits as suggested in >this post have not caught your attention, would you please try them and report your results? Link to comment Share on other sites More sharing options...
PeteW1959 Posted February 1, 2014 Author Share Posted February 1, 2014 Did the edits, and get no orders at all, not even on the unfiltered orders page. Link to comment Share on other sites More sharing options...
bsmither Posted February 1, 2014 Share Posted February 1, 2014 In admin, Store Settings, Advanced tab, please enable Debug mode. Then visit the Orders page. At the bottom of the screen is a grey block of diagnostic data. Please let us know what the POST values are, if any. Later, there will be a list of SQL queries, find the one that starts with: SELECT SQL_CALC_FOUND_ROWS CubeCart_order_summary.*, It should be the among the very last of the queries. Let us know what the entire query is. Please take note if there are any PHP errors (top of the block) or Query errors (at the end of the queries). Link to comment Share on other sites More sharing options...
PeteW1959 Posted February 1, 2014 Author Share Posted February 1, 2014 POST: 'multi-status' => '' 'multi-action' => '' 'search' => 'order_number' => '' 'search_customer_id' => '' 'status' => '6' 'date' => 'from' => '' 'to' => '' 'token' => '932eafd4080ec9799c1490ad5602dd4b' [5] SELECT SQL_CALC_FOUND_ROWS CubeCart_order_summary.*, CubeCart_customer.type, CONCAT(CubeCart_order_summary.last_name, CubeCart_order_summary.first_name) AS `customer`, CubeCart_order_summary.status FROM `CubeCart_order_summary` LEFT JOIN `CubeCart_customer` ON CubeCart_order_summary.customer_id = CubeCart_customer.customer_id WHERE CubeCart_order_summary.status = '6' ORDER BY `order_date` DESC LIMIT 20 OFFSET 0; -- (0.052005052566528 sec) [CACHED] No PHP Errors No Query errors Link to comment Share on other sites More sharing options...
bsmither Posted February 1, 2014 Share Posted February 1, 2014 Thank you. In the first post of the pagination thread, where I said: Near lines 622 and 623, find: $GLOBALS['smarty']->assign('PAGINATION', $GLOBALS['db']->pagination(false, $per_page, $page, 9)); $GLOBALS['smarty']->assign('TOTAL_RESULTS', $GLOBALS['db']->getFoundRows()); Make them look like this: if (!$where) $GLOBALS['smarty']->assign('PAGINATION', $GLOBALS['db']->pagination($orders_count, $per_page, $page, 9)); $GLOBALS['smarty']->assign('TOTAL_RESULTS', $orders_count); CC525 has these two statements for lines 637-638: $GLOBALS['smarty']->assign('ORDER_LIST',$smarty_data['list_orders']); $GLOBALS['smarty']->assign('PAGINATION', $GLOBALS['db']->pagination(false, $per_page, $page, 9)); Do not replace this statement: $GLOBALS['smarty']->assign('ORDER_LIST',$smarty_data['list_orders']); That statement is not one of the two mentioned in the pagination thread. So, for CC525, replace just: $GLOBALS['smarty']->assign('PAGINATION', $GLOBALS['db']->pagination(false, $per_page, $page, 9)); with: if (!$where) $GLOBALS['smarty']->assign('PAGINATION', $GLOBALS['db']->pagination($orders_count, $per_page, $page, 9)); $GLOBALS['smarty']->assign('TOTAL_RESULTS', $orders_count); Link to comment Share on other sites More sharing options...
PeteW1959 Posted February 1, 2014 Author Share Posted February 1, 2014 Your last message is incomplete, it doesn't state what to replace the code with! I am going out for the evening now; will get back to this tomorrow. Thanks for your help. Link to comment Share on other sites More sharing options...
bsmither Posted February 1, 2014 Share Posted February 1, 2014 I noticed that right away. It has been edited. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted February 1, 2014 Share Posted February 1, 2014 Thanks for the ticket. We will take a deep look during UK office hours. We are a very small company and sadly can't provide 24x7 support. Pleased rest assured we will get to the bottom if this. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted February 3, 2014 Share Posted February 3, 2014 Internal ticket 97295 has resolved this issue and new code pushed to version control for 5.2.8. Post search variables have been changed to GET to allow pagination to work for searches with large result sets. Link to comment Share on other sites More sharing options...
Recommended Posts