2011-07-28, 16:05
Hi
I am having trouble with XBMC cleaning the database since using XBMC version 10.0.09. No issues with XBMC 10.0.7
I am currently running:
- XBMC 10.0.9
- IOS 4.2.2 / 8F305
- SQL database used is a shared (2 ATV2 connected) MySQL database on a Synology DS 411j.
A snippet from the debug log suggests that the SQL query is wrong in 10.0.9? (‘SQL: Commands were executed in an improper order’ and ‘ERROR: CleanDatabase failed’):
[…]
ERROR: GetDirectory - Error getting smb://NAS/video/Film og serier/! Film/Tekstet/! Classics/3.10 To Yuma/
DEBUG: VideoInfoScanner: Skipping dir 'smb://NAS/video/Film og serier/! Film/Tekstet/! Classics/3.10 To Yuma/' as it's empty or doesn't exist - adding to clean list
NOTICE: CleanDatabase: Starting videodatabase cleanup ..
DEBUG: Mysql Start transaction
DEBUG: Mysql execute: select files.idFile from files where idPath not in (select idPath from path)
ERROR: SQL: Commands were executed in an improper order
Query: select idMovie from movie where idFile in (2)
ERROR: CleanDatabase failed
[…]
I have advanced settings set this way (and everything worked fine on 10.0.7 – no changes done since 10.0.7):
<advancedsettings>
<videolibrary>
<cleanonupdate>true</cleanonupdate>
</videolibrary>
<videodatabase>
<type>mysql</type>
<host>192.168.1.2</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.2</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://192.168.1.2/video/Thumbnails/XBMC/</to>
</substitute>
</pathsubstitution>
</advancedsettings>
In troubleshooting I have tried creating the database again from scratch and letting XBMC re-scrape all my movies etc. The error still exists.
Manually doing 'Clean library' does not work either. It the same error in the debug log ‘ERROR: SQL: Commands were executed in an improper order’.
When scraping and adding new movies theres no problem - new movies gets added perfectly as always.
Anyone else having the same problems?
I am having trouble with XBMC cleaning the database since using XBMC version 10.0.09. No issues with XBMC 10.0.7
I am currently running:
- XBMC 10.0.9
- IOS 4.2.2 / 8F305
- SQL database used is a shared (2 ATV2 connected) MySQL database on a Synology DS 411j.
A snippet from the debug log suggests that the SQL query is wrong in 10.0.9? (‘SQL: Commands were executed in an improper order’ and ‘ERROR: CleanDatabase failed’):
[…]
ERROR: GetDirectory - Error getting smb://NAS/video/Film og serier/! Film/Tekstet/! Classics/3.10 To Yuma/
DEBUG: VideoInfoScanner: Skipping dir 'smb://NAS/video/Film og serier/! Film/Tekstet/! Classics/3.10 To Yuma/' as it's empty or doesn't exist - adding to clean list
NOTICE: CleanDatabase: Starting videodatabase cleanup ..
DEBUG: Mysql Start transaction
DEBUG: Mysql execute: select files.idFile from files where idPath not in (select idPath from path)
ERROR: SQL: Commands were executed in an improper order
Query: select idMovie from movie where idFile in (2)
ERROR: CleanDatabase failed
[…]
I have advanced settings set this way (and everything worked fine on 10.0.7 – no changes done since 10.0.7):
<advancedsettings>
<videolibrary>
<cleanonupdate>true</cleanonupdate>
</videolibrary>
<videodatabase>
<type>mysql</type>
<host>192.168.1.2</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.2</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<pathsubstitution>
<substitute>
<from>special://masterprofile/Thumbnails</from>
<to>smb://192.168.1.2/video/Thumbnails/XBMC/</to>
</substitute>
</pathsubstitution>
</advancedsettings>
In troubleshooting I have tried creating the database again from scratch and letting XBMC re-scrape all my movies etc. The error still exists.
Manually doing 'Clean library' does not work either. It the same error in the debug log ‘ERROR: SQL: Commands were executed in an improper order’.
When scraping and adding new movies theres no problem - new movies gets added perfectly as always.
Anyone else having the same problems?
