some failed database operations following 3.0beta1 upgrade from 2.2
- Status
- Closed
- Subject
- some failed database operations following 3.0beta1 upgrade from 2.2
- Version
- 3.x
- Category
- Error
- Feature
- Installer (profiles, upgrades and server-related issues)
- Resolution status
- Out of Date
- Submitted by
- Geoff Brickell
- Lastmod by
- Marc Laporte
- Rating
- Description
Doesn't seem to have had any adverse effects but did see these errors when upgrading a test site from 2.2 to 3.0beta1
- 2008-10-19 sylvieg
ALTER TABLE tiki_users_score CHANGE event_id event_id char(200) NOT NULL default ''
Specified key was too long; max key length is 1000 bytes
ALTER TABLE tiki_users_score ADD PRIMARY KEY 110),event_id(110
Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
ALTER TABLE tiki_users_score ADD KEY user (user(110),event_id(110),expire)
Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_search_categorized', 'Can search on objects of this category', 'basic', 'category')
Duplicate entry 'tiki_p_search_categorized' for key 1- Importance
- 6
- Priority
- 30
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 2346
- Created
- Sunday 08 March, 2009 17:17:56 UTC
by Unknown - LastModif
- Friday 15 January, 2010 22:09:38 UTC