Closed (fixed)
Project:
SQL Search (Trip Search)
Version:
4.6.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Feature request
Assigned:
Reporter:
Created:
14 May 2005 at 04:31 UTC
Updated:
24 Jun 2005 at 02:57 UTC
error log:"You have an error in your SQL syntax near 'na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') AND (n.title LIKE "%%' at line 1 query: SELECT DISTINCT(n.type), COUNT(n.nid) AS count, n.title,n.type,n.body,n.sticky,nc.totalcount FROM node n INNER JOIN node_access na ON na.nid = n.nid INNER JOIN node_counter nc ON n.nid = nc.nid WHERE n.status = 1 na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') AND (n.title LIKE "%%aaa%%" OR n.body LIKE "%%aaa%%") GROUP BY n.type ORDER BY n.type in /mywebdir/includes/database.mysql.inc on line 71".
when use isn't admin ,search result nothing.but admin 's search normal.
Comments
Comment #1
nedjoI'm thinking this is fixed in the current release version. Please report back if not.
Comment #2
huyl commentedIt's ok now.I like this module very much.Can you add search support for aggregator ?
think you .
Comment #3
(not verified) commented