Sorry task=clean don't work….
-
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,
-
Hi please give a solution or I m alone that problem
Best regard ,