Thread: How to run a SQL mysql.sql file for plugin "rc-calendar"?

Your most likely going to have to recode the query's that are going to the database. In the calendar.php in the plugin folder there are 5 $rcmail->db->query witch have MySQL formatted query's they will have to be reformatted for PostgreSQL.

Originally Posted by skaero

Your most likely going to have to recode the query's that are going to the database. In the calendar.php in the plugin folder there are 5 $rcmail->db->query witch have MySQL formatted query's they will have to be reformatted for PostgreSQL.

Okay, can you please tell me what You mean with the 5 $rcmail->db->query references?

If you look in the calendar plugin folder in the calendar.php and search for "$rcmail->db->query references" you should find the query that are being sent to the database. The problem is the query are formatted for MySQL not PostgreSQL.

Don't need to do any thing just delete the calendar directory with files using ftp
(previous files), download the attachment, uncompress it & upload it to plugins directory, that's it finish.


no need to run mysql file, no errors works 100%

Originally Posted by Theet

I have installed the plugin "calendar":

RoundCube Calendar

In step 3: Run the SQL file in /calendar/SQL/

How do I run this SQL file?

The plugin have I uploaded into:
/volume1/@appstore/MailStation/roundcubemail/plugins/calendar

Then I have a link for the plugin to the calendar like:
/volume1/@appstore/MailStation/target/roundcubemail/config/main.inc.php

$rcmail_config['plugins'] = array(
'emoticons',
'calendar'
);

Now I will see "SERVER ERROR (OK)" after clicking on de button Calendar.
I will see the calendar and above the ERROR.

When I make an appointment, I will get the message "SERVER CURRENTLY NOT AVAILABLE"

In the forum of the rc-calendar they have write:

If the plugin has a SQL folder:

Adjust "Roundcube" Database as shown in the mysql.sql script.
By default MyRoundcube plugins support MySQL database.

Please who wants to help me?

Drop table events on roundcube database, and them use the sql file to create the drop table...

Originally Posted by charan315

Don't need to do any thing just delete the calendar directory with files using ftp
(previous files), download the attachment, uncompress it & upload it to plugins directory, that's it finish.


no need to run mysql file, no errors works 100%

Is possible share calendar?

if you use Rosali's version of calendar (Rosali's plugins), there is possibility to share it.

yes... i use this is. how i can configured to share calendar? levels

Public--all user
Private-- some users

public - make an account, login with RC, go to calendar feed options, enable option read-only or read-write access, copy link in feed URL and paste it to calendar config file.
private - the same as public, but create another account and don't paste it to config file but into user's calendar feed options.