 |
|
| Search |
| SQL Error: Could not execute query in /opt/coresystem/plugins/search/main.php:124 | | Query: |
SELECT DISTINCT(pages.id),
pages.contenttype,
pages.pagetitle,
pages.linktitle,
plugins.pluginname,
plugins.status AS pluginstatus,
pagecontent.content AS htmlcontent,
0 AS inblock
FROM pages
LEFT JOIN plugins
ON pages.pluginid=plugins.id
LEFT JOIN pagecontent
ON pages.id=pagecontent.pageid
WHERE (pages.status='enabled')
AND (
(pages.contenttype='plugin')
OR ( pages.contenttype='html' AND (pages.linktitle LIKE '%Sears%' OR pages.pagetitle LIKE '%Sears%' OR pagecontent.content LIKE '%Sears%') )
)
ORDER BY CASE linklocation WHEN 'all' THEN 1 WHEN 'top' THEN 2 WHEN 'block' THEN 3 ELSE 4 END ASC,weight ASC
| | Error: | Expression #1 of ORDER BY clause is not in SELECT list, references column 'lightningmonkey_city.pages.linklocation' which is not in SELECT list; this is incompatible with DISTINCT | | Call: | $SQL->select_query(string="
SELECT DISTINCT(pages.id)...",boolean=false) |
Search results for "Sears":
Sorry, there were no matches for your search keyword.
Click here to try another search.
|
|
