Yes. I called the database cake_posts. Do I set something up so that it points to that specific db?
2011/9/29 Vinícius Moraes de Araújo <[email protected]> > You have the table posts created on your database ? > > Atenciosamente, > > Vinícius Moraes > > > 2011/9/29 Yves S. Garret <[email protected]> > >> By the way, this is my database.php file: >> >> <?php >> /** >> * This is core configuration file. >> * >> * Use it to configure core behaviour ofCake. >> * >> * PHP versions 4 and 5 >> * >> * CakePHP(tm) : Rapid Development Framework (http://cakephp.org) >> * Copyright 2005-2011, Cake Software Foundation, Inc. ( >> http://cakefoundation.org) >> * >> * Licensed under The MIT License >> * Redistributions of files must retain the above copyright notice. >> * >> * @copyright Copyright 2005-2011, Cake Software Foundation, Inc. ( >> http://cakefoundation.org) >> * @link http://cakephp.org CakePHP(tm) Project >> * @package cake >> * @subpackage cake.app.config >> * @since CakePHP(tm) v 0.2.9 >> * @license MIT License ( >> http://www.opensource.org/licenses/mit-license.php) >> */ >> /** >> * In this file you set up your database connection details. >> * >> * @package cake >> * @subpackage cake.config >> */ >> /** >> * Database configuration class. >> * You can specify multiple configurations for production, development and >> testing. >> * >> * driver => The name of a supported driver; valid options are as follows: >> * mysql - MySQL 4 & 5, >> * mysqli - MySQL 4 & 5 Improved Interface (PHP5 only), >> * sqlite - SQLite (PHP5 only), >> * postgres - PostgreSQL 7 and higher, >> * mssql - Microsoft SQL Server 2000 and higher, >> * db2 - IBM DB2, Cloudscape, and Apache Derby ( >> http://php.net/ibm-db2) >> * oracle - Oracle 8 and higher >> * firebird - Firebird/Interbase >> * sybase - Sybase ASE >> * adodb-[drivername] - ADOdb interface wrapper (see below), >> * odbc - ODBC DBO driver >> * >> * You can add custom database drivers (or override existing drivers) by >> adding the >> * appropriate file to app/models/datasources/dbo. Drivers should be >> named 'dbo_x.php', >> * where 'x' is the name of the database. >> * >> * persistent => true / false >> * Determines whether or not the database should use a persistent >> connection >> * >> * connect => >> * ADOdb set the connect to one of these >> * (http://phplens.com/adodb/supported.databases.html) and >> * append it '|p' for persistent connection. (mssql|p for example, or >> just mssql for not persistent) >> * For all other databases, this setting is deprecated. >> * >> * host => >> * the host you connect to the database. To add a socket or port number, >> use 'port' => # >> * >> * prefix => >> * Uses the given prefix for all the tables in this database. This >> setting can be overridden >> * on a per-table basis with the Model::$tablePrefix property. >> * >> * schema => >> * For Postgres and DB2, specifies which schema you would like to use the >> tables in. Postgres defaults to >> * 'public', DB2 defaults to empty. >> * >> * encoding => >> * For MySQL, MySQLi, Postgres and DB2, specifies the character encoding >> to use when connecting to the >> * database. Uses database default. >> * >> */ >> class DATABASE_CONFIG { >> >> var $default = array( >> 'driver' => 'mysqli', >> 'persistent' => false, >> 'host' => 'localhost', >> 'login' => 'root', >> 'password' => 'summer11', >> 'database' => 'mysql', >> 'prefix' => '', >> //'encoding' => 'utf8', >> ); >> >> var $cake_posts = array( >> 'driver' => 'mysqli', >> 'persistent' => false, >> 'host' => 'localhost', >> 'login' => 'root', >> 'password' => 'summer11', >> 'database' => 'cake_posts', >> 'prefix' => '', >> //'encoding' => 'utf8', >> ); >> >> var $doc_lookup = array( >> 'driver' => 'mysqli', >> 'persistent' => false, >> 'host' => 'localhost', >> 'login' => 'root', >> 'password' => 'summer11', >> 'database' => 'doc_lookup', >> 'prefix' => '', >> //'encoding' => 'utf8', >> ); >> >> var $test = array( >> 'driver' => 'mysql', >> 'persistent' => false, >> 'host' => 'localhost', >> 'login' => 'user', >> 'password' => 'password', >> 'database' => 'test_database_name', >> 'prefix' => '', >> //'encoding' => 'utf8', >> ); >> } >> >> >> ---------- Forwarded message ---------- >> From: Yves S. Garret <[email protected]> >> Date: Thu, Sep 29, 2011 at 2:02 PM >> Subject: Can't locate the database? >> To: [email protected] >> >> >> I got to the following portion of the tutorial: >> >> http://book.cakephp.org/view/1538/Data-Validation >> >> At the very end of the tutorial I have the impression that I can proceed >> to view at least some fruits of my labor. However, when I went to: >> >> http://localhost/cakery/posts/index >> >> Cakery being where Cake resides, I get the following error... why? >> >> Missing Database Table >> >> *Error: *Database table *posts* for model *Post* was not found. >> >> *Notice: *If you want to customize this error message, create >> app\views\errors\missing_table.ctp >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> [email protected] For more options, visit this group >> at http://groups.google.com/group/cake-php >> > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
