sql problem - phpbb2 to smf

Discussion in 'Programming' started by seopundit, Sep 11, 2006.

  1. #1
    Hi

    I have phpbb and smf forum running, now i want to port all those content from phpbb to smf.

    I have 100's of child board in phpbb, I created in the smf using following

    $q_smfboard="insert into $tn_smfboard (`ID_BOARD`,`ID_CAT`,`childLevel`,`ID_PARENT`,`boardOrder`,`ID_LAST_MSG`,`ID_MSG_UPDATED`,`memberGroups`,`name`,`description`,`numTopics`,`numPosts`,`countPosts`,`ID_THEME`,`permission_mode`,`override_theme`) values ($forumnu,4,1,18,$forumnu,0,0,'-1,0,2,4,5,6,7,8','$temp_ar_cpylist','blahblahdescriptionabouttheboard',0,0,0,0,0,0);";


    The php script ran well and when i checked it in the phpmyadmin it is fine.

    But when i ran the sql query all got screwed up.

    For eg i had 18 boards already in the smf, and create remaing 100 boards in smf using the above query.
    upto 18 boards the query returns correct information , but not after 18th board. Please see the below sample output for more clarity.

    But when i see in phpmyadmin all were fine for all the boards

    | ID_BOARD | ID_CAT | childLevel | ID_PARENT | boardOrder | ID_LAST_MSG | ID_MS
    _UPDATED | memberGroups | name | description
    | numTopics | numPosts | countPosts | ID_THEME | permission_mode | override
    theme |
    | 18 | 4 | 0 | 0 | 1 | 0 |
    0 | 1,0,2,4,5,6,7,8 | board name | board description | 0 | 0 | 0 | 0 | 0 | 0 |

    | 19 | 4 | 1 | 18 | 19 | 0 |
    | 0 | 0 | 0 | 0 | 0 |
    0 |



    Any help is appreciated?
     
    seopundit, Sep 11, 2006 IP
  2. Arkserver

    Arkserver Banned

    Messages:
    2,533
    Likes Received:
    35
    Best Answers:
    0
    Trophy Points:
    0
    #2
    maybe the script got a time-out?
     
    Arkserver, Sep 11, 2006 IP