vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   PayPal Donations For vBulletin 3.5.0 (https://vborg.vbsupport.ru/showthread.php?t=91567)

pbmansion 10-12-2006 06:28 PM

Database error in vBulletin 3.6.1:

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
Date : Monday, October 9th 2006 @ 05:07:49 PM
Script : http://www.*********.com/forums/admi...php?do=install
Referrer : http://www.*********.com/forums/admi...php?do=install
IP Address : ***********
Username : *******
Classname : *********'



Does anyone know why this is happening. Please pm me!

pbmansion 10-12-2006 06:32 PM

after I installed it I got the error and under my admin panel I have most of the options that the mod offers but nothing in the products category for the mod. Any thoughts?

Sanctu 10-14-2006 07:05 PM

Hi there. I'm running VB 3.5.4 and I have the mod running correctly thanks to the abundance of information in this thread. There is one thing that I'm having difficulty with, though. This is an issue with the VBAdvanced addon block, not the core mod for VB.

I can't seem to figure out how to get the "List of Recent/Top Donors" section to display names of people who I manually add. Is there a way to do this?

Example: I cannot donate to myself, but I would like my community to know that I am participating as well. So I manually add in my own donation. I update the goal and the progress bar updates accordingly. However, my name does not show up in the list below where it says "Our Last Donators".

This is only a problem with the VBA block, as my name displays fine within the actual mod itself when you click "View All Donors"

Any help on this would be greatly appreciated. Thank you again :)

TheHeartSmasher 10-17-2006 04:50 AM

Quote:

Originally Posted by Andreas
As this was apparently released under GPL, I've repackaged it as a Product for those interested.

To install it this way, upload the Files from the Attached ZIP, import the Product XML and make the Template Edits.
I left the original HTML File for reference, so don't wonder that it mentions Files that do not exist, File Edits (no File Edits are required), etc.

Thank you :D

zendiver 10-17-2006 05:57 PM

Quote:

Originally Posted by GearTripper
i'm not sure of any problem involving users avatars. i don't see how they would be related.

SOme of the avatars show up....and some of them show the 'No Avatar' pic. Everyone that has donated has an avatar in the forums, but only 2 show their avatars in the donations.

zendiver 10-17-2006 08:38 PM

I think I have located the issue but have no clue how to fix it. It has to do with the vB code on how it brings in custom avatars.

In the alldonors.php file, part of the code says the following:

Code:

        $avatar_row = $vbulletin->db->query_first("SELECT user.showdonor, user.username, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar, customavatar.dateline AS avatardateline
                                                                                                                                                        FROM ".TABLE_PREFIX."user AS user
                                                                                                                                                        LEFT JOIN ".TABLE_PREFIX."avatar AS avatar ON(avatar.avatarid = user.avatarid)
                                                                                                                                                        LEFT JOIN ".TABLE_PREFIX."customavatar AS customavatar ON(customavatar.userid = user.userid)
                                                                                                                                                        WHERE user.userid = '".$row['userid']."'");

What is bolded calls reference to the table 'customavatar' and the field 'filedata'

This particular field uses the type of MEDIUMBLOB with attributes - binary and NULL set to YES as default (don't know why but maybe someone with more experience can explain this one).
All of the avatars that are actually displayed on the ALL DONORS page, have a filedata field setting of '[BLOB - (file size of image) KB]'. All the ones that are NOT displayed, the filedata field has this setting: [BLOB - NULL].

Any thoughts to those that are more 'code savy' than I am?

Thanks for your time.

Hornstar 10-18-2006 07:03 AM

Under We are PayPal Verified! I am wanting the same kind of box as the top donors instead I want this one to be Latest donors, and have the same functionality as to set how many etc.

How Would I do this.

Or would someone be able to do this, im sure others would love it as well.

Thanks.

sinisterpain 10-22-2006 05:19 PM

Ok guys for those of you that have been having issues with installing this mod on 3.6.2 vba 2.2.1:

I so far have got it working from a clean install, also using the vBA module on my home page. The supplied installer creates a phrasetypeid SQL error when you use the supplied installer. I used a XML file I had downloaded not sure who wrote it, and I take no credit for it. I think it was from the original hack not sure. In the zip file there is no name so I do not know who created it, but it installs perfectly at least for me it did.
Proceedure I followed is as follows:
1. Upload the files to your webserver as described by the orig installation instructions.
2. Go to your Plugin&Products in Admin cp =>Manage products=>Add/Import Product. Install the attached XML file. This will add the phrases,templates ect... "Do not use the supplied installer, donationtions_install.php". The XML file will install everything required.
3. If all went ok you should have the paypal donations added to your Admin cp. Just continue with original instructions

Ok missed the thread above the origination of the file is from Andreas https://vborg.vbsupport.ru/showthrea...t=91567&page=8
Sorry guys I uploaded my edited XML with phrase changes I made the attached file is now the original sorry for that.

pbmansion 10-23-2006 08:50 PM

I installed the normal way and I got the error I posted above. I then took the .xml file you attached to your post and I uploaded that to my server. It said everything went well and good. I don't know if everything went well though because after enabling everything in the donor settings the donor link doesn't show up in the navbar. I also don't know if my install files of my old install (the one that gave me the error) were deleted. I know that the old intaller deleted some install files and those still might be on my server. I need help with all this stuff guys. Please help!

pbmansion 10-23-2006 08:51 PM

could I have unloaded the files onto my server wrong? I need someone to help me out.

aim: perrier at pbm
email: jestersgreatest@gmail.com


All times are GMT. The time now is 10:52 AM.

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.01924 seconds
  • Memory Usage 1,757KB
  • 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
  • (1)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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