Re: [Chasers-general] Next Steps

[Jonathan H. <jhe...@de...>]

Nicholas Burmeister wrote:
> Hey Jon & Ken,
>  
> 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 :
>  
>  
> ---------------------------------------------------------------------------------------------------------------------------------
> Couldn't query with: SELECT *
> FROM l_scanner_location
> WHERE is_current 
> 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 '' 
>
> ORDER BY entered_at DESC LIMIT 50 
> 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
> ---------------------------------------------------------------------------------------
>  
>   
The gatekeeping page won't work without the entry tables installed.
These are installed via the install.shelter.sql script (see below).
However, at this point, I wouldn't be too concerned about stray errors.
>  
> 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?
>  
>   
I'd say it's time to customize the database. The easiest way to do this
is to first choose which tables you want to install, and then customize
the tables themselves, which all live in the database/pg/client
directory. The aforementioned install.shelter.sql script creates many
shelter-specific tables. Similarly, install.housing.sql creates
housing-specific tables. These tables (there are sql scripts that create
each table) would need to be customized to the Compass Center's needs.

However, as a first attempt, you might just try creating the tables in
the database by running install.housing.sql via psql, and edit
config/client_config.php to reflect the existence of the new tables.

Before you start changing anything, it might be a good idea to make a
copy of your working version.

-Jonathan