Thread: Profile Enhancements - Invitation System [Beta]
View Single Post
  #94  
Old 03-02-2008, 08:20 PM
TTMT TTMT is offline
 
Join Date: Mar 2008
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For people with "Your invite is either not valid or has already been used." error message:

Technical reason: the invitationcode field in the table invites in your database has length at most 20 characters, whereas the one being sent to users has 32 characters. What happens is usually the invitation token (with 32 chars) generated randomly will be sent to users (in the invitation link), although only the first 20 characters of this token is gonna be stored in the database. When users click on their link, the system basically lookup in the invites table to see if there is any match, but it clearly fails.

Solution:
1. If you have already installed the system, simply go to your invites table (using myphpadmin or any similar database management tool), and change the length of the invitationcode field in the invites table to 32. Notice that this invites table might have prefix (chosen by you at installtion), therefore just look for any table that ends with invites.

After that any new invitations should work. You can delete all previous records in the invites table if you wish.

2. If you haven't installed the system (or want to uninstall your system and reinstall it) then:

First, open product-invitation.xml and find

Code:
$db->query_write("CREATE TABLE ". TABLE_PREFIX ."invites (
  invitecode varchar(20) NOT NULL default '',
then change 20 to 32.

Then install the system as normal. It should work (tested on vbb 3.6.8 patch level 2).
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01164 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete