[sticky_notes] - Enter one-line summary

[GoogleCodeExporter]

Token: c775f3f5edd408dc1248953d535b0341 (Don't modify this token!)
Version: 5.1.17 (12-04-2015)
PHP: 5.5.20
RCMAIL: 1.1.1
Database: 
SERVER: Apache
----
I.  Issue Description: After adding this plugin, I cannot see already existing 
notes.

II. Steps to reproduce the Issue:
1. Installing plugin
2. Copy config.inc.php.dist to config.inc.php
3. Logging in

I can see the "Notes" folder and alreadx existing notes in it. But when I click 
into the notes Icon in the top bar I cannot see or create any notes.

Original issue reported on code.google.com by realriot on 17 Apr 2015 at 9:15

Attachments:

• notes1.jpg
• notes2.jpg
• notes3.jpg

[GoogleCodeExporter]

Your issue description is far too vague to deal with. Check logs and javascript 
console. As a proof of concept that the plugin is know to work, please test @ 
https://s2.myroundcube.com.

Re-open ticket if you can provide any useful debug information.

Original comment by myroundc...@gmail.com on 17 Apr 2015 at 9:39

• Changed state: Worksforme

[GoogleCodeExporter]

After looking into the errorlog I could find the following error regarding the 
sticky_notes plugin:

[20-Apr-2015 16:17:59 +0200]: <42o5pqj3> DB Error: [1] table notes has no 
column named timestamp (SQL Query: INSERT INTO notes
       ("user_id", "nid", "identifier", "pos_x", "pos_y", "text", "timestamp")
       VALUES ('1', '1', 'EE5748FD-53197F2B-D49227B1', '0', '0', 'a:3:{i:0;s:4:"Test";i:1;s:4:"Test";i:2;s:0:"";}', '2015-04-20 14:17:59')) in /Library/Server/Web/Data/Sites/Default/mail/program/lib/Roundcube/rcube_db.php on line 543 (POST /mail/?_task=dummy&_action=plugin.sticky_notes_new_sticky_note?_task=&_action=)

Original comment by realriot on 20 Apr 2015 at 2:18

[GoogleCodeExporter]

For some reason your notes database table scheme it not as it should be.

In order to fix this please execute SQL script in ./plugins/sticky_notes/SQL 
(first *.initial.sql followed by *.[date].sql ASCENDING).

Please use MyRoundcube forum in future (https://forum.myroundcube.com). Your 
request is a support request and not a bug report. This is a bug tracker ONLY.

Original comment by myroundc...@gmail.com on 20 Apr 2015 at 2:36

• Changed state: Invalid

[GoogleCodeExporter]

Ok thanks anyways!

In the sqlite.20130518.sql there's a drop statement for the table "notes" and 
afterwards, within the create statement, the timestamp field is missing.

I've added a forum thread:
https://forum.myroundcube.com/topic/353-sticky-notes-not-working/

Greets
Sascha

Original comment by realriot on 20 Apr 2015 at 6:10

[GoogleCodeExporter]

The "create table" statement for "notes" within the file sqlite.20130518.sql 
should be:

CREATE TABLE 'notes' (
  'id' INTEGER NOT NULL PRIMARY KEY ,
  'nid' INTEGER NOT NULL ,
  'pos_x' INTEGER ,
  'pos_y' INTEGER ,
  'text' TEXT ,
  'user_id' INTEGER NOT NULL ,
  'datetime' DATETIME ,
  'identifier' VARCHAR ( 255 ) ,
  'uid' VARCHAR ( 255 ) ,
  'sender' VARCHAR ( 255 ),
  'timestamp' DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT 'notes_ibfk_1' FOREIGN KEY ('user_id') REFERENCES 'users' ('user_id') ON DELETE CASCADE ON UPDATE CASCADE
) ;

No further errors within the error log and all existing notes appeared.

Original comment by realriot on 20 Apr 2015 at 6:40

[GoogleCodeExporter]

Thanks!

Original comment by myroundc...@gmail.com on 21 Apr 2015 at 3:25