Open verde3ro opened 5 years ago
@verde3ro Can you provide example models when it occurs?
@Jeckerson, Occurs when generating models with Phalcon DevTools or Web Tools.
@verde3ro Please execute model generation per single table and provide output of SHOW CREATE TABLE
of tables where it occurs.
@Jeckerson, Execution generation of model per single table:
Table:
CREATE TABLE "AV_USUARIO_C"
( "ID" NUMBER DEFAULT NULL NOT NULL ENABLE,
"USUARIO" VARCHAR2(20 BYTE) DEFAULT '' NOT NULL ENABLE,
"PASSWORD" VARCHAR2(50 BYTE) DEFAULT '',
"NOMBRE" VARCHAR2(250 BYTE) DEFAULT '' NOT NULL ENABLE,
"CORREO" VARCHAR2(100 BYTE) DEFAULT '',
"ESTATUS" VARCHAR2(5 BYTE) DEFAULT 'AC' NOT NULL ENABLE,
"USUARIO_I" VARCHAR2(20 BYTE) DEFAULT '' NOT NULL ENABLE,
"FECHA_I" DATE DEFAULT SYSDATE NOT NULL ENABLE,
"USUARIO_U" VARCHAR2(20 BYTE),
"FECHA_U" DATE,
"CORRECTO" NUMBER(1,0) DEFAULT 0,
"USUARIO_EBS" VARCHAR2(20 BYTE) DEFAULT '',
CONSTRAINT "AV_USUARIO_PK" PRIMARY KEY ("ID"),
CONSTRAINT "AV_USUARIO_UX" UNIQUE ("USUARIO")
) ;
Configuration:
'database' => [
'adapter' => 'Oracle',
'host' => '127.0.0.1:1521/XE',
'username' => 'MGR_ARVYC',
'password' => 'password01',
'dbname' => '(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA=(SID=XE)))',
'charset' => 'utf8',
],
Execution:
Option config hasn't been defined
is related to another task. That means that your table name will be generated after #1292 will be merged.
Try to find another table that generate this error:
ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared (ext\pdo_oci\oci_statement.c:159)
I did not understand the comment:
Option config hasn't been defined is related to another task. That means that your table name will be generated after #1292 will be merged.
Any table in the schema generate the error when created the model.
ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared
(ext\pdo_oci\oci_statement.c:159)
I did not understand the comment:
You posted screenshot where error is different https://user-images.githubusercontent.com/13452905/54629138-8c121800-4a3c-11e9-87fd-f0ea4daa64d0.png
So your issue is actual.
yes it's actual
ERROR: SQLSTATE[HY000]: General error: 24337 OCIStmtExecute: ORA-24337: statement handle not prepared
(ext\pdo_oci\oci_statement.c:159)
Can be fixed only when Incubator DB Component is ready for Phalcon v4.
Error Option namespace hasn't been defined
when generating a class with constraint relation.
There's 2 typos in the file Model.php
if ($this->modelOptions->hasOption('namespace'))
instead of if ($this->modelOptions->getOption('namespace'))
Devtool tag 4.0.5
@flyingangel I think your issue isn't related to this one. Please create separate one.
I have the following problem when generating the models of an Oracle database.
I hope you can help me.