Page 1 of 2
Quicksearch, the used table doesn't support fulltext...
Posted: Thu Feb 11, 2010 11:28 am
by Galen
Hello,
i just updated my Serendipity version from 1.5 beta 1 to 1.5.2.
In 1.5.-beta1 i always received this message when trying to use Quicksearch on MySQL:
Code: Select all
The search function did not work as expected. Notice for the administrator of this blog: This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query:
CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)
The specific error returned by the database was:
The used table type doesn't support FULLTEXT indexes
After the update, it's still the same problem.
Greetings and many thanks for seredipity
Galen
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Thu Feb 11, 2010 12:07 pm
by garvinhicking
Hi!
Did you read the error mesage?
Regards,
Garvin
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Thu Feb 11, 2010 2:03 pm
by Galen
Yep Garvin,
I've read the errormessage, i just can't believe that s9y under mysql doesn't support full text search.
It tells me, that the table doesn't support full text indicees. In fact, when i saw this error, i tried to create the index myself with the mysql root user, and the same error message comes up.
Well, does that mean, that the search function is not available when using the mysql database? Or is it because the version that I use (and used) maybe created a bad database table type? I remember that i've read somwhere, that this was a bug under the 1.5. beta1 version.
Greetings, Galen
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Thu Feb 11, 2010 2:55 pm
by Galen
Hi Garvin,
solved the problem:
ALTER TABLE serendipity_entries ENGINE = MYISAM;
However, why it was not running on MyISAM, i don't know.
Greetings, Galen
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Thu Feb 11, 2010 3:56 pm
by garvinhicking
Hi!
s9y uses the mysql default table type, if you set that to InnoDB in your configuration, yes, this might have side effects. Great you found this out.
Regards,
Garvin
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Tue Mar 22, 2011 11:55 pm
by kento
have same problem in the new version of the blog, where do i correct that line and in what file?`
hope you can helt
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 7:48 am
by Timbalu
Hi Kento
No panic. Take PhpMyAdmin, a very nice tool to work in the database and open the db where serendipity is in.
Now you just add ALTER TABLE serendipity_entries ENGINE = MYISAM; to the sql form field and submit.
Maybe you need to do this with some more tables, to solve your search issue.
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 7:58 am
by Timbalu
Sorry, I overread you are using workbench. Is there any command panel inside to put in mysql commands? Or maybe you just select the table and convert it it to MyIsam. Is it a working or a connection tool?
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 7:59 am
by kento
Timbalu wrote:Hi Kento
No panic. Take PhpMyAdmin, a very nice tool to work in the database and open the db where serendipity is in.
Now you just add ALTER TABLE serendipity_entries ENGINE = MYISAM; to the sql form field and submit.
Maybe you need to do this with some more tables, to solve your search issue.
im using workbench and have this:
-- Trigger DDL Statements
DELIMITER $$
USE `serendipity`$$
is that the one?
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 8:06 am
by kento
kento wrote:Timbalu wrote:Hi Kento
No panic. Take PhpMyAdmin, a very nice tool to work in the database and open the db where serendipity is in.
Now you just add ALTER TABLE serendipity_entries ENGINE = MYISAM; to the sql form field and submit.
Maybe you need to do this with some more tables, to solve your search issue.
im using workbench and have this:
-- Trigger DDL Statements
DELIMITER $$
USE `serendipity`$$
is that the one?
found this by right click the table:
send to sql editor and then insert sql statement
the it show me this:
INSERT INTO `serendipity`.`serendipity_entries`
(`id`,
`title`,
`timestamp`,
`body`,
`comments`,
`trackbacks`,
`extended`,
`exflag`,
`author`,
`authorid`,
`isdraft`,
`allow_comments`,
`last_modified`,
`moderate_comments`)
VALUES
(
{id: INT},
{title: VARCHAR},
{timestamp: INT UNSIGNED},
{body: TEXT},
{comments: INT UNSIGNED},
{trackbacks: INT UNSIGNED},
{extended: TEXT},
{exflag: INT},
{author: VARCHAR},
{authorid: INT},
{isdraft: ENUM},
{allow_comments: ENUM},
{last_modified: INT UNSIGNED},
{moderate_comments: ENUM}
);
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 8:17 am
by kento
ok timbalu
have opened the db with phpadmin and can se the tables of the blog in the structure label
then what? (havent used phpadmin before)
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 8:30 am
by kento
belive i made it
thanx again timbalu
you talked about i maby need to do this to other tables?
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 8:36 am
by kento
maby this need to be fixed so users dont need to change it manuly
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 8:47 am
by Timbalu
fixed it? Good!
By the way, good music. I love things like Anne Wylie (Deep Water)...
Re: Quicksearch, the used table doesn't support fulltext...
Posted: Wed Mar 23, 2011 9:01 am
by kento
Timbalu wrote:fixed it? Good!
By the way, good music. I love things like Anne Wylie (Deep Water)...
Surre is
and there is alot more to lissen to
Timbalu, i have the user login plugin and tryed it, but the logout didn't work, is there a special url that need to be added in the logout in the plugin (the default dosn't seam to work propperly) ???
Must say, the more that is up and running the more i love using the blog "thumps up" for this blog system