Hi,
I've installed Cake PHP last week and I'm trying to use it with SQL
Server 2005. I have a new database called "test" with the user "sa" as
the only authorised user. This database has one table called "items".
I configure the database.php file with the right parameters and I can
see the right home page for the Cake PHP installation with the
message: "Cake is able to connect to the database".
Then I have one file with the controller called
"items_controller.php" with this code:
class ItemsController extends AppController {
var $name = 'Items';
var $scaffold;
}
And one file with the model called "item.php" with this code:
class Item extends AppModel {
var $name = 'Item';
}
When I try to load http://localhost/example/items I get this error:
Query: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
Warning: SQL Error: Database context changed to 'test'. in C:\Archivos
de programa\Apache Group\Apache2\htdocs\example\cake\libs\model
\datasources\dbo_source.php on line 440
Missing Database Table
No Database table for model Item (expected "items"), create it first.
The table exists and the user has the right permissions. I tried
to:
- Execute de SQL query "SELECT TABLE_NAME FROM
INFORMATION_SCHEMA.TABLES" in the database with the same user and
there's no problem.
- Upgrade Cake PHP to the latest Release Candidate, and I get the SQL
Error.
- Create a new user, change security, put the database "test" as the
default and I get the SQL Error.
Can someone help me? Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
