Hi,
when trying to upgrade from 3.0.4 to 3.0.5 I get the following error
Warning: pg_query(): Query failed: FEHLER: Operator existiert nicht: character varying = integer LINE 1: UPDATE fud30_users SET conf_key =NULL WHERE conf_key =0 ^ HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. in /home/httpd/private/sql/pgsql/db.inc on line 108
Fatal error: Uncaught exception 'Exception' with message ': FEHLER: Operator existiert nicht: character varying = integer LINE 1: UPDATE fud30_users SET conf_key =NULL WHERE conf_key =0 ^ HINT: Kein Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. @ 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: Operat...', '', '9.1.9') #1 /home/httpd//upgrade.php(87): q('UPDATE fud30_us...') #2 /home/httpd//upgrade.php(918): users_conf_key(Array) #3 {main} thrown in /home/httpd//upgrade.php on line 170
It seems like all forum categories are being ignored. All forums are listed under "Private Forums Another test category for demonstration purposes." which I never used.
My configuration is
FUDforum version: 3.0.5
PHP version: 5.4.4-14+deb7u5
PHP built on: Linux rechenknecht 3.2.0-4-amd64 #1 SMP Debian 3.2.51-1 x86_64
Database type: pgsql (pgsql)
Database version: 9.1.9
Web server: Apache/2.2
Web Server load: 0,3
Web server to PHP interface: apache2handler
WebServer User/Group: www-data / www-data (33/33)
Relevant PHP settings:
Safe mode: OFF
Open basedir: none
Display errors: ON
File uploads: ON
Maximum file upload size: 20M
Magic quotes: OFF
Output buffering: Yes
Disabled functions: pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_exec, pcntl_getpriority, pcntl_setpriority,
PSpell support: No
Zlib support: Yes
What should I do? Revert to 3.0.4? Any way to fix this?
Best regards
[Updated on: Fri, 01 November 2013 21:47]
Report message to a moderator