[adoxtater]

Originally Posted by deus83

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 ?

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

Originally Posted by karthik123

In the query change

FROM XXXXXXuser
LEFT JOIN XXXXXXinvitation

to

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):

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.