Problem with save data to database - Windows

[acmt]

I don't know what I do wrong

but i read this #29 and this #67 and try (i think) everything but without success. I always have this error http://imgur.com/a/arICQ

I'm using Windows 8.1. Maybe any advice what to try?
Sorry for my very bad English but i have hope you understand me

[Brideau]

Looks like the web hook listener and the database are at different versions, since listener is trying to add data for a column that doesn't exist. When did you set everything up, and have you applied the patches that have come out since then?

[acmt]

I set up everything today from zero about 20:00. But earlier (before niantic disable api) i set it on other computer and everything work fine

probably i make some very stupid mistake - like always ;/

[Brideau]

Have you added the patch that was put up today? https://github.com/Brideau/pokelyzer/wiki/Patches

[QuadTog]

I'm experiencing the same with the newest patches and everything:

EDIT: Fixed it by re-running the windowsBatch.bat under admin mode. Very weird as it didn't take the first couple of times :|

Z:\Desktop\PokemonGo-Map-develop\pokelyzer-master>node app.js
Running server on port 9876
Error fetching client from pool { [error: password authentication failed for use
r "pokemon_go_role"]
  name: 'error',
  length: 104,
  severity: 'FATAL',
  code: '28P01',
  detail: undefined,
  hint: undefined,
  position: undefined,
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'auth.c',
  line: '285',
  routine: 'auth_failed' }
Idle client error read ECONNRESET Error: read ECONNRESET
    at exports._errnoException (util.js:873:11)
    at TCP.onread (net.js:557:26)

[acmt]

Yes I added all patches - but for sure i can set databese one more time - but today i don't have much time for this

I tried run windowsBatch.bat as admin - but only one time, maybe i need more attemps

I will try manage with this after work and i will tell you about effect

EDIT: I try run windowsBatch.bat as admin (few times) but without success ;/ - i have the same error. Sorry but i don't have time for trying something else. I will back to fight with this problem about weekend

[QuadTog]

It's broken again this morning. Exact same issue, no idea how I got it to work last night only to have it break again this morning. Pokemon_go_role just isn't registering a PW.

[acmt]

I tkink that someone else have the same exprience like you #72

the odd thing is that it worked when i run it the first time (after configure everything on this computer), but when i stop and want to start it one more time i always have this error.

[QuadTog]

Error still here; cannot fix :|

I just tried setting pg_hba.conf to:
host all all IP/32 trust

Still not working :(

[Brideau]

@acmt @QuadTog I just made some changes that allow you to set these parameters in a config file instead of via the command line. Can you try the newest version, and put your settings in config.js and let me know how it goes?

[acmt]

I will try and let you know - but I dont have time for this now - i will check it at weekend

[Pistachio9]

I'm getting a similar error. I tried using the newest version with the config.js file set up but still having issues.

Error running query { [error: column "undefined" does not exist]
name: 'error',
length: 103,,
severity: 'ERROR',
code: '42703',
detail: undefined,
hint: undefined,
position: '431',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column, undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '3090',
routine: 'errorMissingColumn'}

btw, I just set this up yesterday and it seemed to run fine for a couple of hours. This error popped up after I ran the scanner overnight.
Since I set up yesterday and I have the "lured" column in my database I'm assuming my installation is up to date with all of the patches.

Edit: Looked into problem #72 and this is what I get when I uncomment that query_string line
INSERT INTO spotted_pokemon ( encounter_id, last_modified_time, time_until_hidden_ms, hidden_time_unix_s, hidden_time_utc, spawnpoint_id, longitude, latitude, pokemon_id, longitude_jittered, latitude_jittered, pokemon_go_era, lured) VALUES ( '18446744072287771420'::text, undefined::bigint, null::bigint, 1470768054::bigint, '2016-08-09 18:40:54'::timestamp, 'undefined'::text, -114.067758::double precision, 51.045624::double precision, 21::smallint, -114.06758149982942::double precision, 51.04553946576027::double precision, 3::integer, 'Lured'::text ) ON CONFLICT (encounter_id, spawnpoint_id) DO UPDATE SET last_modified_time = EXCLUDED.last_modified_time, time_until_hidden_ms = EXCLUDED.time_until_hidden_ms, hidden_time_unix_s = EXCLUDED.hidden_time_unix_s, hidden_time_utc = EXCLUDED.hidden_time_utc;

Also every once in a while it still says "Pokemon with ID xx found." Does that mean this error only shows up for specific pokemon?

[Brideau]

It looks like it's missing the last_modified_time, time_until_hidden_ms and spawn_point_id fields. This was happening before the latest version of the web hook listener was posted yesterday, since it didn't properly handle 'lured' pokemon. Can you check that you have the newest version of app.js and post its contents here?

[Pistachio9]

I just made sure I had the latest version of app.js but still getting the same issue.
I think you're right... if I run my scanner in an area that I think has no lures (suburbs) I get no errors, if I run it downtown which I assume has a bunch of lures on the errors show up. So it seems like lured pokemon are causing the issue.

What do you mean by "... and post its contents here?"
Do you want me to post the code of the app.js file?

[Brideau]

Yep, post the content itself. It just helps me confirm that the version you're running is the same as mine.