Dear Koen, Thanks for the advice! In fact, I fixed the problem but just to let others know-- you also have to change the procpid to pid in the databasecleanup.py file as well as the databasecleaup.sql file.
But I am still having some trouble as Arches is completely blank. When I open the localhost page- there is no way to view resource types, add resource types, search or edit. <https://lh4.googleusercontent.com/-K0xAR-i7n2E/VFDAmG7fDbI/AAAAAAAAAik/Zj06spqWodA/s1600/12.png> I have taken out my data and tried to load the English heritage sample data and still nothing appears. Any advice would be really great! Thank you Eloise On Wednesday, October 29, 2014 9:34:50 AM UTC+1, Koen Van Daele wrote: > > Hi Eloise, > > > > I think that’s an error you get when running a Postgres 9.3 server. My 9.1 > server has procpid in pg_stat_activity. My 9.3 server has pid instead of > procpid. It’s a change that was introduced in postgres 9.2. > > > > I believe it’s not that big a deal and that the rest of the installation > can just go on. You can probably change “procpid” in > *C:/Temp/archesproject/db/Deployment > Scripts/DatabaseCleanup.sql *to “pid” to fix the error. > > > > Cheers, > > Koen > > > > *Koen Van Daele* > > Applicatiebeheerder > > M +32 (0)499 94 93 68 | T +32 (0)2 553 16 82 > > > > *Van:* [email protected] <javascript:> [mailto: > [email protected] <javascript:>] *Namens *Eloise Stancioff > *Verzonden:* dinsdag 28 oktober 2014 18:09 > *Aan:* [email protected] <javascript:> > *Onderwerp:* [Arches] Re: Problem with loading Arches with own data > > > > Also- I may have found the issue, but I am a bit confused on how to go > about fixing it... > > > > After I have both servers running and build arches, I get the following > error after entering my password for postgres > > > > *C:\Temp\archesproject>C:\Temp\archesproject\build\install_arches_db.bat* > > > > *C:\Temp\archesproject>cd C:\Temp\archesproject\build\..* > > > > *C:\Temp\archesproject>call "virtualenv/ENV/Scripts/activate.bat"* > > *operation: install* > > *current file is: C:\Temp\archesproject\db\Deployment > Scripts\DatabaseCleanup.py* > > *current file is: C:\Temp\archesproject\db\Deployment Scripts\Restore.py* > > *current file is: C:\Temp\archesproject\db\Deployment Scripts\__init__.py* > > *Password for user postgres:* > > *psql:C:/Temp/archesproject/db/Deployment Scripts/DatabaseCleanup.sql:1: > ERROR:* > > *column "procpid" does not exist* > > *LINE 1: SELECT pg_terminate_backend(procpid) from pg_stat_activity w...* > > * ^* > > * pg_terminate_backend* > > *----------------------* > > *(0 rows)* > > > > > > *DROP DATABASE* > > *CREATE DATABASE* > > *Password for user postgres:* > > > > > > > > Any ideas? > > Thank you > > Eloise > On Tuesday, October 28, 2014 11:22:28 AM UTC+1, Eloise Stancioff wrote: > > Hi > > > > I hope this message finds you well. I think that I have followed the > procedure correctly to load Arches with my own data. I used the sample data > set up that I was sent by Adam and then modified only the administrative > subdivision document and values. csv files. I ran the server and built > Arches with no error. But- when I go into Arches- it is as if there is > absolutely no data, no drop down menus. It is completely blank- just gives > me the map and the menu bar. Is there something that I have missed? > > > > Also- in a previous email, I was told to change the map_config settings so > that the map layer would open to my specific region rather than the UK. > Could you tell me where that file is? > > > > > > The files that I edited are as follows: > > > > C:\Temp\archesproject\packages\cds\source_data\resource_info,csv > > > > C:\Temp\archesproject\packages\cds\source_data\concepts\authority_files\Administrative > > Subdivision Authority document.csv > > C:\Temp\archesproject\packages\cds\source_data\concepts\authority_files\Administrative > > Subdivision Authority values.csv > > > > > > Thanks in advance for any advice or help > > Eloise > > -- > -- To post, send email to [email protected] <javascript:>. To > unsubscribe, send email to [email protected] <javascript:>. > For more information, visit > https://groups.google.com/d/forum/archesproject?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Arches Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
