Uploaded image for project: 'Doctrine DBAL'
  1. Doctrine DBAL
  2. DBAL-114

MsSqlPlatform - getListTablesSQL() get's sysdiagrams table

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.4
    • Fix Version/s: 2.1.2, 2.2
    • Component/s: Platforms
    • Labels:
      None
    • Environment:
      Windows 7, PHP 5.3.5, MSSQL 2008

      Description

      getListTablesSQL() function in MsSqlPlatform.php list all tables in database.

      If you have saved Database Diagrams it returns "sysdiagrams" table too.
      This table have field "name" with type "sysname" which have no mapping.

      If you run orm:validate-schema you get:
      [Doctrine\DBAL\DBALException]
      Unknown database type sysname requested, Doctrine\DBAL\Platforms\MsSqlPlatform may not support it.

      Best solution is that when getting tables to ignore "sysdiagrams" tables.

        Activity

        bostjan Bostjan Oblak created issue -
        Hide
        bostjan Bostjan Oblak added a comment -

        One solution is to just add "AND name != 'sysdiagrams' " to sql statement

        Show
        bostjan Bostjan Oblak added a comment - One solution is to just add "AND name != 'sysdiagrams' " to sql statement
        Hide
        beberlei Benjamin Eberlei added a comment -

        Assigned to Jouzas

        Show
        beberlei Benjamin Eberlei added a comment - Assigned to Jouzas
        beberlei Benjamin Eberlei made changes -
        Field Original Value New Value
        Assignee Benjamin Eberlei [ beberlei ] Juozas Kaziukenas [ juokaz ]
        Hide
        yaroslav Yaroslav Zenin added a comment -

        Why it is not fixed yet? The solution is so easy. Please add to repository. Because on every release I should change it manually

        Show
        yaroslav Yaroslav Zenin added a comment - Why it is not fixed yet? The solution is so easy. Please add to repository. Because on every release I should change it manually
        Hide
        beberlei Benjamin Eberlei added a comment -

        Fixed

        Show
        beberlei Benjamin Eberlei added a comment - Fixed
        beberlei Benjamin Eberlei made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.1.2 [ 10160 ]
        Fix Version/s 2.2 [ 10142 ]
        Resolution Fixed [ 1 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira [ 12582 ] jira-feedback2 [ 17715 ]
        beberlei Benjamin Eberlei made changes -
        Workflow jira-feedback2 [ 17715 ] jira-feedback3 [ 20070 ]

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={expand=changesets[0:20].revisions[0:29],reviews, query=DBAL-114}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

          • Assignee:
            juokaz Juozas Kaziukenas
            Reporter:
            bostjan Bostjan Oblak
          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: