Database errors following installation - Joomla! Forum - community, help and support


is there problem sql in installation package?

immediately folowing new installation of 1.0.4 new, empty database, phpmyadmin reports these errors in database:

problems indexes of table `jos_categories`
   more 1 index key created column `section`
problems indexes of table `jos_core_acl_aro_groups`
   more 1 index key created column `parent_id`
problems indexes of table `jos_core_acl_aro_sections`
   more 1 unique key created column `value`
   more 1 index key created column `hidden`

i performed test shown above because live site has more errors, shown here:

problems indexes of table `jos_categories`
   more 1 index key created column `section`
problems indexes of table `jos_core_acl_aro`
   more 1 unique key created column `section_value`
   more 1 index key created column `hidden`
problems indexes of table `jos_core_acl_aro_groups`
   more 1 index key created column `parent_id`
problems indexes of table `jos_core_acl_aro_sections`
   more 1 unique key created column `value`
   more 1 index key created column `hidden`
problems indexes of table `jos_sb_messages`
   primary , index keys should not both set column `id`
problems indexes of table `jos_sb_moderation`
   primary , index keys should not both set column `catid`

one more thing. when open phpmyadmin perform these checks, see warning message: "the mbstring php extension not found , seem using multibyte charset. without mbstring extension phpmyadmin unable split strings correctly , may result in unexpected results."

here system information:
php built on:  linux www38.hostpc.com 2.6.9-22.0.1.elsmp #1 smp thu oct 27 13:14:25 cdt 2005 i686 
database version:  4.1.11-standard 
php version:  4.4.0 
web server:  apache/2.0.55 (unix) mod_perl/1.99_17-dev perl/v5.8.5 mod_ssl/2.0.55 openssl/0.9.7a php/4.4.0 frontpage/5.0.2.2634 
webserver php interface:  apache2handler 
joomla! version:  joomla! 1.0.4 stable [ sundial ] 21-nov-2005 10:00 utc 
user agent:  mozilla/4.0 (compatible; msie 6.0; windows nt 5.1; sv1; .net clr 1.0.3705) 
relevant php settings:  safe mode:  off 
open basedir:  none 
display errors:  on 
short open tags:  on 
file uploads:  on 
magic quotes:  on 
register globals:  on 
output buffering:  off 
session save path:  /tmp 
session auto start:  0 
xml enabled:  yes 
zlib enabled:  yes 
disabled functions:  none 
wysiwyg editor:  no wysiwyg editor






Comments