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'

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

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

I changed the file but still cant search.

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

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?

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.......