Serendipity Forums

Hello, when I search something on my log I get this error.... Does someone know how I can fix this? Thanks!



CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)
De foutmelding van de database is:
SELECT
e.id,
e.author,
a.realname AS author,
a.email,
ec.categoryid,
e.timestamp,
e.comments,
e.title,
e.body,
e.extended,
e.trackbacks,
e.exflag

FROM
serendipity_entries e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid

WHERE
MATCH(title,body,extended) AGAINST('asdg')
AND isdraft = 'false' AND timestamp <= 1114410825
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Can't find FULLTEXT index matching the column list

Use phpMyAdmin or so to execute this query:
If that reports an error, tell us the error.

MySQL fulltext search only works in Versions > 4.0 and your user account needs CREATE INDEX privileges.

Regards
Garvin

#1214 - The used table type doesn't support FULLTEXT indexes

is something locked ? allready thanks!

It seems your MySQL installation does not use MyISAM tables. Check why that happens; MyISAM is normalle the standard type.

You can use phpMyAdmin to change the type of a table back to MyISAM.

Regards,
Garvin

thanks! i can search now, I hope it still works.

just a final question, is it better to change all my tables to MYISAM???

thanks

Well, that depends. For Serendipity - all changes should be set to MyISAM.

MyISAM has a couple of advantages over other table types; Write Speed being one of the important ones as well as fulltext. But it also has disadvantages, namely no referential integrity. But Serendipity does not use the foreign key system of InnoDB for example, so you wouldn't benefit from it being set to InnoDB.

Regards,
Garvin

hello there, how are you today?

yes it's me again, with a question about the search option.

I never get a error with searching, but he never found something...

Do I have to change some tables or something? rights?

hope to hear from you again. allready thanks!

forgot to tell that only my entry_idx is FULLTEXT

just saw that i have the same problem.. when i search something i dont find anything...

Cheers,

My blog is in my sig..

The MySQL Search function only begins to work after a few hundred words. With only a few words it just doesn't work.

Regards,
Garvin

hi, i've encountered the same problem too. I got the same error when search. Then I use phpmyadmin to check the database following garvinhicking's advice and found that the database is of InnoDB type. The question I want to ask is that, how to set the default databse to MyISAM from the beginning? So that when I create a new table, it will use MyISAM type automatically. Thx a lot.

Oh, I've just learned that starting from MySQL 4.1.5, the new Windows installer makes InnoDB the MySQL default table type on Windows. And mine is 4.1.11. So how to change the default table type?

Please look on the MySQL documentation for this, you'll need to edit the mysqld.conf file

Regards,
Garvin

Hello, I´m a beginner and have some questions.

After using the search in serendipity I got the same error message like the first author in this tread.

My tables are: MyISAM .

After executing the following mysql-code in serendi_entries:(my prefix: serendi_)

CREATE FULLTEXT INDEX entry_idx on serendi_entries (title,body,extended)

I got the message from phpmyadmin:

MySQL meldet: Dokumentation
#1044 - Access denied for user: 'webxxx@localhost' to database 'usr_webxxx_1'

What is the Problem ?

Of course the following informations are helpful:

First in Serendipity administration-db-password, nothing is written or could be changed (field db-name is empty) and second:
the ftp permissions in serendipity_config_local.inc are on 700 and I can´t change this in my ftp-program (error message).(How could I change this?)

Please, can someone help?

German_Guest:

MySQL meldet: Dokumentation
#1044 - Access denied for user: 'webxxx@localhost' to database 'usr_webxxx_1'

What is the Problem ?

The problem is what is mentioned: Your user account is not allowed to create fulltext indexes. Talk to your system administrator about the reasons for that.

First in Serendipity administration-db-password, nothing is written or could be changed (field db-name is empty) and second:
the ftp permissions in serendipity_config_local.inc are on 700 and I can´t change this in my ftp-program (error message).(How could I change this?)

The dbPassword is alway set to an empty string when viewing it for security reasons. Only change it if you changed the password.

About the permissions of that file, if your FTP user is the owner of the serendipity directory you should usually be able to change the file permissions. They are also set that strictly because of security reasons.

A workaround would be to create a php script:
which would reset the permissions.

Regards,
Garvin