Re: [Dcmms-info] Re: DCMMS is running

[<Ste...@do...>]

Hi Thomas,

I think you can safely ignore the error messages about the nonexistant 
views.

Can you check whether the files where loaded even though you get the error 
message?
If they are not loaded, try to run

set PGCLIENTENCODING=WINDOWS-1256& set PGPASSWORD=admin& "c:\program 
files\PostgreSQL\8.0.0-rc5\bin\psql.exe" -d dcmms -U admin -h localhost -f 
"c:\tmp\shpB2.tmp\landmark.shp.sql" > "c:\tmp\shpB2.tmp\error.log"

in the cmd.exe - this might give additional error messages.

Please not that WINDOWS-1256 is the Arabic codepage, if you're using 
french accents you may have to use a different codepage (define it in 
dcmconfig.php). This might
also be the source of the problem as it might cause the transactions to 
fail.

Regarding the correction of strPgClientBinDirectory: The idea is that the 
installer takes care of this. However I see that this is currently only a 
TODO
in the installer code. Sorry for this. Shall be fixed in the next release.

Regards,

Steffen




"Thomas Winter" <win...@li...>
28.01.2005 13:28
Please respond to "Thomas Winter"
 
        To:     <Ste...@do...>
        cc: 
        Subject:        Re: [Dcmms-info] Re: DCMMS is running


Hi Steffen,
 
1. when I tried to upload shapefiles, I get the following error...
What kind of error is that? The error.log file contain nothing.
 
2. you should change the path of the following in the dcmconfig.php
 
$_SESSION["strPgClientBinDirectory"] = 
//  "c:\\program files\\PostgreSQL\\8.0.0\\bin\\";
 
// **********TW******************
   "c:\\program files\\PostgreSQL\\8.0.0-rc5\\bin\\";
// **********TW******************
 
Thanks 
 
Thomas 
 
 
 
 
 Received file 'landmark.zip'....
Unzipping ...
Name: landmark.shx Size: 4756
Name: landmark.dbf Size: 83516
Name: landmark.sbn Size: 13108
Name: landmark.sbx Size: 1132
Name: landmark.shp Size: 16396
 
Loading 'landmark.shp' ...
Dropping database views.

Warning: pg_query(): Query failed: ERROR: view "maintenanceview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "pipediameterview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "pipematerialview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "landmarkview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "workorderview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "staffview" does not exist 
in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "materialview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "equipmentview" does not 
exist in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "termview" does not exist 
in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "teamview" does not exist 
in C:\Program Files\dcmms\admin\shapefile_loader.php on line 117

Warning: pg_query(): Query failed: ERROR: view "administrativeareaview" 
does not exist in C:\Program Files\dcmms\admin\shapefile_loader.php on 
line 117
"c:\program files\PostgreSQL\8.0.0-rc5\bin\shp2pgsql.exe" -d 
"c:\tmp\shpB2.tmp\landmark.shp" landmark dcmms > 
"c:\tmp\shpB2.tmp\landmark.shp.sql"
set PGCLIENTENCODING=WINDOWS-1256& set PGPASSWORD=admin& "c:\program 
files\PostgreSQL\8.0.0-rc5\bin\psql.exe" -d dcmms -U admin -h localhost -f 
"c:\tmp\shpB2.tmp\landmark.shp.sql" > "c:\tmp\shpB2.tmp\error.log"
Failed to load shapefile.
Done.