There's obviously a problem connecting to MySQL. Try adding mysql_error()
calls for each mysql function, to trap where the error's ocurring, like this
:-
<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
echo mysql_errno($link) . ": " . mysql_error($link). "\n";
mysql_select_db("nonexistentdb", $link);
echo mysql_errno($link) . ": " . mysql_error($link). "\n";
mysql_query("SELECT * FROM nonexistenttable", $link);
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
?>
Rob.
-----Original Message-----
From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On
Behalf Of srinivas pmm
Sent: 10 February 2009 11:10
To: php-objects@xxxxxxxxxxxxxxx
Subject: Re: Schduler Problem(tables are not creating)
Hi Rob
we added password and tried we are getting the fallowin error
mysql_num_rows(): supplied argument is not a valid MySQL result resource in
*C:\xampp\htdocs\sample\phpjobscheduler\pjsfiles\phpjobscheduler.php* on
line *33*
culd u please tellme if there is any other way to run schduler
On Tue, Feb 10, 2009 at 3:18 PM, Atkinson, Robert
<ratkinson@xxxxxxxxxxxxx>wrote:
> "Have you tried adding a password to the root account and then
> retrying?"
>
> -----Original Message-----
> From: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> [mailto:
> php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>] On
> Behalf Of srinivas pmm
> Sent: 10 February 2009 09:10
> To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> Subject: Re: Schduler Problem(tables are not creating)
>
> Hi Rob
>
> we are using xamp in xamp our mysqldatabase password is empty i.e we put
> the password field empty
>
> On Tue, Feb 10, 2009 at 2:25 PM, Atkinson, Robert
> <ratkinson@xxxxxxxxxxxxx <ratkinson%40tbs-ltd.co.uk>>wrote:
>
> > I notice the password is blank. Is this because you've removed it for
> > security or is it really blank?
> >
> > Have you tried adding a password to the root account and then retrying?
> >
> >
> > Rob.
> >
> > -----Original Message-----
> > From: php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com> [mailto:
> > php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>] On
> > Behalf Of srinivas pmm
> > Sent: 10 February 2009 03:45
> > To: php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>
> > Subject: Re: Schduler Problem(tables are not creating)
> >
> > Hi Rob
> >
> > fallowing is my config file
> > <?php
> > // ---------------------------------------------------------
> > $app_name = "phpJobScheduler";
> > $phpJobScheduler_version = "3.5";
> > // ---------------------------------------------------------
> >
> > define('DBHOST', 'localhost');// MySQL host address - localhost is
> usually
> > fine
> > define('DBNAME', 'smswebsite');// MySQL database name - must already
> exist
> > define('DBUSER', 'root');// MySQL username - must already exist
> > define('DBPASS', '');// MySQL password for above username
> > ?>
> >
> > On Mon, Feb 9, 2009 at 8:08 PM, Atkinson, Robert
> > <ratkinson@xxxxxxxxxxxxx <ratkinson%40tbs-ltd.co.uk> <ratkinson%
> 40tbs-ltd.co.uk>>wrote:
> >
> > > Please send me your config file, so I can check. My guess is you have
> an
> > > error in that somewhere, or have the wrong login credentials.
> > > Thank u
> > >
> > > Rob,
> > >
> > > -----Original Message-----
> > > From: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> <php-objects%40yahoogroups.com><php-objects%
> > 40yahoogroups.com> [mailto:
> > > php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com><php-objects%
> > 40yahoogroups.com>] On
> > > Behalf Of srinivas pmm
> > > Sent: 09 February 2009 14:35
> > > To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> <php-objects%40yahoogroups.com><php-objects%
> > 40yahoogroups.com>
> > > Subject: Re: Schduler Problem(tables are not creating)
> > >
> > > Hi
> > >
> > > Thank you for your Response.
> > > but we are not getting the Response. tables are not created in
> database.
> > > please provide some response.
> > >
> > > On Mon, Feb 9, 2009 at 7:22 PM, Atkinson, Robert
> > > <ratkinson@xxxxxxxxxxxxx <ratkinson%40tbs-ltd.co.uk> <ratkinson%
> 40tbs-ltd.co.uk> <ratkinson%
>
> > 40tbs-ltd.co.uk>>wrote:
> > >
> > > > You could also add this to constants.inc.php :-
> > > >
> > > > define('SHOW_MYSQL_ERRORS', TRUE);
> > > >
> > > >
> > > > Rob.
> > > >
> > > > -----Original Message-----
> > > > From: php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>
> > <php-objects%40yahoogroups.com><php-objects%
> > > 40yahoogroups.com> [mailto:
> > > > php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> <php-objects%40yahoogroups.com><php-objects%
> > 40yahoogroups.com><php-objects%
> > > 40yahoogroups.com>] On
> > > > Behalf Of Atkinson, Robert
> > > > Sent: 09 February 2009 13:46
> > > > To: php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>
> > <php-objects%40yahoogroups.com><php-objects%
> > > 40yahoogroups.com>
> > > > Subject: RE: Schduler Problem(tables are not creating)
> > > >
> > > > Verify the PJS tables exist in the MySQL database (I suspect they
> > don't).
> > > > If
> > > > not then go back through the installation instructions here :-
> > > >
> > > > http://www.phpjobscheduler.co.uk/demo/readme.html
> > > >
> > > > Rob.
> > > >
> > > > -----Original Message-----
> > > > From: php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>
> > <php-objects%40yahoogroups.com><php-objects%
> > > 40yahoogroups.com> [mailto:
> > > > php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> <php-objects%40yahoogroups.com><php-objects%
> > 40yahoogroups.com><php-objects%
> > > 40yahoogroups.com>] On
> > > > Behalf Of malayappa2000
> > > > Sent: 09 February 2009 12:56
> > > > To: php-objects@xxxxxxxxxxxxxxx
<php-objects%40yahoogroups.com><php-objects%
> 40yahoogroups.com>
> > <php-objects%40yahoogroups.com><php-objects%
> > > 40yahoogroups.com>
> > > > Subject: Schduler Problem(tables are not creating)
> > > >
> > > > Hi friends
> > > >
> > > > we downloaded the schduler from fallowing link
> > > > http://www.phpjobscheduler.co.uk/
> > > > we chnged the configaration setting s in
> > > > pjsfiles/configinc.php
> > > > and inclueded the fallowing line
> > > > include( "phpjobscheduler/firepjs.php");
> > > > in cron_email.php whcih sends email on particular time
> > > > when we exectute the cron_email.php
> > > > we are getting the fallowin error
> > > > Warning: mysql_num_rows(): supplied argument is not a valid MySQL
> > > > result resource in
> > > > C:\xampp\htdocs\sample\phpjobscheduler\pjsfiles\phpjobscheduler.php
> on
> > > > line 33
> > > >
> > > > we went throw the code in phpjobscheduler.php line n0 33
> > > >
> > > > here
> > > > phpJobScheduler
> > > > phpJobScheduler_log
> > > >
> > > > tables are not created in database
> > > > after executing the command cron_email.php
> > > >
> > > > that why we are getting the above error
> > > >
> > > > plz tell why tables are not creating
> > > >
> > > > ------------------------------------
> > > >
> > > > Are you looking for a PHP job? Join the PHP Professionals directory
> > Now!
> > > > http://www.phpclasses.org/professionals/Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
*****************************************************************************
> > > > ******
> > > > Any opinions expressed in email are those of the individual and not
> > > > necessarily those of the company. This email and any files
> transmitted
> > > with
> > > > it are confidential and solely for the use of the intended recipient
> > > > or entity to whom they are addressed. It may contain material
> protected
> > > by
> > > > attorney-client privilege. If you are not the intended recipient, or
> a
> > > > person
> > > > responsible for delivering to the intended recipient, be advised that
> > you
> > > > have received this email in error and that any use is strictly
> > > prohibited.
> > > >
> > > > Random House Group + 44 (0) 20 7840 8400
> > > > http://www.randomhouse.co.uk
> > > > http://www.booksattransworld.co.uk
> > > > http://www.kidsatrandomhouse.co.uk
> > > > Generic email address -
> > > enquiries@xxxxxxxxxxxxxxxxx <enquiries%40randomhouse.co.uk><enquiries%
> 40randomhouse.co.uk> <enquiries%
> > 40randomhouse.co.uk><enquiries%
> >
> > > 40randomhouse.co.uk>
> > > >
> > > > Name & Registered Office:
> > > > THE RANDOM HOUSE GROUP LIMITED
> > > > 20 VAUXHALL BRIDGE ROAD
> > > > LONDON
> > > > SW1V 2SA
> > > > Random House Group Ltd is registered in the United Kingdom with
> company
> > > No.
> > > > 00954009, VAT number 102838980
> > > >
> > > >
> > >
> > >
> >
> >
>
>
*****************************************************************************
> > > > ******
> > > >
> > > > ------------------------------------
> > > >
> > > > Are you looking for a PHP job? Join the PHP Professionals directory
> > Now!
> > > > http://www.phpclasses.org/professionals/Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> > > --
> > > Regards
> > > P.M.M.Srinivas
> > > Software Engineer
> > > ID: NGH32053
> > > Ph : +91 9849426596
> > > Home page : www.nannacomputers.com
> > > An ISO 9001:2000 company
> > >
> > > (This e-mail contains information from Nanna Computers, which may be
> > > privileged or confidential. The information is for the intended
> > > individual(s) or entity named above. If you are not the intended
> > recipient
> > > be aware that any copying, disclosing, distribution or use of the above
> > > email and/or its attachments is prohibited and is illegal. If you have
> > > received this electronic message in error, please notify us by
> telephone
> > or
> > > email (to the numbers or address above) immediately. This e-mail is not
> > > un-solicited e-mail under the relevant regulations)
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------------------
> > >
> > > Are you looking for a PHP job? Join the PHP Professionals directory
> Now!
> > > http://www.phpclasses.org/professionals/Yahoo! Groups Links
> > >
> > >
> > >
> >
> > --
> > Regards
> > malayappa
> > Home page : www.nannacomputers.com
> > An ISO 9001:2000 company
> >
> > (This e-mail contains information from Nanna Computers, which may be
> > privileged or confidential. The information is for the intended
> > individual(s) or entity named above. If you are not the intended
> recipient
> > be aware that any copying, disclosing, distribution or use of the above
> > email and/or its attachments is prohibited and is illegal. If you have
> > received this electronic message in error, please notify us by telephone
> or
> > email (to the numbers or address above) immediately. This e-mail is not
> > un-solicited e-mail under the relevant regulations)
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> > Are you looking for a PHP job?
> > Join the PHP Professionals directory Now!
> > http://www.phpclasses.org/jobs/
> > Yahoo! Groups Links
> >
> >
> >
>
> --
>
> (This e-mail contains information from Nanna Computers, which may be
> privileged or confidential. The information is for the intended
> individual(s) or entity named above. If you are not the intended recipient
> be aware that any copying, disclosing, distribution or use of the above
> email and/or its attachments is prohibited and is illegal. If you have
> received this electronic message in error, please notify us by telephone or
> email (to the numbers or address above) immediately. This e-mail is not
> un-solicited e-mail under the relevant regulations)
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Are you looking for a PHP job?
> Join the PHP Professionals directory Now!
> http://www.phpclasses.org/jobs/
> Yahoo! Groups Links
>
>
>
--
Regards
Home page : www.nannacomputers.com
An ISO 9001:2000 company
(This e-mail contains information from Nanna Computers, which may be
privileged or confidential. The information is for the intended
individual(s) or entity named above. If you are not the intended recipient
be aware that any copying, disclosing, distribution or use of the above
email and/or its attachments is prohibited and is illegal. If you have
received this electronic message in error, please notify us by telephone or
email (to the numbers or address above) immediately. This e-mail is not
un-solicited e-mail under the relevant regulations)
[Non-text portions of this message have been removed]
------------------------------------
Are you looking for a PHP job?
Join the PHP Professionals directory Now!
http://www.phpclasses.org/jobs/
Yahoo! Groups Links
