Skip to content

SQlite3-Driver Problem using table named "order" #84

@ghost

Description

Created by Knut Alboldt, 4th Dec 2012. (originally Lighthouse ticket #46):


I found a small glitch in the SQLite(3)-Driver (cakephp 2.2.3, ./lib/Cake/Model/Datasource/Database/Sqlite.php):

I named a table "order". When using "Console/cake bake" I*ve got an Error (sorry, can't remember the right msg now) at the line 475:

475: $indexes = $this->query('PRAGMA index_list(' . $table . ')');

Obviously, "order" is interpreted as a keyword here. Changed the line to

475: $indexes = $this->query('PRAGMA index_list("' . $table . '")');

and "bake" works.

Maybe you could check, if I'm right.

Thanks

Knut

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions