paypal ipn error message

[vikkic]

I'm very new to PHP and MySql but I got the cart installed and running today.

I'm using credit cards processed offline, credit card/money order, and installed Paypal ipn, (PayPal IPN v0.96).

I uploaded the files, wrote the database files and inserted the text as it said in the install file.

It comes up as a choice in the Shipping modules and I have it activated.

 

When I check out and ask for the PayPal ipn payment method, I get the error message

 

The requested URL /catalog/FILENAME_CHECKOUT_PAYPALIPN was not found on this server.

 

I'm sure it's something simple but the answer is eluding me. Could someone help me?

 

Vikki

[zzfritz]

Looks like you need to add this line to catalog/includes/application_top.php:

 

define('FILENAME_CHECKOUT_PAYPALIPN', 'checkout_paypalipn.php');

[vikkic]

Thank you! That DID move me closer!

Now of course I have a table error

 

1054 - Unknown column 'email_address' in 'field list'

 

insert into paypalipn_temp_data (orders_id, email_to, email_address, email_subject, email_text) values ('5', 'Victoria Clayton', '[email protected]', 'Order Process', 'SilkStitches.com

 

But that is just myphpadmin and me, cause I've never written a table or used that program before.

 

Thank you for your help - I appreciate it.

[zzfritz]

That's a bit odd, as it appears to have recognized the new table but not one of the fields that presumable you created with this part of what was in paypalipn.sql in the contribution:

CREATE TABLE paypalipn_temp_data (

 orders_id int(11) NOT NULL default '0',

 email_to varchar(255) NOT NULL default '',

 email_address varchar(96) NOT NULL default '',

 email_subject varchar(255) NOT NULL default '',

 email_text text NOT NULL,

 KEY orders_id (orders_id)

);

 

You might try deleting the table in phpMyAdmin, and running that create again. Getting familiar with phpMyAdmin is wise anyway, for your long term maintenance of the system.

[vikkic]

I did indeed end up doing this - I wish I'd done it before, but at least deleting these paypal ipn files and recreating them did fix the database back up problem I was having.

 

Vikki