1299 Search fails with SQL logic error missing ... [#6455]

[chrisjj]

1 In quick search enter [-22

Expected: search results
Observed: 15s delay and then

Code: Select all

There was a problem querying the database:
Could not retrieve data "SELECT Songs.*
FROM Songs WHERE Songs.ID IN (SELECT rowid FROM SongsText WHERE SongsText MATCH '  -22* ')
" : SQL logic error or missing database (1, 21)

Note: 16K tracks in library, 3.2GHz P4 with 2Mb RAM

Do others get this?

Tracked at: http://www.ventismedia.com/mantis/view.php?id=6455 , marked "fixed".

[Lowlander]

Yep, same here. Entered as: http://www.ventismedia.com/mantis/view.php?id=6455

[chrisjj]

Thanks LL.

I have a hunch all is not what it seems w.r.t. those apparent spaces in the SQL string. I think if anyone can extract the actual string somehow, it could be very revealing.

[Sepulchre]

There was a problem querying the database:
Could not retrieve data "SELECT Songs.*
FROM Songs WHERE Songs.ID IN (SELECT rowid FROM SongsText WHERE SongsText MATCH ' -22* ')
" : SQL logic error or missing database (1, 21)

I am getting this with my latest MM application - is there a solution as yet - I've had this problem for months now. None of the solutions online so far - rebuild database, delete and reupload application have worked.

Thanks

[chrisjj]

What search input causes it there?

[Lowlander]

As the link idicates it's been resolved for version 4 which isn't out yet.

[Sepulchre]

I'm not sure I understand form the link provided

http://www.ventismedia.com/mantis/view.php?id=6455

this is a long-standing error but it's not solvable as yet; only with a new release of MM 4.0?

My MM is incapacitated in the meantime - any suggestions?

As the link idicates it's been resolved for version 4 which isn't out yet.

[nohitter151]

I'm not sure I understand form the link provided

http://www.ventismedia.com/mantis/view.php?id=6455

this is a long-standing error but it's not solvable as yet; only with a new release of MM 4.0?

My MM is incapacitated in the meantime - any suggestions?

As the link idicates it's been resolved for version 4 which isn't out yet.

It will be solved in 4.0. In the meantime, don't enter that search input.

[Sepulchre]

I'm not sure I understand form the link provided

http://www.ventismedia.com/mantis/view.php?id=6455

this is a long-standing error but it's not solvable as yet; only with a new release of MM 4.0?

My MM is incapacitated in the meantime - any suggestions?

As the link idicates it's been resolved for version 4 which isn't out yet.

It will be solved in 4.0. In the meantime, don't enter that search input.

Hmm, okay... I'm not doing anything on MM other than opening the app and trying to play something. MM comes up with multiple error messages (when it tries to read any songs from my database).

I have a bunch of error messages that I have screen shots of and saved as image file - how can I post these to demonstrate the problems I've had for 6 months now.

[nohitter151]

Sounds like a different problem then. You should start a new topic and post some of your error messages there, or get a debug log:
http://www.mediamonkey.com/forum/viewtopic.php?f=7&t=69

Images can be posted in [ img ][ /img ] tags (put URL to the image between the middle ][ brackets and remove spaces.)