-
Notifications
You must be signed in to change notification settings - Fork 197
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
String being passed as int in postgres #1128
Comments
Thanks for the report. I'll look into this closer once I have time. |
The problem seems to happen when DSub tries to fetch the playlist with ID 1 (i.e. the first playlist you have created). If this was night time, then DSub has probably been doing some background syncing. Then, something unexpected happens when the back-end tries to attach the album information to one of the tracks on the playlist. Can you see anything special on any of the tracks on that playlist? |
Steps to reproduce
Expected behaviour
Actual behaviour
Server configuration
Operating system:
Gentoo Linux
Web server:
Nginx
Database:
Postgres
PHP version:
8.1.20
Nextcloud version:
28.0.2
Are you using external storage: No
Are you using encryption: no
Are you using an external user-backend: no
Insert your Nextcloud log here
{"reqId":"ospRiMDvvbjdYaIAJPWy","level":3,"time":"2024-02-22T11:29:59+00:00","remoteAddr":"192.168.1.1","user":"--","app":"index","method":"GET","url":"/apps/music/subsonic/rest/getPlaylist.view?u=admorgan&p=enc:XXXXXXXXXXXXXXXX&v=1.2.0&c=DSub&id=1","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","userAgent":"DSub","version":"28.0.2.5","exception":{"Exception":"Doctrine\DBAL\Exception\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","Code":7,"Trace":[{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1938,"function":"convert","class":"Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1880,"function":"handleDriverException","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":194,"function":"convertExceptionDuringQuery","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/DB/PreparedStatement.php","line":86,"function":"execute","class":"Doctrine\DBAL\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":246,"function":"execute","class":"OC\DB\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":330,"function":"execute","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Db/BaseMapper.php","line":88,"function":"findEntities","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/BusinessLayer/BusinessLayer.php","line":131,"function":"findById","class":"OCA\Music\Db\BaseMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":60,"function":"findById","class":"OCA\Music\AppFramework\BusinessLayer\BusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":420,"function":"findById","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":1374,"function":"injectAlbumsToTracks","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":591,"function":"tracksToApi","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":181,"function":"getPlaylist","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"handleRequest","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/base.php","line":1069,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":87,"Previous":{"Exception":"Doctrine\DBAL\Driver\PDO\Exception","Message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","Code":7,"Trace":[{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\DBAL\Driver\PDO\Exception","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":190,"function":"execute","class":"Doctrine\DBAL\Driver\PDO\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/DB/PreparedStatement.php","line":86,"function":"execute","class":"Doctrine\DBAL\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":246,"function":"execute","class":"OC\DB\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":330,"function":"execute","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Db/BaseMapper.php","line":88,"function":"findEntities","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/BusinessLayer/BusinessLayer.php","line":131,"function":"findById","class":"OCA\Music\Db\BaseMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":60,"function":"findById","class":"OCA\Music\AppFramework\BusinessLayer\BusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":420,"function":"findById","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":1374,"function":"injectAlbumsToTracks","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":591,"function":"tracksToApi","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":181,"function":"getPlaylist","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"handleRequest","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/base.php","line":1069,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","Code":"22P02","Trace":[{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":190,"function":"execute","class":"Doctrine\DBAL\Driver\PDO\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/DB/PreparedStatement.php","line":86,"function":"execute","class":"Doctrine\DBAL\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":246,"function":"execute","class":"OC\DB\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":330,"function":"execute","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Db/BaseMapper.php","line":88,"function":"findEntities","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/BusinessLayer/BusinessLayer.php","line":131,"function":"findById","class":"OCA\Music\Db\BaseMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":60,"function":"findById","class":"OCA\Music\AppFramework\BusinessLayer\BusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":420,"function":"findById","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":1374,"function":"injectAlbumsToTracks","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":591,"function":"tracksToApi","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":181,"function":"getPlaylist","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"handleRequest","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/base.php","line":1069,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","exception":[],"CustomMessage":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: """},"id":"65d75eea7a910"}
The text was updated successfully, but these errors were encountered: