[thesite] [thelist] [BUG] weo cfm error

martin.p.burns at uk.pwcglobal.com martin.p.burns at uk.pwcglobal.com
Mon Jan 14 06:31:07 CST 2002 

Memo from Martin P Burns of PricewaterhouseCoopers

-------------------- Start of message text --------------------

oops - slip of the key. Should have gone here instead.

Sorry
Martin

---------------------- Forwarded by Martin P Burns/UK/MCS/PwC on 14/01/2002
00:47 ---------------------------


Martin <martin at members.evolt.org>@lists.evolt.org on 13/01/2002 18:54:02

Please respond to thelist at lists.evolt.org

Sent by:  thelist-admin at lists.evolt.org

To:   thelist at lists.evolt.org
cc:


Subject:  [thelist] [BUG] weo cfm error


http://evolt.org/user/MartinB/32/index.html



Oracle Error Code = 0

Timeout while obtaining an Oracle statement lock


SQL = "SELECT * FROM users WHERE userid = 32"

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 (22,2) /home/evolt/public_html/evolt/app_chooser.cfm
9.   CFINCLUDE (24,3) /home/evolt/public_html/evolt/app_chooser.cfm
10.  CFSWITCH (3,1) /home/evolt/public_html/evolt/app_user.cfm
11.  CFCASE (8,3) /home/evolt/public_html/evolt/app_user.cfm
12.  CFINCLUDE (9,5) /home/evolt/public_html/evolt/app_user.cfm
13.  CFQUERY (7,1) /home/evolt/public_html/evolt/user/act_signup.cfm

Debugging: APP,CFCATCH,CGI,FORM,SESSION,URL
  Structure: 6 keys

APP
  Structure: 7 keys
PRIV
Structure: 5 keys
0    "None"
1    "User"
2    "Member"
3    "Admin"
4    "Godmin"
RATING
Structure: 6 keys
0    "Unrated"
1    "Poor"
2    "Average"
3    "Good"
4    "Very good"
5    "Excellent"
SESSION
Structure: 7 keys
CFID "549583"
CFTOKEN   "39791262"
PAGETITLE ""
SESSIONID "EVOLT_549583_39791262"
SIDEBAR
Structure: 6 keys
ADMIN
Structure: 4 keys
ARTICLES
Structure: 1 keys
VISIBLE   "1"
COMMENTS
Structure: 1 keys
VISIBLE   "1"
RATINGS
Structure: 1 keys
VISIBLE   "1"
VISIBLE   "1"
JOBS
Structure: 1 keys
VISIBLE   "1"
LOGIN
Structure: 1 keys
VISIBLE   "1"
SEARCH
Structure: 1 keys
VISIBLE   "1"
THELIST
Structure: 1 keys
VISIBLE   "1"
VISIBLE   "1"
URLTOKEN  "CFID=549583&CFTOKEN=39791262"
USER
Structure: 9 keys
DATE_FORMAT    "mm/dd/yyyy"
EMAIL     "martin at members.evolt.org"
ID   "32"
LASTLOGIN "12-JAN-02"
MID  "2748"
NAME "MartinB"
PRIV "3"
SCHEME    "isaac.css"
TIME_FORMAT    "h:mm tt"
SIGNOFF
Structure: 4 keys
0    "New"
1    "Approved"
2    "Denied"
3    "Pending"
STARTING_DISK_PATH  "/home/evolt/public_html"
USERPRIV
Structure: 5 keys
ADMIN     "3"
GODMIN    "4"
GUEST     "0"
MEMBER    "2"
USER "1"
VALID_DATA     "1"

CFCATCH
  Structure: 8 keys

Type Caught an exception, type DATABASE
TagContext
  Array: 13 elements
CFQUERY   7    1    /home/evolt/public_html/evolt/user/act_signup.cfm
CFINCLUDE 9    5    /home/evolt/public_html/evolt/app_user.cfm
CFCASE    8    3    /home/evolt/public_html/evolt/app_user.cfm
CFSWITCH  3    1    /home/evolt/public_html/evolt/app_user.cfm
CFINCLUDE 24   3    /home/evolt/public_html/evolt/app_chooser.cfm
CFCASE    22   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 = 0

Timeout while obtaining an Oracle statement lock


Detail
SQL = "SELECT * FROM users WHERE userid = 32"

Data Source = "EVOLT"


NativeErrorCode     0
SQLState


CGI
  Structure: 30 keys
AUTH_TYPE ""
CF_TEMPLATE_PATH    "/home/evolt/public_html/alphaboxcontroller.cfm"
CONTENT_LENGTH ""
CONTENT_TYPE   ""
HTTP_ACCEPT    "*/*"
HTTP_ACCEPT_LANGUAGE     "en"
HTTP_CONNECTION     "keep-alive"
HTTP_COOKIE

"CFID=549583; CFTOKEN=39791262; EVOLT_LOGIN=00035C4F%2DA0B4%2D1A38%2D950A569BD15384F2"

HTTP_EXTENSION "Security/Remote-Passphrase"
HTTP_HOST "evolt.org"
HTTP_IF_MODIFIED_SINCE   "Sun, 13 Jan 2002 18:32:45 GMT"
HTTP_REFERER   "http://evolt.org/user/MartinB/32/index.html"
HTTP_UA_CPU    "PPC"
HTTP_UA_OS     "MacOS"
HTTP_USER_AGENT     "Mozilla/4.0 (compatible; MSIE 5.12; Mac_PowerPC)"
HTTP_VIA  "1.0 cache-bas (NetCache NetApp/5.1R2D14)"
HTTP_X_FORWARDED_FOR     "80.195.50.226"
PATH_INFO ""
PATH_TRANSLATED     ""
QUERY_STRING   ""
REMOTE_ADDR    "62.31.224.1"
REMOTE_HOST    ""
REMOTE_USER    ""
REQUEST_METHOD "GET"
REQUEST_URI    "/user/index.html?action=edit"
SCRIPT_NAME    "/alphaboxcontroller.cfm"
SERVER_NAME    "evolt.org"
SERVER_PORT    "80"
SERVER_PROTOCOL     "HTTP/1.1"
SERVER_SOFTWARE     "Apache/1.3.20 (Unix)"

FORM
  Structure: 1 keys
SUBMIT    ""

SESSION
  Structure: 7 keys
CFID "549583"
CFTOKEN   "39791262"
PAGETITLE ""
SESSIONID "EVOLT_549583_39791262"
SIDEBAR
Structure: 6 keys
ADMIN
Structure: 4 keys
ARTICLES
Structure: 1 keys
VISIBLE   "1"
COMMENTS
Structure: 1 keys
VISIBLE   "1"
RATINGS
Structure: 1 keys
VISIBLE   "1"
VISIBLE   "1"
JOBS
Structure: 1 keys
VISIBLE   "1"
LOGIN
Structure: 1 keys
VISIBLE   "1"
SEARCH
Structure: 1 keys
VISIBLE   "1"
THELIST
Structure: 1 keys
VISIBLE   "1"
VISIBLE   "1"
URLTOKEN  "CFID=549583&CFTOKEN=39791262"
USER
Structure: 9 keys
DATE_FORMAT    "mm/dd/yyyy"
EMAIL     "martin at members.evolt.org"
ID   "32"
LASTLOGIN "12-JAN-02"
MID  "2748"
NAME "MartinB"
PRIV "3"
SCHEME    "isaac.css"
TIME_FORMAT    "h:mm tt"

URL
  Structure: 25 keys

ACTION    "edit"
ADMIN     ""
AID  "0"
BID  "0"
CATID     "0"
CFID ""
CFTOKEN   ""
CID  "0"
COMMENTS  "true"
DEBUG     "0"
DEBUGLIST ""
EVOLT     ""
FORMAT    ""
KEYWORDS  ""
MENU "0"
MID  "0"
PARAMS    ""
RATING    "true"
SEARCHPANE     "0"
SECTION   "user"
SID  ""
SIDEBAR   ""
SUBSECTION     ""
TID  "0"
UID  "32"



_______________________________________________
email: martin at easyweb.co.uk             PGP ID:    0xA835CCCB
     martin at members.evolt.org      snailmail:      30 Shandon Place
   tel:   +44 (0)774 063 9985                 Edinburgh,
   url:   http://www.easyweb.co.uk            Scotland


--
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !


--------------------- End of message text --------------------

This e-mail is sent by the above named in their
individual, non-business capacity and is not on
behalf of PricewaterhouseCoopers.

PricewaterhouseCoopers may monitor outgoing and incoming
e-mails and other telecommunications on its e-mail and
telecommunications systems.
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited.   If you received
this in error, please contact the sender and delete the material from any
computer.

More information about the thesite mailing list