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