Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a syntax error in the SQL of the "config pull" mechanism. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
4e699c295b70a5fed670151ddf6e5ab3 |
| User & Date: | drh 2018-06-25 18:17:19 |
Context
|
2018-06-25
| ||
| 18:20 | Fix another SQL error on the receiver side of "fossil config pull" check-in: 0b6d3eaf user: drh tags: trunk | |
| 18:17 | Fix a syntax error in the SQL of the "config pull" mechanism. check-in: 4e699c29 user: drh tags: trunk | |
| 18:13 | Change the schema of the subscriber table to make it compatible with the "fossil config sync" mechanism. Upgrading through this check-in requires running "fossil email reset" to rebuild the email notification schema, and losing subscriber information. check-in: 9040de46 user: drh tags: trunk | |
Changes
Changes to src/configure.c.
589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 |
}
if( (groupMask & CONFIGSET_ALERT)!=0
&& db_table_exists("repository","subscriber")
){
db_prepare(&q, "SELECT mtime, quote(semail),"
" quote(suname), quote(sdigest),"
" quote(sdonotcall), quote(ssub),"
" quote(sctime), quote(smip),"
" FROM subscriber WHERE sverified"
" AND mtime>=%lld", iStart);
while( db_step(&q)==SQLITE_ROW ){
blob_appendf(&rec,
"%lld %s suname %s sdigest %s sdonotcall %s ssub %s"
" sctime %s smip %s",
db_column_int64(&q, 0), /* mtime */
|
| |
589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 |
}
if( (groupMask & CONFIGSET_ALERT)!=0
&& db_table_exists("repository","subscriber")
){
db_prepare(&q, "SELECT mtime, quote(semail),"
" quote(suname), quote(sdigest),"
" quote(sdonotcall), quote(ssub),"
" quote(sctime), quote(smip)"
" FROM subscriber WHERE sverified"
" AND mtime>=%lld", iStart);
while( db_step(&q)==SQLITE_ROW ){
blob_appendf(&rec,
"%lld %s suname %s sdigest %s sdonotcall %s ssub %s"
" sctime %s smip %s",
db_column_int64(&q, 0), /* mtime */
|