FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Upgrading 3.0.1 -> 3.0.4.1 failed: Convert reg_ip to registration_ip for IPv6
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Upgrading 3.0.1 -> 3.0.4.1 failed: Convert reg_ip to registration_ip for IPv6 [message #167821] Sat, 13 October 2012 10:08 Go to previous message
-ml- is currently offline  -ml-
Messages: 12
Registered: March 2012
Karma:
Junior Member
Hello All,

My forum is broken since I tried to upgrade from 3.0.1 to 3.0.4.1 Sad

I see the following error during upgrade:

Convert reg_ip to registration_ip for IPv6 compatibility

Warning: pg_query(): Query failed: FEHLER: Spalte »reg_ip« existiert nicht LINE 1: SELECT id, reg_ip FROM fud30_users ^ in /home/httpd/XXX/rag/private/sql/pgsql/db.inc on line 108 Fatal error: Uncaught exception 'Exception' with message ': FEHLER: Spalte »reg_ip« existiert nicht LINE 1: SELECT id, reg_ip FROM fud30_users ^ @ SELECT id, reg_ip FROM fud30_users' in /home/httpd/XXX/rag/upgrade.php:158 Stack trace: #0 /home/httpd/XXX/rag/private/sql/pgsql/db.inc(108): fud_sql_error_handler('SELECT id, reg_...', 'FEHLER: Spalte...', '', '8.4.13') #1 /home/httpd/XXX/rag/upgrade.php(67): q('SELECT id, reg_...') #2 /home/httpd/XXX/rag/upgrade.php(915): users_registration_ip(Array) #3 {main} thrown in /home/httpd/XXX/rag/upgrade.php on line 158 


Before that I saw the following:
Warning: pg_query(): Query failed: FEHLER: Spalte i.oid existiert nicht LINE 1: ...id AND i.forum_id = fud30_ann_forums.forum_id AND i.oid < fu... ^ in /home/httpd/XXX/rag/private/sql/pgsql/db.inc on line 108 Fatal error: Uncaught exception 'Exception' with message ': FEHLER: Spalte i.oid existiert nicht LINE 1: ...id AND i.forum_id = fud30_ann_forums.forum_id AND i.oid < fu... ^ @ DELETE FROM fud30_ann_forums WHERE EXISTS (SELECT 1 FROM fud30_ann_forums i WHERE i.ann_id = fud30_ann_forums.ann_id AND i.forum_id = fud30_ann_forums.forum_id AND i.oid < fud30_ann_forums.oid)' in /home/httpd/XXX/rag/upgrade.php:158 Stack trace: #0 /home/httpd/XXX/rag/private/sql/pgsql/db.inc(108): fud_sql_error_handler('DELETE FROM fud...', 'FEHLER: Spalte...', '', '8.4.13') #1 /home/httpd/XXX/rag/private/include/dbadmin.inc(589): q('DELETE FROM fud...') #2 /home/httpd/XXX/rag/private/include/dbadmin.inc(379): delete_duplicate_rows('fud30_ann_forum...', 'ann_id,forum_id') #3 /home/httpd/XXX/rag/upgrade.php(978): create_primary_key('fud30_ann_forum...', 'ann_id,forum_id') #4 {main} thrown in /home/httpd/XXX/rag/upgrade.php on line 158 


Is this a known issue?
Is there anything I can do?
Currently I can't even log in as administrator. I just get a blank page after login.

My configuration
FUDforum version: 	3.0.1
PHP version: 	5.3.3-7+squeeze8
PHP built on: 	Linux rechenknecht 2.6.32-5-amd64 #1 SMP Mon Jan 16 16:22:28 UTC 2012 x86_64
Database type: 	pgsql (pgsql)
Database version: 	PostgreSQL 8.4.11 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit
Web server: 	Apache/2.2
Web server to PHP interface: 	apache2handler
WebServer User/Group: 	33 / 33
Relevant PHP settings: 	
Safe mode: 	OFF
Open basedir: 	none
Display errors: 	OFF
File uploads: 	ON
Maximum file upload size: 	20M
Magic quotes: 	OFF
Register globals: 	OFF
Output buffering: 	Yes
Disabled functions: 	none
PSpell support: 	No
Zlib support: 	Yes


Any help is highly appreciated!

[Updated on: Sat, 13 October 2012 10:22]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message icon14.gif
Previous Topic: Upgrade from 2.3.5 to 3.0.0 not working
Next Topic: Error when creating custom theme -> mnav.tmpl
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 02:29:07 GMT 2024

Total time taken to generate the page: 0.03949 seconds