Advertisement:

Author Topic: Converting XMB 1.9 - SMF 2.0.13 - The database value you're trying to insert...  (Read 564 times)

Offline indru

  • Newbie
  • *
  • Posts: 3
Hello,

I`m trying to convert XMB 1.9 to SMF 2.0.13 and after converting topics I got this error: Converting posts (this may take some time)...The database value you're trying to insert does not exist: id_member


Offline TE

  • Semi-Newbie
  • *
  • Posts: 28
    • eurich on GitHub
    • ElkArte
I think there's an post in your old database which is not assigned to a specific member..
in xmb_to_smf.sql find the row with:
Code: [Select]
$row['body'] = preg_replace('~\[align=(center|right|left)\](.+?)\[/align\]~i', '[$1]$2[/$1]', stripslashes($row['body']));add after:
Code: [Select]
$ignore = true;Then restart the converter.

Offline indru

  • Newbie
  • *
  • Posts: 3
Unfortunately there was no help, I got the same error.

Converting topics...
Successful.
Converting posts (this may take some time)...The database value you're trying to insert does not exist: id_member

Offline TE

  • Semi-Newbie
  • *
  • Posts: 28
    • eurich on GitHub
    • ElkArte
please try the attached version, I've added a
Code: [Select]
WHERE uf.uid > 0;therefore the converter should only convert posts with a valid uid.

Offline indru

  • Newbie
  • *
  • Posts: 3
With posts now is okay, but next error:

Converting polls... Successful.
Converting poll options...
Warning: array_keys() expects parameter 1 to be array, string given in xxx/smf/convert.php on line 1288

and in the end:

Warning: in_array() expects parameter 2 to be array, null given in xxx/smf/convert.php on line 2612

Warning: Invalid argument supplied for foreach() in xxx/smf/convert.php on line 2624

Warning: array_combine(): Both parameters should have an equal number of elements in xxx/smf/Sources/Subs-Db-mysql.php on line 649
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3

I have on question more, I have in XMB forum 24 forums + subforums but on smf I see only 6 forums?