Sphinx踩的坑

Questions:

http://*.com/questions/18304561/sphinx-warning-source-src1-skipped-10-documents-with-zero-null-ids
WARNING: source src1: skipped 10 document(s) with zero/NULL ids

Answers:

The very first column in your sql_query is ALWAYS taken as the document-ID.
sql_query = SELECT u.username, a.user_id, a.id, ....
In your query, is u.username really a completely unique unsigned 32bit integer?