Thread: Integration with vBulletin - YAFB - Yay! Another Facebook Bridge
View Single Post
  #693  
Old 03-17-2010, 07:57 AM
doubleclick doubleclick is offline
 
Join Date: Jul 2004
Posts: 218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello-

I had reported this error before and thought it had been fixed, but I was too optimistic. I receive it several times night

Code:
Invalid SQL:

SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, picture.state, picture.fbbypass,
albumpicture.dateline, album.state AS albumstate, profileblockprivacy.requirement AS privacy_requirement,
picture.filedata, picture.filesize
FROM vbalbumpicture AS albumpicture
INNER JOIN vbpicture AS picture ON (albumpicture.pictureid = picture.pictureid)
INNER JOIN vbalbum AS album ON (albumpicture.albumid = album.albumid)
LEFT JOIN vbprofileblockprivacy AS profileblockprivacy ON
(profileblockprivacy.userid = picture.userid AND profileblockprivacy.blockid = 'albums')
WHERE albumpicture.albumid = 35 AND albumpicture.pictureid = 147;

MySQL Error : Table '417278_forum.vbprofileblockprivacy' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 16th 2010 @ 01:19:38 PM
Error Date : Tuesday, March 16th 2010 @ 01:19:39 PM
Script : http://www.mysite.com/forum/facebook.php?do=albumpicture&albumid=35&pictureid=147
Referrer :
IP Address : 66.220.145.246
Username : Unregistered
Classname : vB_Database
As I read the error, it seems it is complaining about a missing table: vbprofileblockprivacy

I'm not much of a coder, but it seems if that's the problem, I could just go into phpMyAdmin and add the table. I started to do that this morning, but when I did, besides prompting for the table name, it also wants the number of fields, so it seems I need a bit more info.
  1. Is my conclusion correct that this vbprofileblockprivacy table should be there?
  2. If it should be, then how many fields should it have?
  3. Is this the logical fix?

Thanks for any thoughts on this.

dc
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01176 seconds
  • Memory Usage 1,766KB
  • 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)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