Scoring feature causes intermittent blog access error in v1.9.8.3
- Status
- Pending
- Subject
- Scoring feature causes intermittent blog access error in v1.9.8.3
- Version
- 1.9.x
- Category
- Error
- Feature
- Database MySQL (MyISAM)
Blog
Score - Submitted by
- Connor MacLeod of the Clan MacLeod
- Lastmod by
- Connor MacLeod of the Clan MacLeod
- Rating
- Description
Two users received the following error when trying to access a blog for which they have permissions in TW v1.9.8.3:
An error occurred in a database query!
Context:
File tiki-view_blog.php
Url tiki-view_blog.php?blogId=2
Query:
insert into 'tiki_users_score' ('user','event_id','expire') values (?,?,?)
Values:
0 redacted username of blog creator
1 blog_is_read_redacted username of bug victim:2
2 1200929940
Message:
Error Message Duplicate entry 'redacted blog creator-blog_is_read_redacted bug victim' for key 1
No other users (~60) reported this error. The two affected users reported that other blogs were accessible.When Scoring was turned off, this error did not repeat until Scoring was turned back on.
- Solution
- See forum post "duplicate key in tiki_sessions - a 'solution'". This error is related to excessively long usernames and string length limits on the event_id variable in the tiki_users_score table, combined with MySQL's truncation without TW's awareness.
- Importance
- 4
- Priority
- 20
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 1495
- Created
- Tuesday 22 January, 2008 19:10:18 GMT-0000
by Unknown - LastModif
- Monday 04 February, 2008 05:18:27 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Feature request: Be able to exclude (by category) the pages listed in Latest Changes module
- Add a command to console.php to invalidate certain objects in the search index
- Counting items in Items List Doesn't Work due to lack of , between items
- Modals in Quartz theme are too narrow
- Tracker Currency Field not working
;){kind=link}
;){kind=link}