Text only | Text with Images

coppermine-gallery.com/forum

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: (https://coppermine-gallery.com/forum/proxy.php?request=http%3A%2F%2Fimg301.imageshack.us%2Fimg301%2F8382%2Ferrorsearchingkeywordsclick9wp.th.gif&hash=08c49be8f7e2cf4d8c6e9d2d4a206704bb89a006) (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
Text only | Text with Images