ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

SQL Error creating a new template

November 16, 2011 1:38pm

Subscribe [3]
  • #1 / Nov 16, 2011 1:38pm

    Alex Pereda

    17 posts

    I got the following error when adding a new template. I tired creating and editing, also create by itself. 
    I wasn’t able to find any information on the subject.

    EE v2.1.3
    Build:  20101220

    A Database Error Occurred
    Error Number: 1364

    Field ‘no_auth_bounce’ doesn’t have a default value

    INSERT INTO `exp_templates` (`group_id`, `template_name`, `template_type`, `template_data`, `edit_date`, `site_id`, `last_author_id`) VALUES (‘3’, ‘main_c3’, ‘css’, ‘’, 1321468189, ‘1’, ‘1’)

    Filename: D:\Websites\hsstudent.osvcurriculum.com\_neesys\codeigniter\system\database\DB_driver.php

    Line Number: 330

  • #2 / Nov 16, 2011 2:00pm

    Is your MySQL server running in strict mode?

  • #3 / Nov 16, 2011 2:01pm

    I believe that if you run http://expressionengine.com/overview/requirements/ it will let you know if you aren’t sure about that setting.

  • #4 / Nov 16, 2011 5:58pm

    Alex Pereda

    17 posts

    I don’t think it is. I have another site on the same server that works fine. Same MySQL server and web server.
    Both have sql_mode set to:
    STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    Both have the same version of EE as well.

    Thanks

  • #5 / Nov 17, 2011 2:11pm

    Dan Decker

    7338 posts

    Hi Alex Pereda,

    Are you seeing this on a fresh installation or an update? You mention another installation on the same server, and that install is running fine. Do both installations share the same MySQL user? If not, does the user for the affected installation have all the appropriate rights?

    SELECT
    INSERT
    UPDATE
    DELETE
    CREATE
    INDEX
    ALTER
    DROP

    Thanks!

  • #6 / Nov 17, 2011 2:29pm

    Dan Decker

    7338 posts

    Hi Alex,

    I had a discussion with one of our devs and she suggested that it would be a strict mode issue and offered a possible fix. Can you look at the table PHPMyAdmin perhaps? Look for the exp_templates table and check if “no_auth_bounce” has a default set? If not, can you run this statement:

    ALTER TABLE `exp_templates` CHANGE `no_auth_bounce` `no_auth_bounce` VARCHAR(50) NOT NULL DEFAULT ''

    Let us know if that gets you squared away.

    Thanks!

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases