Yves, Please create a sql dump of this database so I can see the table name. The paste you provided me is useless. I want to see a create statement
-- Larry E. Masters On Fri, Sep 30, 2011 at 10:11 AM, Sam Sherlock <[email protected]>wrote: > cakephp bin is for you to paste code into for others to review code and > give advice better than pasting it to email (urgh) > > you can also browse code snippets by tag > - S > > > > > > On 30 September 2011 16:04, Yves S. Garret <[email protected]>wrote: > >> No problem. >> >> http://bin.cakephp.org/view/1148737643 >> >> By the way, what's bin.cakephp.org? >> >> >> On Fri, Sep 30, 2011 at 10:57 AM, Larry E. Masters <[email protected]>wrote: >> >>> Yes it is possible to use multiple databases in an application written >>> with CakePHP. >>> >>> I want to see the tables in your database use >>> http://bin.cakephp.org/add/Yves and paste the tables from your >>> cake_posts database. Send the url to the paste in a reply to this thread. >>> >>> You either do not have cake_posts.posts table or you named it wrong. >>> There are settings you can put in your model if your table is not following >>> conventions, this is covered in the book. >>> >>> -- >>> Larry E. Masters >>> >>> >>> On Fri, Sep 30, 2011 at 9:46 AM, Yves S. Garret < >>> [email protected]> wrote: >>> >>>> Does anyone know if it's possible to use multiple databases in the same >>>> project in CakePHP? We would like to move to CakePHP, but many of our apps >>>> fall into a similar category. Has anyone tried this before? >>>> >>>> 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 >>>> >>> >>> -- >>> 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
