Thread: Integration with vBulletin - YAFB - Yay! Another Facebook Bridge
View Single Post
  #358  
Old 01-31-2010, 12:44 PM
Zaiaku's Avatar
Zaiaku Zaiaku is offline
 
Join Date: Jul 2007
Location: 3rd Level of Hell
Posts: 502
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Nadeemjp View Post
hey mrpaint, i am having errors, alot of errors whenever someone accesses the albums.
i am posting one of the errors as below:

Code:
Database error in vBulletin 4.0.1:

Invalid SQL:

			SELECT
				a.userid, a.attachmentid, a.state, a.contentid, a.filename, fd.userid as uploader, fd.extension, fd.filedataid, fd.thumbnail_dateline AS dateline, fd.thumbnail_filesize AS filesize, at.extension, at.mimetype, album.state AS albumstate, album.albumid, album.userid AS albumuserid, pbp.requirement AS privacy_requirement, a.fbbypass, a.fbpid
				
			FROM attachment AS a
			INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid) LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension) LEFT JOIN album AS album ON (album.albumid = a.contentid) LEFT JOIN profileblockprivacy AS pbp ON (pbp.userid = a.userid AND pbp.blockid = 'albums')
			
			WHERE a.attachmentid = 282 AND a.contenttypeid = 8;

MySQL Error   : Unknown column 'a.fbbypass' in 'field list'
Error Number  : 1054
Request Date  : Sunday, January 31st 2010 @ 04:56:15 AM
Error Date    : Sunday, January 31st 2010 @ 04:56:15 AM
Script        : http://www.familybunker.com/forums/attachment.php?albumid=150&attachmentid=282t&thumb=1&dl=
Referrer      : http://www.familybunker.com/forums/members/aamir.html
IP Address    : xxxx
Username      : xxx
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.30
with 3.8.4 there wasnt such error.
cna you cure it?
What version of the mod are you using?
Can you verify in myphpadmin there's that column is in your db?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01220 seconds
  • Memory Usage 1,768KB
  • 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)bbcode_quote
  • (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