#1662: Sqlite DataDict some missing data types, and table name like "Order
Details" issue
----------------------------+-----------------------------------------------
Reporter: toni | Owner: jwage
Type: defect | Status: new
Priority: minor | Milestone: Unknown
Component: Import/Export | Version: 1.0.3
Resolution: | Keywords:
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
----------------------------+-----------------------------------------------
Old description:
> I tried to execute command ./doctrine generate-models-db to import
> Northwind.db (sqlite3 format). But it throws an error with
> messages:[[BR]]
> [[BR]]
> '''unknown database attribute type: ntext'''[[BR]]
> '''unknown database attribute type: image'''[[BR]]
> '''unknown database attribute type: nchar'''[[BR]]
> '''unknown database attribute type: money'''[[BR]]
> '''unknown database attribute type: bit'''[[BR]]
>
> And by trial and error i change Doctrine/DataDict/Sqlite.php file to
> supporting this data type (just for testing). But then again throws an
> error:[[BR]]
>
> [[BR]]
> '''General error: 1 near "Order": syntax error'''[[BR]]
>
> The problems in error above maybe because Northwind.db have table name
> "Order Details" (i'm not sure). I try to change table "Order Details" to
> OrderDetails. Then ./doctrine generate-models-db throw an error with
> message:
>
> [[BR]]
> '''Missing "type" from field definition'''[[BR]]
>
> I don't know for sure what cause an error above.
>
> I suggest to that doctrine can import table name from another database
> which do not have a standard format like ("Order Details").
>
> Sorry, if my english very-very bad...
> Thanks!
New description:
I tried to execute command ./doctrine generate-models-db to import
Northwind.db (sqlite3 format). But it throws an error with messages:[[BR]]
[[BR]]
'''unknown database attribute type: ntext'''[[BR]]
'''unknown database attribute type: image'''[[BR]]
'''unknown database attribute type: nchar'''[[BR]]
'''unknown database attribute type: money'''[[BR]]
'''unknown database attribute type: bit'''[[BR]]
And by trial and error i change Doctrine/DataDict/Sqlite.php file to
supporting this data type (just for testing). But then again throws an
error:
[[BR]]
'''General error: 1 near "Order": syntax error'''[[BR]]
The problems in error above maybe because Northwind.db have table name
"Order Details" (i'm not sure). I try to change table "Order Details" to
OrderDetails. Then ./doctrine generate-models-db throw an error with
message:
[[BR]]
'''Missing "type" from field definition'''[[BR]]
I don't know for sure what cause an error above.
I suggest to that doctrine can import table name from another database
which do not have a standard format like ("Order Details").
Sorry, if my english very-very bad...
Thanks![[BR]]
[[BR]]
'''Doctrine Version: 1.0.3'''[[BR]]
PHP 5.2.4-2ubuntu5.3 with Suhosin-Patch 0.9.6.2 (cli) (built: Jul 23 2008
06:46:18)[[BR]]
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies[[BR]]
with Xdebug v2.0.3, Copyright (c) 2002-2007, by Derick Rethans[[BR]]
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1662#comment:1>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
