View Single Post
  #64  
Old 02-01-2011, 12:30 PM
Bestrafung Bestrafung is offline
 
Join Date: Aug 2009
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is it possible to change how often the image is randomized? I've noticed that the same image is loaded for approximately two to three minutes before another random image is loaded.

Edit: I had to remove this widget from our page. It seems after a short period of time it has developed a random database error. We were unable to save articles due to this error. If anyone could point out why it's happening I'd be most appreciative.

HTML Code:
Database error in vBulletin 4.1.1:

Invalid SQL:

    SELECT     alb.albumid, att.attachmentid, att.userid, att.caption, att.dateline, att.state, fdt.filesize, IF(fdt.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fdt.thumbnail_dateline, fdt.thumbnail_width, fdt.thumbnail_height, u.username
    FROM album AS alb
    LEFT JOIN attachment AS att ON alb.albumid = att.contentid
    LEFT JOIN filedata AS fdt ON att.filedataid = fdt.filedataid
    LEFT JOIN user AS u ON att.userid = u.userid
    WHERE alb.state = 'public' AND att.contenttypeid = '8' AND alb.albumid IN (2)
    ORDER BY rand (16470)
   LIMIT 1;

MySQL Error   : FUNCTION gunnook_vb4.rand does not exist
Error Number  : 1305
Request Date  : Tuesday, February 1st 2011 @ 09:57:43 AM
Error Date    : Tuesday, February 1st 2011 @ 09:57:44 AM
Script        : http://xxxxxxxxxxxxxxxxxx.com/content.php?182-Nebraska-FFL-Dealers
Referrer      : http://xxxxxxxxxxxxxxxxxx.com/content.php?139-ffl-dealers
IP Address    : xx.xx.xx.xx
Username      : Admin
Classname     : vB_Database
MySQL Version : 5.0.91-community
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01150 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_html
  • (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