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
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
Post a Comment