Simple Machines Community Forum

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

Which converter are you using?

Hello,

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

try the converter in this topic phpbb3 (http://www.simplemachines.org/community/index.php?topic=218449.0) also read the full topic replies if you encounter some problems !!

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:

u.user_ip AS member_ip2

Replace with:

u.user_ip AS member_ip2, '' AS openid_uri


Quote from: margarett on February 16, 2014, 08:41:00 PM
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

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 :( )

Adding to before:
Find:

u.user_ip AS member_ip2, '' AS openid_uri

Replace with

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


Hello margarett,

It seems be solved with this.

THANKS!!

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

Thanks again!!

Remko

Kewl :P

Welcome to SMF!