bug with search

[dodge]

hi guys,

when i write something in the search-form, there is a correct result, but a few lins under the articel it shows me:

<pre>SELECT f.* FROM serendipity_faqs AS f WHERE MATCH(question,answer) AGAINST('ocean') GROUP BY id ORDER BY changedate DESC</pre> / Kann keinen FULLTEXT-Index finden, der der Spaltenliste entspricht

0 FAQs gefunden:

<pre>SELECT s.*, a.realname FROM serendipity_staticpages AS s LEFT OUTER JOIN serendipity_authors AS a ON a.authorid = s.authorid WHERE MATCH(headline,content) AGAINST('ocean') AND s.publishstatus = 1 AND s.pass = '' GROUP BY id ORDER BY timestamp DESC</pre> / Kann keinen FULLTEXT-Index finden, der der Spaltenliste entspricht

Weitere 0 Seiten gefunden:




is that corect?

cu

[garvinhicking]

Hi!

Seems like your database table serendipity_faqs misses the fulltext index. Try to execute this SQL via phpMyAdmin:

Code: Select all

CREATE FULLTEXT INDEX faqentry_idx on serendipity_faqs (question, answer);

Regards,
Garvin

[dodge]

sprechen ja beide deutsch, oder?

also hab mich bei phpMyAdmin eingeloggt und dann eingegeben, aber er sagte mir ich hätte keine rechte um das zu tun!

soll ein feld "faqentry_idx" in der tabelle serendipity_faqs erstellt werden: diese soll TEXT formatiert und einen INDEX und dann auch VollText sein, richtig?

da er den mysql code nicht nimmt hab ich es mit hand gemacht, aber er meldet mir bei der suche immer noch das gleiche!

1. richtig verstanden?


lg oskar

[garvinhicking]

Hi!

You posted this in an english forum, so now we need to stick with that.

If your phpMyAdmin tells you you have no INDEX privileges, you must tell your Provider to give those privileges to you. Not having INDEX privileges is a mistake of your provider, those privileges are very important for MySQL.

Best regards,
Garvin

[dodge]

but the normal search function still works fine, ist that correct, that some searchterm are false and some correct?

i will wirte a mail to my provider!

CU

[garvinhicking]

Hi!

The normal search uses a different databasetable, maybe for that one the fultext index was (whatever the reasons) created...?

Regards,
Garvin

[dodge]

i can check this, wait a moment, but which tables are important for the search, where i have to look for FULLTEXT?

serendipity_entries????

CU Oskar

[garvinhicking]

Hi!

serendipity_entries and serendipity_faqs.

Regards,
Garvin

[dodge]

serendipity_entries with FULLTEXT:
id
timestamp
comments
trackbacks
exflag
authorid
isdraft
allow_comments
last_modified
moderate_comments

serendipity_faqs with FULLTEXT:
id
cid
faqorder
changedate
changetype

cu

[garvinhicking]

Hi!

What do you mean with that posting?

The only fulltext index on serendipity_entries should be one on the fields (title,body,extended). The only fulltext index on serendipity_faqs should be one on the columns (question, answer).

Regards,
Garvin

[dodge]

oh you are right: but author, too in entries!

and changetype,too in faq

here a the screenshots:

[garvinhicking]

Hi!

Your screenshots only lists the COLUMNS, not the INDICES!

You should have a look at a different section that contains the indexes, it should be below the colu,mn listing.

Regards,
Garvin

[dodge]

ahhhhh, ok i could change it manual:


http://p11028.prtg1.pretago.de/blog/?se ... 5D=mercury

but there is something from staticages, too!
have a look please!
i think its the same solution, but i need the right code to change it please

lg oskar

[garvinhicking]

Hi!

For staticpages, this index:

Code: Select all

CREATE FULLTEXT INDEX huselbusel_idx on serendipity_staticpages
 (headline, content);

HTH,
Garvin

[dodge]

perfekt, funktioniert!

danke!