ScientiaFelis/sebmsR

Install fails

Closed this issue · 7 comments

ScientiaFelis commented

Install from github fails.
Error is a cannot load namespace as it could not coerce a S4 class to vector.

larspett commented

vad vill du att jag gör @ScientiaFelis ?

ScientiaFelis commented

This was due to error when server cannot be connected to during install.

Either we:

  1. remove connecting to server and creating pool while loading ( suggested)
    a. this require solving pool error after multiple connections
  2. make sure users know that and have connection before installing (not suggested)
larspett commented
larspett commented

The latest version installs but now there is a major error trying to connect:

Error in postgresqlExecStatement(conn, statement, ...) :
RPosgreSQL error: could not run statement: no connection to the server

Error in postgresqlExecStatement(conn, statement, ...) :
RPosgreSQL error: could not run statement: no connection to the server

In addition: Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
Could not create execute: SELECT 1
Error in group_by():
! Must group by variables found in .data.
Column situid is not found.
Column sitetype is not found.
Run rlang::last_trace() to see where the error occurred.
Warning message:
In postgresqlQuickSQL(conn, statement, ...) :
Could not create execute: WITH reg AS
(SELECT reg_uid AS reg_id, reg_name AS län
FROM reg_region
WHERE reg_uid IN (87,17,303,74,91,338,121,139,78,107,333,326,312,285,13,293,98,314,239,69,131,39,149,217,224,44,332,266,112,248,241,85,46,210,327,101,174,16,201,70,186,240,308,130,290,226,181,222,32,268,323,347,349,29,86,28,205,258,19,150,95,262,118,311,331,270,280,41,173,256,267,182,9,196,202,330,350,176,275,304,97,194,49,37,42,59,286,128,232,253,301,106,336,151,45,30,334,92,140,178,199,289,21,142,145,200,236,56,299,65,124,282,24,82,26,81,337,146,90,228,57,144,300,8,72,154,335,51,164,100,244,14,84,175,276,180,110,15,277,113,261,4,54,273,170,309,213,339,77,219,165,96,172,35,328,43,2,271,317,147,177,340,187,58,11,189,204,83,195,52,250,284,287,99,18,62,324,251,318,38,211,94,132,88,156,20,141,1,320,305,342,67,159,171,346,242,148,153,5,53,152,184,247,134,233,61,34,108,120,274,344,294,60,206,220,160,183,126,193,315,27,307,155,73,179,283,278,343,125,104,105,50,64,129,351,190,3 [... truncated]

larspett commented

BTW The select clause seems very odd

ScientiaFelis commented

@larspett now it does work?

larspett commented

Yes