SQL ERROR - letter blocks

[ChunkyCurry]

i tried to add letter blocks but it failed

INSERT INTO `phoenix`.`catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`) VALUES
('912345', '91', 'Letter Block', '1', '1', '1', '1', '1', '0', '0', 'default_3x3', '', '', '', '', '', '', '', '0');

It Says

[Err] 1364 - Field 'page_link_description' doesn't have a default value

im using phoenix

 

[JoshuaLuke]

INSERT INTO `uber`.`catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`, `page_link_description`, `page_link_pagename`) VALUES
('912345', '91', 'Letter Block', '1', '1', '1', '1', '1', '0', '0', 'default_3x3', '', '', '', '', '', '', '', '0', ' ', ' ');  [/FONT]

 

[Thom]

Means that you have MySQL Strict mode enabled too. You probably want to disable that.

 

[ChunkyCurry]

Means that you have MySQL Strict mode enabled too. You probably want to disable that.

How do i do this?

 

[JoshuaLuke]

How do i do this?

Open your "my.ini" file within the MySQL installation directory, and look for the text "sql-mode".
Find:
Code:

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"​

Replace with:
Code:

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"​

Or, you can run an SQL query within your database management tool, such as phpMyAdmin:

Code:

SET @@global.sql_mode= '';​