Nuke Treasury 1.1 install help!

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

OK I upgraded from 1.0 today and when I was on 1.0 this was my IPN result:

Code:

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...OK!
Executing test query...PASSED!
PayPal Receiver Email:

Only registered users can see links on this board!
Get registered or login to the forums!

events

----------------------------------------------------------------
If you don't see any error messages, you should be good to go!

The problem with it was: people can donate and I will recieve the money no problem but the donation will not register in the database and in turn will not show up in the block.

After installing v1.1 this was the result of the IPN test:

Code:

Warning: main(../config.php): failed to open stream: No such file or directory in /home/content/m/a/l/xxxxxxxxxxxxx/html/modules/Donations/ipn/ipnppd.php on line 25

Warning: main(../config.php): failed to open stream: No such file or directory in /home/content/m/a/l/xxxxxxxxxxxxxxxx/html/modules/Donations/ipn/ipnppd.php on line 25

Warning: main(): Failed opening '../config.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/m/a/l/xxxxxxxxxxxxxx2/html/modules/Donations/ipn/ipnppd.php on line 25
Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------

Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/m/a/l/xxxxxxxxxxxxx/html/modules/Donations/ipn/ipnppd.php on line 45
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Any ideas what is going on? Thanks in advance!

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

hello,

please use the search function that the furum provides...
first result i get is :

Only registered users can see links on this board!
Get registered or login to the forums!

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

Thanks! Ok I got it all back up and got the same results as last time:

Code:

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...OK!
Executing test query...PASSED!
PayPal Receiver Email:

Only registered users can see links on this board!
Get registered or login to the forums!

events

----------------------------------------------------------------
If you don't see any error messages, you should be good to go

GOt a test donation, recieved it in paypal but did not show up in the block

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

Any ideas? Sorry, I'm just really frustrated with it! It seems to refuse to wanna work!

webservant · Posted: Thu Jan 04, 2007 6:07 am

I would check the following in this order:

1) Does the Check IPN work in your Admin page?

2) Recheck the IPN setup in your Paypal account. When the account receives the donation, Paypal.com posts back to you at the URL that you define to it. It has to be the correct URL, and Paypal.com needs to be able to get to that "page" on your site.

3) In the database, there two tables are updated by the posting from Paypal. Ultimately the data lands in the "transaction" table, but I suspect that this will be empty otherwise you would see the information show up in both the block and the module. However, interim information is posted to the "translog" table. In my version of phpMyAdmin, I only see the beginning of the "logentry" column in the window and need to edit the record or export the data to see the full log entry. Are you getting any data in the "translog" table. If not, then I suspect the page is never being called. If so, there should be enough data to understand where the transaction is dying in the ipnpdp.php script.

Hope this helps... Smile

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

webservant wrote:

I would check the following in this order:

1) Does the Check IPN work in your Admin page?

2) Recheck the IPN setup in your Paypal account. When the account receives the donation, Paypal.com posts back to you at the URL that you define to it. It has to be the correct URL, and Paypal.com needs to be able to get to that "page" on your site.

3) In the database, there two tables are updated by the posting from Paypal. Ultimately the data lands in the "transaction" table, but I suspect that this will be empty otherwise you would see the information show up in both the block and the module. However, interim information is posted to the "translog" table. In my version of phpMyAdmin, I only see the beginning of the "logentry" column in the window and need to edit the record or export the data to see the full log entry. Are you getting any data in the "translog" table. If not, then I suspect the page is never being called. If so, there should be enough data to understand where the transaction is dying in the ipnpdp.php script.

Hope this helps... Smile

Thanks for the reply, I checked the translog table and found 6 entries:

Code:

Debug mode activated
Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
Logging events<br>

It might sound stupid but could it be becasue there is a missing space in the IPN test::

Only registered users can see links on this board!
Get registered or login to the forums!

mLogging events"? Ort maybe it's the permission settings on the folder? the 'Donations' folder was set to '755' should it be something else?

The IPN link running to my paypal is:

Only registered users can see links on this board!
Get registered or login to the forums!

like it says in the instructions so I'm not sure if there is any problem.

Gremmie · Posted: Thu Jan 04, 2007 12:29 pm

I think there is a config entry that sets the verbosity of the logging. Make sure that is turned all the way up. I remember that I actually modified the code to log more when I was having problems. I would get a donation but it would never hit the database. Of course, I haven't had the problem since I increased the logging. Go figure...

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

Gremmie wrote:

I think there is a config entry that sets the verbosity of the logging. Make sure that is turned all the way up. I remember that I actually modified the code to log more when I was having problems. I would get a donation but it would never hit the database. Of course, I haven't had the problem since I increased the logging. Go figure...

Thanks for the info, it is already set at 'Log everything' so that's not it. Crying or Very sad

webservant · Posted: Thu Jan 04, 2007 5:19 pm

OK. Something seems to be amiss with what's coming from Paypal. Here is a cleansed version of a valid testing transaction in the translog table on my site.

Quote:

Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
PayPal Verified
Normal transaction
INSERT INTO transactions (`txn_id`,`business`,`item_name`, `item_number`, `quantity`, `invoice`, `custom`, `memo`, `tax`, `option_name1`, `option_selection1`, `option_name2`, `option_selection2`, `payment_status`, `payment_date`, `txn_type`, `mc_gross`, `mc_fee`, `mc_currency`, `settle_amount`, `exchange_rate`, `first_name`, `last_name`, `address_street`, `address_city`, `address_state`, `address_zip`, `address_country`, `address_status`, `payer_email`, `payer_status`) VALUES ('4MS892024F4297645', 'xxxxxxxx@xxxxxxxx.xxx', 'Donation', '110', '1', '', 'doug', '', '0.00', 'List your name?', 'Yes', '', '', 'Completed', '2006-12-01 16:43:15', 'web_accept', '5.00', '0.45', 'USD', '', '', 'Douglas', 'Peloquin', '', '', '', '', '', '', 'xxxxxxxx@xxxxxxxx.xxx', 'verified')
SQL result = 1
Logging events<br>

As you can see, I have lots more data, and don't even have the "PayPal Verified" statements which means that you not getting through here correctly:

Code:

while (!$dbg && !$ERR && !feof($fp))
{
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0)
{
dprt("PayPal Verified", _INF);
// Ok, PayPal has told us we have a valid IPN here

Have you checked the information in Treasury that pertains to Paypal?

PayPal Receiver Email - the paypal account to which the donation is sent.
URL for cancelled donation - I have this as the donations module itself.
IPN link for PayPal - is the full url to the ipnppd.php file.
and clicking the "Click here to test IPN" gives OK results.

In Paypal, I navigate to the IPN configuration...
Home page --> Profile --> Instant Payment Notification Preferences (under Selling Preferences)

Instant Payment Notification (IPN) is On
Instant Payment Notification (IPN) URL: looks like exactly like the IPN link for PayPal.

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

webservant wrote:

OK. Something seems to be amiss with what's coming from Paypal. Here is a cleansed version of a valid testing transaction in the translog table on my site.

Quote:

Connection to db - OK!
Opening connection and validating request with PayPal...
OK!
PayPal Verified
Normal transaction
INSERT INTO transactions (`txn_id`,`business`,`item_name`, `item_number`, `quantity`, `invoice`, `custom`, `memo`, `tax`, `option_name1`, `option_selection1`, `option_name2`, `option_selection2`, `payment_status`, `payment_date`, `txn_type`, `mc_gross`, `mc_fee`, `mc_currency`, `settle_amount`, `exchange_rate`, `first_name`, `last_name`, `address_street`, `address_city`, `address_state`, `address_zip`, `address_country`, `address_status`, `payer_email`, `payer_status`) VALUES ('4MS892024F4297645', 'xxxxxxxx@xxxxxxxx.xxx', 'Donation', '110', '1', '', 'doug', '', '0.00', 'List your name?', 'Yes', '', '', 'Completed', '2006-12-01 16:43:15', 'web_accept', '5.00', '0.45', 'USD', '', '', 'Douglas', 'Peloquin', '', '', '', '', '', '', 'xxxxxxxx@xxxxxxxx.xxx', 'verified')
SQL result = 1
Logging events<br>

As you can see, I have lots more data, and don't even have the "PayPal Verified" statements which means that you not getting through here correctly:

Code:

while (!$dbg && !$ERR && !feof($fp))
{
$res = fgets ($fp, 1024);
if (strcmp ($res, "VERIFIED") == 0)
{
dprt("PayPal Verified", _INF);
// Ok, PayPal has told us we have a valid IPN here

Have you checked the information in Treasury that pertains to Paypal?

PayPal Receiver Email - the paypal account to which the donation is sent.
URL for cancelled donation - I have this as the donations module itself.
IPN link for PayPal - is the full url to the ipnppd.php file.
and clicking the "Click here to test IPN" gives OK results.

In Paypal, I navigate to the IPN configuration...
Home page --> Profile --> Instant Payment Notification Preferences (under Selling Preferences)

Instant Payment Notification (IPN) is On
Instant Payment Notification (IPN) URL: looks like exactly like the IPN link for PayPal.

I've done all that, still no luck. Could it maybe be something my hosting company is blocking? I use godaddy.com? Not sure what you did different but your IPN test is alot more full then mine, lol. hmmm.

*EDIT*

Foudn this on another site while searching for IPN problems with godaddy:

Quote:

Sorry to ask, but I have recently got a GoDaddy.com Virtual Private Server with PLESK installed. My IPN scripts no longer work. I checked them with a few other hosts (yahoo) and they work there. I tried to make the suggested change with fsocketopen to include the host in the head and tried the cURL modifications (on two different script - but of which are to bypass their proxy). Neither modification seemed to work.

Any ideas were to find a script that is suppose to work with GoDaddy? I've already spent hours debugging and googling. Support just says its out of their area. Is it maybe time to cancel them and go with LunarPages?

Thanks for any input.

And I do infact have Private Registration!

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

Turns out the problem is that Godaddy does NOT allow all that nice stuff, is it possible to transfer the site over and not loose anything (forum post and databases) and if so, what hosting company would you reccomend?

webservant · Posted: Thu Jan 04, 2007 6:50 pm

For PHP-Nuke? Well, I'm at IPowerWeb.com, and I would NOT recommend them for a PHP-Nuke site - too many oddities like on 50000 sql transactions per user per day (AH!).

BTW: I've heard that this site is THE BEST -

Only registered users can see links on this board!
Get registered or login to the forums!

stevenson · New Member Joined: Dec 10, 2006 Posts: 10

Thanks, jsut wondering but do you know of any Donations block that don't require them to go through IPN, I just wanna have a block that will show a goal and I can enter who has donated.

dommike · New Member Joined: Jan 15, 2007 Posts: 3

I get this error when dumping this in mysql help?

SQL query:

# phpMyAdmin SQL Dump
# version 2.5.4
#

Only registered users can see links on this board!
Get registered or login to the forums!

#
# Host: localhost
# Generation Time: Jan 20, 2004 at 09:26 AM
# Server version: 4.0.15
# PHP Version: 4.3.3
#
# Database : `ipnppd`
#
# --------------------------------------------------------
#
# Table structure for table `config`
#
CREATE TABLE `config` (
`name` varchar( 25 ) NOT NULL default '',
`subtype` varchar( 20 ) NOT NULL default '',
`value` varchar( 200 ) NOT NULL default '0',
`text` text NOT NULL
) TYPE = MYISAM

MySQL said: Documentation