app works on localhost but on a server I have the same problem... On 22 sep, 10:27, excepcion <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---