Announcement

Collapse
No announcement yet.

Cannot Convert from IPB 1.1.2 - SQL Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cannot Convert from IPB 1.1.2 - SQL Error

    Hi,

    I've just purchased my vBulletin License and am having a problem converting from Invisionboard, I'm doing everything correctly but am getting the following error :

    Database error in vBulletin Control Panel 2.3.2:
    Invalid SQL: SELECT g_id AS importusergroupid,g_view_board AS canview,g_mem_info AS canviewmembers,
    g_other_topics AS canviewothers,g_use_search AS cansearch,g_email_friend AS canemail,
    g_edit_profile AS canmodifyprofile,g_post_new_topics AS canpostnew,
    g_reply_own_topics AS canreplyown,g_reply_other_topics AS canreplyothers,
    g_edit_posts AS caneditpost,g_delete_own_posts AS candeleteownpost,
    g_open_close_posts AS canopenclose,g_delete_own_topics AS candeletethread,
    g_post_polls AS canpostpoll,g_vote_polls AS canvote,g_use_pm AS canusepm,
    g_is_supmod AS ismoderator,g_access_cp AS cancontrolpanel,g_title AS title,
    g_max_mass_pm AS maxbuddypm
    FROM freedom2support_net_-_forums.ibf_groups
    ORDER BY importusergroupid
    LIMIT 0,4
    mysql error: You have an error in your SQL syntax near '-_forums.ibf_groups
    ORDER BY importusergroupid
    ' at line 10
    mysql error number: 1064
    Date: Friday 24th of October 2003 10:24:56 PM
    Script: http://www.freedom2support.net/foru...mport_invib.php
    Referer: http://www.freedom2support.net/foru...mport_invib.php

    Any ssistance would be appreciated.

    Thanks

    Justin

  • #2
    Try to enter the databasename surronded by backticks (don't know if this is the correct word )

    If the database is named ipb-forums enter `ipb-forums` as the name.

    If I remember correct then the - is causing this problem.
    this is my sig

    Comment


    • #3
      Cheers mate, totally fixed it

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X