detail page of artist, genre, label gives zero results

[othmar52]

each item which's id is lower than 10 has a broken detail page

possible solution A change sphinx-configuration from

index slimpdmain
{
  min_prefix_len    = 2
}

to

index slimpdmain
{
  min_prefix_len    = 1
}

possible solution B Before starting to fill the MySQL database do ALTER TABLEtablenameAUTO_INCREMENT = 10; on each table

[killhellokitty]

Changed the slimpdmain index. I tried to change the mysql :ALTER TABLE slimpd AUTO_INCREMENT = 10; but i just get errors. I'm not that well versed in mysql.

On Thu, Jul 21, 2016 at 3:10 PM, othmar52 notifications@github.com wrote:

each item which's id is lower than 10 has a broken detail page

possible solution A change sphinx from

index slimpdmain { min_prefix_len = 2 }

to

index slimpdmain { min_prefix_len = 1 }

possible solution A Before starting to fill the MySQL database do ALTER TABLEtablenameAUTO_INCREMENT = 10; on each table

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/othmar52/slimpd/issues/16, or mute the thread https://github.com/notifications/unsubscribe-auth/AJKslZy6JfZ773fpiXH2EF0g2wmBV17Bks5qX9IZgaJpZM4JSKzm .

[othmar52]

resolved with solution B because solution A will bloat the sphinx index too much on really huge collections.

unfortunately a complete re-indexing (dropping and re-creating all tables) is necessary :/