Knowledge Base

[TheFearlessDog]

I have just done a svn update to the latest build 585
Love the knowledgebase functionality
except getting an error
DAO_KbArticle(3849):The used table type doesn't support FULLTEXT indexes
every time i try to do a search within the quick search field

also a nice request to be able to use the same pile sort to dump articles into available sub catagories.

[Hildy]

Hey, TheFearlessDog,

Can you post up your version info for web server, php, mysql, etc? Also, I'd like to see the output from "show table status like 'kb_article%';" at a mysql prompt.

Thanks,

[TheFearlessDog]

Server Configuration
Apache version :Apache/2.0.58 (Win32)
PHP version :5.1.4 Loaded extensions :
bcmath, calendar, com_dotnet, ctype, date, ftp, hash, iconv, odbc, pcre, Reflection, session, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, apache2handler, mbstring, gd, imap, mysql, mysqli, PDO, pdo_sqlite, SQLite, mailparse
MySQL version : 5.0.22-community-nt

I had to zip my pdf output from phpmyadmin for the "show table status like 'kb_article%';" sql command

[Hildy]

I am unable to open that zip... can you just paste the text output of that show command?

[TheFearlessDog]

I hope this helps
I have also tried giving you an easier readable jpg of the results as i hate reading csv format.
-----------------------------------------------------------------------------------
SQL result,,,,,,,,,,,,,,,,,

Host: localhost,,,,,,,,,,,,,,,,,
Database: cerb4,,,,,,,,,,,,,,,,,
"Generation Time: May 01, 2008 at 05:09 PM",,,,,,,,,,,,,,,,,
Generated by: phpMyAdmin*2.8.1*/ MySQL*5.0.22-community-nt,,,,,,,,,,,,,,,,,
SQL query: show table status like 'kb_article%';;,,,,,,,,,,,,,,,,,
Rows: 2,,,,,,,,,,,,,,,,,

Name,Engine,Version,Row_format,Rows,Avg_row_length ,Data_length,Max_data_length,Index_length,Data_fre e,Auto_increment,Create_time,Update_time,Check_tim e,Collation,Checksum,Create_options,Comment
kb_article,InnoDB,10,Compact,54,2730,147456,0,1638 4,0,NULL,18/03/2008 18:01,NULL,NULL,latin1_swedish_ci,NULL,,InnoDB free: 7168 kB
kb_article_to_category,InnoDB,10,Compact,82,199,16 384,0,49152,0,NULL,24/04/2008 16:57,NULL,NULL,latin1_swedish_ci,NULL,,InnoDB free: 7168 kB

-------------------------------------------------------------------------------------

[Hildy]

Ah. That's what I was worried about. Your db tables are Innodb, and Innodb doesn't support fulltext indexes. There's some information on converting here: http://forums.mysql.com/read.php?21,26193,26193#msg-26193