Install fails

[ScientiaFelis]

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

[larspett]

vad vill du att jag gör @ScientiaFelis ?

[ScientiaFelis]

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]

Go for 1

From: Georg @.> Sent: den 1 februari 2024 11:43 To: ScientiaFelis/sebmsR @.> Cc: Lars Pettersson @.>; Assign @.> Subject: Re: [ScientiaFelis/sebmsR] Install fails (Issue #50)

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)

— Reply to this email directly, view it on GitHubhttps://github.com/ScientiaFelis/sebmsR/issues/50#issuecomment-1921026061, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEVQXZAYHE4NZMI4PLYN7HLYRNWUBAVCNFSM6AAAAABCRFVUSWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMRRGAZDMMBWGE. You are receiving this because you were assigned.Message ID: @.**@.>>

[larspett]

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]

BTW The select clause seems very odd

[ScientiaFelis]

@larspett now it does work?

[larspett]

Yes