You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
* 17/02/2023 05:54:22 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 17/02/2023 05:50:42 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 06/10/2022 03:03:18 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 25/10/2021 09:05:40 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /Teampass/index.php?page=kb * 24/08/2021 07:43:01 - Query: INSERT INTO `teampass_log_items` (`id_item`,`date`,`id_user`,`action`) VALUES ('', 1629790981, '1', 'at_restored')<br />Error: Incorrect integer value: '' for column 'id_item' at row 1<br />@ /teampass/sources/views.queries.php * 02/12/2020 18:37:15 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 13/07/2020 20:24:37 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 10/07/2020 15:46:11 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 25/11/2019 19:12:02 - Query: SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label,
i.description as description, i.pw as pw, i.login as login, i.anyone_can_modify as anyone_can_modify,
l.date as date
FROM teampass_items as i
INNER JOIN teampass_log_items as l ON (i.id = l.id_item)
WHERE i.inactif = 0
AND (l.action = 'at_creation' OR (l.action = 'at_modification' AND l.raison LIKE 'at_pw :%'))
AND i.id_tree IN ()
ORDER BY i.label ASC, l.date DESC<br />Error: 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 ')
ORDER BY i.label ASC, l.date DESC' at line 8<br />@ /teampass/index.php?page=kb * 22/11/2018 05:55:40 - Query: SELECT i.id AS id, MIN(i.restricted_to) AS restricted_to, MIN(i.perso) AS perso,
MIN(i.label) AS label, MIN(i.description) AS description, MIN(i.pw) AS pw, MIN(i.login) AS login,
MIN(i.anyone_can_modify) AS anyone_can_modify, l.date AS date, i.id_tree AS tree_id,
MIN(n.renewal_period) AS renewal_period,
MIN(l.action) AS log_action, l.id_user AS log_user
FROM teampass_items AS i
INNER JOIN teampass_nested_tree AS n ON (i.id_tree = n.id)
INNER JOIN teampass_log_items AS l ON (i.id = l.id_item)
WHERE (i.id_tree=332) AND (i.inactif=0) AND (l.date=(SELECT date FROM teampass_log_items WHERE action IN ('at_creation', 'at_modification') AND id_item=i.id ORDER BY date DESC LIMIT 1))
GROUP BY i.id, l.date, l.id_user, l.action
ORDER BY i.label ASC, l.date DESC LIMIT 0,<br />Error: 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 '' at line 11<br />@ /teampass/sources/items.queries.php
Log from the web-browser developer console (CTRL + SHIFT + i)
Insert the log here and especially the answer of the query that failed.
The text was updated successfully, but these errors were encountered:
Page on which it happened
Steps to reproduce
Expected behaviour
Tell us what should happen
Actual behaviour
Tell us what happens instead
Server configuration
Operating system: Windows NT NRC2TEAMPASSVM 10.0 build 14393 (Windows Server 2016) AMD64
Web server: Apache/2.4.27 (Win64) OpenSSL/1.1.0f PHP/7.4.33
Database: 5.7.19-log
PHP version: 7.4.33
Teampass version: 3.0.0.22
Teampass configuration file:
Updated from an older Teampass or fresh install:
Client configuration
Browser: -
Operating system: - bits
Logs
Web server error log
Teampass 10 last system errors
Log from the web-browser developer console (CTRL + SHIFT + i)
The text was updated successfully, but these errors were encountered: