Thread

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

Is your MySQL server running in strict mode?

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

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

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!

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!