Error when searching
Post new topic   Reply to topic   Printer Friendly Page     Forum IndexCoppermine
Author Message
blacblam
Nice poster


Joined: Oct 15, 2004
Posts: 103

PostPost subject: Error when searching
Posted: Tue Nov 09, 2004 10:50 pm
Reply with quote

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'

_________________
www.spinstrument.com

blacblam's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
8.2b
Back to top
View user's profile Visit poster's website
Phoenix
Site Admin


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

PostPost subject: Re: Error when searching
Posted: Tue Nov 09, 2004 11:49 pm
Reply with quote

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

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

_________________
DonationsPro for DragonflyCMS, SMF, MyBB, vBulletin

Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website
blacblam
Nice poster


Joined: Oct 15, 2004
Posts: 103

PostPost subject: Re: Error when searching
Posted: Wed Nov 10, 2004 8:26 pm
Reply with quote

I changed the file but still cant search.

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

_________________
www.spinstrument.com

blacblam's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
8.2b
Back to top
View user's profile Visit poster's website
blacblam
Nice poster


Joined: Oct 15, 2004
Posts: 103

PostPost subject: Re: Error when searching
Posted: Thu Nov 11, 2004 9:28 pm
Reply with quote

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?

_________________
www.spinstrument.com

blacblam's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
8.2b
Back to top
View user's profile Visit poster's website
skoeter
Silver Supporter


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

PostPost subject: Re: Error when searching
Posted: Mon Nov 15, 2004 4:01 pm
Reply with quote

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


skoeter's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
server ??/MySQL 5+/PHP 5+/Dragonfly 9.1.2
Back to top
View user's profile Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   Printer Friendly Page     Forum IndexCoppermine All times are GMT
Page 1 of 1


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

stopsoftwarepatents.eu petition banner
User Info [x]

Welcome Anonymous

Nickname
Password
(Register)

Last CVS commits [x]

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

Deutsch
Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.5616 seconds with 20 DB Queries in 0.1912 seconds
Memory Usage: 2.89 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy