Thread: Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite)
View Single Post
  #264  
Old 09-26-2010, 12:07 PM
Tize. Tize. is offline
 
Join Date: Oct 2009
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have error in all my tables and forum, users, user cp, admin cp .
Please help me!!!

PHP Code:
Database error in vBulletin 4.0.3:

Invalid SQL:

                
SELECT user.*, (user.options 512) AS invisible avatar.avatarpathNOT ISNULL(customavatar.userid) AS hascustomcustomavatar.dateline AS avatardatelinecustomavatar.filedata_thumbcustomavatar.height AS avheightcustomavatar.width AS avwidthcustomavatar.width_thumb AS avwidth_thumbcustomavatar.height_thumb AS avheight_thumb
                    
                FROM userlist 
AS userlist
                INNER JOIN user 
AS user ON (user.userid userlist.relationid)
                
LEFT JOIN avatar AS avatar ON (avatar.avatarid user.avatarid)
                
LEFT JOIN customavatar AS customavatar ON (customavatar.userid user.userid
                
                
WHERE userlist.userid 33
                    
AND userlist.type 'buddy'
                    
AND userlist.friend 'yes'
                    
                
ORDER BY RAND()
                
LIMIT 06;

MySQL Error   Can't create/write to file '#sql_3dbb_0.MYD' (Errcode: 17)
Error Number  1
Request Date  
SundaySeptember 26th 2010 02:00:56 PM
Error Date    
SundaySeptember 26th 2010 02:00:56 PM
Script        
http://www.xxxxx.com/member.php?action=getinfo&u=33
Referrer      http://www.xxxxx.com/
IP Address    83.39.77.914
Username      
Tize
Classname     
vB_Database 

Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01587 seconds
  • Memory Usage 1,790KB
  • 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_php
  • (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