Announcement

Collapse
No announcement yet.

Upgrade : Error at step 6 routeid cannot be null

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

  • Upgrade : Error at step 6 routeid cannot be null

    Hi,

    Just did an upgrade from VB4 to VB5 Connect with the starting guide locked in forum.

    I have an error at step 6 : Column 'routeid' cannot be null

    An error has occurred with your database. Please contact vBulletin Support for assistance.Module: final, Step 6 Database Error:1048
    Column 'routeid' cannot be null
    Query:

    UPDATE vb4_node c SET c.routeid = (SELECT MAX(r.routeid) FROM vb4_routenew r WHERE r.contentid = c.nodeid AND class='vB5_Route_Channel') WHERE c.routeid = 0 AND c.contenttypeid = 29
    Did i made something wrong ?

  • #2
    What version of MySQL do you have installed on your server?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      Originally posted by Wayne Luke View Post
      What version of MySQL do you have installed on your server?
      MySQL version 5.1.31

      Comment


      • #4
        Can you run this query in phpMyAdmin (or equivalent) and post the results:

        describe vb4_routenew;
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment


        • #5
          requÍte SQL: describe vb4_routenew;
          Enregistrements: 12
          Field Type Null Key Default Extra
          routeid int(10) unsigned NO PRI NULL auto_increment
          name varchar(100) YES MUL NULL
          redirect301 int(10) unsigned YES NULL
          prefix varchar(200) NO MUL NULL
          regex varchar(200) NO UNI NULL
          class varchar(100) YES MUL NULL
          controller varchar(100) NO NULL
          action varchar(100) NO NULL
          template varchar(100) NO NULL
          arguments mediumtext NO NULL
          contentid int(10) unsigned NO NULL
          guid char(150) YES NULL

          Comment


          • #6
            Still have the routeid error.
            Tried Beta 8, same error.

            Anyone help ?

            Comment


            • #7
              Still no news about his error ?

              Comment


              • #8
                May be related to this issue: http://tracker.vbulletin.com/browse/VBV-1072

                You can petition to reopen. The developers may need a copy of your database to find and fix the error.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API - Full / Mobile
                Vote for your favorite feature requests and the bugs you want to see fixed.

                Comment


                • #9
                  Still having error with new beta.

                  Comment


                  • #10
                    Can you zip your database up and make it available to our developers here: http://tracker.vbulletin.com/browse/VBV-1072

                    They can't currently recreate it but want to work on it with your database.
                    Translations provided by Google.

                    Wayne Luke
                    The Rabid Badger - a vBulletin Cloud demonstration site.
                    vBulletin 5 API - Full / Mobile
                    Vote for your favorite feature requests and the bugs you want to see fixed.

                    Comment


                    • #11
                      Any update on this? We need the database to work on recreating the error.
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud demonstration site.
                      vBulletin 5 API - Full / Mobile
                      Vote for your favorite feature requests and the bugs you want to see fixed.

                      Comment


                      • #12
                        Still having the error on Beta 23.
                        I uploaded the db on the bug tracker as requested.

                        Comment


                        • #13
                          Developers got your database copy and will try to fix it.

                          Sent from my iPhone using Forum Runner

                          vBulletin QA - vBulletin Support French - Lead Project Tools developer

                          Next release? Soon(tm)

                          Comment


                          • #14
                            As i said on tracker, still have same issue with beta 25.

                            Comment


                            • #15
                              I still can't upgrade to last beta due to this problem.
                              Is there a chance to have some help ?

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X