CPG Dragonfly™ CMS

blacblam · Joined: Oct 15, 2004 Posts: 103

When searching on my gallery I get the following error:

While executing query "SELECT SQL_CALC_FOUND_ROWS pid, filepath, filename, p.title, keywords, url_prefix, filesize, pwidth, pheight, ctime, p.aid, p.title, caption FROM cms_cpg_pictures AS p INNER JOIN cms_cpg_albums AS a ON (p.aid = a.aid AND visibility > -1) WHERE MATCH(filename, p.title, caption, keywords,user1,user2,user3,user4) AGAINST ('club' ) AND approved='YES' GROUP BY pid LIMIT 0 ,12" on 0

mySQL error: Unknown column 'SQL_CALC_FOUND_ROWS' in 'field list'

Phoenix · Joined: Apr 19, 2004 Posts: 8729 Location: Netizen

A quick search shows,
cpgnuke.com/Forums/vie...=3602.html

It pays to check bug reports and bug fixes, especially the sticky topics.

blacblam · Joined: Oct 15, 2004 Posts: 103

I changed the file but still cant search.

cpgnuke.com/Forums/vie...=3602.html

blacblam · Joined: Oct 15, 2004 Posts: 103

The search is working but when you search for a pic that is there the result shows this horizontally instead of the pic

6
6
m
m

P
P
P
P

0
0

3
3
5
5

3
3
1
1

2
2

Any ideas?

skoeter · Joined: Aug 17, 2004 Posts: 140 Location: Netherlands

I have the same problem, also my image views do not count.... 100 images in 6 albums in 2 caregories view 0 times things like that
I requested my host to upgrade or I need to find a host who has the technoligy needed.....
Modifying the script with your tips did not change any thing.
error at line 802 of functions.inc the line that says search.inc is needed.....

Anyway.... glad I found this because I felt quite lonely till I noticed you having the same prob.......

CPG Dragonfly™ CMS

DedicatedNow