Thread: Major Additions - vBExperience 4
View Single Post
  #2653  
Old 12-16-2014, 07:36 PM
Dangerboy's Avatar
Dangerboy Dangerboy is offline
 
Join Date: Oct 2008
Location: Canada
Posts: 19
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi I've installed the mod on a test server running vb 4.2.2 P3 and I keep getting this error when I try a recount or if a cron job runs:
Quote:
Invalid SQL:
SELECT
COUNT(*) as mypictures
FROM vbf_ppgal_images
WHERE valid=1 AND userid=1
AND ppgal_images.dateline > 315532800;

MySQL Error : Unknown column 'ppgal_images.dateline' in 'where clause'
Error Number : 1054
Request Date : Tuesday, December 16th 2014 @ 01:17:42 PM
Error Date : Tuesday, December 16th 2014 @ 01:17:43 PM
Script : xperience_admin.php?do=xperience_admin_recount_xp
Referrer : xperience_admin.php?do=recount
IP Address : 173.245.54.100
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.73
I've tried a few times to re-upload and re-install but I cannot seem to get rid of this error. It also generates the error in the "vBExperience vBGallery" plugin is disabled. If uninstalled, the recount works with no issue. I've also tried with just the gallery plugin alone.

Has anyone seen this problem? Can you please let me know how to fix it?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01317 seconds
  • Memory Usage 1,764KB
  • 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_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