** FIXED.. phpBB2 >> Simple Machines >> Incorrect integer value

[whitevamp]

I have an exsiting user base with phbb and i'am wanting to change over to SMF, (SMF is up and running good) but I have ran into a snag with the bridge.
1. when i run the bridge every thing goes good till it starts the db migration, and i get this error

Converting topics... Unsuccessful!
This query:

    INSERT INTO `phpbb`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('1', '0', '1', '28', '2', '12', '1', '', '0', '4', '45'),
    ('2', '0', '4', '74', '4', '8', '1', '', '0', '7', '76'),
    ('4', '1', '12', '12', '3', '3', '3', '', '1', '0', '6'),
    ('5', '1', '13', '13', '3', '3', '3', '', '1', '0', '4'),
    ('6', '1', '14', '14', '3', '3', '3', '', '0', '0', '1'),
    ('7', '1', '15', '15', '3', '3', '3', '', '0', '0', '2'),
    ('8', '1', '16', '16', '3', '3', '3', '', '0', '0', '3'),
    ('9', '1', '17', '17', '3', '3', '3', '', '0', '0', '3'),
    ('10', '1', '18', '18', '3', '3', '3', '', '0', '0', '2'),
    ('11', '1', '19', '19', '3', '3', '3', '', '0', '0', '2'),
    ('12', '1', '20', '20', '3', '3', '8', '', '0', '0', '13'),
    ('13', '1', '21', '21', '3', '3', '8', '', '0', '0', '14'),
    ('14', '1', '22', '22', '3', '3', '8', '', '0', '0', '10'),
    ('15', '1', '23', '23', '3', '3', '8', '', '0', '0', '13'),
    ('16', '1', '24', '24', '3', '3', '8', '', '0', '0', '17'),
    ('17', '1', '25', '25', '3', '3', '4', '', '0', '0', '52'),
    ('18', '1', '26', '26', '3', '3', '2', '', '1', '0', '100'),
    ('19', '1', '27', '27', '3', '3', '6', '', '0', '0', '19'),
    ('20', '0', '29', '29', '12', '12', '6', '', '0', '0', '16'),
    ('21', '0', '30', '65', '9', '8', '7', '', '0', '1', '19'),
    ('22', '0', '31', '31', '9', '9', '6', '', '0', '0', '13'),
    ('23', '0', '32', '32', '4', '4', '6', '', '0', '0', '17'),
    ('24', '0', '35', '35', '13', '13', '6', '', '0', '0', '12'),
    ('25', '0', '36', '42', '5', '4', '6', '', '0', '1', '21'),
    ('26', '0', '37', '37', '8', '8', '6', '', '0', '0', '11'),
    ('27', '0', '40', '45', '12', '5', '1', '', '0', '3', '34'),
    ('28', '1', '46', '46', '4', '4', '5', '', '0', '0', '56'),
    ('29', '0', '47', '64', '4', '8', '7', '', '0', '2', '28'),
    ('30', '0', '51', '67', '9', '8', '7', '', '0', '2', '17'),
    ('31', '0', '53', '70', '18', '8', '6', '', '0', '2', '19'),
    ('32', '1', '56', '56', '2', '2', '9', '', '0', '0', '21'),
    ('33', '0', '57', '84', '3', '2', '7', '', '0', '3', '17'),
    ('34', '1', '58', '58', '2', '2', '9', '', '0', '0', '11'),
    ('35', '0', '59', '59', '21', '21', '6', '', '0', '0', '11'),
    ('36', '0', '61', '71', '22', '8', '1', '', '0', '1', '25'),
    ('37', '0', '62', '79', '4', '3', '7', '', '0', '5', '29'),
    ('38', '0', '69', '69', '8', '8', '7', '', '0', '0', '8'),
    ('39', '0', '72', '77', '23', '8', '6', '', '0', '3', '16'),
    ('40', '0', '80', '81', '3', '12', '10', '1', '0', '1', '12'),
    ('41', '0', '83', '83', '3', '3', '1', '', '0', '0', '1');

Caused the error:

    Incorrect integer value: '' for column 'ID_POLL' at row 1

now i took and ran this on the cml

INSERT INTO `phpbb`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('1', '0', '1', '28', '2', '12', '1', '0', '1', '4', '45'); <-- edited 12-8 to correct values i entered. had forgot to show changes.
please note that i ran the hole section pasted above, but only changed this line #1
EDIT ..    and it ran correctly.   /END EDIT 12-8.
so why is this doing this?

ps: phpBB-2.0.21

EDIT ---
I was able to fix this error and a few other ones that had poped up. It seams that there is a bug in mysql 5.X
and so sence i had access to the my.ini file i changed this line
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to this line
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
and it fixed all error and inserted every thing just fine.

[Neurothustra]

If you could, please explain a little better what you fixed (or how). I changed the my.ini over using the string you supplied, but I did not find the procedure to be as successful. Any other references to this error I've found on the web have been few and are no longer even accessible. I desperately want to switch to SMF, but with almost 2 years worth of forum data, I cannot switch w/out a functional converter.