cms_widgettype doesn't exist eror

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Elyk
    Senior Member
    • Sep 2003
    • 292
    • 4.2.x

    [CMS] cms_widgettype doesn't exist eror

    Running 4.2.0 suite, but have the vbcms disabled.

    Now trying to uninstall other products like vbarcade and when we select uninstall we get this error:


    Database error in vBulletin 4.2.0:

    Invalid SQL:

    DELETE cms_widgettype, cms_widget, cms_widgetconfig
    FROM package AS package
    LEFT JOIN cms_widgettype AS cms_widgettype
    ON cms_widgettype.packageid = package.packageid
    LEFT JOIN cms_widget AS cms_widget
    ON cms_widget.widgettypeid = cms_widgettype.widgettypeid
    LEFT JOIN cms_widgetconfig AS cms_widgetconfig
    ON cms_widgetconfig.widgetid = cms_widget.widgetid
    WHERE package.productid = 'dbtech_vbarcade_vbcredits';

    MySQL Error : Table 'xxxxxx.cms_widgettype' doesn't exist
    Error Number : 1146
    Request Date : Thursday, June 7th 2012 @ 12:27:39 AM
    Error Date : Thursday, June 7th 2012 @ 12:27:40 AM
    Script : http://xxxxxxxxx/forum/admincp/plugi...do=productkill
    Referrer : http://xxxxxxxxx/forum/admincp/plugi...e_vbcredits&s=
    IP Address : xxxxxxxx
    Username : xxxx
    Classname : vB_Database
    MySQL Version : 5.1.52-cll


    Now have 3 items I want to uninstall but cant because of this. Cant even uninstall the vbcms as we get the same error. Saw a bug report when searching but dont see a solution yet for this: - http://tracker.vbulletin.com/browse/VBIV-15165
    Last edited by Elyk; Wed 6 Jun '12, 9:02pm.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Run this query in phpMyAdmin to create your table:

    CREATE TABLE cms_widgettype (
    widgettypeid INT UNSIGNED NOT NULL AUTO_INCREMENT,
    class VARBINARY(50) NOT NULL,
    packageid INT UNSIGNED NOT NULL,
    PRIMARY KEY (widgettypeid)
    )

    then check the 'package' table to get the 'packageid' value for vbcms, change '$packageid' in the query below to that value then run this to populate it with default data:

    INSERT IGNORE INTO " . TABLE_PREFIX . "cms_widgettype
    (class, packageid)
    VALUES
    ('SectionNavExt', $packageid),
    ('CategoryNav', $packageid),
    ('Static', $packageid),
    ('Rss', $packageid),
    ('myFriends', $packageid),
    ('Searchwidget', $packageid),
    ('Poll', $packageid),
    ('StaticBB', $packageid),
    ('Recent', $packageid)

    Now, re-run the upgrade - do you have the same problem?
    Vote for:

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

    Comment

    • Elyk
      Senior Member
      • Sep 2003
      • 292
      • 4.2.x

      #3
      Created table cms_widgettype.

      Now when checking package table I have nothing for vbcms, it shows packageid 1 for vbulletin, packageid 2 for vBBlog, and thats it.

      Strange thing when doing the last upgrade from 4.2.0 beta to 4.2..0 we had no problems and no errors showed with the upgrade.

      - - - Updated - - -

      - - - Updated - - -

      Actually I lied. The guy who did the upgrade said he had no problems and since we do not use the vbcms we just had it disabled. Now checking with phpadmin we have no vbcms table at all showing except for the cms_widgettype that I made following your first step so there must have been a problem with the last upgrade.

      So would running upgrade again make the tables for the vbcms that are not there or would each one have to be manually created?

      Comment

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

        #4
        Delete that table you just created then run the upgrade script - this will re-install the CMS provided all the CMS related files (and the XML in particular) are on your server.
        Vote for:

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

        Comment

        • Elyk
          Senior Member
          • Sep 2003
          • 292
          • 4.2.x

          #5
          Hi Trevor,

          Okay, deleted table. Uploaded the latest 4.2.0 patch level 1 release.

          Started upgrade but it started with the cms processing steps 1 > 32

          Gets to step 31 and we get this action required report:

          Unexpected Text:
          <?xml version="1.0" encoding="windows-1252"?> <?xml version="1.0" encoding="windows-1252"?> <errors> <error><![CDATA[<p>Database Error</p> Invalid SQL: SELECT COUNT(*) AS count FROM cms_node WHERE nodeid <> 1; Table 'kristic_TDishaw.cms_node' doesn't exist]]></error> <error_html><![CDATA[<p>Database error in vBulletin 4.2.0</p> <p>Invalid SQL: SELECT COUNT(*) AS count FROM cms_node WHERE nodeid <> 1;<p> <p> <strong>MySQL Error</strong> : Table 'kristic_TDishaw.cms_node' doesn't exist<br /> <strong>Error Number</strong> : 1146<br /> <strong>Request Date</strong> : Saturday, June 9th 2012 @ 03:37:05 AM<br /> <strong>Error Date</strong> : Saturday, June 9th 2012 @ 03:37:06 AM<br /> <strong>Script</strong> : http://xxxxxx/forum/install/upgrade.php<br /> <strong>Referrer</strong> : http://xxxxxx/forum/install/upgrade.php<br /> <strong>Classname</strong> : vB_Database<br /> <strong>MySQL Version</strong> : 5.1.52-cll<br /> </p>]]></error_html> </errors>



          After clicking on okay on the report you see status:aborted. Does the same thing when running the product_cms via the add/import product manager.

          Comment

          • flash84
            New Member
            • Mar 2012
            • 15
            • 4.2.X

            #6
            Ok I've got the exact same problem as you Elyk. I just upgraded my Vb from 3.8.7 to 4.2. I misunderstood the part where it asks if you want to install the default CMS content. I was thinking no I don't want the default content in the CMS because I want to write my own content. So I clicked "No" to installing the CMS default content.

            When checking my CMS on the Vb4.2 it was completely messed up. So I read some guides and it said to uninstall the CMS. When uninstalling the CMS I got the same error as Elyk.

            Database error in vBulletin 4.2.0:

            Invalid SQL:

            DELETE cms_widgettype, cms_widget, cms_widgetconfig
            FROM package AS package
            LEFT JOIN cms_widgettype AS cms_widgettype
            ON cms_widgettype.packageid = package.packageid
            LEFT JOIN cms_widget AS cms_widget
            ON cms_widget.widgettypeid = cms_widgettype.widgettypeid
            LEFT JOIN cms_widgetconfig AS cms_widgetconfig
            ON cms_widgetconfig.widgetid = cms_widget.widgetid
            WHERE package.productid = 'vbcms';

            MySQL Error : Table 'xxx_xxx.cms_widgettype' doesn't exist
            Error Number : 1146
            Request Date : Sunday, June 10th 2012 @ 01:49:23 PM
            Error Date : Sunday, June 10th 2012 @ 01:49:24 PM
            Script : http://www.xxxxx.com/admincp/plugin.php?do=productkill
            Referrer : http://www.xxxxx.com/admincp/plugin....uctid=vbcms&s=
            IP Address : xxxxxxxx
            Username : xxxx
            Classname : vB_Database
            MySQL Version : 5.1.63-cll


            So I tried creating the table cms_widgettype and then uninstalling the CMS again but got the same error as above (the CMS uninstall did however remove the cms_widgettype table and all other cms tables were removed by the uninstall script).

            So now I have tried to rerun the upgrade script to reinstall the CMS and it goes through the CMS install step by step but then I am getting the following error message at Step 31 of 32 and the install stops running. Also none of the CMS tables have been created in the database.

            Unexpected Text:
            <?xml version="1.0" encoding="windows-1252"?>
            <?xml version="1.0" encoding="windows-1252"?>
            <errors>
            <error><=!=[=C=D=A=T=A=[<p>Database Error</p>

            Invalid SQL:

            SELECT COUNT(*) AS count
            FROM cms_node
            WHERE nodeid <> 1;

            Table 'xxx_xxx.cms_node' doesn't exist]=]=></error>
            <error_html><=!=[=C=D=A=T=A=[<p>Database error in vBulletin 4.2.0</p>
            <p>Invalid SQL:

            SELECT COUNT(*) AS count
            FROM cms_node
            WHERE nodeid <> 1;<p>
            <p>
            <strong>MySQL Error</strong> : Table 'xxx_xxx.cms_node' doesn't exist<br />
            <strong>Error Number</strong> : 1146<br />
            <strong>Request Date</strong> : Sunday, June 10th 2012 @ 02:18:14 PM<br />
            <strong>Error Date</strong> : Sunday, June 10th 2012 @ 02:18:15 PM<br />
            <strong>Script</strong> : http://www.xxxxx.com/install/upgrade.php<br />
            <strong>Referrer</strong> : http://www.xxxxx.com/install/upgrade.php<br />
            <strong>Classname</strong> : vB_Database<br />
            <strong>MySQL Version</strong> : 5.1.63-cll<br />
            </p>]=]=></error_html>
            </errors>

            I would like to use the CMS. So my question is how do I fully remove and then reinstall the CMS? Do I have to wait for a future VB release where the CMS uninstall bug is fixed? Or is there a way to get around the error above when reinstalling the CMS default content?

            Help would be very much appreciated!
            Last edited by flash84; Sat 9 Jun '12, 11:17pm.

            Comment

            • TheLastSuperman
              Senior Member
              • Sep 2008
              • 1799

              #7
              Originally posted by flash84
              I would like to use the CMS. So my question is how do I fully remove and then reinstall the CMS?
              Uninstall the CMS first.
              > AdminCP > Plugins & Products > Product Manager > [Add/Import Product] > Import the CMS.xml file which is found in /includes/xml/product-vbcms.xml


              Former vBulletin Support Staff
              Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
              Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

              Comment

              • flash84
                New Member
                • Mar 2012
                • 15
                • 4.2.X

                #8
                Originally posted by TheLastSuperman
                Uninstall the CMS first.
                > AdminCP > Plugins & Products > Product Manager > [Add/Import Product] > Import the CMS.xml file which is found in /includes/xml/product-vbcms.xml
                Thanks for the quick reply, but when I uninstall the CMS I get the first error message I showed in my post above and the CMS is still displayed as being installed in Manage Products.

                So I tried installing it again anyway without fully uninstalling it using your steps and it goes through the 32 step process.

                All of the installation Steps 1-29 say Skipping step,not needed. Then Step 30 says Product Upgraded Completed and it goes to Step 31 where I am presented with the second error message that I posted above.

                Is there any other way I can uninstall the CMS so that it doesn't give me that error and then think it is still installed?

                Comment

                • flash84
                  New Member
                  • Mar 2012
                  • 15
                  • 4.2.X

                  #9
                  I have solved the CMS uninstall problem.
                  I put in a Vbulletin support ticket and they did something to complete the CMS uninstall process. Then I ran the CMS install script and everything is working now!
                  Last edited by flash84; Mon 11 Jun '12, 5:15am.

                  Comment

                  • oldlock
                    Senior Member
                    • Jun 2009
                    • 171
                    • 3.8.x

                    #10
                    Can anyone post the solution, I have the same issue where I wish to uninstall a number of pre 4.2.0 plugins and this error message presents all the time ?

                    Comment

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

                      #11
                      You're getting this error when trying to uninstall a plugin?
                      Vote for:

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

                      Comment

                      • oldlock
                        Senior Member
                        • Jun 2009
                        • 171
                        • 3.8.x

                        #12
                        Originally posted by Trevor Hannant
                        You're getting this error when trying to uninstall a plugin?
                        Yes, like the OP. If I try to uninstall any plugin the error presents.

                        Comment

                        • oldlock
                          Senior Member
                          • Jun 2009
                          • 171
                          • 3.8.x

                          #13
                          Anyone ?

                          Comment

                          • Matthew Gordon
                            Senior Member
                            • May 2002
                            • 3243
                            • 1.1.x

                            #14
                            Warning: This will delete any CMS data that you have. (But you should already know that as you are uninstalling/reinstalling it.)
                            Run the following MySQL queries:
                            Code:
                            DROP TABLE IF EXISTS `cms_article`, `cms_category`, `cms_grid`, `cms_layout`, `cms_layoutwidget`, `cms_navigation`, `cms_node`, `cms_nodecategory`, `cms_nodeconfig`, `cms_nodeinfo`, `cms_permissions`, `cms_rate`, `cms_sectionorder`, `cms_widget`, `cms_widgetconfig`, `cms_widgettype`;
                            DELETE FROM product WHERE productid = 'vbcms';
                            DELETE FROM productcode WHERE productid = 'vbcms';
                            DELETE FROM productdependency WHERE productid = 'vbcms';
                            Now, run the upgrade script so it can reinstall the CMS properly. Disable the CMS if you want, just don't uninstall it or delete its tables in the database.

                            Comment

                            • oldlock
                              Senior Member
                              • Jun 2009
                              • 171
                              • 3.8.x

                              #15
                              If I re-upload the install folder (minus install.php) will the upgrade script function ? I don't wish to disturb the rest of the site while I tidy this matter up.

                              Comment

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