Cofax - Content Management - News Media

Hi,

I just install cofax 2.3.1 and it's better with cofax installer
i have cofax home page
Three questions

1 I have this import error, but i could continue
DataBase initialization Database schema and Database user exist already Database schema : COFAX DB Schema has been imported
Erreur :java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[', section), ']')) AS sectiondesc, Section FROM tblsections,tblpermusersection ' at line 1
Query :INSERT INTO `tbltoolspackagetags` (`tag_name`,`tag_value`,`create_date`,`modified_date`,`tagID`,`cache`) VALUES('getPubNameFromPublicationsByPubID','SELECT pubName FROM tblpublications WHERE pubID = \'req:PUBID\' ','2001-03-06 00:00:00','2001-03-06 00:00:00',0,1),('getSavedSearchesByUserID','SELECT search, searchName FROM tblpermsavedsearches WHERE userID = \'req:USERID\' ','2001-03-06 00:00:00','2001-03-06 00:00:00',0,0),('getSectionDescAndMapCodeFromSectionsByPubName','ONCAT(CONCAT(pubName, \' - \'),sectionDesc) AS sectionDesc, mappingCode FROM tblsections WHERE pubName = \'req:PUBNAME\' ','2001-03-06 00:00:00','2001-03-06 00:00:00',0,1),('getSectionDescAndSectionFromSectionsByPubName','SELECT sectionDesc, tblsections.section FROM tblsections,tblpermusersection WHERE tblpermusersection.userID=\'req:currentUserID\' AND tblsections.pubName=\'req:PUBNAME\' AND tblsections.mappingCode=tblpermusersection.mappingCode','2001-03-06 00:00:00','2001-03-06 00:00:00',0,1),('getSectionDescAndSectionFromSectionsByPubNameUser','SELECT CONCAT(sectionDesc, CONCAT(CONCAT(' [', section), ']')) AS sectiondesc, Section FROM tblsections,tblpermusersection WHERE tblpermusersection.userID=\'req:currentUserID\' AND tblsections.pubName=\'req:currentPubName\' AND tblsections.mappingCode=tblpermusersection.mappingCode','2003-05-31 00:00:00','2003-05-31 00:00:00',0,0),('getSectionFromtblsectionsByPublicationSectionName','SELECT section FROM tblsections where pubName = \'req:PUBNAME\' and sectionName = \'req:SECTION\' ','2001-03-06 00:00:00','2001-03-06 00:00:00',0,1); Data : default data has been imported


2 there is problem with // after default
http://82.247.148.50/content/default//

3 i have using my root system password for database and user, but when i want to login or send me with mail password, first letter seems missing.

Regards
Philippe