Error converting IPB 3.4 to SMF

[swayne]

Everything was working until I got this error message:

Converting...
Recounting post counts...
Successful.
Converting polls...The database value you're trying to insert does not exist: question

[vbgamer45]

What version of SMF are you converting to?

In your SMF 2.0.x forum the smf_polls table should have the following db structure

Code Select Expand


CREATE TABLE {$db_prefix}polls (
  id_poll mediumint(8) unsigned NOT NULL auto_increment,
  question varchar(255) NOT NULL default '',
  voting_locked tinyint(1) NOT NULL default '0',
  max_votes tinyint(3) unsigned NOT NULL default '1',
  expire_time int(10) unsigned NOT NULL default '0',
  hide_results tinyint(3) unsigned NOT NULL default '0',
  change_vote tinyint(3) unsigned NOT NULL default '0',
  guest_vote tinyint(3) unsigned NOT NULL default '0',
  num_guest_voters int(10) unsigned NOT NULL default '0',
  reset_poll int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) NOT NULL default '0',
  poster_name varchar(255) NOT NULL default '',
  PRIMARY KEY (id_poll)
) ENGINE=MyISAM;


[swayne]

I'm converting using this one: https://download.simplemachines.org/index.php?converters;id=71
From IPB 3.4.7 to SMF 2.0.17

Polls table in SMF is according to your description.

[vbgamer45]

Strange what about your core_polls table in IPB 4.4

[swayne]

It's IPB 3.4 and it has an ibf_polls table but not a core_polls table. It looks normal to me and works fine at the forum.

[vbgamer45]

Hmm try editing .sql file

Code Select Expand


---* {$to_prefix}polls
SELECT
p.pid AS id_poll, SUBSTRING(p.poll_question, 1, 255) AS question,
p.starter_id AS id_member, SUBSTRING(IFNULL(m.name, 'Guest'), 1, 255) AS poster_name
FROM {$from_prefix}core_polls AS p
LEFT JOIN {$from_prefix}core_members AS m ON (m.member_id = p.starter_id);
---*

Change to

Code Select Expand


---* {$to_prefix}polls
SELECT
p.pid AS id_poll, SUBSTRING(p.poll_question, 1, 255) AS question,
p.starter_id AS id_member, SUBSTRING(IFNULL(m.name, 'Guest'), 1, 255) AS poster_name
FROM {$from_prefix}polls AS p
LEFT JOIN {$from_prefix}core_members AS m ON (m.member_id = p.starter_id);
---*


[swayne]

Thanks for your help! I didn't try that, but I ran the converter from start again and for some reason it worked without any problems now.