Re: Can't locate the database?

You have the table posts created on your database ?

Atenciosamente,

Vinícius Moraes

2011/9/29 Yves S. Garret <yoursurrogategod@gmail.com>

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 <yoursurrogategod@gmail.com>
Date: Thu, Sep 29, 2011 at 2:02 PM
Subject: Can't locate the database?
To: cake-php@googlegroups.com

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
cake-php+unsubscribe@googlegroups.com 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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php