vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] [Paid] 1.5.0

[Walter]

Do those attachments have the values set in the vbulletin database?

As far as I can see vb doesn't has these values in the database (no fields for this in the table attachment), the values are determined in the exporter script.

I'll correct this by hand by removing each problematic attachment, but please cover this in the script for the future.

 

[Superfluous]

Same thing here. All user table fields are a mess. My own user got a 150 in the field is_banned.

The reason for this: the exporter writes the fields in a certain order and the importer does a fast LOAD DATA. I have analysed two Xenforo installs, one brand new install of 1.4 and an older one, they have different orders of the fields in the user table. The whole export/import can't work this way!

Phew, not just me. I'm obsessive compulsive over finishing things I start - and my wife has been getting the brunt of my frustration over my failure to make this work over the last 4 or 5 days

 

[Walter]

Same here....

 

[Walter]

@Slavik
I assume the best way to correct this is to do something like reordering the fields in Mysql with something like

alter table `mytable` change column username username varchar(255) after `somecolumn`;

???

Or does this break anything in Xenforo (but I assume Kier+Mike wont user INSERTs without field names)?
Can you provide an ALTER script to change the field names to "correct" ones for all tables affected by the importer? It's quite urgent.

 

[Slavik]

@Slavik
I assume the best way to correct this is to do something like reordering the fields in Mysql with something like
???

Or does this break anything in Xenforo (but I assume Kier+Mike wont user INSERTs without field names)?
Can you provide an ALTER script to change the field names to "correct" ones for all tables affected by the importer? It's quite urgent.

This issue is a very old one, just ensure when you do your XenForo install that the version you install initially is at least 1.2 (i believe)

If you install a 1.x version and upgrade through to 1.4, thats when you'll get the issues.

 

[Jake Bunce]

Same thing here. All user table fields are a mess. My own user got a 150 in the field is_banned.

The reason for this: the exporter writes the fields in a certain order and the importer does a fast LOAD DATA. I have analysed two Xenforo installs, one brand new install of 1.4 and an older one, they have different orders of the fields in the user table. The whole export/import can't work this way!

Correct. The intermediate data relies on column order.

The last time I did a full review of column order for this addon was 1.2. The problem is that the column order in your database can be different depending on if you, for example, installed a new instance of XF 1.4 or upgraded to XF 1.4 from an earlier version. This causes some rigidity in terms of your initial XF version and using this importer.

I will do another column review this weekend so that we can reset the XF version requirements to start with a new installation of XF 1.4. Of course that means it might not work if you upgraded your XF installation from an earlier version to XF 1.4. This rigidity is the nature of this importer.

 

[Jake Bunce]

I get quite a few of these type errors (incorrect integer values, and doesn't contain data for all columns:

Those errors can usually be ignored. This importer isn't "strict" about the data so you can get datatype and datalength errors as a matter of course. This is normal and is not usually a problem.

 

[Superfluous]

I got this issue from a completely clean and full install of 1.4. I'm trying now with 1.2, before upgrading to 1.4 to see if that helps.

 

[Superfluous]

Just finished import into 1.2 - and it's much much healthier (avatars on users, likes imported, threads in correct order, etc). Just doing rebuilds and clean up, before updating to 1.4. But it's looking like my problem was using this script on a fresh 1.4 install.

 

[Walter]

This issue is a very old one, just ensure when you do your XenForo install that the version you install initially is at least 1.2 (i believe)

If you install a 1.x version and upgrade through to 1.4, thats when you'll get the issues.

No. This is a fresh 1.4 install.

On a forum that was converted to Xenforo in August 2012 with the normal importer (dont know what version of Xenforo this was) the column order is different than on this fresh 1.4 install.

 

[Walter]

I will do another column review this weekend so that we can reset the XF version requirements to start with a new installation of XF 1.4.

Yes, this would be awesome.

 

[Dennis B]

Guys,

There doesn't seem to be an updated, detailed list of items imported thru this importer. There's a lot of nice emphasis on how the importer performs, but at least in the OP it's never mentioned exactly what's imported.
I read 'thanks' were added later, and 'blogs' are out. But is there a comprehensive list, or least how it compares to the standard importer?
The only thing I found is this screenshot from over a year ago in the beginning of this thread.

Thanks,

 

[Slavik]

Hi Dennis,

Dropping you a PC.

 

[Superfluous]

Yes, this would be awesome.

Just to let you know - if you install a 1.2 version, then upgrade it to 1.4 - you can do imports after the upgrade to 1.4 as the table structure is the same as what is expected. I did import of my live database today and it worked fine, it even kept all the permissions for users etc that I had fixed before the import.

 

[Brent W]

How do I download this? All I see when viewing the product: https://www.dropbox.com/s/q337giprtmvzzix/Screenshot 2014-10-20 13.28.23.png?dl=0

 

[Slavik]

How do I download this? All I see when viewing the product: https://www.dropbox.com/s/q337giprtmvzzix/Screenshot 2014-10-20 13.28.23.png?dl=0

Click renew maybe? I dunno, @digitalpoint would have to answer, when hes... available

 

[Brent W]

Click renew maybe? I dunno, @digitalpoint would have to answer, when hes... available

https://www.dropbox.com/s/oa30hgb31z6ll2t/Screenshot 2014-10-20 15.15.23.png?dl=0

 

[Slavik]

https://www.dropbox.com/s/oa30hgb31z6ll2t/Screenshot 2014-10-20 15.15.23.png?dl=0

You'd have to contact Digitalpoint support really, I don't know how their system works apart from to enter stuff in there!

 

[Dennis B]

I'd just like to mention here the *outstanding* support level received from the XF team when I ran into some trouble at the final stages of migrating my 5.5M-post vB4 forum to XF this past weekend. @Mike and @Slavik went out of their way to help me and they well deserve a public acknowledgment for that.

 

[Walter]

Here are the differences from mysqldbcompare between a fresh 1.4 install and a forum updated from 1.3 to 1.4:

Moved columns (=order changed):

xf_admin_log: ip_address
xf_bb_code: allow_empty
xf_conversation_message: user_id, message_date
xf_error_log: ip_address
xf_forum: moderate_threads, allow_poll, require_prefix, allowed_watch_notifications
xf_ip: log_date, ip_log_date
xf_liked_content: content_user_id_like_date
xf_login_attempt: login, ip_adress, attempt_date
xf_moderator_log: ip_address
xf_poll: max_votes
xf_session_activity: unique_key, ip
xf_user: activity_visible
xf_user_upgrade_expired: extra
xf_user_upgrade_log: subscriber_id

Hope this helps.