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
Aw: Upgrading 3.0.1 -> 3.0.4.1 failed: Convert reg_ip to registration_ip for IPv6 [message #167823 is a reply to message #167821] Sat, 13 October 2012 21:26 Go to previous messageGo to previous message
-ml- is currently offline  -ml-
Messages: 12
Registered: March 2012
Karma:
Junior Member
I commented out all database modifications that are causing errors in upgrade.php one after another.
Doing this I was able to trigger subsequent errors:

Translations for the German words:
FEHLER means ERROR
existiert nicht means does not exist
Spalte means Column

Convert last_known_ip to last_used_ip IPv6 compatibility
Warning: pg_query(): Query failed: FEHLER: Spalte »last_known_ip« existiert nicht LINE 1: SELECT id, last_known_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 »last_known_ip« existiert nicht LINE 1: SELECT id, last_known_ip FROM fud30_users ^ @ SELECT id, last_known_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, last...', 'FEHLER: Spalte...', '', '8.4.13') #1 /home/httpd/XXX/rag/upgrade.php(77): q('SELECT id, last...') #2 /home/httpd/XXX/rag/upgrade.php(915): users_last_used_ip(Array) #3 {main} thrown in /home/httpd/XXX/rag/upgrade.php on line 158 


Create composite primary key on fud30_ann_forums(ann_id,forum_id).
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


Add new database index fud30_msg_report_i_mu to table fud30_msg_report(msg_id,user_id).
Warning: pg_query(): Query failed: FEHLER: Spalte i.oid existiert nicht LINE 1: ...g_id AND i.user_id = fud30_msg_report.user_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: ...g_id AND i.user_id = fud30_msg_report.user_id AND i.oid < fu... ^ @ DELETE FROM fud30_msg_report WHERE EXISTS (SELECT 1 FROM fud30_msg_report i WHERE i.msg_id = fud30_msg_report.msg_id AND i.user_id = fud30_msg_report.user_id AND i.oid < fud30_msg_report.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(624): delete_duplicate_rows('fud30_msg_repor...', 'msg_id,user_id') #3 /home/httpd/XXX/rag/upgrade.php(942): create_index('fud30_msg_repor...', 'fud30_msg_repor...', 1, 'msg_id,user_id') #4 {main} thrown in /home/httpd/XXX/rag/upgrade.php on line 158 


Recreate database index fud30_mime_f on table fud30_mime(fl_ext).
Warning: pg_query(): Query failed: FEHLER: Spalte i.oid existiert nicht LINE 1: ...d30_mime i WHERE i.fl_ext = fud30_mime.fl_ext 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: ...d30_mime i WHERE i.fl_ext = fud30_mime.fl_ext AND i.oid < fu... ^ @ DELETE FROM fud30_mime WHERE EXISTS (SELECT 1 FROM fud30_mime i WHERE i.fl_ext = fud30_mime.fl_ext AND i.oid < fud30_mime.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(624): delete_duplicate_rows('fud30_mime', 'fl_ext') #3 /home/httpd/XXX/rag/upgrade.php(948): create_index('fud30_mime', 'fud30_mime_f', 1, 'fl_ext') #4 {main} thrown in /home/httpd/XXX/rag/upgrade.php on line 158



I hope this helps for error analysis and bug fixing.

[Updated on: Sat, 13 October 2012 21:37]

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: Sat Feb 01 22:09:13 GMT 2025

Total time taken to generate the page: 0.03945 seconds