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


All times are GMT. The time now is 06:45 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.02873 seconds
  • Memory Usage 1,747KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (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