Ticket #1486018 (closed Bugs: fixed)

Opened 8 months ago

Last modified 8 months ago

db.inc.php.dist - Sequence names not only used with PostgreSQL

Reported by: Gliese Owned by:
Priority: 5 Milestone: 0.3-stable
Component: Database Version: 0.3-rc1
Severity: normal Keywords:
Cc:

Description

The sequence names defined at the end of db.inc.php(.dist) are used even when the db provider is not pgsql (function get_sequence_name in include/main.inc. Whereas it doesn't matter for mysql and sqlite, it triggers errors with mssql, whose command returning the last insert_id takes the table name as argument (SELECT IDENT_CURRENT('$table'), see in program/lib/MDB2/Driver/mssql.php).
Several solutions are possible, starting with instructing the user in INSTALL to comment out those lines if he plans to use mssql.

Change History

Changed 8 months ago by alec

  • status changed from new to closed
  • resolution set to fixed

Fixed in r2834.

Note: See TracTickets for help on using tickets.