I am having the same problems. I know I talked to sinisterpain about this on MSN and he didnt know what it was exactly either.

I have done everything to try and fix the problem but it just doesnt want to work anymore. The funny thing is on my developer forum it works but on our live forum it doesn't

BTW just wondering what is the addy like for your forums

mine is just www.xxx.com/ppverify.php
while my test forum is www.xxx.com/test/ppverify.php

could it be that we cant use our root directory?

I use the forum root www.yourdomain.com/forum/ppverify.php
If paypal does not find the confirmation script or is not allowed access it will not write the member information to the database, but you will see the payment going through your paypal account since the first step in the process for members is going to your paypal account to complete the transaction.
I have had the hack running on my site for a year with only one problem which was due to my playing with the confirmation scripts to try adding subscriptions.
I know the Paypal hack works less a few functions that require fixing, and everyone has different server configurations as well as hacks. In your case it does not make any sense to me why it would work on your test server and not on your live server since they both share the same database. This can only lead me to believe that some configuration is different between the two and it could be the link to the ppverify file and how it is called in the donation settup or on the paypal site.

Database error in vBulletin 3.6.5:

Invalid SQL:
INSERT INTO phrase (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES ('', '-1', 'settinggroup_donations', 'PayPal Donations', '5000');

MySQL Error : Unknown column 'phrasetypeid' in 'field list'
Error Number : 1054

someone help me please

You can not use the authors install files there is an post for a donations.zip in the threads. It has the xml file to do the import of the hack.

Ok after loads of time I have figured it out. I must pay my respects to sinister for his help. These are my findings so listen up. first you must use the .xml and NOT the install script to upload this hack on your system. second when creating sandbox accounts make sure you create two. One to donate with and one for accepting the donations. Which ever sandbox account you use to accept payments with MUST be preimer or business account and MUST be verified and confirmed. Also your server files must be set up correctly. If you use CMPS as your homepage put the index.php for it in your public_html directory. Then you must have a forum directory in your public_html directory for your vbulletin board files. If your like me you will have to put any styles you have in both diectories. Your ppverify.php MUST be in your forum root, in the forum directory along with your donate.php. Then ensure all settings are correct in the admin cp for the donations. Especially your URL's. Remember to add your forum directory to your URL's.
Ok now that we covered that lets mention the module. I continually got a white page when my module was active. If this happens to you try turrning off GZIP HTML Output. Go to admin cp-->vboptions-->Cookies and HTTP Header Options-->GZIP HTML Output. If this fixes the problem your service provider likely allready runs this for you.
Thanks to Sinisterpain for his help in troubleshooting this addon. Its a great addon. Our members wher asking for donor recognition and this is a great start.

Has anyone figured out why the donor table is no longer being updated? Someone mentioned that Paypal made a change to their verification script, is anyone else having this problem? I have been manually putting in my donations for some time.

Thanks!

What type of paypal account do you have? What version of vb are you running? Have you tryed creating a sandbox account to test your donations. Is your ppverify file in the correct location and cmodded 755? Is your paypal IPN on and pointing to the correct directory?

Your extremely welcome

I have a Paypal Premier account, VB 3.6.4.

Everything was working with the 2.x donation release for the last YEAR, and all of the sudden the donations are not being credited properly (i.e. I get a donation, but it is not being recorded in the donor table).

Someone mentioned several pages back that Paypal had changed their format for notices, and that it broke the VB side of the exchange.

Any help would be appreciated.

I believe if you set up a business account in sandbox and test it will work. I believe you need a business account to use the IPN function.