webcalendar icon indicating copy to clipboard operation
webcalendar copied to clipboard

PostgreSQL upgrade fails when upgrading from 1.1.0 to 1.3.0

Open joanventura opened this issue 3 years ago • 0 comments

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

joanventura avatar Oct 16 '21 22:10 joanventura