#124 Base 1.2.2 - Schema Version = 0 - Postgresql

BASE
closed-out-of-date
Kevin Johnson
Interface (166)
5
2006-01-19
2006-01-18
Anonymous
No

I recently upgrade from 1.2 to 1.2.2, and I had to
modify includes/base_db.inc.php in order to get the
schema version from schema table.

When schema version is not set, signature information
is not displayed(name/class), only signature id.

I know this fix works with PostgreSQL, but I don't
know if it cause some problem with MySQL.

Regards,

Carlos.

--- includes/base_db.inc.php.original Wed Jan 18
11:48:35 2006
+++ includes/base_db.inc.php Wed Jan 18 11:54:31
2006
@@ -92,7 +92,7 @@
}

/* Set the database schema version number */
- $sql = "SELECT vseq FROM `schema`";
+ $sql = "SELECT vseq FROM schema";
if ($this->DB_type == "mssql") $sql = "SELECT
vseq FROM [schema]";
$result = $this->DB->Execute($sql);
if ( $this->baseErrorMessage() != "" )
@@ -152,7 +152,7 @@
}

/* Set the database schema version number */
- $sql = "SELECT vseq FROM `schema`";
+ $sql = "SELECT vseq FROM schema";
if ($this->DB_type == "mssql") $sql = "SELECT
vseq FROM [schema]";
$result = $this->DB->Execute($sql);
if ( $this->baseErrorMessage() != "" )

Discussion

  • Kevin Johnson
    Kevin Johnson
    2006-01-19

    Logged In: YES
    user_id=836228

    This was fixed correctly in CVS and will be part of 1.2.4
    which is the next release.

    The attached fix would break MySQL 5.

    Thanks
    Kevin

     
  • Kevin Johnson
    Kevin Johnson
    2006-01-19

    • assigned_to: nobody --> secureideas
    • status: open --> closed-out-of-date