4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
July 30, 2010, 04:44:50 AM

Login with username, password and session length
Search:     Advanced search
Translate this page with google
=>
 Translate this page with Google =>
* Home Help Search Login Register
 
+  4images Forum & Community
|-+  4images Issues / Ausgaben
| |-+  Discussion & Troubleshooting (Moderators: Acidgod, ivan, Rembrandt)
| | |-+  Bug Report 1.6 - Search errors for anything but 'All Fields'
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Print
Author Topic: Bug Report 1.6 - Search errors for anything but 'All Fields'  (Read 5295 times)
Chris
Administrator
4images Guru
*****
Offline Offline

Posts: 4489

Thank You
-Given: 0
-Receive: 2

Did u ever stop to think and then forget to start?


View Profile
« on: June 28, 2002, 06:44:33 AM »

I entered the word 'Pond' into the "Search by Keyword" form field.

CASE 1:

If I leave the "All fields" radio button selected, I get 7 images returned.  There are actually 386 images that have the keyword 'Pond'.

CASE 2:

If I select either the "Only image name", "Only description", or "Only keywords" radio buttons, I get the following error:

1
2
DB Error: Bad SQL Query: SELECT m.image_id FROM 4images_wordlist w, 4images_wordmatch m WHERE w.word_text LIKE 'pond' AND m.word_id = w.word_id AND wm.name_match = 1
Unknown table 'wm' in where clause


Also, for CASE 1, hitting my browser BACK button doesn't return me to the search form.  Instead I see the same search results again but the table width is slightly altered.  Hitting BACK again takes me to the page from where I clicked "Advanced Search".  I don't know if this has anything to do with the problem or helps in any way.
Logged

Jan
Administrator
4images Guru
*****
Offline Offline

Posts: 5015

Thank You
-Given: 0
-Receive: 9


View Profile WWW
« Reply #1 on: June 28, 2002, 09:44:27 AM »

Thanks Chris, i will check this.

Greets Jan
Logged

Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search
Jan
Administrator
4images Guru
*****
Offline Offline

Posts: 5015

Thank You
-Given: 0
-Receive: 9


View Profile WWW
« Reply #2 on: June 28, 2002, 06:39:06 PM »

See: http://www.4homepages.de/forum/viewtopic.php?t=847

Greets Jan
Logged

Your first three "must do" before you ask a question:
1. Forum rules
2. FAQ
3. Search
Pages: [1] Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
piqs.de - Fotocommunity & lizenzfreie Fotos