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 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
- 1495
- Created
- Tuesday 22 January, 2008 19:10:18 UTC
by Unknown - LastModif
- Monday 04 February, 2008 05:18:27 UTC