webcalendar
webcalendar copied to clipboard
PostgreSQL upgrade fails when upgrading from 1.1.0 to 1.3.0
Hello,
Im trying to do a brand new installation on php 7.4 and postgresql 13.
when i get to step 3.. I do the database structure installation, then it give the following message.
"This appears to be an upgrade from version v1.1.0e-CVS to v1.3.0."... so it gives another button to update database, so, I hit the button and it gives the followings sql errors.. And I cant finish step 3.
Any idea?
Warning: pg_exec(): Query failed: ERROR: column "cal_url" of relation "webcal_nonuser_cals" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cat_color" of relation "webcal_categories" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cal_address" of relation "webcal_user" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cal_birthday" of relation "webcal_user" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cal_enabled" of relation "webcal_user" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: syntax error at or near "TABLE" LINE 1: UPDATE TABLE webcal_user SET cal_enabled = 'Y'; ^ in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cal_last_login" of relation "webcal_user" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cal_telephone" of relation "webcal_user" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: column "cal_title" of relation "webcal_user" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394
Warning: pg_exec(): Query failed: ERROR: relation "webcal_timezones" already exists in /srv/www/htdocs/calendar/includes/dbi4php.php on line 394