vb.org Archive - Profile Enhancements - Invitation System v2.0.2 for vB3.6 and 3.5 series

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Profile Enhancements - Invitation System v2.0.2 for vB3.6 and 3.5 series (https://vborg.vbsupport.ru/showthread.php?t=172157)

I just installed on 3.6.8. gives me this error:

Code:

Database error in vBulletin 3.6.8:



Invalid SQL:

SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id

                                                                                 FROM vb_user

                                                                                 LEFT JOIN vb_invitation

                                                                                 ON user.userid = invitation.acceptedby OR user.userid = invitation.email

                                                                                WHERE user.email = 'someone@gmail.com'

                                                                                OR invitation.email = 'someone@gmail.com';



MySQL Error  : Unknown column 'user.userid' in 'field list'

Error Number : 1054

That makes sense, 'user.userid' is an unknown column becuase the query isn't 'from vb_user as user left join vb_invitation as invitation'

Quote:

Originally Posted by deus83 (Post 1489176)

Had a minor problem with the first release. It kind of made an error when they where completing their registration, so we thought we could fix it by upgrading with this new version. Only made it worse... This is what we get as soon as one tries to invite a player to the site.

Suggestions ?

Quote:

Originally Posted by b65ran (Post 1496904)

I am getting the same database errors after updating. Is there any fix for that yet ?

In the query change

Code:

FROM XXXXXXuser

LEFT JOIN XXXXXXinvitation

Code:

FROM XXXXXXuser as user

LEFT JOIN XXXXXXinvitation as invitation

Ok I think this is the major hack that I need to add and launch my site...
mr Hasann, any news on the Gold Version of this hack?

Quote:

Originally Posted by deus83 (Post 1489176)

I had this SAME EXACT issue. Seems that many of us had the same issue. Can the developer please respond?

Quote:

Originally Posted by karthik123 (Post 1510657)

In the query change

Code:

FROM XXXXXXuser

LEFT JOIN XXXXXXinvitation

Code:



FROM XXXXXXuser as user

LEFT JOIN XXXXXXinvitation as invitation

I tried this fix and it got me a bit further along, but I'm still getting errors. Here's the new one (my prefix is sg_ so that part is valid):

Code:

Invalid SQL:

SELECT * FROM sg_invitation

                                                                                        WHERE invitation.email = 'myemail@myemailhost.com'

                                                                                        AND invitation.acceptedby = 0

                                                                                        AND invitation.accepted = 0;



MySQL Error  : Unknown column 'invitation.email' in 'where clause'

Error Number : 1054

Date         : Friday, June 13th 2008 @ 12:21:23 PM

Script       : http://shredguitars.com/profile.php

Referrer     : http://shredguitars.com/profile.php

IP Address   : 205.159.86.10

Username     : CaptainClaw

Classname    : vb_database

Does anyone know of any other invitation systems out there or is this the only one? It looks really promising but it's not working out of the box so I'm interested in trying some other alternatives.

Anyone know if this mod will conflict with the mod vMail?

Thanks a bunch.

Thanks, works like a charm :)

when i send a invitation i get this Your submission could not be processed because a security token was missing or mismatched. any one know how to fix it?

i guess support to this is dead...........same error as post number 92.93 and 97..............we need this working as this is a great hack too bad the gold version is only for 3.7.0 and up....

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01252 seconds Memory Usage 1,748KB 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 (6)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (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
Messages: