Thank you for your reply. The table in-fact does exist there. Can I specify which database configuration I should use in my application?
On Thu, Sep 29, 2011 at 3:37 PM, Fabio Batista Araujo <[email protected]>wrote: > Yves, > > The *cake_posts* is your MySql database and what is missing, accordingly > the error response, is the *table* posts for the model Post. > > To fix it, create the table *posts* inside *cake_posts* database. > > If it is not the case, you have to be sure that you application is running > the correct database configuration, $cake_posts instead $default. > > The simpler way to fix it is doing: > > var $default = array( > 'driver' => 'mysqli', > 'persistent' => false, > 'host' => 'localhost', > 'login' => 'root', > 'password' => 'summer11', > 'database' => 'cake_posts', > 'prefix' => '', > //'encoding' => 'utf8', > ); > > For additional help, take a look at : > http://book.cakephp.org/view/922/Database-Configuration > > "*The $default connection array is used unless another connection is > specified by the $useDbConfig property in a model. For example, if my > application has an additional legacy database in addition to the default > one, I could use it in my models by creating a new $legacy database > connection array similar to the $default array, and by setting var > $useDbConfig = ‘legacy’; in the appropriate models."* > > Hope it helped you, > Fábio > > > 2011/9/29 Yves S. Garret <[email protected]> > >> 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 >> > > -- > 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
