Page 1 of 1

MySQL erros when running script from shell

Posted: Wed May 25, 2005 3:34 pm
by lackiem
Hello,

I am attempting to run a php script with a CRON job and am receiving errors. I can run the exact script successfully from the url via a browser but the CRON jobs gives the following errors. Can someone please shed some light onto this?

Code: Select all

PHP Notice:  Constant MYSQL_ASSOC already defined in Unknown on line 0
PHP Notice:  Constant MYSQL_NUM already defined in Unknown on line 0
PHP Notice:  Constant MYSQL_BOTH already defined in Unknown on line 0
PHP Notice:  Constant MYSQL_CLIENT_COMPRESS already defined in Unknown on line 0
PHP Notice:  Constant MYSQL_CLIENT_INTERACTIVE already defined in Unknown on line 0
PHP Notice:  Constant MYSQL_CLIENT_IGNORE_SPACE already defined in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_connect in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_pconnect in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_close in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_select_db in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_create_db in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_drop_db in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_query in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_unbuffered_query in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_db_query in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_list_dbs in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_list_tables in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_list_fields in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_list_processes in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_error in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_errno in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_affected_rows in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_insert_id in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_result in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_num_rows in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_num_fields in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fetch_row in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fetch_array in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fetch_assoc in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fetch_object in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_data_seek in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fetch_lengths in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fetch_field in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_field_seek in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_free_result in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_field_name in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_field_table in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_field_len in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_field_type in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_field_flags in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_escape_string in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_real_escape_string in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_stat in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_thread_id in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_client_encoding in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_ping in Unknown on line 0
PHP Warning:  Function registration failPHP Warning:  Function registration failed - duplicate name - mysql_get_host_info in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_get_proto_info in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_get_server_info in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_info in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fieldname in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fieldtable in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fieldlen in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fieldtype in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_fieldflags in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_selectdb in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_createdb in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_dropdb in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_freeresult in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_numfields in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_numrows in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_listdbs in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_listtables in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_listfields in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_db_name in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_dbname in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_tablename in Unknown on line 0
PHP Warning:  Function registration failed - duplicate name - mysql_table_name in Unknown on line 0
PHP Warning:  mysql:  Unable to register functions, unable to load in Unknown on line 0
Content-type: text/html
X-Powered-By: PHP/4.3.11
Go Smart Web Design

Posted: Wed May 25, 2005 3:42 pm
by thomas777neo
If you turn errors and warnings off, does it make a difference.

Why do you have two connection types e.g. mysql_connect and mysql_pconnect?

Posted: Wed May 25, 2005 4:28 pm
by lackiem
Doesn't make a difference. I am not even using mysql_connect within my script just mysql_pconnect. In fact most of the mysql functions listed in the error output are not being used in my script. It seems as though when running the script from shell its not handling the mysql stuff correctly. When running it from a browser via the url, it works fine. Does something need to be configured within mysql or PHP in order to run using a CRON job?
Go Smart Web Design

Posted: Wed May 25, 2005 4:38 pm
by thomas777neo
Have you upgraded your server recently?

Most cases it has something to do with the extensions in the php.ini. Or there is an error in the php.ini

Posted: Wed May 25, 2005 4:45 pm
by lackiem
That's kind of what I figured. It’s actually not my server. It's a small Las Vegas hosting company that a client decided to go with against my recommendation. I have been trying to work with them in getting the problem fixed but they are clueless. It's been days now and the problem is still not resolved, which is why I decided to come here for a possible solution. I unfortunately don't have access to the php.ini so I guess I am at their mercy at this point. Thanks for your help.
Go Smart Web Design