Author Topic: calendar and postgresql (Read 22250 times)

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.

rosali · « **Reply #1 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.

pereznicoo · « **Reply #2 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

pereznicoo · « **Reply #3 on:** February 14, 2011, 04:30:42 AM »

Quote from: rosali;33134

http://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???