Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by reneerd

  1. Hi all. Was working through some server side long overdue updates and run into this issue. Per usual READ BSMITHERS replies, he is nearly always spot on. Did the three point check, altered the perms on the cache directory and bam, no more issue.
  2. Success! To answer your question, 43125 records. Okay so I added the following command and value to my.cnf sort_buffer_size=201326592 That was the test value which corrected the issue. While the site is not super high demand to crunch ram resources I am going to tweak and optimize a bit to find the "sweet spot" of working at a minimum value. Thanks again bsmither!
  3. Yep we have full access to the server so that shouldnt be an issue. Appreciate your help as always. I will let you know how I make out.
  4. Hi and ty bsmither! Always a pleasure. Yeah I am sorry, I know better about the CC version, thought I did include it. Version 6.2.2 I checked order_summary and yes it has an index. order_date Index int UNSIGNED No 0
  5. Hi all, been awhile since I needed help so you all are doing great! Hit a snag today. I had to push our MYSQL frome v5.x to current 8.x. Everything went smooth and Cubecart seems overall happy with it (actual response times improved). Hit one issue, when we go to check orders on the admin side we are getting "No orders found" This extends to customers looking up their history on the client side. I checked logs and we are getting File: [orders.index.inc.php] Line: [772] "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 ORDER BY `order_date` DESC LIMIT 20 OFFSET 0;" - Out of sort memory, consider increasing server sort buffer size There are some others but its all variations on the above paradigm and same error message. Now I did confirm that database is fine so this is a between the database and the GUI. I am going through everything but as this is time sensitive I wanted to reach out and see if anyone can point me in a direction. I am currently trying to run down how to up the "sort memory" once I figure out how that is done exactly (first time I ran into that).
  6. Sorry, I actually did not see that in my first response. Technically speaking yes, legally speaking who knows. However, job-speaking when those above my pay grade say they want something, I have to atleast make the effort. You know how it goes
  7. First and foremost, thanks yet again BSmithers! You are the best! Next, agreed. It is a quagmire, and not one I am looking forward in trying to mess with. Though I will look into what you mentioned, that may well solve this as its a distinct exception not a rule. I wish the US Fed level would just mandate all online sales are origin based on tax. Its the most logic solution. Anyway, Ill update the thread on how I make out. Thanks again!
  8. Hello CC, Okay this is about the topic that is fun for everyone: Tax. Let me sketch out the basics in how the US handles taxing online sale. You have 2 categories with one have 2 subsets in regard to online taxing. Origin based tax (where the order is shipped from governs the taxing) Destination based tax (where the order is shipped to governs the taxing) Billing address dictates tax Shipping address dictates tax I am sure some of you already know this and I would imagine they are encountered elsewhere. As the US has 50 states controlling state level taxing and no consensus among them there are some specific headaches we have to deal with. With that in mind, I have a particular situation with the 2nd tax scenario and am hoping there is a plugin that can help or someone can point me in the right direction on what I need to alter myself to make what we need feasible. Its possible I am missing something obvious as I have several projects going on and this one I would not be surprised if I have gotten tunnel visioned. Long story short, cubecart seems to operate exclusively on taxing billing address. In the US, each state makes its own determination on which to tax by. Some use Destination then billing or shipping address as the trigger to tax. I have searched through the plugins here and while I found tax exempt which is useful for something else, I have not found something that addresses this issue. Is there a way to toggle between Billing and Shipping based taxing per customer available natively in CC or with a plugin?
  9. Actually, indirectly related question for anyone, is there a reason why BOGO hasnt been implemented in the out of the box Cubecart or through an extension by a third party. Its so commonly used it is surprising and I wondered if there was a technical road block or a pathological hatred of BOGO
  10. Thank you for the fast responses! The work around is actually quite clever, thanks again! I should have been more clear though, we at a bogo done with a code. So we send out a blast with a BOGO sale, customer comes grabs up the BOGO items but it shows regular price in the cart. The application of the code triggers the discount. Need that to track uses and success of the promotion vs accidentally stumbling up the sale.
  11. Hey all, this is a feature we been looking at for awhile. After doing some scouring I see a few people have brought it up but nothing seems to have come of it. So I figured I would reach out and see what you all have come across. I havent seen any from the developers I usually go to but are there extensions that do BOGO? If so, where/who? Has anyone scripted something on their own? Is there a way to simulate BOGO with standard features of Cubecart? I am just throwing a wide net hoping to catch a tidbit that will help. Thanks all!
  • Create New...