Jump to content
Latest News: (loading..)

Dan Cole

♥Ambassador
  • Content count

    2,442
  • Joined

  • Last visited

  • Days Won

    56

Dan Cole last won the day on November 24 2018

Dan Cole had the most liked content!

About Dan Cole

Profile Information

Recent Profile Visitors

45,617 profile views
  1. Dan Cole

    Email queuing system

    It failed on the older database. Versions as follows: Database it failed on: MySQL 5.5.52-MariaDB Database where it work. MySQL 10.2.22-MariaDB Changing... date_added datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, to date_added TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, seems to have sorted it and the subsequent data seems identical. Dan
  2. Dan Cole

    Email queuing system

    Ahhh....the 2 usual emails and 2 from the new queuing system. I get it. Dan
  3. Dan Cole

    Email queuing system

    Gary I ran into an issue with the sql lines.... date_added datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, that ran okay on one of my databases but not on another. The error given was... #1067 - Invalid default value for 'date_added' I googled that and it suggested that I needed to change the datetime to TIMESTAMP. I tried that and it created the tables but I haven't gone any further yet. I'll do that but in the meantime I thought I'd post my experience with the sql query while I remembered what happened and what I did. Okay I'm off to check out the admin area. Dan
  4. Dan Cole

    Email queuing system

    Received the review request. Awesome. The data is correct too...name, date purchased, and item purchased....all good. Dan
  5. Dan Cole

    Email queuing system

    I completed an order this time so you'd have another purchase to work with. Dan
  6. Dan Cole

    Email queuing system

    Received them both Gary and the data is as it should be. Looks good on this end. Dan
  7. Dan Cole

    Email queuing system

    Gary...I created an account but didn't buy anything. 😧 I thought you might want to test the no purchase module....if you want me to complete an order just let me know. Dan
  8. Maybe what is need is more decimal places. I would think 3000 g would simply be entered as 3.3 kG but I can see where the current setting would have trouble with say 125 grams. Dan
  9. Dan Cole

    Email queuing system

    I'm looking forward to seeing this enhancement Gary. I too think it's a game changer. 👍 Dan
  10. Dan Cole

    Email queuing system

    I've always been surprised that people using PWA style shops would email customers at all. I thought from a customers point of view they were opting not to give or have shopowners use their data or information at all. I would be shocked if I got an email from a shop I opted not to set up an account with. Is that not an issue with guest systems? Dan
  11. Dan Cole

    Help with ot_shipping due the free shipping

    Try adding another bracket "(" before the first one following the initial if....you have 1 opening bracket but 2 closing ones. Dan
  12. Dan Cole

    Best webhost?

    If you want to PM me I have a suggestion for you but it's probably not appropriate to comment here. Dan
  13. Dan Cole

    Email queuing system

    And another good reason to support the ongoing development of osC. Dan
  14. Dan Cole

    Email queuing system

    But I lied. Dan
×