Issue
Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select
I have previously baked a controller for a model that I have created.
When attempting to bake the view using cakephp I get the following errors:
Interactive Bake Shell
---------------------------------------------------------------
[D]atabase Configuration
[M]odel
[V]iew
[C]ontroller
[P]roject
[Q]uit
What would you like to Bake? (D/M/V/C/P/Q)
> v
---------------------------------------------------------------
Bake View
Path: /Applications/MAMP/htdocs/app/views/
---------------------------------------------------------------
Possible Controllers based on your current database:
1. Dealers
2. Products
3. Users
Enter a number from the list above, type in the name of another controller, or 'q' to exit
[q] > 2
Would you like to create some scaffolded views (index, add, view, edit) for this controller?
NOTE: Before doing so, you'll need to create your controller and model classes (including associated models). (y/n)
[n] > y
Would you like to create the views for admin routing? (y/n)
[y] > n
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /Applications/MAMP/htdocs/cake/libs/model/datasources/dbo/dbo_mysql.php on line 500
Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /Applications/MAMP/htdocs/cake/libs/model/datasources/dbo/dbo_mysql.php on line 576
Warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/cake/libs/model/datasources/dbo/dbo_mysql.php on line 102
Warning: array_keys() expects parameter 1 to be array, boolean given in /Applications/MAMP/htdocs/cake/console/libs/tasks/view.php on line 263
Warning: mysql_query() expects parameter 2 to be resource, boolean given in /Applications/MAMP/htdocs/cake/libs/model/datasources/dbo/dbo_mysql.php on line 500
Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /Applications/MAMP/htdocs/cake/libs/model/datasources/dbo/dbo_mysql.php on line 576
Warning: Invalid argument supplied for foreach() in /Applications/MAMP/htdocs/cake/libs/model/datasources/dbo/dbo_mysql.php on line 102
Warning: array_keys() expects parameter 1 to be array, boolean given in /Applications/MAMP/htdocs/cake/console/libs/tasks/view.php on line 382
Creating file /Applications/MAMP/htdocs/app/views/products/index.ctp
Wrote /Applications/MAMP/htdocs/app/views/products/index.ctp
Creating file /Applications/MAMP/htdocs/app/views/products/view.ctp
Wrote /Applications/MAMP/htdocs/app/views/products/view.ctp
Creating file /Applications/MAMP/htdocs/app/views/products/add.ctp
Wrote /Applications/MAMP/htdocs/app/views/products/add.ctp
Creating file /Applications/MAMP/htdocs/app/views/products/edit.ctp
Wrote /Applications/MAMP/htdocs/app/views/products/edit.ctp
---------------------------------------------------------------
View Scaffolding Complete.
Anybody know why? Google hasn't been a whole lot of help.
cakephp 1.2.6 under MAMP on OSX 10.6.2
Database config:
class DATABASE_CONFIG {
var $default = array(
'driver' => 'mysql',
'persistent' => false,
'host' => 'localhost',
'login' => 'root',
'password' => 'root',
'database' => 'cs_db',
'prefix' => '',
'port' => '/Applications/MAMP/tmp/mysql/mysql.sock',
);
Solution
The problem is kind of weird. Restarting MAMP resolved it. I have yet to find a reproducible reason though.
Answered By - Jay
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.