Afficher un message
  #23  
Vieux   
DRACULA1 (Hors ligne)
Membre débutant
DRACULA1 is on a distinguished road
 
Messages: 6
Date d'inscription: March 2006
Par défaut 26/03/2006 , 14h22


Y a un bug au niveau de la suppression d'une news. quand on supprime une news on recoit une erreur Sql directement sur le forum, pour resoudre le probleme il faut enlever le module news de la page d'accueil.

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:

		SELECT user.avatarid, user.avatarrevision, avatarpath as avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline as avatdate, customavatar.width, customavatar.height,
			thread.title as title, thread.threadid as threadid, thread.postusername as username,
			thread.postuserid as userid, thread.views, thread.replycount,
			thread.iconid AS iconid,
			post.pagetext as pagetext, thread.dateline as dateline
		FROM vb3_thread AS thread
			LEFT JOIN vb3_post AS post ON post.postid = thread.firstpostid
			LEFT JOIN vb3_user AS user ON user.userid = thread.postuserid
			LEFT JOIN vb3_avatar AS avatar ON avatar.avatarid = thread.postuserid
			LEFT JOIN vb3_customavatar AS customavatar ON customavatar.userid = thread.postuserid
		WHERE thread.forumid IN()
		ORDER BY thread.dateline DESC;

MySQL Error  : Erreur de syntaxe près de ')
		ORDER BY thread.dateline DESC' à la ligne 11
Error Number : 1064

Réponse avec citation
 
X vBulletin 3.8.11 Debug Information
  • Page Generation 0,01396 seconds
  • Memory Usage 1,245KB
  • Queries Executed 9 (?)
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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_reputation
  • (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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.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
  • fetch_musername
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • showpost_complete