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
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
- 341
- Created
- Thursday 15 September, 2005 19:12:20 UTC
by Unknown - LastModif
- Saturday 08 August, 2009 19:15:14 UTC