[thesite] evolt's search is blowing up (fwd)

Daniel J. Cody djc at members.evolt.org
Wed Feb 6 12:11:01 CST 2002 

---------- Forwarded message ----------
Date: Fri, 1 Feb 2002 10:47:35 -0500
From: Ben Gustafson <Ben_Gustafson at lionbridge.com>
Subject: evolt's search is blowing up

Here's the URL:

http://www.evolt.org/search/index.html?keywords=information+design
<http://www.evolt.org/search/index.html?keywords=information+design&option=p
hrase&tid=0&maxrows=10> &option=phrase&tid=0&maxrows=10

--Ben

  _____

top <http://www.evolt.org/index.html> evolt.org
  <http://www.evolt.org/evolt/images/spacer.gif> Browsers
<http://browsers.evolt.org/>  | Lists <http://lists.evolt.org/>  | "
href="http://lists.evolt.org/harvest/">Tips | Members
<http://members.evolt.org/>  | Directory <http://dir.evolt.org/>
  <http://www.evolt.org/evolt/images/spacer.gif>
  <http://www.evolt.org/evolt/images/spacer.gif>
  <http://www.evolt.org/evolt/images/spacer.gif>
  <http://www.evolt.org/evolt/images/tab_cap.gif>
 <http://www.evolt.org/index.html> Home
<http://www.evolt.org/faq/index.html> FAQ
<http://www.evolt.org/contact/index.html> Contact

 Choose a category...    - Backend    - Code    - Commentary & Society    -
Community News    - IA/Usability    - Jobs    - News    - Reviews & Links
- Site Development    - Software    - Suggestions    - Visual Design
<http://www.evolt.org/evolt/images/spacer.gif>
Oracle Error Code = 904


ORA-00904: invalid column name



SQL = "SELECT content.contentid, content.contentname, content.synopsis,
content.datemod, content.rating, content.ratings, content.replies,
content.signoff, users.userid, users.who, users.email, categorys.category,
categorys.categoryid, (SELECT Count(*) FROM replies WHERE contentid =
content.contentid AND datemod > '18-Jan-02') AS newcomments FROM content,
users, categorys WHERE content.categoryid = categorys.categoryid AND (
Lower(content.synopsis) LIKE '%information design%' OR
Lower(content.contentname) LIKE '%information design%' OR Lower(users.who)
LIKE '%information design%' OR Lower(users.email) LIKE '%information
design%' OR content.contentid = INF ) AND content.userid = users.userid AND
content.signoff = 1 ORDER BY content.datemod DESC"


Data Source = "EVOLT"



  _____

Caught an exception, type = DATABASE

The contents of the tag stack are:

1.	CFTRY (24,1) /home/evolt/public_html/alphaboxcontroller.cfm

2.	CFINCLUDE (26,3) /home/evolt/public_html/alphaboxcontroller.cfm

3.	CFSWITCH (3,1) /home/evolt/public_html/evolt/index.cfm

4.	CFDEFAULTCASE (19,3) /home/evolt/public_html/evolt/index.cfm

5.	CFINCLUDE (20,5) /home/evolt/public_html/evolt/index.cfm

6.	CFINCLUDE (50,4) /home/evolt/public_html/evolt/home_design.cfm

7.	CFSWITCH (3,1) /home/evolt/public_html/evolt/app_chooser.cfm

8.	CFCASE (19,2) /home/evolt/public_html/evolt/app_chooser.cfm

9.	CFINCLUDE (20,3) /home/evolt/public_html/evolt/app_chooser.cfm

10.	CFSWITCH (3,1) /home/evolt/public_html/evolt/app_search.cfm

11.	CFDEFAULTCASE (4,2) /home/evolt/public_html/evolt/app_search.cfm

12.	CFINCLUDE (5,3) /home/evolt/public_html/evolt/app_search.cfm

13.	CFIF (17,1) /home/evolt/public_html/evolt/search/act_search.cfm

14.	CFQUERY (30,2) /home/evolt/public_html/evolt/search/act_search.cfm

Debugging: APP,CFCATCH,CGI,FORM,SESSION,URL


 Click to Collapse <http://www.evolt.org/images/minus.gif> Structure: 6 keys


APP
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 7 keys

PRIV
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 5 keys

0	 "None"
1	 "User"
2	 "Member"
3	 "Admin"
4	 "Godmin"
RATING
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 6 keys

0	 "Unrated"
1	 "Poor"
2	 "Average"
3	 "Good"
4	 "Very good"
5	 "Excellent"
SESSION
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 7 keys

CFID	 "404297"
CFTOKEN	 "94337015"
PAGETITLE	 ""
SESSIONID	 "EVOLT_404297_94337015"
SIDEBAR
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 6 keys

ADMIN
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 4 keys

ARTICLES
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
COMMENTS
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
RATINGS
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
VISIBLE	 "1"
JOBS
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
LOGIN
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
SEARCH
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
THELIST
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
VISIBLE	 "1"
URLTOKEN	 "CFID=404297&CFTOKEN=94337015"
USER
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 9 keys

DATE_FORMAT	 "mm/dd/yyyy"
EMAIL	 "ben_gustafson at lionbridge.com"
ID	 "17165"
LASTLOGIN	 "18-JAN-02"
MID	 ""
NAME	 "ben_g"
PRIV	 "1"
SCHEME	 "isaac.css"
TIME_FORMAT	 "hh:mm tt"
SIGNOFF
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 4 keys

0	 "New"
1	 "Approved"
2	 "Denied"
3	 "Pending"
STARTING_DISK_PATH	 "/home/evolt/public_html"
USERPRIV
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 5 keys

ADMIN	 "3"
GODMIN	 "4"
GUEST	 "0"
MEMBER	 "2"
USER	 "1"
VALID_DATA	 "1"
CFCATCH
 Click to Collapse <http://www.evolt.org/images/minus.gif> Structure: 8 keys


Type	 Caught an exception, type DATABASE
TagContext
 Click to Expand <http://www.evolt.org/images/plus.gif> Array: 14 elements

CFQUERY 	30 	2
/home/evolt/public_html/evolt/search/act_search.cfm
CFIF 	17 	1 	/home/evolt/public_html/evolt/search/act_search.cfm

CFINCLUDE 	5 	3 	/home/evolt/public_html/evolt/app_search.cfm

CFDEFAULTCASE 	4 	2 	/home/evolt/public_html/evolt/app_search.cfm

CFSWITCH 	3 	1 	/home/evolt/public_html/evolt/app_search.cfm

CFINCLUDE 	20 	3
/home/evolt/public_html/evolt/app_chooser.cfm
CFCASE 	19 	2 	/home/evolt/public_html/evolt/app_chooser.cfm
CFSWITCH 	3 	1
/home/evolt/public_html/evolt/app_chooser.cfm
CFINCLUDE 	50 	4
/home/evolt/public_html/evolt/home_design.cfm
CFINCLUDE 	20 	5 	/home/evolt/public_html/evolt/index.cfm

CFDEFAULTCASE 	19 	3 	/home/evolt/public_html/evolt/index.cfm

CFSWITCH 	3 	1 	/home/evolt/public_html/evolt/index.cfm

CFINCLUDE 	26 	3
/home/evolt/public_html/alphaboxcontroller.cfm
CFTRY 	24 	1 	/home/evolt/public_html/alphaboxcontroller.cfm
Message	 Oracle Error Code = 904


ORA-00904: invalid column name


Detail
SQL = "SELECT content.contentid, content.contentname, content.synopsis,
content.datemod, content.rating, content.ratings, content.replies,
content.signoff, users.userid, users.who, users.email, categorys.category,
categorys.categoryid, (SELECT Count(*) FROM replies WHERE contentid =
content.contentid AND datemod > '18-Jan-02') AS newcomments FROM content,
users, categorys WHERE content.categoryid = categorys.categoryid AND (
Lower(content.synopsis) LIKE '%information design%' OR
Lower(content.contentname) LIKE '%information design%' OR Lower(users.who)
LIKE '%information design%' OR Lower(users.email) LIKE '%information
design%' OR content.contentid = INF ) AND content.userid = users.userid AND
content.signoff = 1 ORDER BY content.datemod DESC"


Data Source = "EVOLT"


NativeErrorCode	 904
SQLState
CGI
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 25 keys

AUTH_TYPE	 ""
CF_TEMPLATE_PATH	 "/home/evolt/public_html/alphaboxcontroller.cfm"

CONTENT_LENGTH	 ""
CONTENT_TYPE	 ""
HTTP_ACCEPT	 "application/vnd.ms-excel, application/msword,
application/vnd.ms-powerpoint, image/gif, image/x-xbitmap, image/jpeg,
image/pjpeg, */*"
HTTP_ACCEPT_ENCODING	 "gzip, deflate"
HTTP_ACCEPT_LANGUAGE	 "en-us,zh-tw;q=0.8,ja;q=0.5,de;q=0.3"
HTTP_CONNECTION	 "Keep-Alive"
HTTP_COOKIE	 "CFID=404297; CFTOKEN=94337015;
EVOLT_LOGIN=0003D4DC%2D0857%2D1BE7%2DB6D400017F00106C"
HTTP_HOST	 "www.evolt.org"
HTTP_REFERER	 "http://www.evolt.org/search/index.html?keywords=layers"

HTTP_USER_AGENT	 "Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0;
T312461)"
PATH_INFO	 ""
PATH_TRANSLATED	 ""
QUERY_STRING	 ""
REMOTE_ADDR	 "4.22.195.16"
REMOTE_HOST	 ""
REMOTE_USER	 ""
REQUEST_METHOD	 "GET"
REQUEST_URI
"/search/index.html?keywords=information+design&option=phrase&tid=0&maxrows=
10"
SCRIPT_NAME	 "/alphaboxcontroller.cfm"
SERVER_NAME	 "evolt.org"
SERVER_PORT	 "80"
SERVER_PROTOCOL	 "HTTP/1.1"
SERVER_SOFTWARE	 "Apache/1.3.20 (Unix)"
FORM
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 7 keys

KEYWORDS	 ""
MAXROWS	 "10"
OPTION	 "all"
STATUS	 "1"
SUBMIT	 ""
SYNOPSIS	 "0"
TID	 "0"
SESSION
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 7 keys

CFID	 "404297"
CFTOKEN	 "94337015"
PAGETITLE	 ""
SESSIONID	 "EVOLT_404297_94337015"
SIDEBAR
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 6 keys

ADMIN
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 4 keys

ARTICLES
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
COMMENTS
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
RATINGS
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
VISIBLE	 "1"
JOBS
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
LOGIN
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
SEARCH
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
THELIST
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 1 keys

VISIBLE	 "1"
VISIBLE	 "1"
URLTOKEN	 "CFID=404297&CFTOKEN=94337015"
USER
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 9 keys

DATE_FORMAT	 "mm/dd/yyyy"
EMAIL	 "ben_gustafson at lionbridge.com"
ID	 "17165"
LASTLOGIN	 "18-JAN-02"
MID	 ""
NAME	 "ben_g"
PRIV	 "1"
SCHEME	 "isaac.css"
TIME_FORMAT	 "hh:mm tt"
URL
 Click to Expand <http://www.evolt.org/images/plus.gif> Structure: 29 keys

ACTION	 ""
ADMIN	 ""
AID	 "0"
BID	 "0"
CATID	 "0"
CFID	 ""
CFTOKEN	 ""
CID	 "0"
COMMENTS	 "true"
DEBUG	 "0"
DEBUGLIST	 ""
EVOLT	 ""
FORMAT	 ""
KEYWORDS	 "information design"
MAXROWS	 "10"
MENU	 "0"
MID	 "0"
OPTION	 "phrase"
PARAMS	 ""
RATING	 "true"
SEARCHPANE	 "0"
SECTION	 "search"
SID	 ""
SIDEBAR	 ""
STATUS	 "1"
SUBSECTION	 ""
SYNOPSIS	 "0"
TID	 "0"
UID	 "0"

More information about the thesite mailing list