Text only | Text with Images

Roundcube Community Forum

Third Party Contributions => API Based Plugins => Topic started by: pereznicoo on February 11, 2011, 11:14:10 AM

Title: calendar and postgresql
Post by: pereznicoo on February 11, 2011, 11:14:10 AM
when i create the database calendar i have this error :

NOTICE:  CREATE TABLE créera des séquences implicites « events_event_id_seq » pour la colonne serial « events.event_id »
NOTICE:  CREATE TABLE / PRIMARY KEY créera un index implicite « events_pkey » pour la table « events »
NOTICE:  CREATE TABLE créera des séquences implicites « events_cache_event_id_seq » pour la colonne serial « events_cache.event_id »
NOTICE:  CREATE TABLE / PRIMARY KEY créera un index implicite « events_cache_pkey » pour la table « events_cache »
ERREUR:  la relation « events_user_id » existe déjà

after i have error i my interface calendar.
Title: calendar and postgresql
Post by: rosali on February 12, 2011, 02:44:16 AM
http://myroundcube.googlecode.com/files/calendar2.zip

Create database table from scratch, reconfigure it (there are config keys for Postgre) and test it.
Title: calendar and postgresql
Post by: pereznicoo on February 14, 2011, 04:03:07 AM
i try with mysql and i have this error :

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `events_cache` (
  `event_id` int(11) unsigned NOT NULL AUTO_INCREM' at line 30

roundcube work properly but the calendar no
Title: calendar and postgresql
Post by: pereznicoo on February 14, 2011, 04:30:42 AM
Quote from: rosali;33134http://myroundcube.googlecode.com/files/calendar2.zip

Create database table from scratch, reconfigure it (there are config keys for Postgre) and test it.

I am a beginer in database. If i restart from scratch i use postgres.initial.sql for my database. I do modify this file???? or the sql file for calendar???
Text only | Text with Images