Fork me on GitHub
Subscribe 2

Ticket #962 (open bug)

convert from smf and merge with my forum

  • Created: 2014-04-02 07:47:07
  • Reported by: ytsejam
  • Assigned to: None
  • Milestone: None
  • Component: systems
  • Priority: normal

I am trying to convert a forum used with SMF 2.0.4 and merge with my system until now I cant succes because I am getting an error :

An error was encountered
File: /home/ytsejam/public_html/mergeforums/fluxbb/converter/include/fluxbb.class.php
Line: 227

FluxBB reported: Unable to insert values 

Database reported: Duplicate entry '4' for key 'PRIMARY' (Errno: 1062) 

Failed query: INSERT INTO groups (g_id, g_title, g_moderator) VALUES('4', 'Eski Interrailci', '')

Here is log shortly

#0  conv_error_handler(2, mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given, /home/ytsejam/public_html/mergeforums/fluxbb/converter/include/dblayer/mysqli.php, 254, Array ())
#1  mysqli_free_result() called at [/home/ytsejam/public_html/mergeforums/fluxbb/converter/include/dblayer/mysqli.php:254]
#2  mysqli_wrapper->close() called at [/home/ytsejam/public_html/mergeforums/fluxbb/converter/include/fluxbb.class.php:100]
#3  FluxBB->close_database() called at [/home/ytsejam/public_html/mergeforums/fluxbb/converter/include/functions_web.php:44]
#4  conv_error(Unable to insert values, /home/ytsejam/public_html/mergeforums/fluxbb/converter/include/fluxbb.class.php, 227, Array ([error_sql] => INSERT INTO groups (g_id, g_title, g_moderator) VALUES('4', 'Eski Interrailci', ''),[error_no] => 1062,[error_msg] => Duplicate entry '4' for key 'PRIMARY')) called at [/home/ytsejam/public_html/mergeforums/fluxbb/converter/include/fluxbb.class.php:227]
#5  FluxBB->add_row(groups, Array ([g_id] => 4,[g_title] => Eski Interrailci,[g_moderator] => )) called at [/home/ytsejam/public_html/mergeforums/fluxbb/converter/forums/SMF_2.php:272]

I added smf_ prefix while trying. I use nginx and php-fpm with version : PHP 5.5.10 (cli)
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies



ytsejam 2014-04-02 07:50:38

  • Uploaded patch converter.txt. (view)

Franz 2014-04-18 23:23:03

Is this still a problem? The merging is clearly the problem.