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
Upgrade from 3.0.4 to 3.0.5 failed [message #183593] Fri, 01 November 2013 21:38 Go to previous message
-ml- is currently offline  -ml-
Messages: 12
Registered: March 2012
Karma:
Junior Member
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

[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: Tue Jun 18 07:10:52 GMT 2024

Total time taken to generate the page: 0.04438 seconds