|
Post by metro on Mar 3, 2019 23:40:32 GMT -5
Have any Linux users run the Simple database.bas code supplied with lb5-347 I get the following error
|
|
|
Post by Rod on Mar 4, 2019 4:19:08 GMT -5
The example fails for me on Win10 second run with an error "Payables already exists" If I remove Records.db it will run again. But it isn't the same error you have.
|
|
|
Post by metro on Mar 4, 2019 6:32:54 GMT -5
Thanks Rod,
I'm not sure if this can be put down to my limited experience but.... if exists= 0 has no effect I have changed it to if exists < 0
I have tried to jump the if exists with > 0 then .... goto [jump]
and failed. (with both win10 and linux) two more lines are added to the Db
|
|
|
Post by metro on Mar 4, 2019 18:23:45 GMT -5
Still scratching my head here. I copied Records.db and the simple database.bas from my Win10 machine to the lb5-347 folder on my Linux machine load and run the bas ...Records.db is detected with the line exists = #accessor hasAnswer() which then drops execution down to input "Press Enter to continue."; a$ pressing enter should then query the Db .......BUT I get the error
I have received the same error with any of the code Dan has posted that tries to access a Db
==2019/3/5==7:01:19==BEGIN RUNTIME DIAGNOSTIC DUMP Note: this file stored in VisualWorks #source (UTF-8) encoding
Cause of Dump: Unhandled exception: Error - : Smalltalk Version: 'VisualWorks®, Pre-Release 8.3.2 (apr18.3) of April 20, 2018' Object Memory versionId: #[172 40 76 176 83 2 3 4 172 47 76 176] Class creating this dump: ErrorDumper ------------------------------------------------------------ Active Process Process named: 'Unnamed Process' Process priority: 50 Process identity hash: 10599 Context Stack: [1] MainwinIOPortal(Object)>>error: [2] MainwinIOPortal>>runtimeError: [3] BranchingProgramDirector(Director)>>runtimeError: [4] [] in BranchingProgramDirector>>innerDirect [5] BlockClosure>>cull: [6] UnableToConnectToSQLenvironment(GenericException)>>performHandler: [7] UnableToConnectToSQLenvironment(GenericException)>>propagatePrivateFrom: [8] UnableToConnectToSQLenvironment(GenericException)>>propagateFrom: [9] UnableToConnectToSQLenvironment(GenericException)>>propagate [10] UnableToConnectToSQLenvironment(GenericException)>>raiseSignal [11] UnableToConnectToSQLenvironment class(GenericException class)>>raise [12] SQLite3Connection>>serverAttachEnvironmentExternal: [13] optimized [] in SQLite3Connection>>acquireExternal: [14] BlockClosure>>ifCurtailed: [15] SQLite3Connection>>acquireExternal: [16] SQLite3Connection(ExternalDatabaseConnection)>>acquire: [17] SQLite3Connection(ExternalDatabaseConnection)>>connect: [18] SQLite3Connection(ExternalDatabaseConnection)>>connect [19] SQLiteAccessor(DatabaseAccessor)>>connect [20] SQLiteConnectFrame>>animate: [21] optimized [] in BranchingProgramDirector>>innerDirect [22] BlockClosure>>on:do: [23] BranchingProgramDirector>>innerDirect [24] BranchingProgramDirector>>direct: [25] BranchingProgramDirector(Director)>>for:direct: [26] BranchingProgramDirector>>for:direct: [27] Program>>runWithDirector: [28] optimized [] in Program>>runForked [29] BlockClosure>>on:do: [30] optimized [] in Process class>>forBlock:priority:
------------------------------------------------------------ Unhandled Exception: class: UnhandledException creator: UnhandledException errorString: Unhandled exception: Error - : parameter: an Error
==2019/3/5==7:01:19==END RUNTIME DIAGNOSTIC DUMP
|
|
|
Post by Chris Iverson on Mar 4, 2019 18:56:35 GMT -5
Uh, I don't think that's the right block from the error log.
I got this error:
==2019/3/4==17:54:59==BEGIN RUNTIME DIAGNOSTIC DUMP Note: this file stored in VisualWorks #source (UTF-8) encoding
Cause of Dump: Unhandled exception: Connection Exception--unable to connect to database environment Smalltalk Version: 'VisualWorks®, Pre-Release 8.3.2 (apr18.3) of April 20, 2018' Object Memory versionId: #[172 40 76 176 83 2 3 4 172 47 76 176] Class creating this dump: ErrorDumper ------------------------------------------------------------ Active Process Process named: 'Unnamed Process' Process priority: 50 Process identity hash: 6462 Context Stack: [1] optimized [] in Director>>direct: [2] BlockClosure>>cull: [3] UnableToConnectToSQLenvironment(GenericException)>>performHandler: [4] UnableToConnectToSQLenvironment(GenericException)>>propagatePrivateFrom: [5] UnableToConnectToSQLenvironment(GenericException)>>propagateFrom: [6] UnableToConnectToSQLenvironment(GenericException)>>propagate [7] UnableToConnectToSQLenvironment(GenericException)>>raiseSignal [8] optimized [] in Director>>direct: [9] BlockClosure>>cull: [10] UnableToConnectToSQLenvironment(GenericException)>>performHandler: [11] UnableToConnectToSQLenvironment(GenericException)>>propagatePrivateFrom: [12] UnableToConnectToSQLenvironment(GenericException)>>propagateFrom: [13] UnableToConnectToSQLenvironment(GenericException)>>propagate [14] UnableToConnectToSQLenvironment(GenericException)>>raiseSignal [15] optimized [] in Director>>direct: [16] BlockClosure>>cull: [17] UnableToConnectToSQLenvironment(GenericException)>>performHandler: [18] UnableToConnectToSQLenvironment(GenericException)>>propagatePrivateFrom: [19] UnableToConnectToSQLenvironment(GenericException)>>propagateFrom: [20] UnableToConnectToSQLenvironment(GenericException)>>propagate [21] UnableToConnectToSQLenvironment(GenericException)>>raiseSignal [22] UnableToConnectToSQLenvironment class(GenericException class)>>raise [23] SQLite3Connection>>serverAttachEnvironmentExternal: [24] optimized [] in SQLite3Connection>>acquireExternal: [25] BlockClosure>>ifCurtailed: [26] SQLite3Connection>>acquireExternal: [27] SQLite3Connection(ExternalDatabaseConnection)>>acquire: [28] SQLite3Connection(ExternalDatabaseConnection)>>connect: [29] SQLite3Connection(ExternalDatabaseConnection)>>connect [30] SQLiteAccessor(DatabaseAccessor)>>connect [31] SQLiteConnectFrame>>animate: [32] optimized [] in [] in Director>>direct: [33] OrderedCollection>>do: [34] optimized [] in Director>>direct: [35] BlockClosure>>on:do: [36] ScopedDirector(Director)>>direct: [37] ScopedDirector>>for:produce:parameters: [38] SubClip(NamedClip)>>animate:parameters: [39] SubClip(NamedClip)>>animate:with: [40] optimized [] in UndefinedObject>>unboundMethod [41] CallFrame>>animate: [42] optimized [] in [] in Director>>direct: [43] OrderedCollection>>do: [44] optimized [] in Director>>direct: [45] BlockClosure>>on:do: [46] Director>>direct: [47] Director>>for:direct: [48] IfThenClip>>animate: [49] optimized [] in [] in Director>>direct: [50] OrderedCollection>>do: [51] optimized [] in Director>>direct: [52] BlockClosure>>on:do: [53] ProgramDirector(Director)>>direct: [54] ProgramDirector>>direct: [55] ProgramDirector(Director)>>for:direct: [56] ProgramDirector>>for:direct: [57] Program>>runWithDirector: [58] optimized [] in Program>>runForked [59] BlockClosure>>on:do: [60] optimized [] in Process class>>forBlock:priority:
------------------------------------------------------------ Unhandled Exception: class: UnhandledException creator: UnhandledException errorString: Unhandled exception: Connection Exception--unable to connect to database environment parameter: an UnableToConnectToSQLenvironment
==2019/3/4==17:54:59==END RUNTIME DIAGNOSTIC DUMP
|
|
|
Post by Carl Gundel on Mar 4, 2019 19:00:17 GMT -5
It looks to me like it isn't connected to the database. Do you have the sqlite3 libraries installed in your computer? Also, remember that this is the 32-bit version of LB5 so if you only have 64-bit sqlite3 libs then this might be a problem. I will plan to include the libraries in the next build, like I have done for Windows in build 347.
|
|
|
Post by metro on Mar 4, 2019 19:00:37 GMT -5
Thanks Chris, I deleted error.log and re-run haven't compared them yet
==2019/3/5==7:58:59==BEGIN RUNTIME DIAGNOSTIC DUMP Note: this file stored in VisualWorks #source (UTF-8) encoding
Cause of Dump: Unhandled exception: Error - : Smalltalk Version: 'VisualWorks®, Pre-Release 8.3.2 (apr18.3) of April 20, 2018' Object Memory versionId: #[172 40 76 176 83 2 3 4 172 47 76 176] Class creating this dump: ErrorDumper ------------------------------------------------------------ Active Process Process named: 'Unnamed Process' Process priority: 50 Process identity hash: 12976 Context Stack: [1] MainwinIOPortal(Object)>>error: [2] MainwinIOPortal>>runtimeError: [3] BranchingProgramDirector(Director)>>runtimeError: [4] [] in BranchingProgramDirector>>innerDirect [5] BlockClosure>>cull: [6] UnableToConnectToSQLenvironment(GenericException)>>performHandler: [7] UnableToConnectToSQLenvironment(GenericException)>>propagatePrivateFrom: [8] UnableToConnectToSQLenvironment(GenericException)>>propagateFrom: [9] UnableToConnectToSQLenvironment(GenericException)>>propagate [10] UnableToConnectToSQLenvironment(GenericException)>>raiseSignal [11] UnableToConnectToSQLenvironment class(GenericException class)>>raise [12] SQLite3Connection>>serverAttachEnvironmentExternal: [13] optimized [] in SQLite3Connection>>acquireExternal: [14] BlockClosure>>ifCurtailed: [15] SQLite3Connection>>acquireExternal: [16] SQLite3Connection(ExternalDatabaseConnection)>>acquire: [17] SQLite3Connection(ExternalDatabaseConnection)>>connect: [18] SQLite3Connection(ExternalDatabaseConnection)>>connect [19] SQLiteAccessor(DatabaseAccessor)>>connect [20] SQLiteConnectFrame>>animate: [21] optimized [] in BranchingProgramDirector>>innerDirect [22] BlockClosure>>on:do: [23] BranchingProgramDirector>>innerDirect [24] BranchingProgramDirector>>direct: [25] BranchingProgramDirector(Director)>>for:direct: [26] BranchingProgramDirector>>for:direct: [27] Program>>runWithDirector: [28] optimized [] in Program>>runForked [29] BlockClosure>>on:do: [30] optimized [] in Process class>>forBlock:priority:
------------------------------------------------------------ Unhandled Exception: class: UnhandledException creator: UnhandledException errorString: Unhandled exception: Error - : parameter: an Error
==2019/3/5==7:58:59==END RUNTIME DIAGNOSTIC DUMP
|
|
|
Post by Chris Iverson on Mar 4, 2019 19:04:08 GMT -5
It looks to me like it isn't connected to the database. Do you have the sqlite3 libraries installed in your computer? Also, remember that this is the 32-bit version of LB5 so if you only have 64-bit sqlite3 libs then this might be a problem. I will plan to include the libraries in the next build, like I have done for Windows in build 347. This was what was gonna be my next question, actually, because I saw you had the SQLite Windows DLL there, and you had the SQLite library in the Linux bundle for RBP. Checking stuff now.
|
|
|
Post by metro on Mar 4, 2019 19:11:09 GMT -5
It looks to me like it isn't connected to the database. Do you have the sqlite3 libraries installed in your computer? Also, remember that this is the 32-bit version of LB5 so if you only have 64-bit sqlite3 libs then this might be a problem. I will plan to include the libraries in the next build, like I have done for Windows in build 347. Would this be all I need ? If so has been installed six months or more EDIT:
Chris, do you mean.....sqlite-3.6.2.so in the linux86 folder ?
Thanks for the help, back in 6 hours (house reno)
|
|
|
Post by Carl Gundel on Mar 4, 2019 19:33:58 GMT -5
Alright, let me figure it out. It isn't working for me either. Don't knock yourself out trying to make this work. Perhaps this is a packaging problem in the build.
|
|
|
Post by Carl Gundel on Mar 5, 2019 13:45:59 GMT -5
Alright, let me figure it out. It isn't working for me either. Don't knock yourself out trying to make this work. Perhaps this is a packaging problem in the build. I haven't figure this out yet, but you should be able to work around this if you have a Windows machine handy to do your testing on. The Sqlite3 functionality seems to be working fine on Windows for build 347.
|
|
|
Post by metro on Mar 5, 2019 17:33:48 GMT -5
Alright, let me figure it out. It isn't working for me either. Don't knock yourself out trying to make this work. Perhaps this is a packaging problem in the build. I haven't figure this out yet, but you should be able to work around this if you have a Windows machine handy to do your testing on. The Sqlite3 functionality seems to be working fine on Windows for build 347. No worries Carl, I've been using the windows version on my linux machine too, I have to put up with a space character between each reserved word and variable though! Also , not sure if this is a bug if you see the code in the editor (screenshot) I have inserted a line to [jump] the creation of the table should Records.db exist that line does nothing , I have tried "<>", "<","<" none of them has an impact
|
|
|
Post by Carl Gundel on Mar 6, 2019 8:33:00 GMT -5
There does seem to be a problem with the file accessor and Linux.
I'm baffled by the appearance of the screenshot you've attached.
|
|
|
Post by metro on Mar 6, 2019 9:08:11 GMT -5
There does seem to be a problem with the file accessor and Linux. I'm baffled by the appearance of the screenshot you've attached. Well it is the windows version running in wine. So it could be a wine issue. Though I've never seen it before with any other software And with a Linux version on the horizon I will be using that.
|
|