Sticky_Notes - Three little bugs

[Drakon]

Hi Rosali,

I save a video with three little bugs on Sticky_Notes plugin:
2011-03-12_2331_Stick_Notes_Bug - Drakonworld's library

Thanks for the plugin!  

Regards,
Drakon.

[rosali]

Thanks for the video. Sticky Notes is a third party jquery pluging which is used by my roundcube plugin. Please report your bugs @ jQuery Sticky Notes | Google Groups

Thank you.

[rosali]

http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/8174-sticky-notes-plugin-refactoring.html

[Drakon]

Very nice!
Thanks Rosali!

Drakon.

[billstif]

I have added sticky_notes in the plugins directory and added it to the plugins array in the main config file.  When I click on the Notes button, a Loading window pops up, but I never get an Add button to add a sticky note.

What am I overlooking?  I have downloaded the latest version of jqueryui I could find, and it is the first plugin listed in my array in the main config file.

[rosali]

Did you install jqueryui plugin?

Did you create the database table for the plugin?

Looking into Roundcube's error log is always a good idea.

[billstif]

How do I create the database table?  That is the step I am missing.

[billstif]

After clicking on the Sticky_Notes icon, this is the resulting entry in the Roundcube Error log:
 
[11-Apr-2011 12:12:16 -0600]: PHP Error: Deprecated hook name. outgoing_message_headers -> message_outgoing_headers in /home4/billstif/public_html/mail/program/include/rcube_plugin_api.php on line 207 (GET /mail/?_task=dummy&_remote=1&_action=keep-alive&_t=1302545535809&_=1302545535809&_unlock=0)
[11-Apr-2011 12:12:16 -0600]: PHP Error: Deprecated hook name. outgoing_message_headers -> message_outgoing_headers in /home4/billstif/public_html/mail/program/include/rcube_plugin_api.php on line 207 (GET /mail/?_task=dummy&_action=plugin.sticky_notes)
[11-Apr-2011 12:12:17 -0600]: PHP Error: Deprecated hook name. outgoing_message_headers -> message_outgoing_headers in /home4/billstif/public_html/mail/program/include/rcube_plugin_api.php on line 207 (POST /mail/?_task=dummy&_action=plugin.sticky_notes_return_sticky_notes?_task=&_action=)
[11-Apr-2011 12:12:17] MDB2 Error: no such table (-18): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_324c082b3f912ef66a1ae08367b6fcbf17960966e FROM 'SELECT * FROM `notes` \r\n WHERE `user_id`=?']
[Native code: 1146]
[Native message: Table 'billstif_rc01.notes' doesn't exist]
 
[11-Apr-2011 12:12:17 -0600]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_324c082b3f912ef66a1ae08367b6fcbf17960966e FROM 'SELECT * FROM `notes` \r\n WHERE `user_id`=?']
[Native code: 1146]
[Native message: Table 'billstif_rc01.notes' doesn't exist]
in /home4/billstif/public_html/mail/program/include/rcube_mdb2.php on line 268 (POST /mail/?_task=dummy&_action=plugin.sticky_notes_return_sticky_notes?_task=&_action=)
[11-Apr-2011 12:13:17 -0600]: PHP Error: Deprecated hook name. outgoing_message_headers -> message_outgoing_headers in /home4/billstif/public_html/mail/program/include/rcube_plugin_api.php on line 207 (GET /mail/?_task=dummy&_remote=1&_action=keep-alive&_t=1302545596900&_=1302545596900&_unlock=0)
[11-Apr-2011 12:14:17 -0600]: PHP Error: Deprecated hook name. outgoing_message_headers -> message_outgoing_headers in /home4/billstif/public_html/mail/program/include/rcube_plugin_api.php on line 207 (GET /mail/?_task=dummy&_remote=1&_action=keep-alive&_t=1302545656882&_=1302545656882&_unlock=0)
[11-Apr-2011 12:15:17 -0600]: PHP Error: Deprecated hook name. outgoing_message_headers -> message_outgoing_headers in /home4/billstif/public_html/mail/program/include/rcube_plugin_api.php on line 207 (GET /mail/?_task=dummy&_remote=1&_action=keep-alive&_t=1302545716864&_=1302545716864&_unlock=0)

 
I'm guessing from this that the main problem is that I haven't created the database table, which I do not know how to do.

[rosali]

How did you create the initial roundcube database tables?

Use f.e. PHPMyAdmin if you are on MySQL and run the script located in the SQL folder.

[billstif]

I used a Simple Scripts installation of Roundcube from HostMonster, which, I suppose, did all of that invisibly for me.

These are the files currently in my Roundcube SQL directory:
mssql.initial.sql
mssql.upgrade.sql
mysql.initial.sql
mysql.update.sql
postgres.initial.sql
postgres.update.sql
sqlite.initial.sql
sqlite.update.sql

Although I have never used them, Hostmonster has the MySQL Database Wizard and the phpMyAdmin tools available to me along with several others.  

Which of the above sql files would I run, and should I use the MySQL Database Wizard or the phpMyAdmin tool?  Or am I in over my head?  LOL

[rosali]

Look into the SQL folder of sticky_notes plugin an run the script for MySQL.

Sorry, no offense but you are asking for basics:


/**
 *
 * Usage: http://mail4us.net/myroundcube/
 *
 **/

[dshepherd]

The SQL file you need to run is located in the SQL directory of the plugin folder, not the RC SQL directory. The path to this directory will be something like /plugins/sitcky_notes/sql.

phpMyAdmin would be a good tool to use to run the script. You can either use the import the script as it is or open in a text editor and copy/paste teh commands into the phpMyAdmin SQL tab.

There is likely only 1 mysql file in the SQL directory and this is the one you need.

[billstif]

No offense taken, Rosali.  Roundcube is my first experience with php or SQL.  I am fumbling my way along. dshepherd--Your advice was the final step I needed.

Thank you all for your help.  I have it running now.  I've been fiddling around with several of the extensions.  Sticky_Notes was the first where I had to run SQL.

I'm used to writing in HTML code, so, while php is strange, I'm not completely lost--thankfully.

[billstif]

I was able to use what I learned from installing sticky_notes to also install Rosali's calendar plugin.