Re: Error using CakePHP with SQL Server

app works on localhost but on a server I have the same problem...

On 22 sep, 10:27, excepcion <excepc...@gmail.com> wrote:
> Hi,
>
>    I've installed Cake PHP last week and I'm trying to use it with SQL
> Server 2005. I have a newdatabasecalled "test" with the user "sa" as
> the only authorised user. Thisdatabasehas one table called "items".
> I configure thedatabase.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 thedatabase".
>
>    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 loadhttp://localhost/example/itemsI get this error:
> Query: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
> Warning: SQL Error:Databasecontextchanged to 'test'. in C:\Archivos
> de programa\Apache Group\Apache2\htdocs\example\cake\libs\model
> \datasources\dbo_source.php on line 440
>
> MissingDatabaseTable
> NoDatabasetable 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 thedatabasewith 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 thedatabase"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 cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---