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: Re: Aw: Upgrading 3.0.1 -> 3.0.4.1 failed: Convert reg_ip to registration_ip for IPv6 [message #167825 is a reply to message #167824] Mon, 15 October 2012 20:49 Go to previous messageGo to previous message
-ml- is currently offline  -ml-
Messages: 12
Registered: March 2012
Karma:
Junior Member
Thanks for your answer.

Might that 'reg_ip' column have gone during an earlier attempt to update to 3.0.3? I tried this some months ago without success.

Now the good news is that my forum seems to work again.
The consistency check was successful. So far I have no complaints from my users except one:
Adding attachments does not seem to work. I get the following SQL error in the log:

/home/httpd/XXX/rag/index.php:120
/home/httpd/XXX/rag/index.php:210
/home/httpd/XXX/rag/theme/RAG_neu/post.php:2972
/home/httpd/XXX/rag/theme/RAG_neu/post.php:4237
/home/httpd/XXX/rag/index.php:1360
) : FEHLER: NULL-Wert in Spalte »location« verletzt Not-Null-Constraint
Query: INSERT INTO fud30_attach (location, message_id, original_name, owner, attach_opt, mime_type,fsize) SELECT null AS location, 0 AS message_id, 'Erfahrungsbericht 2012.pdf' AS original_name, 2 AS owner, 0 AS attach_opt, id AS mime_type, 71319 AS fsize FROM fud30_mime WHERE fl_ext IN('*', 'pdf') ORDER BY fl_ext DESC LIMIT 1 OFFSET 0
_GET: array ( 't' => 'post', )
_POST: array ( 'S' => '49e73d1e58b7448156ef68da94aac5a7', 'SQ' => 'e36871d64803a03b624c93fd9e7d5250', 'submitted' => '', 'reply_to' => '0', 'th_id' => '113', 'frm_id' => '6', 'start' => '0', 'msg_id' => '959', 'pl_id' => '0', 'old_subject' => '', 'prev_loaded' => '1', 'msg_subject' => 'Fehler in der Forensoftware beim Einrichten für 2013', 'msg_tdescr' => '', 'thr_ordertype' => '0', 'thr_orderexpiry' => '1000000000', 'msg_icon' => '', 'fnt_size' => '', 'fnt_color' => '', 'fnt_face' => '', 'msg_body' => 'YYY', 'MAX_FILE_SIZE' => '20971520', 'attach_control_add' => 'Datei hochladen', 'tmp_f_val' => '1', 'msg_poster_notif' => 'Y', 'msg_show_sig' => 'Y', 'minimsg_pager_switch' => '0', )
Database version: 8.4.13


Looks like there is something wrong with the 'location' column. Is there anything I can do to fix this?
I won't like to revert to an rather old backup.

[Updated on: Mon, 15 October 2012 20:56]

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: Thu Dec 05 02:43:51 GMT 2024

Total time taken to generate the page: 0.03560 seconds