nk4um

but I''m no MySQL expert either, so I was hoping you could tell me what switch to set. Instead it looks like its RTFM time.

You might modify the BLOGXTER install instructions to indicate that it requires the ISAM tables.

Thanks for the help.  I''ll post more when I get it all fixed up.

My guess would be that you need to make sure your MySQL is defaulting to ISAM tables this is the default that I''ve used (from memory - better check docs!).  I''m not a MySQL expert but it would appear that features (fulltext indexing) depend on which table format you use.

well here is the point of failure.
any suggestions?

CREATE TABLE IF NOT EXISTS blogxter.entries (
   id         MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(id),
   blogid      MEDIUMINT UNSIGNED ,
   title      TEXT,
   author      MEDIUMINT UNSIGNED ,
   created      DATETIME,
   modified   DATETIME,
   summary      TEXT,
   entry      LONGTEXT,
   publicid   TEXT,
   status      ENUM("approved","pending", "deleted"),
   FULLTEXT (title, entry)
);
ERROR 1214 : The used table type doesn''t support FULLTEXT indexes

Hi Charlie,

Strange, not had problems on earlier versions of MySQL.  Here''s some places to start looking...

The SQL can be found in install/setupDB.xml in the blogxter-services*.jar module.

The ConfigRDBMS.xml is dynamically generated from the form data provided and will be sunk to scratch for the blogxter-services module. Take a look in

[install]/scratch/module_blogxter_services_xxxx/etc/ConfigRDBMS.xml

Hope this helps - please let me know how you get on.

Peter

Error
Table ''blogxter.entries'' doesn''t exist
Please check your database permissions. The DB Admin account you use must have remote access and GRANT permissions. Also make sure you have a MySQL JDBC driver installed in mod_db/lib/.

does, does and do.
Also set up the ConfigRDBMS,xml file in <install>etc
Created 23 tables, and the blogxter user.
Can''t find the SQL so I can''t figure out specifically what it is trying to do.
Using Mysql 4.1.2.
Can you help me debug this thing?
Looks like it might be quite useful, this blogxter.