Error/Debug Log with Bad Date/Time

Discussion in 'Troubleshooting' started by Jraheem, Mar 18, 2004.

  1. Jraheem

    Jraheem Guest

    I had aMember Free installed, tried it and then loved the way it worked. So I followed the instructions and deleted everything but the DBs and reinstalled the full Pro version.

    I found out the problem with the PayPal submitting back via IPN was because the account wasn't verified yet.

    However, the Error/Debug Log files are showing unsually dates/times like:

    06/11/1985 00:00:00
    09/11/1978 00:00:00
    03/08/1981 00:00:00

    etc...

    Where are these dates/times coming from? And how do I fix them?

    The site is hosted on a Linux server.

    Also, the log entries are one after the other so there's no reason for it.

    Please advise.
    Jerry
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    This just started to happen for many peoples, but it is not inside aMember.

    access_log table has "time" column of "timestamp" type. It does mean that MySQL substututes current time into this column automatically, aMember doesn't touch this field, so it seems to be a problem in MySQL.

    Please ask your hosting provider to restart MySQL server and try again - may be it will disappear. It is serious.
  3. Jraheem

    Jraheem Guest

    Not sure if its a MySQL problem. I have a custom built CMS tied into the same database as AMember and the CMS reports the time/date in and out of the database through PHP correctly.

    BTW, I'm running 2.1.5.

    J.
  4. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Believe me, I understand what I say...
  5. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    and it cannot be script problem. Just because my script doesn't touch time in any kind in this situation. it all inside mysql.
  6. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    I'm sorry for my mistake in previous posts. It is problem nor with MySQL, nor with aMember code, the problem was in Smarty library functions. Anyway, we have released bugfix for it.

    Please get file atttached to this topic, unpack and upload to
    amember/smarty/plugins/shared.make_timestamp.php
  7. Jraheem

    Jraheem Guest

    No problem... thanks for the quick fix. About to install it now.

    Thanks
    J.
  8. Jraheem

    Jraheem Guest

    alex... thanks, it works great and the problem is fixed.

    J.
  9. magicpoison

    magicpoison New Member

    Joined:
    Mar 12, 2005
    Messages:
    4
    The zip does not work.

    Alex.. I have the same problem.. and tried to download the zipfile to correct this matter but the zip files does not contain any data..

    this seems to be a invalid archive..try to download it again..

    Mandy

Share This Page