| |
prezes Account closed
Registered: Apr 2002 Posts: 16 |
Bug
In advanced search after submitting empty form:
Could not execute SQL query: "SELECT group_id FROM groups_type WHERE grouptype_id IN ()"
|
|
| |
Perff Administrator
Posts: 1680 |
I can't recreate the error you described. If you could feed me an url it would be nice. :) |
| |
prezes Account closed
Registered: Apr 2002 Posts: 16 |
It seems its some Opera-specific bug, under IE everything works fine:
http://noname.c64.org/csdb/search/advanced.php
fill nothing, just hit Perform Search.
Error:
Could not execute SQL query: "SELECT DISTINCT g.id,lower(g.name) FROM groups g WHERE 1=1 AND g.id IN () AND g.hqcountry IN () ORDER BY lower(g.name)" |
| |
Pater Pi Account closed
Registered: Jan 2002 Posts: 121 |
same for some nicks, but don't ask me what nicks that were i searhced for 8( |
| |
Perff Administrator
Posts: 1680 |
Quote: It seems its some Opera-specific bug, under IE everything works fine:
http://noname.c64.org/csdb/search/advanced.php
fill nothing, just hit Perform Search.
Error:
Could not execute SQL query: "SELECT DISTINCT g.id,lower(g.name) FROM groups g WHERE 1=1 AND g.id IN () AND g.hqcountry IN () ORDER BY lower(g.name)"
I made some double-check code so it shouldn't happen again.
Please test it.
|
| |
Nafcom
Registered: Apr 2002 Posts: 588 |
Quote: I made some double-check code so it shouldn't happen again.
Please test it.
Hello there!
Works fine here now in "Opera"! :)
All the best!
Bye!
Joerg |
| |
prezes Account closed
Registered: Apr 2002 Posts: 16 |
Under Opera 6.0 I still get:
Could not execute SQL query: "SELECT grouptype FROM grouptypes WHERE id=''" |
| |
Perff Administrator
Posts: 1680 |
Now if done made a lot of if-code in the advanced search to try to avoid theese illegal empty sql's.
Hope I got all of them and didn't make other bugs in the process.
You are welcome to try to make the advanced search report and sql-error. :)
/Perff
|
| |
prezes Account closed
Registered: Apr 2002 Posts: 16 |
It's ok now. :) |