Problem when upgrading from 4.2.0 to 4.2.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • king sense
    New Member
    • Jul 2012
    • 4
    • 4.2.X

    Problem when upgrading from 4.2.0 to 4.2.1


    • Processing CMS
    • Step 30 - Updating cms_widgettype table

    • An error has occurred with your database. Please contact vBulletin Support for assistance.


      Module: vbcms, Step 30 Database Error:1064


      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5


      Query:



      INSERT IGNORE INTO cms_widgettype
      (class, packageid)
      VALUES
      ('ActivityStream', )



  • king sense
    New Member
    • Jul 2012
    • 4
    • 4.2.X

    #2
    no one can help me!!?

    Comment

    • Paul M
      Former Lead Developer
      vB.Com & vB.Org
      • Sep 2004
      • 9886

      #3
      Its a Sunday, I suggest a little patience.
      Baby, I was born this way

      Comment

      • BirdOPrey5
        Senior Member
        • Jul 2008
        • 9613
        • 5.6.3

        #4
        Did you have your CMS disabled or uninstalled?

        In any case use phpmyadmin or another MySQL tool to look at your package table int he database.

        Does it have 3 entries?

        Basically it should look something like this:

        Code:
        packageid | productid | class
        1 | vbulletin | vBForum
        2 | vbblog | vBBlog
        3 | vbcms |vBCms

        Comment

        • king sense
          New Member
          • Jul 2012
          • 4
          • 4.2.X

          #5
          my CMS disabled

          Comment

          • AliMadkour
            Senior Member
            • Dec 2004
            • 1588
            • 6.X

            #6
            Do you have important articles in CMS, If no try to manually uninstall it by running those queries from SQL tab in PhpMyAdmin
            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';
            Don't forget to add prefix if use it,

            then run upgrade process from
            Code:
            http://www.domain.com/forum/install/upgrade.php?version=vbcms&only=1
            after this upgrade completed run the final upgrade from:
            Code:
            http://www.domain.com/forum/install/upgrade.php

            Former vBulletin Support Staff
            Need Help?, Or P.M. Me

            Comment

            • king sense
              New Member
              • Jul 2012
              • 4
              • 4.2.X

              #7
              my upgrade completed but I have some problems :

              1- When I enable the vBulletin CMS happening this problem when I open my home page

              [ATTACH]n60325[/ATTACH]

              2- And the other problem is I can't upload any photo

              [ATTACH=CONFIG]n60326[/ATTACH]

              Comment

              • g00gl3r
                Senior Member
                • Sep 2004
                • 336
                • 3.5.x

                #8
                Did you manage to fix this? I have the same problem.

                Comment

                Related Topics

                Collapse

                Working...