--
Larry E. Masters
On Fri, Sep 30, 2011 at 11:08 AM, Yves S. Garret <yoursurrogategod@gmail.com> 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 <phpnut@gmail.com> 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. MastersOn Fri, Sep 30, 2011 at 10:59 AM, Yves S. Garret <yoursurrogategod@gmail.com> wrote:
I got it off of the tutorial. I ran only that query in the cake_posts 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 <phpnut@gmail.com> 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. MastersOn Fri, Sep 30, 2011 at 10:11 AM, Sam Sherlock <sam.sherlock@gmail.com> 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 <yoursurrogategod@gmail.com> wrote:No problem.By the way, what's bin.cakephp.org?
On Fri, Sep 30, 2011 at 10:57 AM, Larry E. Masters <phpnut@gmail.com> 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. MastersOn Fri, Sep 30, 2011 at 9:46 AM, Yves S. Garret <yoursurrogategod@gmail.com> 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 <fbaraujo84@gmail.com> 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 <yoursurrogategod@gmail.com>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 <vinizinmoraes@gmail.com>
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* 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.comI got to the following portion of the tutorial:
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: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
--
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
--
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
--
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
--
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
--
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
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
No comments:
Post a Comment