vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Integration with vBulletin - Facebook Connect - Allow your users to login with their Facebook account (for 3.8) (https://vborg.vbsupport.ru/showthread.php?t=203064)

webgroup 06-13-2009 03:45 AM

I got this error today, any help fixing it will be appreciated:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT user.*,usertextfield.*,userfield.*, user.userid, options, fbuser.fbuid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

, IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime



FROM vbnewuser AS user
LEFT JOIN vbnewfbuser AS fbuser ON(user.userid = fbuser.userid)
LEFT JOIN vbnewusertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN vbnewuserfield AS userfield ON(userfield.userid=user.userid)

LEFT JOIN vbnewavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbnewcustomavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1
AND (user.usergroupid IN (-1,6,26,18,23,25,7,22,2,20,5,21))

ORDER BY user.username asc
LIMIT 138100, 100;

MySQL Error : Incorrect key file for table '/tmp/#sql_2e8e_1.MYI'; try to repair it
Error Number : 126
Request Date : Saturday, June 13th 2009 @ 12:12:45 AM
Error Date : Saturday, June 13th 2009 @ 12:13:03 AM

asiaphoto 06-13-2009 04:49 AM

Hi,

I read somewhere earlier in this thread that the original coder of this facebook connect add-on is no longer servicing or supporting this mod?

I'm hoping to install this mod and will appreciate if someone skillful and good with support can help me do it. i'm willing to pay for the service.

pls PM me if you could help me? thanks

Datenpapst 06-13-2009 12:42 PM

I get an unexpected { in functions.php :(

Digital Jedi 06-13-2009 01:30 PM

Quote:

Originally Posted by asiaphoto (Post 1828783)
Hi,

I read somewhere earlier in this thread that the original coder of this facebook connect add-on is no longer servicing or supporting this mod?

I'm hoping to install this mod and will appreciate if someone skillful and good with support can help me do it. i'm willing to pay for the service.

pls PM me if you could help me? thanks

I think you should wait until the coder comes back and verifies that. Second hand accounts of what a coder is doing based on whether they got help or not is always just speculation at best.

shortbus1662 06-13-2009 07:29 PM

I have setup a new facebook application, turned off my forum, etc. Upon attempting to add the cpnav_fbconnect.xml, I am presented with: Invalid File Specified.

I am on Vbulletin 3.8.2 with Php 5.

wolfyman 06-14-2009 03:28 PM

I'm amazed that I'm the first to have a 500 error... am I?

Everything appears to be working, until I choose a nickname and click to continue. Rather than logging me in, I get a

"The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.
"

Digital Jedi 06-14-2009 03:51 PM

Quote:

Originally Posted by shortbus1662 (Post 1829161)
I have setup a new facebook application, turned off my forum, etc. Upon attempting to add the cpnav_fbconnect.xml, I am presented with: Invalid File Specified.

I am on Vbulletin 3.8.2 with Php 5.

The cpnav file is part of the Upload folder. You only Import the product XML through your Admin CP. Not every XML in the ZIP file.

webgroup 06-14-2009 09:48 PM

Quote:

Originally Posted by webgroup (Post 1828757)
I got this error today, any help fixing it will be appreciated:



Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT user.*,usertextfield.*,userfield.*, user.userid, options, fbuser.fbuid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid

,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

, IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime



FROM vbnewuser AS user
LEFT JOIN vbnewfbuser AS fbuser ON(user.userid = fbuser.userid)
LEFT JOIN vbnewusertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN vbnewuserfield AS userfield ON(userfield.userid=user.userid)

LEFT JOIN vbnewavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbnewcustomavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1
AND (user.usergroupid IN (-1,6,26,18,23,25,7,22,2,20,5,21))

ORDER BY user.username asc
LIMIT 138100, 100;

MySQL Error : Incorrect key file for table '/tmp/#sql_2e8e_1.MYI'; try to repair it
Error Number : 126
Request Date : Saturday, June 13th 2009 @ 12:12:45 AM
Error Date : Saturday, June 13th 2009 @ 12:13:03 AM

Any body?

thanks! :)

wolfstream 06-14-2009 10:44 PM

Quote:

Originally Posted by webgroup (Post 1829799)
Any body?

thanks! :)

Your Mysql database is corrupted, that has nothing to do with the app itself.

Quote:

Incorrect key file for table '/tmp/#sql_2e8e_1.MYI'; try to repair it
You need to try to repair the database itself.

webgroup 06-15-2009 12:54 AM

Quote:

Originally Posted by wolfstream (Post 1829820)
Your Mysql database is corrupted, that has nothing to do with the app itself.



You need to try to repair the database itself.

vbnewfbdatamap Check Status: OK
vbnewfbdatamap Optimize Status: Table is already up to date
vbnewfbuser Check Status: OK
vbnewfbuser Optimize Status: Table is already up to date



I have run the repair various times.

And this is the only DB error Im getting from the forum.


Any ideas?

Thanks! :)

dchoi 06-15-2009 08:22 AM

Am I the only one having problems creating the Facebook app? I'm sure I followed the directions as written, yet I'm constantly met with the same error:

Code:

Base Domain is not valid. Connect URL must be derived from your Base Domain.

fulviods 06-15-2009 09:09 AM

Quote:

Originally Posted by fulviods (Post 1824045)
Thanks for your answer. I dont speak perfectly english. Could you tell me if my infos are ok?
Here are infos in my forum admin:
General settings:
Url of my website : http://www.mywebsite.com
Url of my forums : http://www.mywebsite.com/forum
FB Connect options:
Same API and secret key that in the fb application.
Import user data: no
The system generated 3 different template ID.
Data mapping:
Actually i linked only one field : location ->location
Do I have to create fields in vbulletin to match the others fields? (facebook uid,name,first name...)

Here are the infos in the facebook application:
G?n?ral tab: I just put the name of the application & logo and email.
2nd tab authentification: http://www.mywebsite.com/forum in the 2 fields
3rd tab Profiles: Ony the first chapter (name of the tab and url) and http://www.mywebsite.com for the call back
I didnt fill the other fields
Canvas tab : http://apps.facebook.com/myname / Canvas callback url http://www.mywebsite.com/forum
Optional : i put nothing /Canvas settings : Iframe/intelligent/complete/deactivate other fields empty
Connexion tab: connect url : http://www.mywebsite.com / Base domain : http://www.mywebsite.com other fields empty
widgets: empty
advanced settings: empty

Thanks a lot...

Can someone tell me if this settings are ok? :erm:

fulviods 06-15-2009 02:27 PM

I found!!! Shame on me!! There was a spelling error :(

Only problem i see is that fb users are not assigned to the usergroup i specified in the Default User Group ID. A solution?

vbreal 06-15-2009 05:06 PM

i have a question

when uses sign up via facebook connect they always have to sign in through the facebook connect button?

that causes a problem when users try to log on to my mobile theme. they can't log in with a name and password.

is there a way to fix this?

wolfyman 06-15-2009 06:23 PM

Hay guise!

I'm amazed that I'm the first to have a 500 error... am I?

Everything appears to be working, until I choose a nickname and click to continue. Rather than logging me in, I get a

"The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.
"

Thankssssssssssss!

shortbus1662 06-15-2009 10:52 PM

Update: Nevermind, it was a stupid mistake I made; I tried to import cpnav_ other than the product xml. We are all setup now and I give this 5 out of 5 stars!

shortbus1662 06-16-2009 02:39 PM

It would be nice if users had the User CP option of enabling/disabling the Facebook window from popping up every time they make a post. It would also be great if this app had the ability to allow you to invite friends from your list that are not members of your site.

Teletubby 06-16-2009 05:13 PM

I also would really like "Invite your Friends" (Facebook Friends) feature added to this mod then it would be amazing!

Brad

vbreal 06-16-2009 07:00 PM

sllik
Coder
Last Activity: 24 Apr 2009 17:38



its been a while since the coder has been on. *sigh*

rrudeboy 06-17-2009 12:49 PM

bummer.... my host runs PHP 4.4.9...

mmoore5553 06-17-2009 01:09 PM

rrude

just call your hosting company and have them update it . It will take five mins if that. It is not hard at all and should not affect anything. I would do it cause php 4 will be old soon and out of date.

GamerPerfection 06-17-2009 08:50 PM

Hi, I have a quick question regarding this.

If a non-member of my forums logs in via their FaceBook account does that then add an account for them on my forums? I'm wondering how it works in relation to a profile etc.

So if they post on the forums do they have a profile, and do they appear in the who's online etc etc.

Stevie Night 06-18-2009 03:27 PM

Quote:

Originally Posted by clarkey25 (Post 1831518)
Hi, I have a quick question regarding this.

If a non-member of my forums logs in via their FaceBook account does that then add an account for them on my forums? I'm wondering how it works in relation to a profile etc.

So if they post on the forums do they have a profile, and do they appear in the who's online etc etc.

I'd like to know this too before I install lol

GamerPerfection 06-18-2009 07:29 PM

Quote:

Originally Posted by Stevie Night (Post 1831988)
I'd like to know this too before I install lol

I've had a read through some of the 50 odd pages in this thread and it seems to be that an account is automatically created and it obtains details from their facebook profile.

Although it wouldn't hurt for one of the 544 people that have installed this to post quickly confirming what happens.

wolfstream 06-18-2009 07:51 PM

Quote:

Originally Posted by clarkey25 (Post 1832161)
Although it wouldn't hurt for one of the 544 people that have installed this to post quickly confirming what happens.

How many times does it need to be confirmed, really?
I know I've said it a few dozen times myself

GamerPerfection 06-18-2009 07:54 PM

Quote:

Originally Posted by wolfstream (Post 1832167)
How many times does it need to be confirmed, really?
I know I've said it a few dozen times myself

Yes but I don't fancy reading through 53 pages.

And instead of making such a comment like that you could have been a bit more helpful.

Smitty 06-18-2009 08:23 PM

Quote:

Originally Posted by clarkey25 (Post 1832170)
Yes but I don't fancy reading through 53 pages.

You want to be spoon fed as well, eh?

vbreal 06-18-2009 09:38 PM

yes it creats an account automatically

john graham 06-18-2009 11:23 PM

How long does it take if I sign up for professional installation? Signed up today and I thought it would be done between 5 and 8 est but no luck.

wolfstream 06-18-2009 11:56 PM

Quote:

Originally Posted by john graham (Post 1832299)
How long does it take if I sign up for professional installation? Signed up today and I thought it would be done between 5 and 8 est but no luck.

Some have said they get it done within hours, but since the owner hasn't shown up here in 2 months, I would think you won't have much luck

john graham 06-19-2009 12:15 AM

Quote:

Originally Posted by wolfstream (Post 1832323)
Some have said they get it done within hours, but since the owner hasn't shown up here in 2 months, I would think you won't have much luck

Great!? I finally try to change my forum and this....=/

asiaphoto 06-19-2009 03:41 AM

Hi all,

I'v sent the coder Sllik an email and couldn't get any replies. Read somewhere later in this thread that he last logged on around mid-april...

is there another experienced coder willing to provide support for installation as well as further modifications of this facebook connect app?

pls PM me to discuss budget. thanks

eagerly in need of support.

Quote:

Originally Posted by Digital Jedi (Post 1828958)
I think you should wait until the coder comes back and verifies that. Second hand accounts of what a coder is doing based on whether they got help or not is always just speculation at best.


Smitty 06-19-2009 04:06 AM

I'll admit to having paid a coder to take an abandoned script and update it to work with the vB version I use. If the mod author leaves and does not respond to emails, I'll get a coder to update the mod and they leave the appropriate credits in the script. If the mod author would complain, I'll offer to pay US$100 or so. That has never happened, but I'm not wanting to avoid paying. The *function* of the script is important to me.

asiaphoto 06-19-2009 08:14 AM

Hi Smitty,

any chance of me paying the same coder or you to get it installed to work with my forum at http://www.asiaphoto.com/forum ?

i'm also concerned that the new version of vbulletin's coming up, version 4.0 and i hope it will continue to work.

Smitty, could you PM me your forum url so i can take a look to see how it's working out so far?

Smitty 06-19-2009 11:36 AM

The last time I used someone was a couple years ago. I'll look at the script this afternoon and PM you the person's email, but you may want to look around for a coder - The fellow I used may not still be around. I will say you can expect to pay some $.

Lee G 06-19-2009 02:21 PM

I just installed this and if you follow the instructions to the letter it is surprisingly simple.

I was a bit hesitant myself after seeing how many pages had accumulated on this thread.

Great little hack

wolfstream 06-19-2009 03:56 PM

Quote:

Originally Posted by john graham (Post 1832757)
Of course, the problem is I already sent the money via paypal to have it done. What recourse do I have?

Sadly, not much, especially if you specified 'services' when you sent the money.
Paypal does not cover 'services' in their normal refunds.

Now, if you funded the transaction through your CC, then you can call your bank and have them take care of it. Usually banks are pretty good about that as they want to keep their own customers!

renlok 06-19-2009 07:05 PM

brilliant :D

asiaphoto 06-21-2009 01:53 AM

Hi Wolfstream,

i was just looking thru the old threads and saw this post of yours.

yes, it will be great if you could contribute to further development of this mod. i see it being put to action in some forums... which i logged in with my facebook account. it's really need.

but there could be more improvements such as

(1) disabling the prompt to publish everything into the user's facebook wall
as a user, it gets annoying each time i'm asked and i have to click "skip"

(2) adding a link to members' facebook profile automatically.

(3) an option to request facebook members to also key in their email addresses during the signup stage (where they choose their username for this forum)

(4) an option to automatically add such users to a facebook group so admins can email them as a group.
currently, i think no email addresses are captured to the forum mailing lists.


Quote:

Originally Posted by wolfstream (Post 1819854)
Ok, well, that didn't go over too well, apparently. Despite the author's being gone, there's really nothing more I can do here.

I HATE that, because there's just sooooo much good that can come from this application, but if the gods say no, the gods say no.

I'll look through his code, see how impossible it would be to rewrite and SEE (note: see) what I can do. I really can't guarantee much, however.


wolfstream 06-21-2009 02:05 AM

There are problems with the last two. Because of this, you may want to require users to register before using this application, and then link the app to their account.

When a user registers through facebook, they expect that all details will be kept there. This is a security thing, more than anything else, just like a user paying through paypal expects THEIR details to be kept @ paypal.

You can't mess with the facebook email addresses at all without screwing things up, unfortunately.


All times are GMT. The time now is 06:14 PM.

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.04347 seconds
  • Memory Usage 1,848KB
  • 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
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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