Log inRegister an accountBrowse CSDbHelp & documentationFacts & StatisticsThe forumsAvailable RSS-feeds on CSDbSupport CSDb Commodore 64 Scene Database
You are not logged in - nap
CSDb User Forums


Forums > CSDb Bug Reports > Bug
2003-01-21 10:29
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 ()"

2003-01-21 10:56
Perff
Administrator

Posts: 1680
I can't recreate the error you described. If you could feed me an url it would be nice. :)
2003-01-23 20:50
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)"
2003-01-24 09:22
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(
2003-01-25 21:26
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.
2003-01-27 16:45
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
2003-01-28 20:35
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=''"
2003-01-28 21:56
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
2003-01-29 23:00
prezes
Account closed

Registered: Apr 2002
Posts: 16
It's ok now. :)
RefreshSubscribe to this thread:

You need to be logged in to post in the forum.

Search the forum:
Search   for   in  
All times are CET.
Search CSDb
Advanced
Users Online
Chrx/Design/Chaos
Wisdom/Crescent
Twoflower/ΤRIΛD
nucleus/TempesT
E$G/HF ⭐ 7
bugjam
bepp/ΤRIΛD
Mibri/ATL^MSL^PRX
Guests online: 290
Top Demos
1 Next Level  (9.7)
2 13:37  (9.7)
3 Codeboys & Endians  (9.7)
4 Coma Light 13  (9.6)
5 Mojo  (9.6)
6 Edge of Disgrace  (9.6)
7 Uncensored  (9.6)
8 Comaland 100%  (9.6)
9 Wonderland XIV  (9.6)
10 What Is The Matrix 2  (9.6)
Top onefile Demos
1 Nine  (9.7)
2 Layers  (9.6)
3 Party Elk 2  (9.6)
4 Cubic Dream  (9.6)
5 Copper Booze  (9.6)
6 Libertongo  (9.5)
7 Dawnfall V1.1  (9.5)
8 Rainbow Connection  (9.5)
9 Onscreen 5k  (9.5)
10 Morph  (9.5)
Top Groups
1 Oxyron  (9.3)
2 Booze Design  (9.3)
3 Performers  (9.3)
4 Censor Design  (9.2)
5 Triad  (9.2)
Top Musicians
1 Jeroen Tel  (9.7)
2 Hein  (9.6)
3 Reyn Ouwehand  (9.6)
4 Rob Hubbard  (9.6)
5 dEViLOCk  (9.6)

Home - Disclaimer
Copyright © No Name 2001-2025
Page generated in: 0.056 sec.