DB update SQL statement
- Status
- Closed
- Subject
- DB update SQL statement
- Version
- 3.x
- Category
- Error
- Patch
- Feature
- Database MySQL (MyISAM)
- Resolution status
- Fixed or Solved
- Submitted by
- Ushindi Gedeon
- Lastmod by
- Ushindi Gedeon
- Rating
- Description
When upgrade from version 2.2 to 3.9, I received one database error.
The error is related to this statement:
INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `ur
l`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (197,42,'o','Mind Map','tiki-mindmap.php',255,'feature_wiki_mindmap','tiki_p_view','',0) The SQL statement failed to complete because the optionId 197 already exist.
- Solution
I believe since the optionId is auto-increment, I think there is no need to include the optionId in the insert statement.
- Workaround
- Importance
- 5
- Priority
- 25
- 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
- 3953
- Created
- Tuesday 26 July, 2011 13:14:39 UTC
by y_d_hsu - LastModif
- Thursday 02 July, 2026 09:40:49 UTC