I don't have mysql 5 (4.1.22-standard) or php 5 (4.4.8) does this make a difference. 

Other settings are:

Safe Mode:  OFF 
Open basedir:  none 
Display Errors:  ON 
Short Open Tags:  ON 
File Uploads:  ON 
Magic Quotes:  ON 
Register Globals:  OFF 
Output Buffering:  OFF 
Session save path:  /tmp 
Session auto start:  0 
XML enabled:  Yes 
Zlib enabled:  Yes 
Disabled Functions:  show_source, system, shell_exec, passthru, exec, phpinfo, popen, proc_open, fsockopen, socket_create

So far mia seems to be working fine.
Nootkan

Hi

I experienced this Strict Mode issue as well and since it was a test installation on my local machine, I decided to proceed with the process without disabling that setting.  Unsurprisingly, the installation was terminated prematurely with this message: 

and the following error log was generated:

SQL=BLOB/TEXT column 'text' can't have a default value:
- - - - - - - - - -
# Table structure for table `mia_poll_data`
CREATE TABLE `mia_poll_data` (
  `id` int(11) NOT NULL auto_increment,
  `pollid` int(4) NOT NULL default '0',
  `text` text NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
# Dumping data for table `mia_poll_data`
INSERT INTO `mia_poll_data` VALUES (20, 15, '', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (19, 15, '', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (18, 15, '', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (17, 15, 'Scott Adams', 1)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (16, 15, 'Tim Berners-Lee', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (15, 15, 'Linus Torvalds', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (14, 15, 'Bill Gates', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (13, 15, 'Steve Jobs', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (21, 15, '', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (22, 15, '', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (23, 15, '', 0)
= = = = = = = = = =
SQL=Table 'miacms_db.mia_poll_data' doesn't exist:
- - - - - - - - - -
INSERT INTO `mia_poll_data` VALUES (24, 15, '', 0)
= = = = = = = = = =

This raises a serious question.  What happens if a user does not have administrative rights to alter the Strict Mode setting?  A possible answer to this is that the user, if dealing with a hosting company, can simply request that action be taken. If the host is uncooperative, the subscriber can switch to a more accommodating provider.

The problem with this scenario is that it practically forces an idividual to make possibly highly disruptive changes.  I have performed numerous full or test installations using other CMS, Wikis, Learning Management Systems, Shopping Cart Systems, Blogging Engines, Forums, etc which use a MySQL database and none have required Strict Mode to be disabled. 

The folks at MySQL evidently saw the merits of having this setting enabled and based on my experience its appears that most system developers have designed their frameworks to be compliant.  When can we expect MiaCMS to become compatible?

Regards

Good stuff! Hope to see it happen .

Yep I figured out as much.  Actually only one instance needs to be altered.

In ../installation/miacms/sql/miacms.sql find (in line 566, the "#__poll_data" table creation query)

`text` text NOT NULL default '',

and change it to:

`text` text NOT NULL,

I am just wondering though how would this impact on the further functionality of the system and whether ther are any known issues with Strict Mode and any MiaCMS extensions.

Regards

Last edited by jazz (2008-10-10 13:27:25)

Apparently this is not the case.  I successfully completed the installation with Strict Mode enabled by editing the ../installation/sql/miacms.sql file, however  some problems were experienced in the  back-end.  These were solved by disabling Strict Mode.  The thread outlining the issues and solution can be viewed there http://forum.miacms.org/viewtopic.php?id=497.

Regards

Ok cauld, looking forward to the Strict Mode support .

Cheers