Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

IPN Test problem


jab1972

Recommended Posts

when I try to use the IPN transactions feature in admin I get this error message:

The requested URL /catalog/admin/FILENAME_PAYPALIPN_TRANSACTIONS was not found on this server

 

This also happens with the test ipn option where I get this error message:

The requested URL /catalog/admin/FILENAME_PAYPALIPN_TESTS was not found on this server

 

I have used the most up to date version of ipn and i used the recommended overwrite files but i am still getting this error.

 

Can anyone help?

 

Thanks[/b]

Link to comment
Share on other sites

Hi,

 

In admin/includes/application_top.php you need to add the following lines;

 

  define('FILENAME_PAYPALIPN_TRANSACTIONS', 'paypalipn_txn.php'); // PAYPALIPN

 define('FILENAME_PAYPALIPN_TESTS', 'paypalipn_tests.php'); // PAYPALIPN

 

This should fix those errors!

Reddy to Rumble

 

Thank you osCommerce and all who Contribute to her!

Link to comment
Share on other sites

Thanks,

 

I tried that but now I get these error's:

 

Parse error: parse error in /home/.sites/76/site98/web/catalog/admin/includes/application_top.php on line 66

 

Fatal error: Call to undefined function: tep_href_link() in /home/.sites/76/site98/web/catalog/admin/index.php on line 17

 

 

I'm slowly going mad. Any more help much appreciated!

Link to comment
Share on other sites

Paste lines 60 through to 70 or admin/includes/application_top.php here.

 

Also paste line 17 from admin/index.php here.

Reddy to Rumble

 

Thank you osCommerce and all who Contribute to her!

Link to comment
Share on other sites

lines 60 -70:

 

define('FILENAME_LANGUAGES', 'languages.php');

define('FILENAME_MAIL', 'mail.php');

define('FILENAME_MANUFACTURERS', 'manufacturers.php');

define('FILENAME_MODULES', 'modules.php');

define('FILENAME_NEWSLETTERS', 'newsletters.php');

define('FILENAME_ORDERS', 'orders.php');

define('FILENAME_ORDERS_INVOICE', 'invoice.php');

define('FILENAME_ORDERS_PACKINGSLIP', 'packingslip.php');

define('FILENAME_ORDERS_STATUS', 'orders_status.php');

define('FILENAME_PAYPALIPN_TRANSACTIONS', 'paypalipn_txn.php'); // PAYPALIPN

? define('FILENAME_PAYPALIPN_TESTS', 'paypalipn_tests.php'); // PAYPALIPN

 

 

 

Line 17:

 

'href' => tep_href_link(FILENAME_CONFIGURATION, 'selected_box=configuration&gID=1'),

 

Thanks again

Link to comment
Share on other sites

Slight correction...

 

It actually says these errors...

 

Parse error: parse error in /home/.sites/76/site98/web/catalog/admin/includes/application_top.php on line 70

 

Fatal error: Call to undefined function: tep_href_link() in /home/.sites/76/site98/web/catalog/admin/index.php on line 17

Link to comment
Share on other sites

thanks for your help,

 

I got it working eventually - however, I now can't get the transactions page in admin to work. I get this error:

 

1146 - Table 'bkpnqiy0soeb.TABLE_PAYPALIPN_TXN' doesn't exist

 

select count(*) as total from TABLE_PAYPALIPN_TXN

 

[TEP STOP]

 

 

Even though there is a TABLE_PAYPALIPN_TXN in my database.

Bugger!

Link to comment
Share on other sites

i got it to work but when i hit send to test i get this error

 

TEST IPN Processed for order #1245351146 - Table 'majesticstore.table_paypalipn_txn' doesn't exist

 

select txn_id from TABLE_PAYPALIPN_TXN where txn_id='1058483195'

 

[TEP STOP]

Link to comment
Share on other sites

Hi Adrian

 

Have you declared the following line in admin/includes/application_top.php?

 

define('TABLE_PAYPALIPN_TXN', 'paypalipn_txn'); // PAYPALIPN

Reddy to Rumble

 

Thank you osCommerce and all who Contribute to her!

Link to comment
Share on other sites

this is where i hav it declared at in application top under admin /includes

 

 

  define('TABLE_ZONES', 'zones');

 define('TABLE_PAYPALIPN_TXN', 'paypalipn_txn'); // PAYPALIPN

Link to comment
Share on other sites

  • 3 months later...

Hello,

 

I tried your solution, putting the two lines :

 

------

define('TABLE_ZONES', 'zones');

 

define('TABLE_PAYPALIPN_TXN', 'paypalipn_txn'); // PAYPALIPN

------

 

in the admin/includes application_top.php

 

But I do still have this error message appearing each time someone is buying a product (it appears when checkout_success.php is called) :

 

---

1146 - Table 'mybebsite.com.paypalipn_txn' doesn't exist

 

select o.orders_status,p.* from orders o LEFT JOIN paypalipn_txn p on p.item_number = o.orders_id AND o.customers_id = '2' order by o.date_purchased desc limit 1

 

[TEP STOP]

----

 

I checked and the 'paypalipn_txn' doesn't exist in my mySQL directory.

 

I really don't know how to manage with this.

 

If someone's got an idea, I would be pleased to try is solution ! :)

 

Mikemas

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...