Announcement

Collapse
No announcement yet.

error ipb 1.3 to vb 3.5

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

  • error ipb 1.3 to vb 3.5

    ImpEx Database errormysql error: Invalid SQL:
    SELECT * FROM groups
    ORDER BY g_id

    mysql error: Table 'slidell_forums.groups' doesn't exist
    mysql error number: 1146
    Date: Tuesday 01st of November 2005 02:15:52 PM

  • #2
    I'm guessing that you had lots of red tables on the database check module as well and it said that your sourcetableprefix shold be 'ibf_' in ImpExConfig.php and it isn't set ?
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      yep, how do i fix?

      Comment


      • #4
        Hello?
        I have done this and still get all reds........

        Comment


        • #5
          Originally posted by Andrew Wetzel
          Hello?
          I have done this and still get all reds........
          Then you still have the wrong table prefix, the first page tries to guess what your prefix is, just look at the bottom of the page.
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            I tried to change it the pre fix is ipb_ i put this and still get any error.

            Comment


            • #7
              What's the newest error?
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment


              • #8
                Originally posted by Steve Machol
                What's the newest error?
                Still the same, do you think that vb can look at it?

                Comment


                • #9
                  You couldn't get that exact same error if you changed the source table prefix setting.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #10
                    Altering tablesImpEx will now Alter the tables in the vB database to include import id numbers.This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time.They will also be left after the import if you need to link back to the origional vB userid.
                    moderator - importmoderatorid Completed
                    usergroup - importusergroupid Completed
                    ranks - importrankid Completed
                    poll - importpollid Completed
                    forum - importforumid Completed
                    forum - importcategoryid Completed
                    user - importuserid Completed
                    style - importstyleid Completed
                    thread - importthreadid Completed
                    post - importthreadid Completed
                    thread - importforumid Completed
                    smilie - importsmilieid Completed
                    pmtext - importpmid Completed
                    avatar - importavatarid Completed
                    customavatar - importcustomavatarid Completed
                    customprofilepic - importcustomprofilepicid Completed
                    post - importpostid Completed
                    attachment - importattachmentid Completed
                    pm - importpmid Completed

                    Valid found tables :


                    Possiablly custom tables or incorrect prefix :

                    ipbadmin_logs NOT found.
                    ipbadmin_sessions NOT found.
                    ipbbadwords NOT found.
                    ipbcache_store NOT found.
                    ipbcalendar_events NOT found.
                    ipbcategories NOT found.
                    ipbcontacts NOT found.
                    ipbcss NOT found.
                    ipbemail_logs NOT found.
                    ipbemoticons NOT found.
                    ipbfaq NOT found.
                    ipbforum_perms NOT found.
                    ipbforum_tracker NOT found.
                    ipbforums NOT found.
                    ipbgroups NOT found.
                    ipblanguages NOT found.
                    ipbmacro NOT found.
                    ipbmacro_name NOT found.
                    ipbmember_extra NOT found.
                    ipbmembers NOT found.
                    ipbmessages NOT found.
                    ipbmoderator_logs NOT found.
                    ipbmoderators NOT found.
                    ipbpfields_content NOT found.
                    ipbpfields_data NOT found.
                    ipbpolls NOT found.
                    ipbposts NOT found.
                    ipbreg_antispam NOT found.
                    ipbsearch_results NOT found.
                    ipbsessions NOT found.
                    ipbskin_templates NOT found.
                    ipbskins NOT found.
                    ipbspider_logs NOT found.
                    ipbstats NOT found.
                    ipbsubscription_currency NOT found.
                    ipbsubscription_extra NOT found.
                    ipbsubscription_logs NOT found.
                    ipbsubscription_methods NOT found.
                    ipbsubscription_trans NOT found.
                    ipbsubscriptions NOT found.
                    ipbtemplates NOT found.
                    ipbtitles NOT found.
                    ipbtmpl_names NOT found.
                    ipbtopic_mmod NOT found.
                    ipbtopics NOT found.
                    ipbtracker NOT found.
                    ipbvalidating NOT found.
                    ipbvoters NOT found.
                    ipbwarn_logs NOT found.

                    If you have all red tables, i.e. none correct this could possible be your table prefix :

                    ibf_

                    Comment


                    • #11
                      ImpEx Database errormysql error: Invalid SQL:
                      SELECT * FROM ipbgroups
                      ORDER BY g_id

                      mysql error: Table 'slidell_forums.ipbgroups' doesn't exist
                      mysql error number: 1146
                      Date: Friday 04th of November 2005 12:49:07 AM

                      Comment


                      • #12
                        As Jerry said you need to set your source table prefix to 'ipb_', not 'ipb'.
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #13
                          I have did this.,....

                          Comment


                          • #14
                            You could not posssibly get that error if the table prefix is set to: ipb_
                            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                            Change CKEditor Colors to Match Style (for 4.1.4 and above)

                            Steve Machol Photography


                            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                            Comment


                            • #15
                              $impexconfig['source']['database'] = 'slidell_forums';
                              $impexconfig['source']['tableprefix'] = 'ipb_';

                              # Error logging will log import errors to a database table impexerror
                              # for use with support.
                              # Language file is the file of phrases to be used, default is english.
                              # pagespeed is the second(s) wait before the page refreshes.
                              $impexconfig['system']['errorlogging'] = true;
                              $impexconfig['system']['language'] = 'impex/impex_language.php';
                              $impexconfig['system']['pagespeed'] = 10;
                              ?>

                              ImpExConfig.php

                              Comment

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