forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: Quinti on July 04, 2006, 08:46:01 am

Title: error searching keywords by click
Post by: Quinti on July 04, 2006, 08:46:01 am
Hi people

i'm upgrading from 1.3.5 to 1.4.8

and when i'm click a keyword to show results, give me this sql error:

Code: [Select]
While executing query "SELECT COUNT(*) FROM cpg133_pictures WHERE () AND ctime > UNIX_TIMESTAMP() - 172800 AND ctime < UNIX_TIMESTAMP() - 172800 " 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() - 172800 AND ctime < UNIX_TIMESTAMP() - 172800' at line 1
in line: 249, functions.inc.php

thank u very much
Title: Re: error searching keywords by click
Post by: Sami on July 04, 2006, 08:53:37 am
post a link ?
Title: Re: error searching keywords by click
Post by: Quinti on July 04, 2006, 09:06:44 am
Hi

http://www.fotosdesarria.com/1.4.8/search.php (http://www.fotosdesarria.com/1.4.8/search.php)
Title: Re: error searching keywords by click
Post by: Sami on July 04, 2006, 09:09:25 am
looks fine for me !
can you post a direct link to your issue?
Title: Re: error searching keywords by click
Post by: Quinti on July 04, 2006, 09:17:02 am
capture: (http://img301.imageshack.us/img301/8382/errorsearchingkeywordsclick9wp.th.gif) (http://img301.imageshack.us/my.php?image=errorsearchingkeywordsclick9wp.gif)

and clicking...for example "1995" - http://www.fotosdesarria.com/1.4.8/thumbnails.php?album=search&search=1995 (http://www.fotosdesarria.com/1.4.8/thumbnails.php?album=search&search=1995)

my error is: "There was an error while processing a database query"
Title: Re: error searching keywords by click
Post by: Joachim Müller on July 04, 2006, 12:37:37 pm
unable to replicate.
Title: Re: error searching keywords by click
Post by: Sami on July 04, 2006, 01:08:15 pm
  :o
I don't see any error  ???
no mysql error at all
Title: Re: error searching keywords by click
Post by: Quinti on July 04, 2006, 02:28:07 pm
now yes run....

very strange...

well, i think is solved...ji

thank u very much guys