[BC2009]

*BUMP*

Just updated to 12.2 and this issue still does not seem to be fixed.

[Kib]

All logs have been outdated, please upload a debug log (wiki) again. Not trying to be difficult, sometimes this stuff just gets buried.

[fbacher]

Was this ever resolved? This fails for me in 12.2 Git:32b1a53 Ubuntu 13.04 using mysql 5.5.34 instead of the built in database.

I can give the full log, but the critical part is:

<videodatabase>
<type>mysql</type>
<host>192.168.1.118</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
...
20:43:45 T:140183070914432 DEBUG: CGUIMediaWindow::GetDirectory (special://profile/playlists/video/dog.xsp)
20:43:45 T:140183070914432 DEBUG: ParentPath = [special://videoplaylists/]
20:43:45 T:140183070914432 ERROR: SQL: Undefined MySQL error: Code (1064)
Query: select * from movieview WHERE ((CAST(movieview.c11 as INTEGER) > 60))
20:43:45 T:140183070914432 ERROR: GetMoviesByWhere failed
20:43:45 T:140183070914432 ERROR: GetDirectory - Error getting special://profile/playlists/video/dog.xsp
20:43:45 T:140183070914432 ERROR: CGUIMediaWindow::GetDirectory(special://profile/playlists/video/dog.xsp) failed
20:43:45 T:140183070914432 DEBUG: CGUIMediaWindow::GetDirectory (special://videoplaylists/)
20:43:45 T:140183070914432 DEBUG: ParentPath = []

Using MySQLWorkbench (5.2.45 rev 10251), I can see that mySql sHates the "INTEGER" keyword. It is happy with the query
SELECT * FROM MyVideos75.movieview where (movieview.c11 > 60);

Or with

SELECT * FROM MyVideos75.movieview where ((CAST movieview.c11 as SIGNED) > 60));

It seems that SQLite has a slightly different syntax and uses INTEGER instead of signed. I wonder if it requires the cast?

I can see that moveview.c11 is a text field

A more detailed list of mySQL install levels is:
libdbd-mysql-perl 4.021-1
libmysqlclient18:amd64 5.5.34-0ubuntu0.13.04.1
libqt4-sql-mysql:amd64 4:4.8.4+dfsg-0ubuntu9.4
mysql-client-5.5 5.5.34-0ubuntu0.13.04.1
mysql-client-core-5.5 5.5.34-0ubuntu0.13.04.1
mysql-common 5.5.34-0ubuntu0.13.04.1
mysql-server 5.5.34-0ubuntu0.13.04.1
mysql-server-5.5 5.5.34-0ubuntu0.13.04.1
mysql-server-core-5.5 5.5.34-0ubuntu0.13.04.1
mysql-workbench-gpl 5.2.45-1ubu1204
php5-mysql 5.4.9-4ubuntu2.3
python-mysqldb 1.2.3-1ubuntu1

[jmarshall]

I suspect you want DECIMAL which should work with both?

EDIT: Actually, probably UNSIGNED INTEGER will work with both.

[kebarvid]

will this be fixed in gotham?