Print

[Pascal YAP]

Bonjour all,
(CPG 1.3.2)

   I have a small problem with my search.php who answer each time a Critical Error.
Only one answer : "There was an error while processing a database query."
The CPG Debug-Mod said :

Code: [Select]

While executing query "SELECT COUNT(*) FROM CPG_pictures WHERE () AND ctime > UNIX_TIMESTAMP() - 0 AND ctime < UNIX_TIMESTAMP() - 0 " on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ctime > UNIX_TIMESTAMP() - 0 AND ctime < UNIX_TIMESTAMP()
UPDATE.php do not fix this problem at all.
What's wrong, i cannot find and fix this Critical Error 

Thanx for your HELP

PYAP

[Joachim Müller]

Try checking out the most recent version of search.php from the stable branch of the CVS and see if this cures your problem.

Joachim

[Pascal YAP]

Gaugau,

I try to dowload a fresh SEARCH.PHP in CVS stable branche....and nothing new after :-(
It's really a db problem not localized yet !

Because with differents personnal SEARCH.PHP the CRITICAL ERROR stay as answer...

PYAP

[Joachim Müller]

the problem is the empty WHERE block. Try finding the code line and see what it contains - maybe it's something with your db...

Joachim

[Nibbler]

You are using dev code. All the important search stuff is in include/search.inc.php. It is that file you need to replace with search.inc.php from the stable branch of CVS.

[Pascal YAP]

Ah ah Nibbler, (-;

Your are the Copper-King, and me, only the Mystake-King

K-Thanx Nibbler and Gau² all is all right now......

PYAP