News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Error converting IPB 3.4 to SMF

Started by swayne, April 04, 2020, 11:07:38 AM

Previous topic - Next topic

swayne

Everything was working until I got this error message:

QuoteConverting...
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

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;
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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

---* {$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

---* {$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);
---*
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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.  ???

Advertisement: