Wednesday 8 August 2018

mysql - Drupal - PDOException: SQLSTATE[42S02]




This is a problem with my Drupal website which shows this errors when I do a search.



Can someone help me?



Thank you so much




PDOException: SQLSTATE[42S02]: Base table or view not found: 1146
Table 'mysite/_drupal7_2013.search_config_exclude' doesn't exist:

SELECT SUM(i.score * t.count) AS calculated_score FROM {search_index}
i INNER JOIN {node} n ON n.nid = i.sid INNER JOIN {search_total} t ON
i.word = t.word LEFT OUTER JOIN {search_config_exclude} sc ON n.nid =
sc.entity_id AND sc.entity_type = :type WHERE (n.status =
:db_condition_placeholder_0) AND( (i.word =
:db_condition_placeholder_1) )AND (i.type =
:db_condition_placeholder_2) AND (n.nid NOT IN
(:db_condition_placeholder_3)) AND (sc.entity_id IS NULL ) GROUP BY
i.type, i.sid HAVING (COUNT(*) >= :matches) ORDER BY calculated_score
DESC LIMIT 1 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1

[:db_condition_placeholder_1] => asdasdasd
[:db_condition_placeholder_2] => node [:db_condition_placeholder_3] =>
0 [:matches] => 1 [:type] => node ) in SelectQueryExtender->__call()
(line 841 of
/home/mysite/public_html/mysite.com/includes/database/select.inc).



Answer



You are getting this error i.e.



> Table 'mysite/_drupal7_2013.search_config_exclude' doesn't exist



Either your database is not having this table or your search functionality code is having fault.
Please share your site link if possible.




For more technical articles or help, have a look at
http://etutorialz.com



No comments:

Post a Comment

php - file_get_contents shows unexpected output while reading a file

I want to output an inline jpg image as a base64 encoded string, however when I do this : $contents = file_get_contents($filename); print &q...