4. Sorry task=clean don't work….

Sorry task=clean don't work….

  • K

    Hi
    :blush: http://ip/jabbercam/admin.php?task=clean don't work result=deleted 0 session…...?
    But clean=cleanAll it's Ok.......

    DELETE sessions, filters, user_settings, user_prefs, chats FROM sessions ".
    "LEFT JOIN filters ON sessions.id=filters.id LEFT JOIN user_settings ON sessions.id=user_settings.id ".
    "LEFT JOIN user_prefs ON sessions.id=user_prefs.id LEFT JOIN chats ON sessions.id=chats.peer1 || ".
    "sessions.id=chats.peer2 ".
    "WHERE type=0 && created_at < DATE_SUB(NOW(),INTERVAL $TIME_TO_LIVE SECOND)

    error

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '". "LEFT JOIN filters ON sessions.id=filters.id LEFT JOIN user_settings ON se' at line 1
    DELETE sessions,

    0
  • K

    Hi please give a solution or I m alone that problem

    Best regard ,

    0
Log in to reply