Solved

CakePhp Console not working (Vista)

Posted on 2010-09-05
29
2,049 Views
Last Modified: 2013-11-10
Hi All,

I have installed CakePhp 3 on my vista pc with wamp server and set the system variables for cakephp.

All the paths seems ok but I'm getting these errors when trying to ue the cakephp console tool.

/*************************/
/* ERRORS
/************************/
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
filepro.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
filter.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
fribidi.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
gd2.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
gettext.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
gmp.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
gopher.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
hash.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
http.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
hyperwave.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ibm_db2.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
id3.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ifx.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
iisfunc.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
imagick.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
imap.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ingres.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
interbase.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ixsfunc.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
java.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
json.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ldap.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
lzf.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mailparse.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
maxdb.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mbstring.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
exif.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mcrypt.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mcrypt_filter.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mhash.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mime_magic.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ming.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
msql.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mssql.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mysql.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
mysqli.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
netools.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ntuser.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
oracle.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
oci8.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
oggvorbis.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
openssl.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
parsekit.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdf.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_firebird.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_mssql.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_mysql.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_oci.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_oci8.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_odbc.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pdo_sqlite.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
perl.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pgsql.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
phpdoc.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pop3.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
printer.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
pspell.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
radius.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
runkit.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
sdo.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
sdo_das_xml.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
shmop.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
smtp.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
snmp.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
soap.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
sockets.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
sqlite.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ssh2.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
stats.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
svn.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
sybase_ct.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
threads.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
tidy.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
timezonedb.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
translit.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
win32ps.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
win32scheduler.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
win32service.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
win32std.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
xdebug.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
xmlreader.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
xmlrpc.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
xmlwriter.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
xsl.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
yaz.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
zip.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
zlib_filter.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
ps.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_
paradox.dll' - The specified module could not be found.
 in Unknown on line 0
PHP Warning:  Cannot open 'C:\xampp\php\browscap\browscap.ini' for reading in Un
known on line 0


IThe errors above are looking for C:\xampp\ although I'm not using xampp ..so how can I fix this please?

Thanks


 
0
Comment
Question by:error77
  • 16
  • 13
29 Comments
 

Author Comment

by:error77
Comment Utility
Anyone please?
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
First, take a look through this page, even if you think you've done it all right. Please just check! - http://docs.php.net/manual/en/install.windows.commandline.php

The reason xampp is there is probably because your php.ini file (or equivalent) has in it ...

extension_dir=c:\xampp\php\ext

You need to edit the ini file and correct this line.

Where is the INI file ???

At the command prompt, type ...

php --ini

I get ...

[2010/09/06 11:36:05] [Z:\] [\\richardquadling\scratch$ ] >php --ini
Configuration File (php.ini) Path: C:\WINDOWS
Loaded Configuration File:         D:\PHP\INI\php-cli.ini
Scan for additional .ini files in: (none)
Additional .ini files parsed:      (none)

My ini file (for CLI operation) is in D:\PHP\INI\php-cli.ini

NOTE: This is a different ini file to my FastCGI operation and different to the ones on the development/live servers.

0
 

Author Comment

by:error77
Comment Utility
Hmm very interesting ... Just getting 1 error now:

Fatal error: Call to undefined function mysql_query() in C:\wamp\cake\cake\libs\
model\datasources\dbo\dbo_mysql.php on line 588

Any ideas ?
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Several things.

1 - The php_mysql.dll extension isn't loaded in your php.ini file.

extension=php_mysql.dll


2 - Dependent libraries for php_mysql.dll aren't available - http://docs.php.net/manual/en/mysql.installation.php

0
 

Author Comment

by:error77
Comment Utility
I've got them all loaded :o/

All extensions are ok too.

I am not able to create the cake project and it works fine ... but I cannot bake a model as I get that error :o/
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
If you create a simple PHP script ...

<?php
phpinfo();
?>

And save this in the document root (public_html, htdocs, etc. whatever your system is using).

Load if via the browser.

What do you see in terms of mysql?

NOTE: Not mysqli or mysqlnd or any other sql, but mysql.
0
 

Author Comment

by:error77
Comment Utility
OK this is what I get:

MYSQL

MySQL Support      enabled
Active Persistent Links       0
Active Links       0
Client API version       mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
Persistent cache      enabled
put_hits       0
put_misses       0
get_hits       0
get_misses       0
size       2000
free_items       2000
references       2

Directive      Local Value      Master Value
mysql.allow_local_infile      On      On
mysql.allow_persistent      On      On
mysql.cache_size      2000      2000
mysql.connect_timeout      60      60
mysql.default_host      no value      no value
mysql.default_password      no value      no value
mysql.default_port      no value      no value
mysql.default_socket      no value      no value
mysql.default_user      no value      no value
mysql.max_links      Unlimited      Unlimited
mysql.max_persistent      Unlimited      Unlimited
mysql.trace_mode      Off      Off

mysqli
MysqlI Support      enabled
Client API library version       mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $
Active Persistent Links       0
Inactive Persistent Links       0
Active Links       0
Persistent cache      enabled
put_hits       0
put_misses       0
get_hits       0
get_misses       0
size       2000
free_items       2000
references       2

Directive      Local Value      Master Value
mysqli.allow_local_infile      On      On
mysqli.allow_persistent      On      On
mysqli.cache_size      2000      2000
mysqli.default_host      no value      no value
mysqli.default_port      3306      3306
mysqli.default_pw      no value      no value
mysqli.default_socket      no value      no value
mysqli.default_user      no value      no value
mysqli.max_links      Unlimited      Unlimited
mysqli.max_persistent      Unlimited      Unlimited
mysqli.reconnect      Off      Off
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
So mysql is installed.

New script to run. Same location as the phpinfo() script please.

Hopefully you'll get a list of functions which have "sql" in their name.

Can you now put this script in the same location as the script that is failing.

Anything different in the results?


<?php
foreach(get_defined_functions() as $key => $set)
	{
	foreach($set as $func)
		{
		if (False !== strpos($func, 'sql'))
			{
			echo "Found $func in $key<br />";
			}
		}
	}

Open in new window

0
 

Author Comment

by:error77
Comment Utility
Cool ... I'll do it as soon as I get home and get back with the result. thanks!
0
 

Author Comment

by:error77
Comment Utility
Ok, I've run the script and this is the result:

/*****************************************/
/* RESULT
/*****************************************/
Found sql_regcase in internal
Found mysql_connect in internal
Found mysql_pconnect in internal
Found mysql_close in internal
Found mysql_select_db in internal
Found mysql_query in internal
Found mysql_unbuffered_query in internal
Found mysql_db_query in internal
Found mysql_list_dbs in internal
Found mysql_list_tables in internal
Found mysql_list_fields in internal
Found mysql_list_processes in internal
Found mysql_error in internal
Found mysql_errno in internal
Found mysql_affected_rows in internal
Found mysql_insert_id in internal
Found mysql_result in internal
Found mysql_num_rows in internal
Found mysql_num_fields in internal
Found mysql_fetch_row in internal
Found mysql_fetch_array in internal
Found mysql_fetch_assoc in internal
Found mysql_fetch_object in internal
Found mysql_data_seek in internal
Found mysql_fetch_lengths in internal
Found mysql_fetch_field in internal
Found mysql_field_seek in internal
Found mysql_free_result in internal
Found mysql_field_name in internal
Found mysql_field_table in internal
Found mysql_field_len in internal
Found mysql_field_type in internal
Found mysql_field_flags in internal
Found mysql_escape_string in internal
Found mysql_real_escape_string in internal
Found mysql_stat in internal
Found mysql_thread_id in internal
Found mysql_client_encoding in internal
Found mysql_ping in internal
Found mysql_get_client_info in internal
Found mysql_get_host_info in internal
Found mysql_get_proto_info in internal
Found mysql_get_server_info in internal
Found mysql_info in internal
Found mysql_set_charset in internal
Found mysql in internal
Found mysql_fieldname in internal
Found mysql_fieldtable in internal
Found mysql_fieldlen in internal
Found mysql_fieldtype in internal
Found mysql_fieldflags in internal
Found mysql_selectdb in internal
Found mysql_freeresult in internal
Found mysql_numfields in internal
Found mysql_numrows in internal
Found mysql_listdbs in internal
Found mysql_listtables in internal
Found mysql_listfields in internal
Found mysql_db_name in internal
Found mysql_dbname in internal
Found mysql_tablename in internal
Found mysql_table_name in internal
Found mysqli_affected_rows in internal
Found mysqli_autocommit in internal
Found mysqli_change_user in internal
Found mysqli_character_set_name in internal
Found mysqli_close in internal
Found mysqli_commit in internal
Found mysqli_connect in internal
Found mysqli_connect_errno in internal
Found mysqli_connect_error in internal
Found mysqli_data_seek in internal
Found mysqli_dump_debug_info in internal
Found mysqli_debug in internal
Found mysqli_errno in internal
Found mysqli_error in internal
Found mysqli_stmt_execute in internal
Found mysqli_execute in internal
Found mysqli_fetch_field in internal
Found mysqli_fetch_fields in internal
Found mysqli_fetch_field_direct in internal
Found mysqli_fetch_lengths in internal
Found mysqli_fetch_all in internal
Found mysqli_fetch_array in internal
Found mysqli_fetch_assoc in internal
Found mysqli_fetch_object in internal
Found mysqli_fetch_row in internal
Found mysqli_field_count in internal
Found mysqli_field_seek in internal
Found mysqli_field_tell in internal
Found mysqli_free_result in internal
Found mysqli_get_cache_stats in internal
Found mysqli_get_connection_stats in internal
Found mysqli_get_client_stats in internal
Found mysqli_get_charset in internal
Found mysqli_get_client_info in internal
Found mysqli_get_client_version in internal
Found mysqli_get_host_info in internal
Found mysqli_get_proto_info in internal
Found mysqli_get_server_info in internal
Found mysqli_get_server_version in internal
Found mysqli_get_warnings in internal
Found mysqli_init in internal
Found mysqli_info in internal
Found mysqli_insert_id in internal
Found mysqli_kill in internal
Found mysqli_more_results in internal
Found mysqli_multi_query in internal
Found mysqli_next_result in internal
Found mysqli_num_fields in internal
Found mysqli_num_rows in internal
Found mysqli_options in internal
Found mysqli_ping in internal
Found mysqli_poll in internal
Found mysqli_prepare in internal
Found mysqli_report in internal
Found mysqli_query in internal
Found mysqli_real_connect in internal
Found mysqli_real_escape_string in internal
Found mysqli_real_query in internal
Found mysqli_reap_async_query in internal
Found mysqli_rollback in internal
Found mysqli_select_db in internal
Found mysqli_set_charset in internal
Found mysqli_stmt_attr_get in internal
Found mysqli_stmt_attr_set in internal
Found mysqli_stmt_field_count in internal
Found mysqli_stmt_init in internal
Found mysqli_stmt_prepare in internal
Found mysqli_stmt_result_metadata in internal
Found mysqli_stmt_send_long_data in internal
Found mysqli_stmt_bind_param in internal
Found mysqli_stmt_bind_result in internal
Found mysqli_stmt_fetch in internal
Found mysqli_stmt_free_result in internal
Found mysqli_stmt_get_result in internal
Found mysqli_stmt_get_warnings in internal
Found mysqli_stmt_insert_id in internal
Found mysqli_stmt_reset in internal
Found mysqli_stmt_param_count in internal
Found mysqli_sqlstate in internal
Found mysqli_stat in internal
Found mysqli_stmt_affected_rows in internal
Found mysqli_stmt_close in internal
Found mysqli_stmt_data_seek in internal
Found mysqli_stmt_errno in internal
Found mysqli_stmt_error in internal
Found mysqli_stmt_more_results in internal
Found mysqli_stmt_next_result in internal
Found mysqli_stmt_num_rows in internal
Found mysqli_stmt_sqlstate in internal
Found mysqli_stmt_store_result in internal
Found mysqli_store_result in internal
Found mysqli_thread_id in internal
Found mysqli_thread_safe in internal
Found mysqli_use_result in internal
Found mysqli_warning_count in internal
Found mysqli_refresh in internal
Found mysqli_bind_param in internal
Found mysqli_bind_result in internal
Found mysqli_client_encoding in internal
Found mysqli_escape_string in internal
Found mysqli_fetch in internal
Found mysqli_param_count in internal
Found mysqli_get_metadata in internal
Found mysqli_send_long_data in internal
Found mysqli_set_opt in internal


Hope this helps.

0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Well, not really.

As you can see, I'm using PHP to report to me all the functions with SQL in their name

In the list is mysql_query.

So, let's go SLOWLY through how you get the problem.

How do you get the error? What do you type or load?
0
 

Author Comment

by:error77
Comment Utility
I get the error as soon as I try to build a model via the command prompt: Cake Bake Model.

So.. I first type: Cake Bake Projectname ....as it created the project without errors.

Then I go to the project folder cd\projectname and once there I try to bake the model:

Cake Bake Model and press enter ...

I then get:

C:\wamp\www\admin>cake bake model

¿
Welcome to CakePHP v1.3.3 Console
---------------------------------------------------------------
App : admin
Path: C:\wamp\www\admin
---------------------------------------------------------------

Warning: include_once(C:\wamp\www\admin\config\database.php): failed to open str
eam: No such file or directory in C:\wamp\cake\cake\libs\model\connection_manage
r.php on line 23

Warning: include_once(): Failed opening 'C:\wamp\www\admin\config\database.php'
for inclusion (include_path='.;C:\php5\pear') in C:\wamp\cake\cake\libs\model\co
nnection_manager.php on line 23
---------------------------------------------------------------
Bake Model
Path: C:\wamp\www\admin\models\
---------------------------------------------------------------
---------------------------------------------------------------
Database Configuration:
---------------------------------------------------------------
Name:
[default] >


0
 

Author Comment

by:error77
Comment Utility
1 thing I can see in the error is that it says: C:\php5\pear  ... I don't have that directory, so where is it trying to get if from?
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Your PHP.ini file.

It seems like the installation of CakePHP is incomplete.

I would expect to see some element of Cake in the include_dir.

0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:error77
Comment Utility
I'm download cakephp again and overwrite files ..see what happens
0
 

Author Comment

by:error77
Comment Utility
Hi again...

I've downloaded cake and overwrote the previous cake folder.

Then I tried again ... see what happened:

Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>cd\

C:\>cd wamp

C:\wamp>cd www

C:\wamp\www>cake bake test

¿
Welcome to CakePHP v1.3.3 Console
---------------------------------------------------------------
App : www
Path: C:\wamp\www
---------------------------------------------------------------
---------------------------------------------------------------
Bake Tests
Path: C:\wamp\www\tests\
---------------------------------------------------------------
---------------------------------------------------------------
Select an object type:
---------------------------------------------------------------
1. Model
2. Controller
3. Component
4. Behavior
5. Helper
Enter the type of object to bake a test for or (q)uit (1/2/3/4/5/q)
[q] > q


C:\wamp\www>dir
 Volume in drive C is Vista
 Volume Serial Number is B25E-0F88

 Directory of C:\wamp\www

07/09/2010  21:34    <DIR>          .
07/09/2010  21:34    <DIR>          ..
06/09/2010  23:59    <DIR>          admin
06/09/2010  23:09    <DIR>          cakecms
07/09/2010  21:34               202 index.php
               1 File(s)            202 bytes
               4 Dir(s)  14,449,172,480 bytes free

C:\wamp\www>cake bake

¿
Welcome to CakePHP v1.3.3 Console
---------------------------------------------------------------
App : www
Path: C:\wamp\www
---------------------------------------------------------------
What is the full path for this app including the app directory name?
 Example:C:\wamp\www\myapp
[C:\wamp\www\myapp] >
Bake Project
Skel Directory: C:\wamp\cake\cake\console\templates\skel
Will be copied to: C:\wamp\www\myapp
---------------------------------------------------------------
Look okay? (y/n/q)
[y] > y
Do you want verbose output? (y/n)
[n] >
---------------------------------------------------------------
Created: myapp in C:\wamp\www\myapp
---------------------------------------------------------------

Creating file C:\wamp\www\myapp\views\pages\home.ctp
Wrote `C:\wamp\www\myapp\views\pages\home.ctp`
Welcome page created
Random hash key created for 'Security.salt'
Random seed created for 'Security.cipherSeed'
CAKE_CORE_INCLUDE_PATH set to C:\wamp\cake in webroot/index.php
CAKE_CORE_INCLUDE_PATH set to C:\wamp\cake in webroot/test.php
Remember to check these value after moving to production server
Your database configuration was not found. Take a moment to create one.
---------------------------------------------------------------
Database Configuration:
---------------------------------------------------------------
Name:
[default] >
Driver: (db2/firebird/mssql/mysql/mysqli/odbc/oracle/postgres/sqlite/sybase)
[mysql] >
Persistent Connection? (y/n)
[n] >
Database Host:
[localhost] >
Port?
[n] >
User:
[root] >
Password:
>
The password you supplied was empty. Use an empty password? (y/n)
[n] > y
Database Name:
[cake] > cakecms
Table Prefix?
[n] >
Table encoding?
[n] >

---------------------------------------------------------------
The following database configuration will be created:
---------------------------------------------------------------
Name:         default
Driver:       mysql
Persistent:   false
Host:         localhost
User:         root
Pass:
Database:     cakecms
---------------------------------------------------------------
Look okay? (y/n)
[y] > y
Do you wish to add another database configuration?
[n] > n

Creating file C:\wamp\www\myapp\config\database.php
Wrote `C:\wamp\www\myapp\config\database.php`


C:\wamp\www>dir
 Volume in drive C is Vista
 Volume Serial Number is B25E-0F88

 Directory of C:\wamp\www

07/09/2010  23:33    <DIR>          .
07/09/2010  23:33    <DIR>          ..
06/09/2010  23:59    <DIR>          admin
06/09/2010  23:09    <DIR>          cakecms
07/09/2010  21:34               202 index.php
07/09/2010  23:33    <DIR>          myapp
               1 File(s)            202 bytes
               5 Dir(s)  14,451,654,656 bytes free

C:\wamp\www>cd myapp

C:\wamp\www\myapp>cake bake model

¿
Welcome to CakePHP v1.3.3 Console
---------------------------------------------------------------
App : myapp
Path: C:\wamp\www\myapp
---------------------------------------------------------------
---------------------------------------------------------------
Bake Model
Path: C:\wamp\www\myapp\models\
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_query() in C:\wamp\cake\cake\libs\
model\datasources\dbo\dbo_mysql.php on line 588


C:\wamp\www\myapp>

Same error :o(
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Looks like I'm going to have to install Cake. Later today ...
0
 

Author Comment

by:error77
Comment Utility
Hmm seems like a tough one :-) I've got it installed on my xp pc but vista is another story :-/
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Did you follow the same setup on both systems? I'm still on XP.

Most likely there is a permissions issue somewhere. A file cannot be saved in the appropriate location or the location isn't present on Vista (but is on XP).

What version of Cake? (Not looked at versions yet, so just pre-empting this).
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
OK. I'm going to be asking a bunch of questions. Some may seem daft or already covered. Please answer them though.

1 - What is the full path to all your cake.bat files?

Type the following 2 lines in a console.

CD /D C:\
DIR cake.bat /s /b

Repeat for all drives, changing C: to D:, etc.


2 - What is the contents of your PATH environment variable?

Type

SET PATH


3 - What is the contents of your PATHEXT environment variable?

Type

SET PATHEXT


4 - Do PHP files have an associated type?

Type

ASSOC .php


5 - Do PHP files have an associated file handler?

Type

FTYPE xxxx

where xxx is the value after the = sign in the output to the above command.



6 - What is the content of all the cake.bat files you find?
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
7 - What is your include path?

8 - How many instances of PHP have you got installed?

9 - How many php.ini files (or equivalent) have you got?


I wonder if your webserver is different setup to your CLI - this is that it looks like.

I don't have the time to setup Cake.

0
 

Author Comment

by:error77
Comment Utility
OK, here are the answers to your questions

/**********************************/
/*  ANSWERS
/*********************************/
OK. I'm going to be asking a bunch of questions. Some may seem daft or already covered. Please answer them though.

1 - What is the full path to all your cake.bat files? Answer = C:\wamp\cake\cake\console

Type the following 2 lines in a console.

CD /D C:\
DIR cake.bat /s /b =DONE

Repeat for all drives, changing C: to D:, etc. = DONE


2 - What is the contents of your PATH environment variable?

Type

SET PATH

Answer = C:\>set path
Path=C:\PHP\;C:\Windows;C:\Windows\system32;C:\Windows\system32\Wbem;C:\PROGRA~1
\COMMON~1\ULEADS~1\MPEG;
C:\wamp\cake\cake\console;C:\wamp\bin\php\php5.3.0;C:\wamp\bin\mysql\mysql5.1.36;C:\wamp\bin
\mysql\mysql5.1.36\bin;C:\wamp\bin\mysql\mysql5.1.36\data;C:\Users\Public\Docume
nts\RAD Studio\5.0\Bpl
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC


3 - What is the contents of your PATHEXT environment variable?

Type

SET PATHEXT

Answer = C:\>set pathext
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC


4 - Do PHP files have an associated type?

Type

ASSOC .php

Answer = C:\>assoc .php
File association not found for extension .php


5 - Do PHP files have an associated file handler?

Type

FTYPE xxxx

where xxx is the value after the = sign in the output to the above command.

Answer = File association not found for extension .php



6 - What is the content of all the cake.bat files you find?

Answer = @echo.
@echo off

SET app=%0
SET lib=%~dp0

php -q "%lib%cake.php" -working "%CD%" %*

echo.

7 - What is your include path? - No sure what you mean

8 - How many instances of PHP have you got installed? Answer = 1

9 - How many php.ini files (or equivalent) have you got? Answer = 1


I wonder if your webserver is different setup to your CLI - this is that it looks like.

I've got the same setup installed on xp and no problems at all.

Hope all this helps.

Thanks

0
 

Author Comment

by:error77
Comment Utility
Any ideas?
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Can you load SysInternals ProcMon. http://live.sysinternals.com/ProcMon.exe

Set it to watch for Process contains php and highlight mysql

Do this on both machines.

Run it to the point of failure on Vista and then to the same point (more or less) on XP.

Save the logs.

Attach them.

Can you run the script in 33615892 at the console rather than via a browser?

0
 

Author Comment

by:error77
Comment Utility
I'm seriously thinking of getting rid of vista and installing xp on my laptop :o/
0
 
LVL 40

Accepted Solution

by:
RQuadling earned 500 total points
Comment Utility
Yeah. XP just works.
0
 

Author Closing Comment

by:error77
Comment Utility
Got rid of Vista and installed XP. Worked first time. No problems at all! :o)  So the solution for me? Good old XP :o)
0
 
LVL 40

Expert Comment

by:RQuadling
Comment Utility
Sorry I couldn't get it working on Vista for you. I think XP will be my last windows. Next OS will probably be Ubuntu, even though I'll have a learning curve (25 years of DOS/Windows experience to overcome).

But, on the plus side, you points gave me a new rank of Master in PHP Frameworks. Woo Hoo for me.
0
 

Author Comment

by:error77
Comment Utility
Congrats :-)
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now