SMF Support > vBulletin

vBulletin 3.6.8 pl2 -> SMF Wrong value type sent to the database

<< < (2/3) > >>

jlbooker:
If a little more detail would help...

The query that's failing is:
INSERT IGNORE INTO `phpws_forums_smf`.smf_messages(`id_msg`, `id_topic`, `poster_time`, `id_member`, `subject`, `poster_name`, `poster_ip`, `id_board`, `smileys_enabled`, `body`, `poster_email`, `modified_name`, `icon`) VALUES (....<bunch of message bodies here>....) ORDER BY null

The URL this fails on is:
convert.php?step=1&substep=7&start=5500

I've tried turning on debug mode (by adding '&debug=1' to the url) It seems to be detecting this flag (I added a line of code to check..), but doesn't ever write a debug log, or output anything different to the browser.

Oldiesmann:
I'm not sure what's going on with that. This appears to be the query that's causing the problem:


--- Code: ------* {$to_prefix}messages (update id_msg)
SELECT postid AS id_msg, username AS modified_name, dateline AS modified_time
FROM {$from_prefix}editlog
ORDER BY dateline;
---*
--- End code ---

However, that query shouldn't be interfering with the previous one at all.

Does the SQL file from this topic work any better?

jlbooker:
That file appears to be largely the same, but it says it's for converting to smf 1.1. I'm using smf 2.0.

I tried it anyways, but it doesn't get past converting the members:

--- Code: ---Converting members...Unknown column 'memberName' in 'field list'
--- End code ---

Any other ideas?

Oldiesmann:
Ah. I thought that one was for 2.0. Sorry.

I'll send someone else this way who knows more about converters and see if we can figure out what's going on with that query.

ardnas:
I had the exact same problem as the first poster, and I replaced the values as instructed and now have this error:

Converting polls...Wrong value type sent to the database. Integer expected. (id_member)

help?  Thanks!

Navigation

[0] Message Index

[#] Next page

[*] Previous page