By winner on

Warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (module,delta,theme,status) VALUES('user', 0, 'garland', 1) in D:\www\Apache\Apache2\www\includes\database.mysql.inc on line 167

Warning: Field 'pages' doesn't have a default value query: INSERT INTO blocks (module,delta,theme,status) VALUES('user', 1, 'garland', 1) in D:\www\Apache\Apache2\www\includes\database.mysql.inc on line 167

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at D:\www\Apache\Apache2\www\includes\database.mysql.inc:167) in D:\www\Apache\Apache2\www\includes\bootstrap.inc on line 735

Warning: Cannot modify header information - headers already sent by (output started at D:\www\Apache\Apache2\www\includes\database.mysql.inc:167) in D:\www\Apache\Apache2\www\includes\bootstrap.inc on line 413

Warning: Cannot modify header information - headers already sent by (output started at D:\www\Apache\Apache2\www\includes\database.mysql.inc:167) in D:\www\Apache\Apache2\www\includes\bootstrap.inc on line 414

Warning: Cannot modify header information - headers already sent by (output started at D:\www\Apache\Apache2\www\includes\database.mysql.inc:167) in D:\www\Apache\Apache2\www\includes\bootstrap.inc on line 415

Warning: Cannot modify header information - headers already sent by (output started at D:\www\Apache\Apache2\www\includes\database.mysql.inc:167) in D:\www\Apache\Apache2\www\includes\bootstrap.inc on line 416

Warning: Cannot modify header information - headers already sent by (output started at D:\www\Apache\Apache2\www\includes\database.mysql.inc:167) in D:\www\Apache\Apache2\www\includes\bootstrap.inc on line 417

⋅ Categories: Drupal 5.x

Comments

alphaomega’s picture

alphaomega commented

Can someone tell me how I could intercept the call to insert into a table for any TEXT or longtext value.

The problem is because alot of fields are TEXT or LONGTEXT and in MySQL 5 they can't have default value anymore. (was ok in MySQL4)

Turning strict mode MySQL 4 is not an option.

If I knew where to change and add all thoses fields in the INSERT QUERY it could help alot with migrating to MySQL 5.