Make changes that I suggested first then move on to more advanced topics. If you can not get the simple blog tutorial working you should not be trying to move past it until you do.
-- Larry E. Masters On Fri, Sep 30, 2011 at 11:08 AM, Yves S. Garret <[email protected] > wrote: > "Unless you have set $useDbConfig = 'cake_posts'; in your models." > > Where do I set this? > > On Fri, Sep 30, 2011 at 12:05 PM, Larry E. Masters <[email protected]>wrote: > >> Just took a quick look @ your database.php again and this is your problem. >> >> var $default = array( >> 'driver' => 'mysqli', >> 'persistent' => false, >> 'host' => 'localhost', >> 'login' => 'root', >> 'password' => 'summer11', >> 'database' => 'mysql', >> 'prefix' => '', >> //'encoding' => 'utf8', >> ); >> >> Unless you have set $useDbConfig = 'cake_posts'; in your models. >> >> Since you are starting new with this remove all setting in this class >> except for the var $default and change it to look like this, >> >> var $default = array( >> 'driver' => 'mysqli', >> 'persistent' => false, >> 'host' => 'localhost', >> 'login' => 'root', >> 'password' => 'summer11', >> 'database' => 'cake_posts', >> 'prefix' => '', >> //'encoding' => 'utf8', >> ); >> >> >> -- >> Larry E. Masters >> >> >> On Fri, Sep 30, 2011 at 10:59 AM, Yves S. Garret < >> [email protected]> wrote: >> >>> I got it off of the tutorial. I ran only that query in the cake_posts >>> database: >>> >>> http://book.cakephp.org/view/1530/Creating-the-Blog-Database >>> >>> Didn't change anything else. >>> >>> But here is what I got out of phpMyAdmin: >>> >>> http://bin.cakephp.org/view/728618965 >>> >>> >>> On Fri, Sep 30, 2011 at 11:44 AM, Larry E. Masters <[email protected]>wrote: >>> >>>> 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.organd >>>>>>>>>>>> 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.organd >>>>>>>>>>> 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.organd >>>>>>>>>> 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.organd >>>>>>>>> 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 > -- 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
