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

To get bugs in the current release fixed, please report them here.

Moderator: Gurus

chrisjj
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

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

Post by chrisjj » Wed Sep 01, 2010 7:16 pm

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".
Chris

Lowlander
Posts: 47363
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: 1299 Search fails with "SQL logic error or missing datab

Post by Lowlander » Wed Sep 01, 2010 7:28 pm

Lowlander (MediaMonkey user since 2003)

chrisjj
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: 1299 Search fails with "SQL logic error or missing datab

Post by chrisjj » Wed Sep 01, 2010 8:15 pm

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.
Chris

Sepulchre

Re: Search fails with SQL logic error missing database [#645

Post by Sepulchre » Sat Sep 25, 2010 3:11 pm

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
Posts: 4933
Joined: Wed Feb 14, 2007 5:14 pm
Location: UK

Re: Search fails with SQL logic error missing database [#645

Post by chrisjj » Sat Sep 25, 2010 4:03 pm

What search input causes it there?
Chris

Lowlander
Posts: 47363
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Search fails with SQL logic error missing database [#645

Post by Lowlander » Sat Sep 25, 2010 10:12 pm

As the link idicates it's been resolved for version 4 which isn't out yet.
Lowlander (MediaMonkey user since 2003)

Sepulchre
Posts: 10
Joined: Sat Sep 25, 2010 3:13 pm

Re: Search fails with SQL logic error missing database [#645

Post by Sepulchre » Thu Oct 28, 2010 8:31 am

I'm not sure I understand form the link provided
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? :roll:
Lowlander wrote:As the link idicates it's been resolved for version 4 which isn't out yet.

nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: Search fails with SQL logic error missing database [#645

Post by nohitter151 » Thu Oct 28, 2010 9:03 am

Sepulchre wrote:I'm not sure I understand form the link provided
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? :roll:
Lowlander wrote: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.
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.

Sepulchre
Posts: 10
Joined: Sat Sep 25, 2010 3:13 pm

Re: Search fails with SQL logic error missing database [#645

Post by Sepulchre » Thu Oct 28, 2010 9:51 am

nohitter151 wrote:
Sepulchre wrote:I'm not sure I understand form the link provided
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? :roll:
Lowlander wrote: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
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: Search fails with SQL logic error missing database [#645

Post by nohitter151 » Thu Oct 28, 2010 9:56 am

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.)
MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.

Post Reply