Jump to content
Latest News: (loading..)

Dan Cole

♥Ambassador
  • Content count

    2,081
  • Joined

  • Last visited

  • Days Won

    54

Dan Cole last won the day on January 7

Dan Cole had the most liked content!

Profile Information

Recent Profile Visitors

40,353 profile views
  1. Are you able to post a link so someone can have a look? Dan
  2. Information section of store

    And before you get to far are you using the correct version? ie EDGE. See this post. Dan
  3. Can you find the code that contains this class in your actual index.php file? Paste the section of your code that does that along with a few of the lines that follow and I'm sure someone can point you in the right direction. Dan
  4. Icloud email servers rejecting emails

    Now that I think about it....you're probably not the right person to ask....I hear your Iguanas fall out of the trees with the first hint of cold weather. Dan
  5. Icloud email servers rejecting emails

    John I noticed that you referenced ICloud in the threads title....aren't these the same folks giving us grief with attributes? If so, they might have security screwed down a little tight. Dan PS: Do you have any Iguanas you can send me?
  6. Icloud email servers rejecting emails

    Thanks Smoky...that's interesting....here is what SpamExperts say about outgoing filtering. Dan
  7. Icloud email servers rejecting emails

    @crimble crumble Smoky did you ask your host why they were marking them as spam....it seems odd that they would be the ones doing that. I can see the recipient server doing so but your host? Dan
  8. themes error

    That templates appears to be for an older version of oscommerce (2.2) and won't likely work with newer versions. If you're just new to osC be sure to install the EDGE version which you'll find referenced in this post. Dan
  9. I spent a little more time looking at the query I posted above, probably way more time than I should have but what can I say I'm both curious and stubborn. To make a long story short I shorten the query to isolate the problem. The short version goes like this. SELECT `customers_dob` FROM `customers` WHERE concat(year(now()), '', date_format(customers_dob,'%m%d')) < date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AND concat(year(now()), '', date_format(customers_dob,'%m%d')) > date_format(SUBDATE(now(), INTERVAL 17 DAY),'%Y%m%d') AND customers_dob != '0000-00-00 00:00:00' This runs just fine but still falls to pick up any records prior to year end. To see what data I was getting I copied the where conditions to the select portion of the query so I could see what output was generated each step of the way. Here is what that query looks like. SELECT `customers_dob`, concat(year(now()), '', date_format(customers_dob,'%m%d')) AS FIRST_AHEAD, date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AS SECOND_AHEAD, concat(year(now()), '', date_format(customers_dob,'%m%d')) AS FIRST_BEHIND, date_format(SUBDATE(now(), INTERVAL 17 DAY),'%Y%m%d') AS SECOND_BEHIND FROM `customers` WHERE concat(year(now()), '', date_format(customers_dob,'%m%d')) < date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AND concat(year(now()), '', date_format(customers_dob,'%m%d')) > date_format(SUBDATE(now(), INTERVAL 17 DAY),'%Y%m%d') AND customers_dob != '0000-00-00 00:00:00' This products the following output. + Options customers_dob FIRST_AHEAD SECOND_AHEAD FIRST_BEHIND SECOND_BEHIND 2009-01-06 00:00:00 20180106 20180118 20180106 20171225 2010-01-04 00:00:00 20180104 20180118 20180104 20171225 2006-01-12 00:00:00 20180112 20180118 20180112 20171225 2009-01-03 00:00:00 20180103 20180118 20180103 20171225 2008-01-05 00:00:00 20180105 20180118 20180105 20171225 2008-01-09 00:00:00 20180109 20180118 20180109 20171225 2008-01-11 00:00:00 20180111 20180118 20180111 20171225 2002-01-01 00:00:00 20180101 20180118 20180101 20171225 1999-01-15 00:00:00 20180115 20180118 20180115 20171225 2006-01-12 00:00:00 20180112 20180118 20180112 20171225 2005-01-01 00:00:00 20180101 20180118 20180101 20171225 2006-01-03 00:00:00 20180103 20180118 20180103 20171225 2013-01-07 00:00:00 20180107 20180118 20180107 20171225 2002-01-06 00:00:00 20180106 20180118 20180106 20171225 2008-01-16 00:00:00 20180116 20180118 20180116 20171225 It still doesn't catch any records in the previous year. Can anyone see what it is that I'm doing wrong or have any suggestion on how I can test this further to determine what the issue is? At this point this is not terribly important to me but I'm very curious as to why it doesn't work. Dan - The Stubborn one! PS: There are indeed records that the query should select.
  10. Seems to be an issue with the model number then ie perhaps it needs to already exist and that is starting to ring a bell with me but not loud enough to me to remember the answer. If you add the module number you want to your database with a minimum of detail I assume you can update it with Easy Populate? Humm....does the category need to exists already my memory is fuzzy. Maybe when my morning coffee kicks in so will my memory. If so I'll come back to this. Dan
  11. Maybe you want to back up....put the working version back in place and then make minor changes to the look and feel to suit what you want. If the submit button is not working it sounds to me that you have the form messed up. I do know that the original contribution works since I'm using it so it must be something you changed along the way. Backing up should get you back on the right track again. Dan
  12. Have you set up the form...ie using tep_draw_form? Dan
  13. If you leave the model number alone but change the product name or some other data point, what happens? Dan
  14. I think it should be tep_db_query. That must be a pretty old add-on you have there. Dan
  15. My guess...this file but I don't use it so I can't check it for you. Dan
×