Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    Anyone here ????

    Comment


    • #3
      Anyone here ????

      Comment


      • #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


        • #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 - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment

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