During Vbulletin4 setup error "Field 'gridhtml_backup' doesn't have a default value"

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wtrk68
    Member
    • Apr 2015
    • 75
    • 4.2.x

    During Vbulletin4 setup error "Field 'gridhtml_backup' doesn't have a default value"

    When I want to test vbulletin 4 for another host it gives an error during installation.

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

    Module: vbcms, Step 1 Database Error:1364

    Field 'gridhtml_backup' doesn't have a default value

    Query:

    REPLACE INTO cms_grid
    (gridid, gridhtml, title, addcolumn, addcolumnsnap, addcolumnsize, `columns`, flattened)
    VALUES
    (1,

    Anyone have idea ?
    Last edited by wtrk68; Sun 24 Feb '19, 2:17am.
  • wtrk68
    Member
    • Apr 2015
    • 75
    • 4.2.x

    #2
    Anyone here ????

    Comment

    • wtrk68
      Member
      • Apr 2015
      • 75
      • 4.2.x

      #3
      Anyone here ????

      Comment

      • motd2
        Member
        • Jun 2010
        • 49
        • 3.8.x

        #4
        You have a problem with MySQL on the server.
        Can help query in the phpmyadmin:
        Code:
        set global sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

        Comment

        • Wayne Luke
          vBulletin Technical Support Lead
          • Aug 2000
          • 73976

          #5
          That field is a mediumtext field and shouldn't need a default.

          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API

          Comment

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