[Alfa1]

Originally Posted by Scythe42

What settings do you use on your forum? Invite only? Invite and normal registration? Email Verfication needed? Any errors in your php.log? Any special cookie related settings on your end or the users' browser? How does the entry in the invitation table for that invitation code looks like? Where any signups successful or do they all fail in regards to the invitation code?

If you provide me with some more details I can try to reproduce it and find a solution for the scenario.

The code that updates the table is pretty simple. It's called on "register_addmember_complete". It checks for the invitationcode cookie that was set when the signup process started. If present it continues and updates the table for that code. If it is not present an error message is shown when normal registration is disabled. If normal registration is still enabled, the user is passed through like a normal registration.

My settings:
Invite and normal registration
I cant look back more than a day in my apache error log
No special cookie settings on the site. I am awaiting more info about the members cookie settings.
The invitation table looks like this:

PHP Code:

b0a3283e9ebd7a14732fbfdc44036731      example@example.com      04-06-2008      Not Confirmed Yet      Delete 


Other signups where successful.

Edit: the invited user found a cookie named "bb1referrerid."

EDIT2: I just received this database error:

PHP Code:

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:
SELECT user.userid AS user_id, user.email AS user_email, invitation.email AS inv_email, invitation.acceptedby as inv_id
                                         FROM vbprefix_user
                                         LEFT JOIN vbprefix_invitation
                                         ON user.userid = invitation.acceptedby OR user.userid = invitation.email
                                        WHERE user.email = 'example@example.com'
                                        OR invitation.email = 'example@example.com';

MySQL Error   : Unknown column 'user.userid' in 'field list'
Error Number  : 1054
Date          : Friday, April 11th 2008 @ 04:00:44 AM
Script        : http://www.mysite.com/forum/profile.php
Referrer      : http://www.mysite.com/forum/profile.php?do=invitation
IP Address    : xxxxx
Username      : xxxx
Classname     : vB_Database
MySQL Version : 5.0.45