× נושא השיעור:
שמות הקודש
- user warning: Error writing file '/tmp/#sql5f1_4d18a0_0.frm' (Errcode: 28)
query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1550416843) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM node AS n INNER JOIN term_node AS term_node_51033 ON n.nid = term_node_51033.nid AND n.vid = term_node_51033.vid LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE (n.language ='he' OR n.language ='' OR n.language IS NULL) AND ( ((n.status = 1) AND (n.type IN ('lesson')) AND (term_node_51033.tid = 51033)) AND n.nid IN (SELECT node.nid AS nid
FROM node node
LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 3
LEFT JOIN flag_content flag_content ON node.nid = flag_content.content_id AND (flag_content.fid = 3 AND flag_content.uid = 0 AND flag_content.sid = 0)
WHERE node.status = 1
) )GROUP BY n.nid ASC ORDER BY score DESC in /home/old.beinenu.com/beinenu.com/sites/all/modules/faceted_search/faceted_search.inc on line 1181.
- user warning: Table 'bein_bein20141203.temp_faceted_search_results_1' doesn't exist
query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /home/old.beinenu.com/beinenu.com/sites/all/modules/faceted_search/faceted_search.inc on line 1182.
החיפוש לא החזיר כל תוצאה
- יש לבדוק את האיות.
- הורד מרכאות מביטויים בכדי לחפש את המילים הבודדות: "שבת" יניב פחות תוצאות מאשר שבת.
- ניתן להגמיש את החיפוש ע"י שימוש בביטוי OR: שבת הגדול יניב פחות תוצאות מאשר שבת OR הגדול.
