FUDforum: FUDforum Installation Issues » Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9

Home » FUDforum » FUDforum Installation Issues » Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9

Show: Today's Messages :: Polls :: Message Navigator

Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 [message #168753]

Mon, 15 July 2013 11:50

now_what
Messages: 6
Registered: July 2013

Karma:

Junior Member

upgrade 2.8 -> 3.0.0 ran without trouble.

upgrade.php 3.0.0 -> 3.0.4 complains about postgres 9.1.9 not being newer than the requested version 8.1.0
After fixing include dbadmin.inc, this output:

Create new database table /var/www/FUDforum//sql/fud_custom_fields.tbl.
Create new database table /var/www/FUDforum//sql/fud_pages.tbl.
Add new database column ann_opt to table fud28_announce.
Alter database column ip_addr in table fud28_pmsg.
Alter database column subject in table fud28_pmsg.
Drop unused database column id from table fud28_thread_notify.
Drop unused database index fud28_thread_notify_i_ut from table fud28_thread_notify.
Create composite primary key on fud28_thread_notify(user_id,thread_id).

Warning: pg_query(): Query failed: ERROR: column i.oid does not exist LINE 1: ...D i.thread_id = fud28_thread_notify.thread_id AND i.oid < fu... ^ in /var/www/FUDforum/sql/pgsql/db.inc on line 108

Fatal error: Uncaught exception 'Exception' with message ': ERROR: column i.oid does not exist LINE 1: ...D i.thread_id = fud28_thread_notify.thread_id AND i.oid < fu... ^ @ DELETE FROM fud28_thread_notify WHERE EXISTS (SELECT 1 FROM fud28_thread_notify i WHERE i.user_id = fud28_thread_notify.user_id AND i.thread_id = fud28_thread_notify.thread_id AND i.oid < fud28_thread_notify.oid)' in /var/www/byteplant/forum/upgrade.php:158 Stack trace: #0 /var/www/FUDforum/sql/pgsql/db.inc(108): fud_sql_error_handler('DELETE FROM fud...', 'ERROR: column ...', '', '9.1.9') #1 /var/www/FUDforum/include/dbadmin.inc(589): q('DELETE FROM fud...') #2 /var/www/FUDforum/include/dbadmin.inc(379): delete_duplicate_rows('fud28_thread_no...', 'user_id,thread_...') #3 /var/www/byteplant/forum/upgrade.php(978): create_primary_key('fud28_thread_no...', 'user_id,thread_...') #4 {main} thrown in /var/www/byteplant/forum/upgrade.php on line 158

Thanks for any help!

Report message to a moderator

[Message index]

		Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 15 July 2013 11:50
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Fri, 19 July 2013 14:49
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Fri, 19 July 2013 15:13
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 12 August 2013 16:24
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 17 August 2013 18:20
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 19 August 2013 07:33
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: cpreston on Sat, 24 August 2013 17:42
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 07 September 2013 08:00
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 07 September 2013 08:39

Previous Topic:	Register + Activate Account
Next Topic:	Error upgrade from 3.0.0 to 3.0.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 09:34:10 GMT 2024

Total time taken to generate the page: 0.04000 seconds