Sphinx踩的坑

http://stackoverflow.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?

 

发表评论

电子邮件地址不会被公开。 必填项已用*标注