Convertor problem.........

[remkot]

Hello,

Can somebody help me?

If i try to convert mij phpBB3 to smf i get:

Converting members...Field 'openid_uri' doesn't have a default value

Even with a fresh phpBB3 install i get this.

Can somebody help me?

Thanks,
Remko

[margarett]

Which converter are you using?

[remkot]

Hello,

I use this one:
http://download.simplemachines.org/?converters;software=phpbb

[Herman's Mixen]

try the converter in this topic phpbb3 also read the full topic replies if you encounter some problems !!

[margarett]

I tested here and I was able to convert without issues, so I assume some strange behavior in different MySQL versions...

You can edit phpbb3_to_smf.sql and find:

Code Select Expand


u.user_ip AS member_ip2

Replace with:

Code Select Expand


u.user_ip AS member_ip2, '' AS openid_uri


[remkot]

I tested here and I was able to convert without issues, so I assume some strange behavior in different MySQL versions...

You can edit phpbb3_to_smf.sql and find:

Code Select Expand


u.user_ip AS member_ip2

Replace with:

Code Select Expand


u.user_ip AS member_ip2, '' AS openid_uri


Hello,

This works for me! Manny thanks for this!

But the next problem is:
Converting members...Field 'ignore_boards' doesn't have a default value

[margarett]

A similar tweak is needed, I'll check it when I get to my computer.
But that's strange, it shouldn't be necessary (and I have the feeling it will need several edits like this )

[margarett]

Adding to before:
Find:

Code Select Expand


u.user_ip AS member_ip2, '' AS openid_uri

Replace with

Code Select Expand


u.user_ip AS member_ip2, '' AS openid_uri, '' AS ignore_boards


[remkot]

Hello margarett,

It seems be solved with this.

THANKS!!

Only one little problem wiht the attachments, but....... whatever.......

Thanks again!!

Remko

[margarett]

Kewl

Welcome to SMF!