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

Home » FUDforum » FUDforum Installation Issues » Upgrade from 3.0.4 to 3.0.5 failed (DB upgrade with Fatal error: Uncaught exception )
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Upgrade from 3.0.4 to 3.0.5 failed [message #183628 is a reply to message #183605] Sun, 03 November 2013 12:35 Go to previous messageGo to previous message
-ml- is currently offline  -ml-
Messages: 12
Registered: March 2012
Karma:
Junior Member
Hi naudefj,

both applying the patch re-trying do not resolve the problem.

I now get
Warning: pg_query(): Query failed: FEHLER: NULL-Wert in Spalte »conf_key« verletzt Not-Null-Constraint in /home/httpd/private/sql/pgsql/db.inc on line 108

Fatal error: Uncaught exception 'Exception' with message ': FEHLER: NULL-Wert in Spalte »conf_key« verletzt Not-Null-Constraint @ UPDATE fud30_users SET conf_key =NULL WHERE conf_key ='0'' in /home/httpd/upgrade.php:170 Stack trace: #0 /home/httpd/private/sql/pgsql/db.inc(108): fud_sql_error_handler('UPDATE fud30_us...', 'FEHLER: NULL-W...', '', '9.1.9') #1 /home/httpd/upgrade.php(87): q('UPDATE fud30_us...') #2 /home/httpd/upgrade.php(921): users_conf_key(Array) #3 {main} thrown in /home/httpd/upgrade.php on line 170


Just for curiosity I commented out line 170 in upgrade.php which throws the exception. This results in
Warning: pg_query(): Query failed: FEHLER: NULL-Wert in Spalte »conf_key« verletzt Not-Null-Constraint in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: NULL-Wert in Spalte »reset_key« verletzt Not-Null-Constraint in /home/httpd/private/sql/pgsql/db.inc on line 108
Alter database column reset_key in table fud30_users.
Convert reset_key & conf_key from 0 to NULL

Warning: pg_query(): Query failed: FEHLER: NULL-Wert in Spalte »conf_key« verletzt Not-Null-Constraint in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: NULL-Wert in Spalte »reset_key« verletzt Not-Null-Constraint in /home/httpd/private/sql/pgsql/db.inc on line 108
Alter database column registration_ip in table fud30_users.
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/private/sql/pgsql/db.inc on line 108

Warning: pg_fetch_row() expects parameter 1 to be resource, boolean given in /home/httpd/private/sql/pgsql/db.inc on line 148
Alter database column last_used_ip in table fud30_users.
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/private/sql/pgsql/db.inc on line 108

Warning: pg_fetch_row() expects parameter 1 to be resource, boolean given in /home/httpd/private/sql/pgsql/db.inc on line 148
Alter database column ip_addr in table fud30_msg.
Alter database column ip_addr in table fud30_pmsg.

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(übliche)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(überwinden)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(übernommen)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(über)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(übernachtet)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(überlegt)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(üben)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(ärztliches)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(könnte)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108

Warning: pg_query(): Query failed: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »fud30_search_i_w« DETAIL: Schlüssel »(word)=(übernehmen)« existiert bereits. in /home/httpd/private/sql/pgsql/db.inc on line 108
SQL upgrades completed.
Checking GLOBAL variables.
Please manually update custom theme RAG_neu.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
WARNING: {DEF: img_ext} is deprecated. Please replace it with .png in drawmsg.tmpl.
Theme RAG_neu was successfully compiled.
Theme default was successfully compiled.
Theme Grau was successfully compiled.


The good news is that the categories are back.

Any idea how to fix the remaining issues?


Thanks
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Can't logout from Firefox
Next Topic: Problems part 2
Goto Forum:
  

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

Current Time: Thu Nov 28 04:32:38 GMT 2024

Total time taken to generate the page: 0.02794 seconds