Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 01-04-2007, 11:16 PM
Mr.Dosa's Avatar
Mr.Dosa Mr.Dosa is offline
 
Join Date: Jun 2005
Location: Egypt
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help

this mysql error


Code:
Invalid SQL:

		SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1167958688 AND open <> 10, 1, 0)) AS newthread
		
		FROM thread AS thread
		
		
		WHERE forumid = 36
			AND sticky = 0
			 AND visible = 1 
			AND postuserid NOT IN (213.6.152.159);

what i should do to solve this proplem

Still waiting
Reply With Quote
  #2  
Old 01-06-2007, 12:36 PM
Mr.Dosa's Avatar
Mr.Dosa Mr.Dosa is offline
 
Join Date: Jun 2005
Location: Egypt
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

my board is closed please help me
Reply With Quote
  #3  
Old 01-06-2007, 01:48 PM
peterska2 peterska2 is offline
 
Join Date: Oct 2003
Location: Manchester, UK
Posts: 6,504
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This sounds like it is linked to a plugin which you have installed.

Disable the plugin system by editing config.php and adding this line right under <?php

Code:
define('DISABLE_HOOKS', true);
Now, check to see if it is working.

If it is working, disable all plugins and products in the admincp, remove the line from config.php and then enable one product/plugin at a time testing between each one until you find the problem.

If it is not working even when you have added the line into config.php and you have applied any file edits, then you should upload a clean set of files overwriting your current set (if in doubt back up your files from your server and do this anyway).

If all else fails, and plugins are disabled, and no file edits are present, then you will probably be best off submitting a support ticket via your Members Area
Reply With Quote
  #4  
Old 01-06-2007, 08:20 PM
Mr.Dosa's Avatar
Mr.Dosa Mr.Dosa is offline
 
Join Date: Jun 2005
Location: Egypt
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i do that before write this thread here and the proplem still appeare

Note : when i log in as admin the board work whithout proplems but when members or guests log in this error appeare

i upgrade form 3.5.4 to 3.6.4 to avoid this proplem but nothing happened and the error is still appearing
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:47 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07117 seconds
  • Memory Usage 2,180KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete