You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
I have a new installation with node 9.3. I have imported schema to postgresql 9.5 from the default postgres-creation.sql. After authentication however, user gets this error:
An error occured
Error: No Row
Apparently there is no room to join:
miaou=> \dt
List of relations
Schema | Name | Type | Owner
--------+--------------------+-------+-------
public | access_request | table | miaou
public | ban | table | miaou
public | db_version | table | miaou
public | message | table | miaou
public | message_vote | table | miaou
public | ping | table | miaou
public | player | table | miaou
public | player_name_change | table | miaou
public | plugin_player_info | table | miaou
public | pref | table | miaou
public | room | table | miaou
public | room_auth | table | miaou
public | room_tag | table | miaou
public | scm_hook | table | miaou
public | scm_hook_room | table | miaou
public | survey_vote | table | miaou
public | tag | table | miaou
public | watch | table | miaou
(18 rows)
miaou=> SELECT * from room;
id | name | private | listed | dialog | lang | img | description
----+------+---------+--------+--------+------+-----+-------------
(0 rows)
The error stack:
From previous event:
at /home/me/miaou/libs/server.js:25:3
at pass (/home/me/miaou/node_modules/passport/lib/authenticator.js:357:9)
at Authenticator.deserializeUser (/home/me/miaou/node_modules/passport/lib/authenticator.js:362:5)
at SessionStrategy.authenticate (/home/me/miaou/node_modules/passport/lib/strategies/session.js:60:10)
at attempt (/home/me/miaou/node_modules/passport/lib/middleware/authenticate.js:361:16)
at authenticate (/home/me/miaou/node_modules/passport/lib/middleware/authenticate.js:362:7)
at Layer.handle [as handle_request] (/home/me/miaou/node_modules/express/lib/router/layer.js:95:5)
at trim_prefix (/home/me/miaou/node_modules/express/lib/router/index.js:317:13)
at /home/me/miaou/node_modules/express/lib/router/index.js:284:7
at Function.process_params (/home/me/miaou/node_modules/express/lib/router/index.js:335:12)
at next (/home/me/miaou/node_modules/express/lib/router/index.js:275:10)
at initialize (/home/me/miaou/node_modules/passport/lib/middleware/initialize.js:53:5)
at Layer.handle [as handle_request] (/home/me/miaou/node_modules/express/lib/router/layer.js:95:5)
at trim_prefix (/home/me/miaou/node_modules/express/lib/router/index.js:317:13)
at /home/me/miaou/node_modules/express/lib/router/index.js:284:7
at Function.process_params (/home/me/miaou/node_modules/express/lib/router/index.js:335:12)
at next (/home/me/miaou/node_modules/express/lib/router/index.js:275:10)
at /home/me/miaou/node_modules/express-session/index.js:489:7
at Command.callback (/home/me/miaou/node_modules/connect-redis/lib/connect-redis.js:167:14) message: 'No Row' }
Unexpectedly Missing Row in
select id, name, img, description, private, listed, dialog, lang, auth, (select array(select tag from room_tag where room=689)) as tags from room left join room_auth a on a.room=room.id and a.player=4 where room.id=689
How to fix this?
Thanks in advance.
The text was updated successfully, but these errors were encountered:
Hi,
I have a new installation with node 9.3. I have imported schema to postgresql 9.5 from the default postgres-creation.sql. After authentication however, user gets this error:
Apparently there is no room to join:
The error stack:
How to fix this?
Thanks in advance.
The text was updated successfully, but these errors were encountered: