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 ?!