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
When i delete a API's client
Lorsque je tente de supprimer un client de l'API j'ai une erreur sql.
Internal Server Error
An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (sql-wallabag.wallabag_oauth2_access_tokens, CONSTRAINT FK_368A420919EB6921 FOREIGN KEY (client_id) REFERENCES wallabag_oauth2_clients (id))
Logs :
[2016-10-05 10:37:08] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: "An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (sql-wallabag.wallabag_oauth2_access_tokens, CONSTRAINTFK_368A420919EB6921FOREIGN KEY (client_id) REFERENCESwallabag_oauth2_clients(id))" at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ForeignKeyConstraintViolationException(code: 0): An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (sql-wallabag.wallabag_oauth2_access_tokens, CONSTRAINTFK_368A420919EB6921FOREIGN KEY (client_id) REFERENCESwallabag_oauth2_clients(id)) at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\\DBAL\\Driver\\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (sql-wallabag.wallabag_oauth2_access_tokens, CONSTRAINTFK_368A420919EB6921FOREIGN KEY (client_id) REFERENCESwallabag_oauth2_clients(id)) at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (sql-wallabag.wallabag_oauth2_access_tokens, CONSTRAINTFK_368A420919EB6921FOREIGN KEY (client_id) REFERENCESwallabag_oauth2_clients(id)) at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
Environment
wallabag 2.1.1
install with git ( fresh install )
php version : PHP 5.6.24
debian stable
type of hosting : dedicated
storage system : MySQL > serveur 5.5.52-0+deb8u1-log - (Debian)
The text was updated successfully, but these errors were encountered:
Issue details
When i delete a API's client
Lorsque je tente de supprimer un client de l'API j'ai une erreur sql.
Internal Server Error
An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (
sql-wallabag
.wallabag_oauth2_access_tokens
, CONSTRAINTFK_368A420919EB6921
FOREIGN KEY (client_id
) REFERENCESwallabag_oauth2_clients
(id
))Logs :
[2016-10-05 10:37:08] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException: "An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (
sql-wallabag.
wallabag_oauth2_access_tokens, CONSTRAINT
FK_368A420919EB6921FOREIGN KEY (
client_id) REFERENCES
wallabag_oauth2_clients(
id))" at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 60 {"exception":"[object] (Doctrine\\DBAL\\Exception\\ForeignKeyConstraintViolationException(code: 0): An exception occurred while executing 'DELETE FROM wallabag_oauth2_clients WHERE id = ?' with params [1]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (
sql-wallabag.
wallabag_oauth2_access_tokens, CONSTRAINT
FK_368A420919EB6921FOREIGN KEY (
client_id) REFERENCES
wallabag_oauth2_clients(
id)) at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60, Doctrine\\DBAL\\Driver\\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (
sql-wallabag.
wallabag_oauth2_access_tokens, CONSTRAINT
FK_368A420919EB6921FOREIGN KEY (
client_id) REFERENCES
wallabag_oauth2_clients(
id)) at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (
sql-wallabag.
wallabag_oauth2_access_tokens, CONSTRAINT
FK_368A420919EB6921FOREIGN KEY (
client_id) REFERENCES
wallabag_oauth2_clients(
id)) at /DIR_WALLABAG/wallabag/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
Environment
The text was updated successfully, but these errors were encountered: