vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Paypal Donations for vBulletin 3.0.7 (https://vborg.vbsupport.ru/showthread.php?t=82978)

Devil Woman 08-21-2005 07:10 AM

Can any one help me fix this please.
Thankyou

Invalid SQL: INSERT INTO donation_paypalipn (
`txn_id`, `userid`, `test_ipn`, `notify_version`, `verify_sign`,
`first_name`, `last_name`, `payer_business_name`, `address_name`,
`address_street`, `address_city`, `address_state`, `address_zip`,
`address_country`, `address_status`, `payer_email`, `payer_id`,
`payer_status`, `business`, `receiver_email`, `receiver_id`,
`item_name`, `ip_address`, `quantity`, `invoice`,
`memo`, `tax`, `option_name1`, `option_selection1`, `option_name2`,
`option_selection2`, `payment_date`, `parent_txn_id`, `txn_type`,
`payment_type`, `payment_status`, `pending_reason`, `reason_code`,
`mc_gross`, `mc_fee`, `mc_currency`, `mc_handling`, `mc_shipping`,
`settle_amount`, `settle_currency`, `exchange_rate`, `case_id`,
`case_type`, `case_creation_date`, `valid`
) VALUES (
'', '0', '0', '0', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '0', '',
'', '0', '', '', '',
'', '', '', '',
'', '', '', '',
'0', '0', '', '0', '0',
'0', '', '0', '',
'', '', '0'
);
mysql error: Duplicate entry '' for key 1

mysql error number: 1062

Date:
Script:
Referer:

mholtum 08-25-2005 07:22 AM

Quote:

Originally Posted by Devil Woman
Can any one help me fix this please.
Thankyou

Invalid SQL: INSERT INTO donation_paypalipn (
`txn_id`, `userid`, `test_ipn`, `notify_version`, `verify_sign`,
`first_name`, `last_name`, `payer_business_name`, `address_name`,
`address_street`, `address_city`, `address_state`, `address_zip`,
`address_country`, `address_status`, `payer_email`, `payer_id`,
`payer_status`, `business`, `receiver_email`, `receiver_id`,
`item_name`, `ip_address`, `quantity`, `invoice`,
`memo`, `tax`, `option_name1`, `option_selection1`, `option_name2`,
`option_selection2`, `payment_date`, `parent_txn_id`, `txn_type`,
`payment_type`, `payment_status`, `pending_reason`, `reason_code`,
`mc_gross`, `mc_fee`, `mc_currency`, `mc_handling`, `mc_shipping`,
`settle_amount`, `settle_currency`, `exchange_rate`, `case_id`,
`case_type`, `case_creation_date`, `valid`
) VALUES (
'', '0', '0', '0', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '0', '',
'', '0', '', '', '',
'', '', '', '',
'', '', '', '',
'0', '0', '', '0', '0',
'0', '', '0', '',
'', '', '0'
);
mysql error: Duplicate entry '' for key 1

mysql error number: 1062

Date:
Script:
Referer:

I have this setup and running with one exception, this exact same error when I go to http://www.yourdomain.com/forum/ppverify.php is there are fix?

xfaethorx 08-25-2005 07:37 AM

Quote:

Originally Posted by paul41598
I dont get this. Ive done the instructions like 3 times. Everytime I donate and get taken back to my page, it says Ive donated 0.00 and I dont get added to the goal, nor the donater top 5 list. Plus it doesnt show nothing but 0's in my admin cp, for valid, invalid transactoins.


Damit..

I'm quoting this as its the EXACT same problem I've been having I've tried uninstalling and re-installing it from scratch over and over. Bottoms line is it doesn't work even if I add it by hand. Has anyone else had this problem? did you fix it? if not how many people have it ? I had this hack working once

CHIngs 08-25-2005 04:27 PM

I make new goals every month.

I have one question. If someone donates, why isint the goal updating itself? Everytime someone donates, I have to manually update the goal.

Now it seems ok because there arent so many donators, but if alot of people start donating, there is no way to keep track of ALL of them.

Is there a solution for this?

mholtum 08-25-2005 04:41 PM

Quote:

Originally Posted by Devil Woman
Can any one help me fix this please.
Thankyou

Invalid SQL: INSERT INTO donation_paypalipn (
`txn_id`, `userid`, `test_ipn`, `notify_version`, `verify_sign`,
`first_name`, `last_name`, `payer_business_name`, `address_name`,
`address_street`, `address_city`, `address_state`, `address_zip`,
`address_country`, `address_status`, `payer_email`, `payer_id`,
`payer_status`, `business`, `receiver_email`, `receiver_id`,
`item_name`, `ip_address`, `quantity`, `invoice`,
`memo`, `tax`, `option_name1`, `option_selection1`, `option_name2`,
`option_selection2`, `payment_date`, `parent_txn_id`, `txn_type`,
`payment_type`, `payment_status`, `pending_reason`, `reason_code`,
`mc_gross`, `mc_fee`, `mc_currency`, `mc_handling`, `mc_shipping`,
`settle_amount`, `settle_currency`, `exchange_rate`, `case_id`,
`case_type`, `case_creation_date`, `valid`
) VALUES (
'', '0', '0', '0', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '0', '',
'', '0', '', '', '',
'', '', '', '',
'', '', '', '',
'0', '0', '', '0', '0',
'0', '', '0', '',
'', '', '0'
);
mysql error: Duplicate entry '' for key 1

mysql error number: 1062

Date:
Script:
Referer:

Bump

LEAD_WEIGHT 08-25-2005 07:18 PM

mysql error number: 1062
I thought it was white space error.
I almost always think that number is white space.

paul41598 08-29-2005 10:14 PM

my module doesnt work. I have it set to show the latest 5 donors, and its only showing 3. Another person just donated, so thats 4 people total, however it only shows 3 on the homepage????

mholtum 08-30-2005 12:46 AM

Bump

alyster4k 08-31-2005 02:23 PM

Thanks for the add-on.

I use vBadvanced CMPS 2.0 and the Donations block is full text size. Can anyone be so kind to point me in the direction where to change a particular template to include the "smallfont" tag? Thank you!

paul41598 08-31-2005 08:37 PM

wish there was a way where if someone donated, it would auto PM the administrator or something! :(


All times are GMT. The time now is 11:08 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03172 seconds
  • Memory Usage 1,747KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete