Hello All,
I am hoping someone here has some ideas on this one. I'm working on
creating a very simple app using CakePHP 1.2 (from
cake_1.2.0.6311-beta.zip).
At this point I've created a very simple table and I'm simply trying to do
an index that does find all. Here is what I am getting:
SNIP:
-------------------
Warning (2): ociexecute() [function.ociexecute]: ORA-00923: FROM keyword
not found where expected
[CORE/cake/libs/model/datasources/dbo/dbo_oracle.php, line 291]
Code | Context
$sql = "SELECT User.id, User.email, User.password, User.question,
User.answer, User.modified_date, User.modified_by,
User.failed_login_attempts, User.locked FROM users User WHERE 1 = 1 "
$mode = 32
Warning: implode() [function.implode]: Invalid arguments passed in
/var/www/http/eservice/cake/libs/debugger.php on line 497
ociexecute - [internal], line ??
DboOracle::_execute() -
CORE/cake/libs/model/datasources/dbo/dbo_oracle.php, line 291
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php,
line 155
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php,
line 297
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 565
Model::find() - CORE/cake/libs/model/model.php, line 1752
Model::findAll() - CORE/cake/libs/model/model.php, line 1799
UserController::index() - APP/controllers/user_controller.php, line 14
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 268
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 240
[main] - APP/webroot/index.php, line 84
CakePHP: the rapid development php framework
Missing View
Error: The view for UserController::index() was not found.
Error: Confirm you have created the file:
/var/www/http/eservice/app/views/user/index.ctp
Notice: If you want to customize this error message, create
app/views/errors/missing_view.ctp
4 queries took 217 ms Nr Query Error Affected Num. rows Took (ms)
1 ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' 0 4
2 SELECT view_name AS name FROM user_views UNION SELECT table_name AS name
FROM user_tables 13 13 133
3 SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM user_tab_columns WHERE
table_name = 'USERS' 9 9 56
4 SELECT User.id, User.email, User.password, User.question, User.answer,
User.modified_date, User.modified_by, User.failed_login_attempts,
User.locked FROM users User WHERE 1 = 1 0 24
--------------------
The table I am selecting is defined as:
CREATE TABLE CS_USERS
(
ID INTEGER NOT NULL,
EMAIL VARCHAR2(250 BYTE) NOT NULL,
PASSWORD VARCHAR2(250 BYTE) NOT NULL,
QUESTION VARCHAR2(250 BYTE),
ANSWER VARCHAR2(250 BYTE),
MODIFIED_DATE DATE,
MODIFIED_BY VARCHAR2(250 BYTE),
FAILED_LOGIN_ATTEMPTS INTEGER,
LOCKED CHAR(1 BYTE)
);
ALTER TABLE CS_USERS ADD (
PRIMARY KEY
(ID));
and the model is defined as:
<?php
class User extends AppModel
{
var $name = 'User';
var $useTable = 'CS_USER';
var $validate = array(
'email' => VALID_EMAIL,
'password' => VALID_NOT_EMPTY,
'question' => VALID_NOT_EMPTY,
'password' => VALID_NOT_EMPTY
);
}
?>
This is so incredible simple, it should just work. But for some reason
Cake is constructing SQL statements that Oracle just doesn't like.
Does anyone have any ideas as to what I need to do to fix this? I've had
a ton of success with Cake and MySQL and unfortunately I'm being forced
into Oracle for this project. If I cannot make this work for Oracle I'll
have to look at some other frameworks, which I definitely don't want to
do.
Thanks in advance!
Brian
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
