Thread: Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite)
View Single Post
  #239  
Old 12-21-2008, 02:33 AM
Vitaly's Avatar
Vitaly Vitaly is offline
 
Join Date: Apr 2004
Location: Russia, St.Petersburg
Posts: 428
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Deceptor View Post
Vitaly - Some users have said it works on 3.7, others not, this is designed around 3.8 however. Could you tell me the db error that occured? Thanks.
Code:
Database error in vBulletin 3.7.4:

Invalid SQL:

        SELECT
            user.username, (user.options & 512) AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.useragent,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
        FROM session AS session
        LEFT JOIN user AS user ON(user.userid = session.userid)
        WHERE session.lastactivity >;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
Error Number  : 1064
Request Date  : Sunday, December 21st 2008 @ 07:30:26 AM
Error Date    : Sunday, December 21st 2008 @ 07:30:27 AM
Script        : http://forum.rcdesign.ru/
Referrer      : 
IP Address    : ****
Username      : ****
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.51a
Have vb 3.7.4 + vbseo + memcached. Latest stable php + eaccelerator and so on...

Just enabled from admincp WOL=60 & refreshed main page. Other pages are ok.

Anyway, I'm not disapponted. WOL feature is not critical. Now vboptimise effect is not noticeable at my site, but will have to wait for middle of monday to compare.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01546 seconds
  • Memory Usage 1,767KB
  • 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