View Single Post
  #499  
Old 06-23-2004, 06:58 PM
Ranma2k Ranma2k is offline
 
Join Date: Dec 2001
Location: Earth
Posts: 586
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by AndrewD
Beta release 1.25 uploaded in first post to this thread. Please test and report.

New features:
a) Boolean fulltext searches and highlighted keywords
b) Ability to sort links display on name, date, hits
c) Facility to link to local downloads outside the web directory tree

Modifications:
a) Bug fix for quotes in usernames
b) More consistent error templates

There is a bug if you did a search
it will give the error

Code:
Invalid SQL: 
		SELECT link.linkid AS linkid, link.linkname AS linkname, link.linkuserid AS linkuserid, 
			link.linkusername AS linkusername, link.linkurl AS linkurl, link.linkdesc AS linkdesc, 
			link.linkhits AS linkhits, link.linkstatus AS linkstatus, link.linkdate AS linkdate,
			ltoc.catid AS linkcatid
		FROM local_linkslink AS link
		LEFT JOIN local_linksltoc AS ltoc
		ON link.linkid = ltoc.linkid
			
		WHERE
			link.linkforum NOT IN (0)
			AND (link.linkmoderate = 0 OR link.linkuserid =1 )
		
			AND  MATCH (link.linkname, link.linkdesc) AGAINST ('Naruto2' IN BOOLEAN MODE) 
			
			ORDER BY linkcatid, linkname
		
mysql error: You have an error in your SQL syntax near 'BOOLEAN MODE) )
			
			ORDER BY linkcatid, linkname
how can i fix this ?!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01152 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