Fix bug #3: Inserting notes on PostgreSQL

diff --git a/ChangeLog b/ChangeLog
index c7e73b7908fb23873340c76e593b3e66b68c8bda..abbc1eb2fcc2d59a71976132d6d4fdc5f5e8ba78 100644 (file)
--- a/ChangeLog
+++ b/ChangeLog
@@ -3,4 +3,4 @@
        * Fix oauth verification with tomdroid
        * Fix database date field lengths
        * Tomdroid sync works now
        * Fix oauth verification with tomdroid
        * Fix database date field lengths
        * Tomdroid sync works now

-
+       * Fix bug #3: Inserting notes on PostgreSQL

diff --git a/lib/notestorage.php b/lib/notestorage.php
index d80266915da4efdfda5dbd7a33c11e7ea3a08f58..74494176d7856626198291bf314776c3c419fef3 100644 (file)
--- a/lib/notestorage.php
+++ b/lib/notestorage.php
@@ -407,8 +407,8 @@ class NoteStorage
             'note_last_change_date'          => $note->{'last-change-date'},
             'note_last_metadata_change_date' => $note->{'last-metadata-change-date'},
             
             'note_last_change_date'          => $note->{'last-change-date'},
             'note_last_metadata_change_date' => $note->{'last-metadata-change-date'},
             

-            'note_open_on_startup' => $note->{'open-on-startup'},
-            'note_pinned'          => $note->pinned,
+            'note_open_on_startup' => (int) $note->{'open-on-startup'},
+            'note_pinned'          => (int) $note->pinned,

             'note_tags'            => json_encode($note->tags),
 
             'note_last_sync_revision' => $note->{'last-sync-revision'},
             'note_tags'            => json_encode($note->tags),
 
             'note_last_sync_revision' => $note->{'last-sync-revision'},