how to run the .net C# demo on local computer?

[jqrv]

I've installed the sqlite-sync on my local computer ,which runs windows with apache,mysql and tomcat. when I access http://127.0.0.1:8080/SqliteSync/API3 from chrome,it works correctly as display: API[3.2.7] SQLite-Sync.COM is working correctly! Database connected!

I changed the C# demo code, set wsUrl = "http://127.0.0.1:8080/SqliteSync/API3"; when I click 'Reintialize database' or 'Send and Recieve' button, I always get an error.

the response is ：Error creating new subscriber for UUID 1

I open logo file, There is an error: Table 'testdb.mergesubscribers' doesn't exist. testdb is my database name.

Question is: how to create mergesubscribers??
Isn't it automatic?

[sqlite-sync]

You need to add at least one table to synchronization. https://projects.ampliapps.com/projects/ampli-sync/wiki#AddTable-control-method The missing object will create automatically.

On Sat, Oct 5, 2019 at 7:46 AM jqrv notifications@github.com wrote:

I've installed the sqlite-sync on my local computer ,which runs windows and apache,mysql and tomcat. when I access http://127.0.0.1:8080/SqliteSync/API3 from chrome,it works right as display: API[3.2.7] SQLite-Sync.COM is working correctly! Database connected!

I changed the C# demo code, set wsUrl = " http://127.0.0.1:8080/SqliteSync/API3"; when I click 'Reintialize database' or 'Send and Recieve' button, I always get an error.

the response is ：Error creating new subscriber for UUID 1

I open logo file, There is an error: Table 'testdb.mergesubscribers' doesn't exist. testdb is my database name.

how to create mergesubscribers?? Is it not automatic?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/sqlite-sync/SQLite-sync.com/issues/16?email_source=notifications&email_token=ACNU5N2BNA5WCN65H2XDQA3QNAS3DA5CNFSM4I5WOJKKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HPZ6UIQ, or mute the thread https://github.com/notifications/unsubscribe-auth/ACNU5N5QC7I3GRYB4V4TL4DQNAS3DANCNFSM4I5WOJKA .

-- Best regards Tomek Dziemidowicz E-mail: tomek@dziemidowicz.cloud Take care of the Environment with us! Do not print this message or other documents if it is not necessary.

[jqrv]

Tomek, thank you so much. I add one table to synchronization, the framework works correctly ！It's a great tool!

[sqlite-sync]

Hard to say, but my first guess is, that you are missing somewhere UTC timezone marker. When you making a conversion without taking care of UTC then you will get the wrong date/time.

On Mon, Oct 7, 2019 at 6:23 AM jqrv notifications@github.com wrote:

Tomek, thank you so much. I add one table to synchronization, the framework works！ I add add the ending string to the

&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC Like this:

DB_ENGINE = mysql DBURL = jdbc:mysql:// 127.0.0.1:3306/daxiang?rewriteBatchedStatements=true&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC DBUSER = root DBPASS = root DBDRIVER = com.mysql.cj.jdbc.Driver DATE_FORMAT = yyyy-MM-dd HH:mm:ss HISTORY_DAYS = 7 LOG_LEVEL = 4

But, The Datetime column which received from server, is more 8 hours faster than the server's. local place is beijing,china. Will I How to do? thanks a lots!

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/sqlite-sync/SQLite-sync.com/issues/16?email_source=notifications&email_token=ACNU5NYTB2TG7Y3FG43RISDQNK2UBA5CNFSM4I5WOJKKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAO7LRA#issuecomment-538834372, or mute the thread https://github.com/notifications/unsubscribe-auth/ACNU5N35NTRINXXWEALJ763QNK2UBANCNFSM4I5WOJKA .

[jqrv]

your are right. if the time is not correct, need to edit the config file,set the correct time zone(java).

[man1989]

@sqlite-sync What is the logic behind adding a table for synchronization? I am confused because, this is not linked to any subscriber id