Hi I'm getting this error when I try create a new button any idea what could be causing it?
Thaks
Rebel

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO paypal_donatebuttons (id,
business,
item_name,
item_number,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
custom,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, '', 'Site Donations', '', '', '', 'http://www.mysite.com/forum1/paypal.php?action=success', '1', 'http://www.mysite.com/forum1/paypal.php?action=cancel', '', 'Comments', '1', 'mysite', 'Aus1', 'N/A', 'USD', '$200', 'http://www.mysite.com/donate.gif')
mysql error: Unknown column 'item_number' in 'field list'

mysql error number: 1054

Date: Sunday 22nd of June 2003 07:34:50 AM
Script: http://www.mysite.com/forum1/forum1/...ypal_admin.php
Referer: http://www.mysite.com/forum1/admin/p...n=make_button&

You haven't installed the queries correctly as the item_number column does not exist :) ^^

Try

- miSt

nice update on this Cloudrunner

Actually, the item_number column was removed for the guest posters portion of the hack...unfortunately, this is my fault, I forgot to remove that in the paypal_admin.php.

I will fix it and get the fixed archive up again.

bug found ;)

mist, okay, I'm not quite understanding again...you want the donation button to be displayed for xxx amount of (days, weeks, months, years, etc). and then upon expiration anyone who donated using that button get their awards and such removed right? What about the topten listing? do we want them removed from there as well?

I fix my post upstairs too...sorry, I thought it was funny :P

Okay to fix the donate_buttons query before I get the new archive up here:

edit: This bug has been fixed and is in the archive for 0.9.5 and later.

Found another bug, sorry!

edit: This bug has been fixed and is in the archive for 0.9.5 and later.

definatly clicked on install on this one man.. looks GREAT..

question though, i had a friend of mine who wasn't registered on my board post a $1 donation at a test - everything is in the db correctly, however he isn't showing up on the contributor list.. nothing listed on there, not even guest. design or flaw?

until the donation is marked as "Complete" from paypal's IPN then nothing will show up on the contributors list. If after the payment_status column shows up as "Complete" for that transaction, the information still does not show on the contributors list then let me know cus then it would be a bug...Thanks

There appears to be a big discrepancy in the code for this when editing/adding buttons now. 0.9.2 worked fine, but it seems to be trying to find several columns which no longer exist...

Database error in vBulletin Control Panel 2.3.0:


Invalid SQL: INSERT INTO paypal_donatebuttons (id,
business,
item_name,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
custom,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, 'donations@expectedmiracles.com', 'emdonation', 'http://www.expectedmiracles.com/images/expect.1.jpg', '', 'http://www.expectedmiracles.com/forums/paypal.php?action=success', '1', 'http://www.expectedmiracles.com/forums/paypal.php?action=cancel', '', 'Comments:', '0', '', '', '', '', '', 'http://www.expectedmiracles.com/forums/images/donate.gif')
mysql error: Unknown column 'custom' in 'field list'


mysql error number: 1054


Date: Monday 23rd of June 2003 10:24:12 PM
Script: http://www.expectedmiracles.com/foru...ypal_admin.php
Referer: http://www.expectedmiracles.com/foru...make_button&s=

-and-

Database error in vBulletin Control Panel 2.3.0:


Invalid SQL: INSERT INTO paypal_donatebuttons (id,
business,
item_name,
item_number,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
custom,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, 'donations@expectedmiracles.com', 'emdonation', '', 'http://www.expectedmiracles.com/images/expect.1.jpg', '', 'http://www.expectedmiracles.com/forums/paypal.php?action=success', '1', 'http://www.expectedmiracles.com/forums/paypal.php?action=cancel', '', 'Comments:', '0', '', '', '', '', '', 'http://www.expectedmiracles.com/forums/images/donate.gif')
mysql error: Unknown column 'item_number' in 'field list'


mysql error number: 1054


Date: Monday 23rd of June 2003 10:20:54 PM
Script: http://www.expectedmiracles.com/foru...ypal_admin.php
Referer: http://www.expectedmiracles.com/forums/admin/paypal

I got it working but I had to remove those two lines of code from the paypal_admin file. Not sure what happened there or if you were aware of it just yet.

It's showing up as completed in the DB.

Crazy Pete--

Both database errors were addressed already ;)

https://vborg.vbsupport.ru/showthrea...663#post411663

And a bug found as well after that one was addressed:

https://vborg.vbsupport.ru/showthrea...680#post411680

Shorty--Please contact me via on of the IM's listed in my profile. I need to take a look at your setup, I may have missed something, but my end is working fine.