1. Alexis Colon Lugo
  2. Valentina Server
  3. Friday, July 12 2019, 01:54 PM
  4.  Subscribe via email
Dim sqlLocation As Text = App.mSessionURL + "/sql_fast"
mSQLSocket.Start( App.mHost, App.mSessionID, sqlLocation, "SQLite", "ipadcrnew.db", " Insert into main(socionum,name,last_name,cell,address) value ( '2' , 'jose' , 'lugo' , 'abc' , 'jajaj' );";)
Comment
There are no comments made yet.
Alexis Colon Lugo Accepted Answer
thanks
now works it was the database extension was missing
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Alexis,

That is correct.

If you get an error about insert command you can erase and retype " Insert" part with quotes.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 2
Alexis Colon Lugo Accepted Answer
I don't understand now is that.
can you show line example
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 3
Sergey Pashkov Accepted Answer
Noticed a syntax error here:
"address) value ( '2'"
Must be values

What is the error message?
If it is about "Near "INSERT" syntax error", then you should retype beginning of the SQL query

Dim sqlLocation As Text = App.mSessionURL + "/sql_fast"
mSQLSocket.Start( App.mHost, App.mSessionID, sqlLocation, "SQLite", "ipadcrnew.db", " Insert into

Try to retype " Insert into" - there can be an invisible character.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 4
Alexis Colon Lugo Accepted Answer
I have an error the name of one of col no have in the table but is there in the dDB
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 5
Alexis Colon Lugo Accepted Answer
Dim sqlLocation As Text = App.mSessionURL + "/sql_fast"
Dim StrSql As Text
Dim v1 As Text
Dim v2 As Text
Dim v3 As Text
Dim v4 As Text
Dim v5 As Text

v1="2"
v2="Jose"
v3="Appellido"
v4="Casa"
v5="local"
StrSql=" INSERT INTO main(socionum,name,last_name,cell,address) VALUES ('" + v1 + "','"+ v2 + "','" + v3 + "','" + v4 + "','" + v5 + "')"
mSQLSocket.Start( App.mHost, App.mSessionID, sqlLocation, "SQLite", "ipadcrnew.db", StrSql)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 6
Alexis Colon Lugo Accepted Answer
BEGIN;

-- CREATE TABLE "main" -----------------------------------------
CREATE TABLE "main"(
"socionum" Text NOT NULL,
"name" Text NOT NULL,
"last_name" Text NOT NULL,
"cell" Text,
"address" Text,
CONSTRAINT "unique_socionum" UNIQUE ( "socionum" ) );
-- -------------------------------------------------------------

COMMIT;
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 7
Sergey Pashkov Accepted Answer
Please attach the original log file from a server.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 8
Alexis Colon Lugo Accepted Answer
pi@raspberrypi:/opt/VServer/vlogs $ sudo cat vserver_20190712_090517.log
2019-07-12 09:05:17.651222 (TID 1996049872): Database engine inited
2019-07-12 09:05:17.658448 (TID 1996049872): REST SSL port ignored - no rest SSL certificate.
2019-07-12 09:05:17.677594 (TID 1996049872): REST server started
Licence license_lin_4440801612235611 is registered to Alexis Colon Lugo.
Valid until 9999-12-31. Subscription valid until 2020-07-02.


/*************************************************************************************/
vServer name : vserver
vServer version : 9.3.1
vKernel version : 9.3.1
vServer arch : x32
vKernel type : internally-synched type (MT)
SQLite lib version : 3.26.0

HOSTINGMODE : false
ACCESSCONTROLLIST :
SINGLECONNECTIONPERLOGIN : false
LICENSECATALOG : licenses
SYSTEMCATALOG : databases
SYSTEMBACKUPCATALOG :
SYSTEMPROJECTCATALOG : projects
USEOLDPASSWORDS : false
FLUSHEACHDATACHANGES : false
PRIVILEGESENABLE : false
DISABLEDNS : true
BACKLOG : 20
THREADS : 5
MAXIDLECLIENTTIMEOUT : 20
MAXEXECUTIONCLIENTTIMEOUT : 0
MAXCONNECTIONTIMEOUT : 20
MAXTRANSFERTIMEOUT : 20
INITSLEEPTIME : 0
SLAVEMODE : false
EARLYOPENINGDATABASES : false
SQLITESYSTEMCATALOG : databases_sqlite
BONJOURENABLE : true
SCHEDULEENABLE : false
CACHESIZE : 10
MAILENABLE : false
LOGTOCONSOLE : true
LOGTOFILE : true
LOGTOSYSLOG : false
LOGFILESLOCATION : vlogs
LOGCONNECTIONTRAFFIC : false
VERBOSELEVEL : 2
CRASH_REPORTER_SEND : true
CRASH_REPORTER_OWNER_NAME : (null)
CRASH_REPORTER_OWNER_EMAIL : (null)
CRASH_REPORTER_LAST_CRASH : (null)

Maximum number of Valentina connections : 5
Maximum number of Sqlite connections : 10
Maximum number of REST connections : 5

Valentina Non-secure port : 15432
Valentina SSL port : 15434
Sqlite port : 15532
Sqlite SSL port : 15534
REST port : 1970
REST_SSL port : 1973
SNMP port : 15161
Notification port : 15436

WARNING: Owner name and email are missing in the INI file. It is highly recommended to fill this in to let the Valentina team contact you in case the server crashes.
2019-07-12 09:05:21.888829 (TID 1996049872): ERROR: Cannot initialize bonjour service (error code 2887d)
2019-07-12 09:05:26.764217 (TID 1996049872): ERROR: Cannot initialize bonjour service (error code 2887d)
2019-07-12 09:05:29.764917 (TID 1996049872): ERROR: Cannot initialize bonjour service (error code 2887d)
2019-07-12 09:05:32.765762 (TID 1996049872): ERROR: Cannot initialize bonjour service (error code 2887d)

2019-07-12 09:05:32.766756 (TID 1996049872): VProject facilities are available
2019-07-12 09:05:32.766882 (TID 1996049872): Server started

2019-07-12 09:37:45.013312 (TID 1765786416): (UID 20) Connection established with '10.123.0.6:52766'. ( vSqlite-connections count: '0')
2019-07-12 09:37:45.015990 (TID 1732215600): (UID 20) Closing connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 09:37:46.879345 (TID 1749001008): (UID 20) Connection established with '10.123.0.6:52770'. ( vSqlite-connections count: '0')
2019-07-12 09:37:46.883925 (TID 1765786416): (UID 20) vSqlite-connection established. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 09:37:46.889302 (TID 1765786416): (UID 20) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-07-12 09:37:46.923060 (TID 1749001008): (UID 20) SqlConnection object created.
2019-07-12 09:37:46.959254 (TID 1732215600): (UID 20) Opening SqliteDatabase 'ipadcr.db': OK
2019-07-12 09:37:46.959482 (TID 1732215600): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 15809400 registered.
2019-07-12 09:37:46.963444 (TID 1749001008): (UID 20) Opening SqliteDatabase 'iPadProjects.db': OK
2019-07-12 09:37:46.963681 (TID 1749001008): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1832980232 registered.
2019-07-12 09:37:46.968031 (TID 1765786416): (UID 20) Opening SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 09:37:46.968229 (TID 1765786416): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 1811980472 registered.
2019-07-12 09:37:53.413680 (TID 1732215600): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 16071808 registered.
2019-07-12 09:37:53.429573 (TID 1732215600): (UID 20) SqliteCursor remoteID 15980984 registered.
2019-07-12 09:37:53.441643 (TID 1765786416): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 09:37:53.450410 (TID 1732215600): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 16071808 unregistered.
2019-07-12 09:37:53.450621 (TID 1732215600): (UID 20) SqliteCursor remoteID 15980984 unregistered.
2019-07-12 09:37:54.204699 (TID 1749001008): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1832986600 registered.
2019-07-12 09:37:54.210395 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832986832 registered.
2019-07-12 09:37:54.217361 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 09:37:54.221244 (TID 1749001008): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1832986600 unregistered.
2019-07-12 09:37:54.221438 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832986832 unregistered.
2019-07-12 09:37:54.284585 (TID 1749001008): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 1832986992 registered.
2019-07-12 09:37:54.291738 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832981016 registered.
2019-07-12 09:37:54.299953 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 09:37:54.304093 (TID 1749001008): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 1832986992 unregistered.
2019-07-12 09:37:54.304301 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832981016 unregistered.
2019-07-12 09:41:45.576127 (TID 1732215600): (UID 24) Connection established with '10.123.0.6:52780'. ( vSqlite-connections count: '1')
2019-07-12 09:41:45.578563 (TID 1749001008): (UID 24) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 09:45:45.563474 (TID 1765786416): (UID 24) Connection established with '10.123.0.6:52797'. ( vSqlite-connections count: '1')
2019-07-12 09:45:45.568198 (TID 1749001008): (UID 24) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 09:46:57.612374 (TID 1853694768): (UID 25) REST connection 20892e654aac205efd602227a00bbcb1 established with '10.123.0.6:52845'. ( available: '4')
2019-07-12 09:46:58.703622 (TID 1862087472): Start parsing 'ipadcrnew.db' Access Control List (ACL).
2019-07-12 09:46:58.706500 (TID 1862087472): Finish parsing 'ipadcrnew.db' Access Control List (ACL).
2019-07-12 09:46:58.708601 (TID 1862087472): (UID 25) URI: "/rest/session_20892e654aac205efd602227a00bbcb1;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "value": syntax error".".
2019-07-12 09:47:42.388469 (TID 1843393328): (UID 25) Closing REST connection 20892e654aac205efd602227a00bbcb1. ( available: '5')
2019-07-12 09:48:28.473967 (TID 1832907568): (UID 25) REST connection 1ffdbcd76c93572181502759320f56e7 established with '10.123.0.6:52850'. ( available: '4')
2019-07-12 09:49:53.284844 (TID 1749001008): (UID 24) Connection established with '10.123.0.6:52857'. ( vSqlite-connections count: '1')
2019-07-12 09:49:53.287906 (TID 1732215600): (UID 24) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 09:50:14.454620 (TID 1803543344): (UID 27) REST connection 0cdbbf68d53e591823a44174c56c2694 established with '10.123.0.6:52862'. ( available: '3')
2019-07-12 09:50:19.983471 (TID 1822421808): (UID 27) URI: "/rest/session_0cdbbf68d53e591823a44174c56c2694;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "value": syntax error".".
2019-07-12 09:53:59.966880 (TID 1757393712): (UID 24) Connection established with '10.123.0.6:52937'. ( vSqlite-connections count: '1')
2019-07-12 09:53:59.968534 (TID 1732215600): (UID 24) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 09:57:59.977995 (TID 1732215600): (UID 24) Connection established with '10.123.0.6:52978'. ( vSqlite-connections count: '1')
2019-07-12 09:57:59.982123 (TID 1740608304): (UID 24) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 10:01:59.982229 (TID 1732215600): (UID 24) Connection established with '10.123.0.6:53023'. ( vSqlite-connections count: '1')
2019-07-12 10:01:59.984382 (TID 1740608304): (UID 24) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 10:04:23.711999 (TID 1732215600): (UID 20) Closing SqliteDatabase 'ipadcr.db': OK
2019-07-12 10:04:23.712264 (TID 1732215600): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 15809400 unregistered.
2019-07-12 10:04:23.712427 (TID 1732215600): (UID 20) Closing SqliteDatabase 'iPadProjects.db': OK
2019-07-12 10:04:23.712664 (TID 1732215600): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1832980232 unregistered.
2019-07-12 10:04:23.712820 (TID 1732215600): (UID 20) Closing SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 10:04:23.712917 (TID 1732215600): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 1811980472 unregistered.
2019-07-12 10:04:23.728535 (TID 1732215600): (UID 20) Closing vSqlite-connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 10:04:36.026683 (TID 1774179120): (UID 21) REST connection 9f9206d736d2cbe37b880b060419b4e1 established with '10.123.0.6:53183'. ( available: '2')
2019-07-12 10:04:53.897545 (TID 1782571824): (UID 21) URI: "/rest/session_9f9206d736d2cbe37b880b060419b4e1;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "value": syntax error".".
2019-07-12 10:06:19.337051 (TID 1790964528): (UID 22) REST connection 79e1e3e95f1ada59908212f8e00e3096 established with '10.123.0.6:53208'. ( available: '1')
2019-07-12 10:06:32.100952 (TID 1862087472): (UID 22) URI: "/rest/session_79e1e3e95f1ada59908212f8e00e3096;/sql_fast". Error - "Sqlite db "ipadcrnew.db": Error : "near "value": syntax error".".
2019-07-12 10:07:04.885733 (TID 1843393328): (UID 23) REST connection 82d2b809761d06ffaa6b62e346bbaaac established with '10.123.0.6:53232'. ( available: '0')
2019-07-12 10:07:06.035222 (TID 1832907568): (UID 23) URI: "/rest/session_82d2b809761d06ffaa6b62e346bbaaac;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "value": syntax error".".
2019-07-12 10:08:42.460399 (TID 1878872880): (UID 25) Closing REST connection 1ffdbcd76c93572181502759320f56e7. ( available: '1')
2019-07-12 10:10:22.462071 (TID 1878872880): (UID 27) Closing REST connection 0cdbbf68d53e591823a44174c56c2694. ( available: '2')
2019-07-12 10:25:02.472699 (TID 1878872880): (UID 21) Closing REST connection 9f9206d736d2cbe37b880b060419b4e1. ( available: '3')
2019-07-12 10:26:42.474467 (TID 1878872880): (UID 22) Closing REST connection 79e1e3e95f1ada59908212f8e00e3096. ( available: '4')
2019-07-12 10:27:12.475454 (TID 1878872880): (UID 23) Closing REST connection 82d2b809761d06ffaa6b62e346bbaaac. ( available: '5')
2019-07-12 13:55:39.071125 (TID 1811936048): (UID 21) REST connection 919c2bd8e66cedee7da400275eedc16d established with '10.123.0.6:55116'. ( available: '4')
2019-07-12 13:55:40.163812 (TID 1803543344): (UID 21) URI: "/rest/session_919c2bd8e66cedee7da400275eedc16d;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "value": syntax error".".
2019-07-12 13:57:39.017970 (TID 1822421808): (UID 22) REST connection db3776a286d5c0b30aee5b12d552df16 established with '10.123.0.6:55142'. ( available: '3')
2019-07-12 13:57:40.063453 (TID 1774179120): (UID 22) URI: "/rest/session_db3776a286d5c0b30aee5b12d552df16;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "VALUE": syntax error".".
2019-07-12 13:59:53.583512 (TID 1790964528): (UID 23) REST connection 15836d02f3de3b2529beebe352c6b7ad established with '10.123.0.6:55162'. ( available: '2')
2019-07-12 14:00:27.425108 (TID 1853694768): (UID 23) URI: "/rest/session_15836d02f3de3b2529beebe352c6b7ad;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "VALUE": syntax error".".
2019-07-12 14:02:18.308856 (TID 1862087472): (UID 24) REST connection 6936875fc80e193319db19c5ef4c1142 established with '10.123.0.6:55185'. ( available: '1')
2019-07-12 14:02:21.836484 (TID 1843393328): (UID 24) URI: "/rest/session_6936875fc80e193319db19c5ef4c1142;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "table main has no column named socionum".".
2019-07-12 14:02:44.189710 (TID 1740608304): (UID 20) Connection established with '10.123.0.6:55192'. ( vSqlite-connections count: '0')
2019-07-12 14:02:44.193216 (TID 1757393712): (UID 20) Closing connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 14:02:45.558703 (TID 1765786416): (UID 20) Connection established with '10.123.0.6:55196'. ( vSqlite-connections count: '0')
2019-07-12 14:02:45.562076 (TID 1749001008): (UID 20) vSqlite-connection established. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 14:02:45.563165 (TID 1749001008): (UID 20) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-07-12 14:02:45.588555 (TID 1765786416): (UID 20) SqlConnection object created.
2019-07-12 14:02:45.607945 (TID 1732215600): (UID 20) Opening SqliteDatabase 'ipadcr.db': OK
2019-07-12 14:02:45.608074 (TID 1732215600): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 15809976 registered.
2019-07-12 14:02:45.610871 (TID 1765786416): (UID 20) Opening SqliteDatabase 'iPadProjects.db': OK
2019-07-12 14:02:45.610983 (TID 1765786416): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1811984392 registered.
2019-07-12 14:02:45.613832 (TID 1749001008): (UID 20) Opening SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 14:02:45.613961 (TID 1749001008): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 1832986296 registered.
2019-07-12 14:02:47.924693 (TID 1749001008): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1832978496 registered.
2019-07-12 14:02:47.932289 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832954392 registered.
2019-07-12 14:02:47.940421 (TID 1765786416): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:02:47.946003 (TID 1749001008): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1832978496 unregistered.
2019-07-12 14:02:47.946221 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832954392 unregistered.
2019-07-12 14:02:49.616230 (TID 1749001008): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1832986136 registered.
2019-07-12 14:02:49.621856 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832978832 registered.
2019-07-12 14:02:49.629127 (TID 1765786416): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:02:49.634209 (TID 1765786416): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1832986136 unregistered.
2019-07-12 14:02:49.634414 (TID 1765786416): (UID 20) SqliteCursor remoteID 1832978832 unregistered.
2019-07-12 14:02:49.674485 (TID 1765786416): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 1811981288 registered.
2019-07-12 14:02:49.679933 (TID 1765786416): (UID 20) SqliteCursor remoteID 1811987344 registered.
2019-07-12 14:02:49.687310 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:02:49.690477 (TID 1765786416): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 1811981288 unregistered.
2019-07-12 14:02:49.690672 (TID 1765786416): (UID 20) SqliteCursor remoteID 1811987344 unregistered.
2019-07-12 14:04:04.865828 (TID 1832907568): (UID 29) REST connection 833c179ee8e58e8f6ef0dddab37d319f established with '10.123.0.6:55208'. ( available: '0')
2019-07-12 14:04:07.859553 (TID 1811936048): (UID 29) URI: "/rest/session_833c179ee8e58e8f6ef0dddab37d319f;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "table main has no column named socionum".".
2019-07-12 14:06:11.305751 (TID 1749001008): (UID 20) Closing SqliteDatabase 'ipadcr.db': OK
2019-07-12 14:06:11.306012 (TID 1749001008): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 15809976 unregistered.
2019-07-12 14:06:11.306159 (TID 1749001008): (UID 20) Closing SqliteDatabase 'iPadProjects.db': OK
2019-07-12 14:06:11.306257 (TID 1749001008): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1811984392 unregistered.
2019-07-12 14:06:11.306380 (TID 1749001008): (UID 20) Closing SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 14:06:11.306475 (TID 1749001008): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 1832986296 unregistered.
2019-07-12 14:06:11.334512 (TID 1749001008): (UID 20) Closing vSqlite-connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 14:15:42.616687 (TID 1878872880): (UID 21) Closing REST connection 919c2bd8e66cedee7da400275eedc16d. ( available: '1')
2019-07-12 14:18:02.618798 (TID 1878872880): (UID 22) Closing REST connection db3776a286d5c0b30aee5b12d552df16. ( available: '2')
2019-07-12 14:20:32.620988 (TID 1878872880): (UID 23) Closing REST connection 15836d02f3de3b2529beebe352c6b7ad. ( available: '3')
2019-07-12 14:22:22.622823 (TID 1878872880): (UID 24) Closing REST connection 6936875fc80e193319db19c5ef4c1142. ( available: '4')
2019-07-12 14:24:32.624731 (TID 1878872880): (UID 29) Closing REST connection 833c179ee8e58e8f6ef0dddab37d319f. ( available: '5')
2019-07-12 14:32:58.513238 (TID 1822421808): (UID 21) REST connection dc159c14da2e1d621627f43efa22f1e8 established with '10.123.0.6:55453'. ( available: '4')
2019-07-12 14:33:04.383398 (TID 1774179120): (UID 21) URI: "/rest/session_dc159c14da2e1d621627f43efa22f1e8;/sql_fast". Error - "Sqlite db "ipadcrnew.db": Error : "table main has no column named socionum".".
2019-07-12 14:34:46.830366 (TID 1782571824): (UID 22) REST connection bbaa76c0338ac07a3923f480b4f0dbc3 established with '10.123.0.6:55467'. ( available: '3')
2019-07-12 14:35:06.431396 (TID 1790964528): (UID 22) URI: "/rest/session_bbaa76c0338ac07a3923f480b4f0dbc3;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "near "Where": syntax error".".
2019-07-12 14:37:20.139602 (TID 1853694768): (UID 23) REST connection db8db018044b34eca272a23b6d71f9a6 established with '10.123.0.6:55482'. ( available: '2')
2019-07-12 14:38:01.841587 (TID 1862087472): (UID 24) REST connection 417ba4fc1ca84c133a516c81f3da1fc1 established with '10.123.0.6:55490'. ( available: '1')
2019-07-12 14:39:04.352124 (TID 1843393328): (UID 25) REST connection 4a73acf8b8a1edc8d7350ad75abb1ea7 established with '10.123.0.6:55498'. ( available: '0')
2019-07-12 14:39:16.736747 (TID 1832907568): (UID 25) URI: "/rest/session_4a73acf8b8a1edc8d7350ad75abb1ea7;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "table main has no column named socionum".".
2019-07-12 14:39:48.610818 (TID 1765786416): (UID 20) Connection established with '10.123.0.6:55503'. ( vSqlite-connections count: '0')
2019-07-12 14:39:48.612986 (TID 1749001008): (UID 20) Closing connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 14:39:49.698804 (TID 1757393712): (UID 20) Connection established with '10.123.0.6:55508'. ( vSqlite-connections count: '0')
2019-07-12 14:39:49.701634 (TID 1732215600): (UID 20) vSqlite-connection established. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 14:39:49.703478 (TID 1732215600): (UID 20) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-07-12 14:39:49.732601 (TID 1757393712): (UID 20) SqlConnection object created.
2019-07-12 14:39:49.755946 (TID 1749001008): (UID 20) Opening SqliteDatabase 'ipadcr.db': OK
2019-07-12 14:39:49.756171 (TID 1749001008): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 1832980216 registered.
2019-07-12 14:39:49.759473 (TID 1757393712): (UID 20) Opening SqliteDatabase 'iPadProjects.db': OK
2019-07-12 14:39:49.759651 (TID 1757393712): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1822477008 registered.
2019-07-12 14:39:49.763277 (TID 1732215600): (UID 20) Opening SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 14:39:49.763482 (TID 1732215600): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 15800032 registered.
2019-07-12 14:39:51.303670 (TID 1749001008): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1832960136 registered.
2019-07-12 14:39:51.310711 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832962464 registered.
2019-07-12 14:39:51.319219 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "iPadProjects.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:39:51.325324 (TID 1749001008): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1832960136 unregistered.
2019-07-12 14:39:51.325535 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832962464 unregistered.
2019-07-12 14:39:52.162854 (TID 1749001008): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1832977952 registered.
2019-07-12 14:39:52.169950 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832974216 registered.
2019-07-12 14:39:52.178306 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:39:52.182452 (TID 1749001008): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1832977952 unregistered.
2019-07-12 14:39:52.182785 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832974216 unregistered.
2019-07-12 14:39:53.758940 (TID 1749001008): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1832978200 registered.
2019-07-12 14:39:53.764740 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832973736 registered.
2019-07-12 14:39:53.772366 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:39:53.776108 (TID 1749001008): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1832978200 unregistered.
2019-07-12 14:39:53.776320 (TID 1749001008): (UID 20) SqliteCursor remoteID 1832973736 unregistered.
2019-07-12 14:39:53.818560 (TID 1732215600): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 15799832 registered.
2019-07-12 14:39:53.825274 (TID 1732215600): (UID 20) SqliteCursor remoteID 15800200 registered.
2019-07-12 14:39:53.833409 (TID 1757393712): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:39:53.837937 (TID 1732215600): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 15799832 unregistered.
2019-07-12 14:39:53.838757 (TID 1732215600): (UID 20) SqliteCursor remoteID 15800200 unregistered.
2019-07-12 14:40:05.023567 (TID 1749001008): (UID 20) Closing SqliteDatabase 'ipadcr.db': OK
2019-07-12 14:40:05.023831 (TID 1749001008): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 1832980216 unregistered.
2019-07-12 14:40:05.023994 (TID 1749001008): (UID 20) Closing SqliteDatabase 'iPadProjects.db': OK
2019-07-12 14:40:05.024110 (TID 1749001008): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1822477008 unregistered.
2019-07-12 14:40:05.025342 (TID 1749001008): (UID 20) Closing SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 14:40:05.025568 (TID 1749001008): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 15800032 unregistered.
2019-07-12 14:40:05.058103 (TID 1749001008): (UID 20) Closing vSqlite-connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 14:45:49.215134 (TID 1732215600): (UID 20) Connection established with '10.123.0.6:55678'. ( vSqlite-connections count: '0')
2019-07-12 14:45:49.218393 (TID 1757393712): (UID 20) Closing connection. ( vSqlite-connections count: '0'. Available: '10')
2019-07-12 14:45:51.133017 (TID 1765786416): (UID 20) Connection established with '10.123.0.6:55682'. ( vSqlite-connections count: '0')
2019-07-12 14:45:51.137534 (TID 1740608304): (UID 20) vSqlite-connection established. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 14:45:51.139146 (TID 1740608304): (UID 20) User: sa. Connection encoding: UTF-16 - LittleEndian.
2019-07-12 14:45:51.165404 (TID 1757393712): (UID 20) SqlConnection object created.
2019-07-12 14:45:51.192126 (TID 1732215600): (UID 20) Opening SqliteDatabase 'ipadcr.db': OK
2019-07-12 14:45:51.192340 (TID 1732215600): (UID 20) SqliteDatabase 'ipadcr.db' remoteID 15798704 registered.
2019-07-12 14:45:51.195995 (TID 1757393712): (UID 20) Opening SqliteDatabase 'iPadProjects.db': OK
2019-07-12 14:45:51.196193 (TID 1757393712): (UID 20) SqliteDatabase 'iPadProjects.db' remoteID 1822471224 registered.
2019-07-12 14:45:51.200428 (TID 1740608304): (UID 20) Opening SqliteDatabase 'ipadcrnew.db': OK
2019-07-12 14:45:51.200623 (TID 1740608304): (UID 20) SqliteDatabase 'ipadcrnew.db' remoteID 1843459744 registered.
2019-07-12 14:45:52.592961 (TID 1757393712): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1822733560 registered.
2019-07-12 14:45:52.600731 (TID 1757393712): (UID 20) SqliteCursor remoteID 1822642616 registered.
2019-07-12 14:45:52.610143 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:45:52.616439 (TID 1757393712): (UID 20) SqliteStatement 'SELECT 0 as 'Temp', * FROM sqlite_master WHERE name NOT LIKE 'sqlite_%' UNION SELECT 1 as 'Temp', * FROM sqlite_temp_master WHERE name NOT LIKE 'sqlite_%'' remoteID 1822733560 unregistered.
2019-07-12 14:45:52.616653 (TID 1757393712): (UID 20) SqliteCursor remoteID 1822642616 unregistered.
2019-07-12 14:45:54.140560 (TID 1757393712): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1822643280 registered.
2019-07-12 14:45:54.146632 (TID 1757393712): (UID 20) SqliteCursor remoteID 1822642184 registered.
2019-07-12 14:45:54.153587 (TID 1732215600): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:45:54.157063 (TID 1757393712): (UID 20) SqliteStatement 'PRAGMA collation_list' remoteID 1822643280 unregistered.
2019-07-12 14:45:54.157332 (TID 1757393712): (UID 20) SqliteCursor remoteID 1822642184 unregistered.
2019-07-12 14:45:54.202731 (TID 1732215600): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 15800608 registered.
2019-07-12 14:45:54.209053 (TID 1732215600): (UID 20) SqliteCursor remoteID 15800328 registered.
2019-07-12 14:45:54.216108 (TID 1740608304): (UID 20) ERROR 0x68500: Sqlite db "ipadcrnew.db": Error : "cannot commit - no transaction is active".
2019-07-12 14:45:54.219636 (TID 1732215600): (UID 20) SqliteStatement 'SELECT stat FROM sqlite_stat1 WHERE tbl='main' LIMIT 1' remoteID 15800608 unregistered.
2019-07-12 14:45:54.219826 (TID 1732215600): (UID 20) SqliteCursor remoteID 15800328 unregistered.
2019-07-12 14:49:58.228458 (TID 1740608304): (UID 29) Connection established with '10.123.0.6:55738'. ( vSqlite-connections count: '1')
2019-07-12 14:49:58.231709 (TID 1757393712): (UID 29) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 14:53:12.644824 (TID 1878872880): (UID 21) Closing REST connection dc159c14da2e1d621627f43efa22f1e8. ( available: '1')
2019-07-12 14:54:07.969901 (TID 1757393712): (UID 21) Connection established with '10.123.0.6:55797'. ( vSqlite-connections count: '1')
2019-07-12 14:54:07.971546 (TID 1740608304): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 14:55:12.646589 (TID 1878872880): (UID 22) Closing REST connection bbaa76c0338ac07a3923f480b4f0dbc3. ( available: '2')
2019-07-12 14:57:22.648394 (TID 1878872880): (UID 23) Closing REST connection db8db018044b34eca272a23b6d71f9a6. ( available: '3')
2019-07-12 14:58:02.649368 (TID 1878872880): (UID 24) Closing REST connection 417ba4fc1ca84c133a516c81f3da1fc1. ( available: '4')
2019-07-12 14:58:17.958219 (TID 1757393712): (UID 21) Connection established with '10.123.0.6:55837'. ( vSqlite-connections count: '1')
2019-07-12 14:58:17.959770 (TID 1732215600): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 14:59:22.650677 (TID 1878872880): (UID 25) Closing REST connection 4a73acf8b8a1edc8d7350ad75abb1ea7. ( available: '5')
2019-07-12 15:01:16.681607 (TID 1811936048): (UID 22) REST connection 272117e4dd5ebc2e098377a1c988fe3c established with '10.123.0.6:55880'. ( available: '4')
2019-07-12 15:01:20.175229 (TID 1803543344): (UID 22) URI: "/rest/session_272117e4dd5ebc2e098377a1c988fe3c;/sql_fast". Error - "Sqlite db "ipadcrnew.db": Error : "table main has no column named socionum".".
2019-07-12 15:02:17.951106 (TID 1740608304): (UID 21) Connection established with '10.123.0.6:55896'. ( vSqlite-connections count: '1')
2019-07-12 15:02:17.953501 (TID 1732215600): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 15:05:03.743968 (TID 1774179120): (UID 24) REST connection e3a21f2d01766c8cdf71c632afa3c41f established with '10.123.0.6:55934'. ( available: '3')
2019-07-12 15:05:07.329127 (TID 1782571824): (UID 24) URI: "/rest/session_e3a21f2d01766c8cdf71c632afa3c41f;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcrnew.db": Error : "table main has no column named socionum".".
2019-07-12 15:06:17.940357 (TID 1732215600): (UID 21) Connection established with '10.123.0.6:55944'. ( vSqlite-connections count: '1')
2019-07-12 15:06:17.941981 (TID 1757393712): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 15:10:27.929910 (TID 1740608304): (UID 21) Connection established with '10.123.0.6:55981'. ( vSqlite-connections count: '1')
2019-07-12 15:10:27.933646 (TID 1757393712): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 15:14:32.881810 (TID 1765786416): (UID 21) Connection established with '10.123.0.6:56233'. ( vSqlite-connections count: '1')
2019-07-12 15:14:32.883818 (TID 1757393712): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 15:18:41.174478 (TID 1732215600): (UID 21) Connection established with '10.123.0.6:56631'. ( vSqlite-connections count: '1')
2019-07-12 15:18:41.177156 (TID 1749001008): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 15:21:42.664814 (TID 1878872880): (UID 22) Closing REST connection 272117e4dd5ebc2e098377a1c988fe3c. ( available: '4')
2019-07-12 15:22:48.630650 (TID 1732215600): (UID 21) Connection established with '10.123.0.6:56718'. ( vSqlite-connections count: '1')
2019-07-12 15:22:48.632506 (TID 1765786416): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
2019-07-12 15:25:12.667738 (TID 1878872880): (UID 24) Closing REST connection e3a21f2d01766c8cdf71c632afa3c41f. ( available: '5')
2019-07-12 15:26:49.958935 (TID 1732215600): (UID 21) Connection established with '10.123.0.6:56809'. ( vSqlite-connections count: '1')
2019-07-12 15:26:49.960821 (TID 1749001008): (UID 21) Closing connection. ( vSqlite-connections count: '1'. Available: '9')
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 9
Sergey Pashkov Accepted Answer
Not copy-pasting the terminal output, please attach the file vserver_20190712_090517.log itself.
Copy-paste doesn't preserve invisible characters we're interested in.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 10
Alexis Colon Lugo Accepted Answer
VS logs
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 11
Sergey Pashkov Accepted Answer
Please try to execute INSERT statement using the REST interface and attach a log with an error about it.
It is necessary to check the query in this log.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 12
Alexis Colon Lugo Accepted Answer
my last rest log
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 13
Sergey Pashkov Accepted Answer
The same problem - invisible characters (Byte Order Mark) before the "socionum".
It is necessary to retype the query including quotes.

Still not sure where these characters come from to the Xojo source, maybe we can get rid of them.
Actually, Valentina engine just ignores them, but SQLite recognizes them as ordinary characters.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 14
Alexis Colon Lugo Accepted Answer
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 15
Alexis Colon Lugo Accepted Answer
so 2019r1 no works or what is the problem i retype all select and insert statement
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 16
Sergey Pashkov Accepted Answer
Then invisible characters were inserted again.
I created an issue in mantis to remove these characters for SQLite.
If you wish you can send me the project, I'll check it with the HEX editor and remove them.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 17
Alexis Colon Lugo Accepted Answer
Ok
so this is an error from XOJO or Valentina SQLite Rest.

thanks
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
It is SQLite problem, but I don't think they will change anything, so we have to erase Byte Order Mark characters either in code or on the server side.

Is the error again about "socionum" column?
If you can send me the project, even clearing sensitive data (password, login), I'll fix it in code.

In the future versions, I think we'll add BOM erasing on the Valentina Server specifically for SQLite.
Comment
There are no comments made yet.
Alexis Colon Lugo Accepted Answer
Ok
If I use Valentina and not Sqlite the rest API shut works without these problems
Comment
There are no comments made yet.
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories