Probleme install CMS

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lolo04
    New Member
    • Oct 2004
    • 25
    • 3.6.x

    [Suite] Probleme install CMS

    Hello ,
    i have upgrade my vb 3.8.1==> vb4 suite gold
    the upgrade systeme work fine just step 6 i have a probleme
    Database error in vBulletin 4.0.0:

    Invalid SQL:
    ALTER TABLE cms_widget DROP INDEX title, ADD INDEX title(title);

    MySQL Error : Table '37.cms_widget' doesn't exist
    Error Number : 1146
    Request Date : Tuesday, December 22nd 2009 @ 10:49:57 AM
    Error Date : Tuesday, December 22nd 2009 @ 10:49:57 AM
    Script :
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.1.41
    i try to reimport after by xml file but i have the same error
    can you help me for ind a solution
    thanks in advence
    Last edited by lolo04; Tue 22 Dec '09, 2:10am.
  • Jorge Martinez
    New Member
    • Feb 2008
    • 28

    #2
    I have the same problem since installing the suite.

    Comment

    • lolo04
      New Member
      • Oct 2004
      • 25
      • 3.6.x

      #3
      any one know ??

      Comment

      • lolo04
        New Member
        • Oct 2004
        • 25
        • 3.6.x

        #4
        no body can help me ??

        Comment

        • Trevor Hannant
          vBulletin Support
          • Aug 2002
          • 24325
          • 5.7.X

          #5
          Can you post the script that you've taken out from the error above (rename the site to site.com if you wish to keep your site private)
          Vote for:

          - Admin Settable Paid Subscription Reminder Timeframe (vB6)
          - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

          Comment

          • lolo04
            New Member
            • Oct 2004
            • 25
            • 3.6.x

            #6
            when i try to install via plugin this link
            Database error in vBulletin 4.0.0:

            Invalid SQL:
            ALTER TABLE cms_widget DROP INDEX title, ADD INDEX title(title);

            MySQL Error : Table '37.cms_widget' doesn't exist
            Error Number : 1146
            Request Date : Wednesday, December 23rd 2009 @ 10:18:36 AM
            Error Date : Wednesday, December 23rd 2009 @ 10:18:36 AM
            Script : http://**********/admincp/plugin.php?do=productimport
            Referrer : http://********/admincp/plugin.php?do=productadd
            IP Address :
            Username : lolo04
            Classname : vB_Database
            MySQL Version : 5.1.41
            thanks for your help

            Comment

            • lolo04
              New Member
              • Oct 2004
              • 25
              • 3.6.x

              #7
              or when i re run upgrade
              Database error in vBulletin 4.0.0:

              Invalid SQL:
              ALTER TABLE cms_widget DROP INDEX title, ADD INDEX title(title);

              MySQL Error : Table '37.cms_widget' doesn't exist
              Error Number : 1146
              Request Date : Wednesday, December 23rd 2009 @ 10:40:42 AM
              Error Date : Wednesday, December 23rd 2009 @ 10:40:43 AM
              Script : http://**********/install/finalupgrade.php?step=6
              Referrer : http://********/install/finalupgrade.php?step=5
              IP Address :
              Username :
              Classname : vB_Database
              MySQL Version : 5.1.41

              Comment

              • Trevor Hannant
                vBulletin Support
                • Aug 2002
                • 24325
                • 5.7.X

                #8
                Can you post a screenshot of the list of cms tables that do exist on your database?
                Vote for:

                - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                Comment

                • lolo04
                  New Member
                  • Oct 2004
                  • 25
                  • 3.6.x

                  #9
                  i have no table on my database
                  Click image for larger version

Name:	Sans titre 1.jpg
Views:	2
Size:	10.8 KB
ID:	3677267

                  Comment

                  • Trevor Hannant
                    vBulletin Support
                    • Aug 2002
                    • 24325
                    • 5.7.X

                    #10
                    I assume you have a backup of your database from before the attempt to upgrade? If so, can you do the following and see what happens here:

                    - drop all vB database tables
                    - restore your 3.8.1 backup
                    - delete all your vBulletin files (except any custom avatar/signature folders)
                    - upload the contents of the 'upload' folder
                    - re-run yoursite.com/install/upgrade.php

                    Make sure that everything uploads correctly before re-attempting the upgrade.
                    Vote for:

                    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                    Comment

                    • lolo04
                      New Member
                      • Oct 2004
                      • 25
                      • 3.6.x

                      #11
                      I have the same issue on my test board when i upgrade rc4 to gold same error

                      works great on fresh install :s
                      Last edited by lolo04; Wed 23 Dec '09, 4:02am.

                      Comment

                      • Trevor Hannant
                        vBulletin Support
                        • Aug 2002
                        • 24325
                        • 5.7.X

                        #12
                        Did you try what I suggested above?
                        Vote for:

                        - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                        - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                        Comment

                        • lolo04
                          New Member
                          • Oct 2004
                          • 25
                          • 3.6.x

                          #13
                          I have delete all files
                          delete my database
                          uplaod my save of db
                          re-upload all new files
                          re run upgrade and I have exactly the same error
                          Database error in vBulletin 4.0.0:

                          Invalid SQL:
                          ALTER TABLE cms_widget DROP INDEX title, ADD INDEX title(title);

                          MySQL Error : Table 'forum_40.cms_widget' doesn't exist
                          Error Number : 1146
                          Request Date : Wednesday, December 23rd 2009 @ 02:21:57 PM
                          Error Date : Wednesday, December 23rd 2009 @ 02:21:57 PM
                          Script : http://*********/install/finalupgrade.php?step=6
                          Referrer :
                          IP Address : 90.0.41.46
                          Username :
                          Classname : vB_Database
                          MySQL Version : 5.1.41

                          Comment

                          • Trevor Hannant
                            vBulletin Support
                            • Aug 2002
                            • 24325
                            • 5.7.X

                            #14
                            Can you raise a Support Ticket for this as there is something specific to your installation that's preventing the tables from being created before that step. Please also carry out the following steps:

                            - drop all vB database tables
                            - restore your 3.8.1 backup
                            - restore your 3.8.1 files
                            Vote for:

                            - Admin Settable Paid Subscription Reminder Timeframe (vB6)
                            - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

                            Comment

                            • lolo04
                              New Member
                              • Oct 2004
                              • 25
                              • 3.6.x

                              #15
                              I'have resolve my probleme
                              restore my db
                              re-up all files on 3.8
                              remove all my plugin
                              and run upgrade and now i have the cms fix for me happy

                              Comment

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