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

Originally Posted by skaero

Yes Rosali is another moderator and is also working on the calendar plugin, he may have a better idea if it would work with Postgres SQL.

Will you please inform Rosali about this forum item?
I'm very interested for a solution, because there are more plugins which are working with SQL... Thanks in advance.

I sent him a PM.

Sorry, but I have no knowledge about Postgres database.

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.

Originally Posted by dziobak

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?

'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.

Originally Posted by dziobak

'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!

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 '',
`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?

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