Scoring Mods for PostGres installs
- Status
- Closed
- Subject
- Scoring Mods for PostGres installs
- Version
- 1.9.x
- Category
- Error
- Patch
- Feature
- Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc)
Score - Resolution status
- Works For Me
- Submitted by
- wbeaver2
- Volunteered to solve
- wbeaver2
- Lastmod by
- Kissaki
- Rating
- Description
lib/tikilib and lib/score/scorelib.php functions send no timestamp argument to tiki_users_score isert queries. This results in query failure because tiki_users_score tstamp column in Tiki 1.9 distrib. contains a 'not null' constraint.
The following PostGres query sets the default timestamp of tiki_users_score alter column tstamp to 'now', which ensures against attempted insertion of NULL values from the tiki codebase: alter table tiki_users_score alter column tstamp set default now();
- Solution
Please upgrade to a more recent version of tiki,
try again, check tracker items and add a new item if the problem persists.- 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
- 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 currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 341
- Created
- Thursday 15 September, 2005 19:12:20 UTC
by Unknown - LastModif
- Saturday 08 August, 2009 19:15:14 UTC