Enabling CMS Causes Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Front Range
    New Member
    • Apr 2008
    • 29
    • 3.6.x

    [CMS] Enabling CMS Causes Database Error

    Can someone explain what this means? When I enable CMS I get this error. When running upgrade it went through the installing CMS fine and it does show in the ACP with content.

    Database error in vBulletin 4.0.0:

    Invalid SQL:
    SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
    (CASE WHEN node.contenttypeid = 17 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
    (CASE WHEN node.contenttypeid = 17 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
    node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight,
    node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall, node.showrating,
    node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
    parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled

    FROM v_cms_node AS node
    LEFT JOIN v_cms_node AS parent ON parent.nodeid = node.parentnode

    WHERE node.nodeid = 1;

    MySQL Error : Unknown column 'node.showrating' in 'field list'
    Error Number : 1054
    Request Date : Wednesday, December 23rd 2009 @ 12:39:42 PM
    Error Date : Wednesday, December 23rd 2009 @ 12:39:42 PM
    Script : http://www.mydomain.com/forums/content.php
    Referrer : http://www.nydomain.com/forums/forum.php
    IP Address : 76.25.209.116
    Username : Chris
    Classname : vB_Database
    MySQL Version : 5.0.81-community
  • Lynne
    Former vBulletin Support
    • Oct 2004
    • 26255

    #2
    Did you have any problems during your upgrade? Do you have access to your database? Check out the table v_cmx_node and see if the field "showrating" is there. It is the last field in that table in my database.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    • Front Range
      New Member
      • Apr 2008
      • 29
      • 3.6.x

      #3
      No problems during upgrade Lynn. I do not see "showrating" in v_cmx_node. Is that something I can add, this is getting a bit beyond my comfort level but looking at phpMyAdmin it looks doable.

      Comment

      • Front Range
        New Member
        • Apr 2008
        • 29
        • 3.6.x

        #4
        I added "showrating" which seems to have fixed it. Thanks Lynn!
        Attached Files
        Last edited by Front Range; Wed 23 Dec '09, 10:44am.

        Comment

        • Lynne
          Former vBulletin Support
          • Oct 2004
          • 26255

          #5
          You should change that a bit. showrating should be a smallint (not varchar)- length of 6 - notnull (you have that correct) - and default of '0' (no apostrophe around that).

          Please don't PM or VM me for support - I only help out in the threads.
          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
          Want help modifying your vbulletin forum? Head on over to vbulletin.org
          If I post CSS and you don't know where it goes, throw it into the additional.css template.

          W3Schools <- awesome site for html/css help

          Comment

          • Front Range
            New Member
            • Apr 2008
            • 29
            • 3.6.x

            #6
            Thank you Lynn!

            Comment

            • Front Range
              New Member
              • Apr 2008
              • 29
              • 3.6.x

              #7
              Darn, it stopped the error when enabling CMS but now when I try to create an article I get this:

              Database error in vBulletin 4.0.0:

              Invalid SQL:
              INSERT INTO v_cms_nodeinfo
              (nodeid, description, creationdate, title, html_title)
              VALUES
              (150, 'New Article', 1261604374, 'New Article', 'New Article');

              MySQL Error : Duplicate entry '150' for key 1
              Error Number : 1062

              Would it be possible to delete the CMS tables and run the upgrade to solve this? I'd like to eliminate all errors since I suspect this may be one error after another. Ideally I'd like the sample CMS which I didn't install when I had the chance.

              Comment

              • Front Range
                New Member
                • Apr 2008
                • 29
                • 3.6.x

                #8
                I've uninstalled the blog & CMS.

                Comment

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