|
From: Nicholas B. <nbu...@co...> - 2006-09-06 17:07:44
|
Hey Jon & Ken, =20 Now that we have it at least working with an IP, what do you think is = the best way to proceed? I am still getting a few error messages here = and there, such as this one when selecting Gatekeeping, a function I do = not understand : =20 =20 -------------------------------------------------------------------------= -------------------------------------------------------- Couldn't query with: SELECT * FROM l_scanner_location WHERE is_current=20 The Postgres SQL server reported an error. The error text was: ERROR: relation "l_scanner_location" does not exist The program is continuing Warning: pg_fetch_array() expects parameter 1 to be resource, boolean = given in /var/www/html/chasers/sql_layer.php on line 448 Warning: array_keys() [function.array-keys]: The first argument should = be an array in /var/www/html/chasers/entry.php on line 94 Couldn't query with: SELECT * FROM entry WHERE scanner_location_code IN ''=20 ORDER BY entered_at DESC LIMIT 50=20 The Postgres SQL server reported an error. The error text was: ERROR: syntax error at or near "''" at character 52 The program is continuing Warning: pg_num_rows(): supplied argument is not a valid PostgreSQL = result resource in /var/www/html/chasers/sql_layer.php on line 420 -------------------------------------------------------------------------= -------------- =20 =20 Or would it be better to start working on customizing the database? If = so, perhaps you can send me a list of items that are DESC-particular and = need to be commented out? =20 =20 Nicholas Burmeister IT Department The Compass Center 206-357-3144 nbu...@co... =20 ________________________________ From: cha...@li... on behalf of = Jonathan Hedstrom Sent: Tue 9/5/2006 1:41 PM To: general Subject: Re: [Chasers-general] Next Steps Nicholas Burmeister wrote: > Even better news! By giving the httpd.conf file a real IP address for = the server, instead of the name we were trying to give the server = (wwi.compasscenter.org), workstations within compass center can connect = to the chasers database! > =20 Nice work indeed. Cheers, Jonathan |