SMF Support > IPB

[SMF Converter] IPB 1.3.x

(1/34) > >>

JayBachatero:
Software: IPB
Version: 1.3.x

This is the official support topic for IPB 1.3 converter.  Use this topic to ask for support for this converter.  I merged all the changes that were floating around.  Lets use this topic to get a final working version.

Changelog
! Initial update
! Poll convert update.

convert.php
Use this convert.php with the .sql file attached in this topic.

Puc conDoin:
Hi, I have a problem with the converter.

I have the following error:


--- Quote ---Converting poll options... Unsuccessful!
This query:

    INSERT INTO `forzona`.smf_poll_choices
    (ID_POLL, ID_CHOICE, label, votes)
    VALUES (187, SUBSTRING('0', 1, 255), 'foto1: foto van Janet.', 1, 255), '3'),
    (187, SUBSTRING('1', 1, 255), 'foto2: foto van Maj', 1, 255), '3'),
    (187, SUBSTRING('2', 1, 255), 'foto3: foto van Loebas', 1, 255), '2'),
--- End quote ---

and at the bottom of the page:


--- Quote ---Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''3'),
    (187, SUBSTRING('1', 1, 255), 'foto2: foto van Maj', 1, 255), '3'' at line 3
--- End quote ---

And this is the exported query from the IPB database:


--- Quote ---INSERT INTO `ibf_polls` VALUES (187, 7338, 1129495368, 'a:8:{i:0;a:3:{i:0;i:0;i:1;s:23:"foto1:  foto van Janet.";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:20:"foto2:  foto van Maj";i:2;i:3;}i:2;a:3:{i:0;i:2;i:1;s:23:"foto3:  foto van Loebas";i:2;i:2;}i:3;a:3:{i:0;i:3;i:1;s:22:"foto4:  foto van Mesje";i:2;i:1;}i:4;a:3:{i:0;i:4;i:1;s:22:"foto5:  foto van Cyber";i:2;i:1;}i:5;a:3:{i:0;i:5;i:1;s:20:"foto6:  foto van Puc";i:2;i:3;}i:6;a:3:{i:0;i:6;i:1;s:22:"foto7:  foto van Heidi";i:2;i:2;}i:7;a:3:{i:0;i:7;i:1;s:23:"foto8:  foto van Shanon";i:2;i:0;}}', 95, 15, 8, 'Hier kun je stemmen, en geef ook je commentaar');
--- End quote ---

How can I correct this error, to get the conversion to work?

Puc conDoin:
I've tried Sarke's solution: http://www.simplemachines.org/community/index.php?topic=137630.msg903435#msg903435

But now I get this error:


--- Quote ---Caused the error:

    Duplicate entry '12-0' for key 1
--- End quote ---

JayBachatero:

--- Quote from: Puc conDoin on February 04, 2007, 02:44:00 PM ---I've tried Sarke's solution: http://www.simplemachines.org/community/index.php?topic=137630.msg903435#msg903435

But now I get this error:


--- Quote ---Caused the error:

    Duplicate entry '12-0' for key 1
--- End quote ---


--- End quote ---
Ok what table did you get this error on?

Puc conDoin:
Still the same table: `forzona`.smf_poll_choices

Navigation

[0] Message Index

[#] Next page

Go to full version