Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. jimlongo

    MySQL 5.7 gotcha

    John, I'm not aware what Aria db engine is. I did an inplace installation of Maria10.1 over (probably) 5.5 once cPanel implemented it . . . it was so long ago I forgot. For those who don't know and are wondering, MariaDB is a drop in replacement for MYSQL. The reason behind it is to be open source instead of controlled by Oracle. There are pros and cons to each Have never had any problems with it. Everything is the same.
  2. jimlongo

    MySQL 5.7 gotcha

    The code that I needed to change only involved custom code as far as I can tell, and only inserts so it was fairly easy to find where it was happening. The solution in my case was to not send an empty string as a numeric value. I suppose in the past it had been type cast as 0. So when encountering this in the code simply set the empty string to 0. In my cases NULL was not acceptable, it must be numeric. if ($val==""){$val=0;} Otherwise the error would be a very ugly mysql error 1366 - incorrect integer value. I've been using the MariaDB replacement to MYSQL for a couple of years, and just updated from 10.1 to 10.3 on Friday.
  3. jimlongo

    MySQL 5.7 gotcha

    FWIW I ran into the same issue after an upgrade from MariaDB 10.1 to 10.3 (and unfortunately cPanel dowgrades are not supported). Throwing a msyql error 1366 on checkout in checkout_process.php. In my case it's the insert(s) around line 241 Has to do with not being able to insert an empty string in a numeric field type https://jira.mariadb.org/browse/MCOL-2059
  4. jimlongo

    Pay what you want pricing

    That's a great sounding way to handle these transactions. If I could issue credits that could be used in the course of a purchase that would handle most of these cases. Is there such a module?
  5. jimlongo

    Pay what you want pricing

    A sad fact of doing business indeed. We (a tennis club) have dozens of lesson programs of various prices. Customers regularly want to switch lessons they've paid for. That creates either a balance owing or a credit on their account. They need a way to pay the balance. Currently I get their CC information and enter it manually into our payment processor. I guess you're suggesting I don't allow them to switch lessons? That's a board decision, not mine. And it's not pennies, it's amounts up to hundreds of dollars and cents. PayPal sounds interesting, but we don't use it. I'm just trying to avoid the manual entry. Currently I have a product called "balance owing" and I change the price for the use case at hand. That's usually okay as this doesn't happen that often (and I could always create more than 1 of this "product"), but a text field for amount entry would allow the customer to pay $xx.xx for the balance owing on their account. Yes, they are notified they owe a balance. They need to pay it. I'm trying to make it easier for both of us. We don't ship any products, they are all virtual.
  6. jimlongo

    Pay what you want pricing

    Is there any support for, or addons that would enable a product with a variable price. That is a text input so the person could pay whatever amount they want. I often have customers who for one reason or another owe me a balance on some transactions. The amount always varies. Normally I have to send them a form so they can send me credit card details and I manually go to my Merchant account and charge the CC the amount owing . . . total pita. So what I'd like is a catalog item with a text input as a price, they could enter whatever that balance owing amount is.
  7. What my company has done in our API is to (simplified) encrypt all data fields such as name, address, email (anything identifiable) on the way into the db, and decrypt it whenever it comes out. So you never store anything in your db unencrypted. Makes it harder for searches from your app, but there you go. You don't need to delete data ever.
  8. Order Editor is the thing I want the most. Otherwise the backend is not really useful for reporting purposes. Outside of that I have so many custom additions to my store that updating is a nightmare. I have the concept of family accounts, with members inside that account, and items are purchased for the members in the account. Think "sports club". This has to touch so many files you literally have to search and replace dozens if not hundreds of files. Anyway I doubt this is very important to anyone, BUT if there was some system more like the WordPress "child" system where you could write your own functions and templates that hooked into the core, then of course this enables the core to be continually updated without damaging your theme. To me that is the only way to win. Non-update-ability is the road to getting hacked, and a platform that is easily hacked is not going to be extremely popular.
  9. jimlongo

    Upgrading to the latest version

    I've used Foundation quite a bit, but not Bootstrap. Can I install any version of Bootstrap into /ext/bootstrap? I want to use Less or Sass for my css. I'm thinking I can drop in a version of Bootstrap, install the appropriate components and make with npm to do this. Does that sound right? Thanks for any advice.
  10. As I said the database index you suggested adding only affects the Orders dashboard box, nothing to do with AOH.
  11. It has something to do with this query around line 40 in /admin/includes/modules/dashboard/d_orders.php $orders_query = tep_db_query("select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by date_last_modified desc limit 14"); If I change it to take out the "greatest" function in the select section it is okay. $orders_query = tep_db_query("select o.orders_id, o.customers_name, o.date_purchased as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by date_last_modified desc limit 14");
  12. Yes it is strange. It of course doesn't affect the database dates. And the Orders page is okay, it's only the Orders box on the admin front page. And every time I refresh the page there are different orders in the box, all dated 11-30-2036 . . . hmmmm
  13. Create Order - create_order.php in v2 PHP Fatal error: Call to undefined method mysqli_result::fetch_all() in /admin/create_order.php on line 89
  14. Hi, I'm back after i spent some time with getting it working properly with my mods before attempting yours again. For the most part it is working with your v2, except for a few things I will note below. First in the updates since v2 there seem to be a couple little things . . . Post #40 I believe has an extra } at the end which causes an error with the javascript. (error is an expected token ')' missing) Also the 2 SQL statements in #53, the second one really messes up my orders, changes order dates to 2036 Now to the few bugs I'm noticing. 1. If I open an order in the Quick Order Editor, then select a field like a price, the Enter New Value window opens. At this point I cannot enter a value (cannot select inside the input field). Now select OK or close the Enter New Value box, BUT NOW I can't close the Quick Order Editor window. The only way out is to refresh the browser. 2. If I edit an order and change a price of any item the Total goes to ZERO. Thanks again for all your hard work on this.