Thread

Apache 2.2 on Win XP PHP 5.2.2 mysql 5.0.41

I navigate to update.php, click on the link and I get:

Error: The following error was encountered
MySQL ERROR:

Error Number: 1364

Description: Field ‘site_description’ doesn’t have a default value

Query: INSERT INTO `exp_sites` (`site_id`, `site_label`, `site_name`) VALUES (‘1’, ‘The \‘Hood’, ‘the_hood’)

in ud_16.php, the function do_update() first creates the table and then tries to insert a row that doesn’t meet the constraints.

$Q[] = "CREATE TABLE `exp_sites` (
              `site_id` int(5) unsigned NOT NULL auto_increment,
              `site_label` varchar(100) NOT NULL default '',
              `site_name` varchar(50) NOT NULL default '',
              `site_description` text NOT NULL,
              `site_system_preferences` TEXT NOT NULL ,
              `site_mailinglist_preferences` TEXT NOT NULL ,
              `site_member_preferences` TEXT NOT NULL ,
              `site_template_preferences` TEXT NOT NULL ,
              `site_weblog_preferences` TEXT NOT NULL ,
              PRIMARY KEY  (`site_id`),
              KEY `site_name` (`site_name`))";
            
        $Q[] = $DB->insert_string('exp_sites', 
                                  array('site_id'                    => 1, 
                                          'site_label'                => $conf['site_name'],
                                          'site_name'                    => $this->create_short_name($conf['site_name'])));

gah, this is a strict mode issue.

Are you able to get around it manually by updating in PHPMyAdmin or something similar?

Yeah, I just reconfigured the mysql instance and disabled strict mode.

Cool. I did find a knowledge base article about how to do that.

Enjoy 1.6!

We added a check for Strict mode to the installer, but had not for the update utility.  I’ve gone ahead and added it for the next build so anyone encountering this in the future will get a descriptive error message when trying to update.  Of course, long term, for 2.0, we plan to support Strict mode, but for now, this should help alleviate problems or confusion.