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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    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 customization and demonstration site.
        vBulletin 5 Documentation - Updated every Friday. Report issues here.
        vBulletin 5 API - Full / Mobile
        I am not currently available for vB Messenger Chats.

        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 customization and demonstration site.
                vBulletin 5 Documentation - Updated every Friday. Report issues here.
                vBulletin 5 API - Full / Mobile
                I am not currently available for vB Messenger Chats.

                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 customization and demonstration site.
                    vBulletin 5 Documentation - Updated every Friday. Report issues here.
                    vBulletin 5 API - Full / Mobile
                    I am not currently available for vB Messenger Chats.

                    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 customization and demonstration site.
                      vBulletin 5 Documentation - Updated every Friday. Report issues here.
                      vBulletin 5 API - Full / Mobile
                      I am not currently available for vB Messenger Chats.

                      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