PayPal Error with IPN Test?

New Member Joined: Aug 20, 2005 Posts: 10

Everything setting up, but get this error all the time:

Warning: main(config.php): failed to open stream: No such file or directory in E:\W3Sites\domain\www\modules\Donations\ipn\ipnppd.php on line 25

Warning: main(): Failed opening 'config.php' for inclusion (include_path='.;c:\php4\pear') in E:\W3Sites\domain\www\modules\Donations\ipn\ipnppd.php on line 25
Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------
Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Selecting database...FAILED - err:
Executing test query...No Database Selected

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

The Nuke Treasury module has its own config.php file that must be stored in the /modules/donations directory. It seems it can't one there.

Posted: Sat Aug 20, 2005 9:16 am

I have to config file there Sad

changed the info also, but then this error Sad

Posted: Sat Aug 20, 2005 9:23 am

I could also be a problem running on Windows. It isn't specifying a path on the include, and the directory is clearly not IN the path listed in the error message. Maybe if you change the include statement in E:\W3Sites\domain\www\modules\Donations\ipn\ipnppd.php from

Code:

include("config.php");

to

Code:

include("E:\W3Sites\domain\www\modules\Donations\config.php");

Posted: Sat Aug 20, 2005 9:37 am

Hmmm...it must be a Windows thing. I checked my old copy of the Treasury module, and the line in ipnppd.php is actually:

Code:

include("../config.php");

Normally, that tells PHP to look in the directory above the current directory (which should be modules/Donations. But I haven't tested this under Windows, so I assume it must not be working the same there.

Try the suggestion I gave above, even though it's generally not a good idea to hard code stuff like that, at least we can see if it works, then we know what the problem is.

Posted: Sat Aug 20, 2005 9:38 am

Got it so far now Smile

You fixed the first errors Smile

Now its just last errors...

Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------
Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Selecting database...FAILED - err:
Executing test query...No Database Selected

Posted: Sat Aug 20, 2005 9:40 am

that's in your modules/Donations/config.php. You can configure Treasury to use a different database (or the same database), so there are connection parameters in that additional config.php file. Something isn't right with the DB name, user or password OR the database isn't created.

Posted: Sat Aug 20, 2005 9:45 am

Database is created Sad

username & database is correct Sad

Posted: Sat Aug 20, 2005 9:55 am

Right. It can connect to the database, but it can't find the table. Is the table named with the same prefix as the other Nuke tables?

Posted: Sat Aug 20, 2005 10:00 am

Nope

They got no prefix.
Here is what they look like in MySQL:

config
financial
transactions
translog

Posted: Sat Aug 20, 2005 10:05 am

Did you create these tables in a different database from Nuke? If so, is the Treasury database specified in the modules/Donations/config.php or the Nuke database?

If not (or the database is specified correctly in config.php), search ipnppd.php for

Code:

   echo "Selecting database...";

In the SQL line right before that, is that table correctly defined in your database?

Posted: Sat Aug 20, 2005 10:09 am

Here is what that section got:

if( $dbg )
{
$sql = "SELECT * FROM transactions LIMIT 10";
echo "Selecting database...";
$res = mysql_select_db($database_ipnppd, $ipnppd);
if($res)
echo "OK! ";
else
echo "FAILED - err: $res ";
echo "Executing test query...";
$Result1 = mysql_query($sql, $ipnppd) or die(mysql_error());
if($Result1)
echo "PASSED! ";
else
echo "FAILED ";
echo "PayPal Receiver Email: $tr_config[receiver_email]" ;
}

Posted: Sat Aug 20, 2005 10:11 am

Something must been working right.

The block shows on the frontpage, but if i change database name to test, I got errors, so the connection must be ok so far as I can see Sad

Posted: Sat Aug 20, 2005 10:18 am

Is the value $database_ipnppd defined correctly in the modules/Donations/config.php file? Does it match the exact name of the database in MySQL?

Posted: Sat Aug 20, 2005 10:22 am

I found the bug/error Razz

You need to go into your ipnppd.php file and change the config.php file to config.inc.php
Its on line 25

taken from: http://www.codezwiz.com/ftopicp-32499.html

Thanks M8 anyway Smile

Posted: Sat Aug 20, 2005 10:28 am

Actually, you're supposed to rename config.inc.php to config.php...but either will do.

Posted: Sat Aug 20, 2005 11:25 am

But I got another problem now Sad

*lol*

I just installed it locally on my own machine.

php-nuke and anything works perfectly, but the playpal thing deny me in the database!

Access denied for user: 'ODBC@localhost' (Using password: NO)

Help Smile

New Member Joined: Aug 26, 2006 Posts: 5

inoculateit wrote:

But I got another problem now Sad

*lol*

I just installed it locally on my own machine.

php-nuke and anything works perfectly, but the playpal thing deny me in the database!

Access denied for user: 'ODBC@localhost' (Using password: NO)

Help Smile

Thats usually when you do not specify the password and username for the database - What I had to do was copy config.inc.php to config.php and keep both....

$hostname_ipnppd = "localhost";
$database_ipnppd = "nuke";
$username_ipnppd = "youraccount";
$password_ipnppd = "Yourpassword";

Regards