Author Topic: How to run a SQL mysql.sql file for plugin "rc-calendar"?  (Read 20888 times)

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #15 on: March 29, 2010, 07:29:23 AM »
Quote from: dziobak;26433
you can install 'phpPgAdmin' and make in easy way that table in database.
I don't know if there is only sql language used for mysql. If yes, you should contact with author of this plugin.


I don't know You mean phpMyAdmin?  Yes I have installed phpMyAdmin.
Is there a possibillity to install only the calendar part on phpMyAdmin?

How can I make a link to the database with below standing fields?

CREATE TABLE `events` (
  `event_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `start` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `end` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `summary` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY(`event_id`),
  CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`)
    /*!40008
      ON DELETE CASCADE
      ON UPDATE CASCADE */
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;

and something like:

/* database table name */
$rcmail_config['db_table_events'] = 'events';

password and user?

Offline dziobak

  • Full Member
  • ***
  • Posts: 184
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #16 on: March 29, 2010, 08:46:51 AM »
'phpMyAdmin' is a WWW interface for mysql database.
You are using PostgreSQL so you need to work o application designed for this database. If you what to use WWW interface you mus use 'phpPgAdmin'.

The code to create table is designed for mysql database. You must recode if to PostgreSQL database. For example MySQL users AUTO_INCREMENT and in PostgreSQL (if i remember this) is serial.
« Last Edit: March 29, 2010, 08:50:52 AM by dziobak »

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #17 on: March 30, 2010, 02:50:32 AM »
Quote from: dziobak;26447
'phpMyAdmin' is a WWW interface for mysql database.
You are using PostgreSQL so you need to work o application designed for this database. If you what to use WWW interface you mus use 'phpPgAdmin'.

The code to create table is designed for mysql database. You must recode if to PostgreSQL database. For example MySQL users AUTO_INCREMENT and in PostgreSQL (if i remember this) is serial.

I have installed phpPgAdmin yesterday, but I can't login yet because of: "Login disallowed for security reasons".

Now I have to configure phpPgAdmin and I hope, after that login is possible, I can read the sql databases of the Synology...

After that I hope that it is possible to insert the field which are important for the calendar.
Then I think I can use all other plugins which have to use the postgreSQL database.

Thank You that I have learned much more after all Your advices, I hope it will succeeded!
« Last Edit: March 30, 2010, 02:55:58 AM by Theet »

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #18 on: March 30, 2010, 05:51:51 PM »
Now I have installed phpPgAdmin into Synology, it works pritty well!
I can see all PostgreSQL databases and I can edit/add etc.

I cannot import a table, so I have made a table with 8 columns but the calendar is still
not working:

CREATE TABLE `events` (
  1) `event_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  2) `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  3) `start` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  4) `end` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  5) `summary` varchar(255) NOT NULL,
  6) `description` text NOT NULL,
  7) `category` varchar(255) NOT NULL DEFAULT '',
  8) `all_day` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY(`event_id`),
  CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
    REFERENCES `users`(`user_id`)
    /*!40008
      ON DELETE CASCADE
      ON UPDATE CASCADE */
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;

what to do with the last part of this sql sript? CONSTRAINT...to */; ??? How can I tell the table to do this?

Can anybody tell me how I define (commands) the fields above with phpPgAdmin?
« Last Edit: March 31, 2010, 07:27:02 AM by Theet »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #19 on: March 31, 2010, 01:53:24 PM »
Your going to have to convert the database to PostgreSQL here is a guild witch mite help Converting MySQL to PostgreSQL - Wikibooks, collection of open-content textbooks

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #20 on: April 01, 2010, 08:47:33 AM »
Quote from: skaero;26519
Your going to have to convert the database to PostgreSQL here is a guild witch mite help Converting MySQL to PostgreSQL - Wikibooks, collection of open-content textbooks

Thank You, I have take some information from here.
Now I have:

This is okya now! I will not see this error anymore...
Now I will see "SERVER ERROR (OK)" after clicking on de button Calendar.
I will see the calendar and above the ERROR.

but...

The next error comes when I will make an appointment, what is probably wrong here?
When I make an appointment, I will get the message "SERVER CURRENTLY NOT AVAILABLE"

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #21 on: April 01, 2010, 09:42:06 AM »
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.

Offline Theet

  • Jr. Member
  • **
  • Posts: 42
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #22 on: April 01, 2010, 11:17:56 AM »
Quote from: skaero;26555
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?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #23 on: April 03, 2010, 12:26:18 AM »
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.

Offline charan315

  • Jr. Member
  • **
  • Posts: 10
I had solution
« Reply #24 on: June 17, 2010, 01:27:20 PM »
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%
« Last Edit: June 17, 2010, 01:30:34 PM by charan315 »

Offline jcreyesb

  • Newbie
  • *
  • Posts: 4
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #25 on: August 18, 2010, 02:48:49 PM »
Quote from: Theet;26347
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...

Offline jcreyesb

  • Newbie
  • *
  • Posts: 4
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #26 on: August 18, 2010, 02:50:23 PM »
Quote from: charan315;28109
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?

Offline dziobak

  • Full Member
  • ***
  • Posts: 184
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #27 on: August 18, 2010, 03:54:14 PM »
if you use Rosali's version of calendar (Rosali's plugins), there is possibility to share it.

Offline jcreyesb

  • Newbie
  • *
  • Posts: 4
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #28 on: August 18, 2010, 05:48:59 PM »
yes... i use this is. how i can configured to share calendar?  levels

Public--all user
Private-- some users

Offline dziobak

  • Full Member
  • ***
  • Posts: 184
How to run a SQL mysql.sql file for plugin "rc-calendar"?
« Reply #29 on: August 19, 2010, 12:44:31 AM »
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.