#30 SQL database creation error -> array problem in PHP

[Alexander Bruch]

Hi,
It seems that there is an bug at initial Database
creation, it fails for me with the following Error:
-----------
SQL ERROR:
CREATE TABLE working_days ( setup_name VARCHAR( 11 )
DEFAULT '-1' NOT NULL , Mon TINYINT( 1 ) DEFAULT '1' ,
Tue TINYINT( 1 ) DEFAULT '1' , Wed TINYINT( 1 ) DEFAULT
'1' , Thu TINYINT( 1 ) DEFAULT '1' , Fri TINYINT( 1 )
DEFAULT '1' , Sat TINYINT( 1 ) DEFAULT '' , Sun
TINYINT( 1 ) DEFAULT '', PRIMARY KEY ( setup_name ))
Invalid default value for 'Sat'
SQL ERROR:
INSERT INTO working_days (setup_name ,Mon ,Tue ,Wed
,Thu ,Fri ,Sat ,Sun ) VALUES ( 'ite_0' ,'1' ,'1' ,'1'
,'1' ,'1' ,'' ,'' )
Table 'xpweb.working_days' doesn't exist
SQL ERROR:
SELECT * FROM working_days WHERE setup_name = 'ite_0'
LIMIT 1
Table 'xpweb.working_days' doesn't exist

------------

The problem is that there is no '0' on Sun and Sat.

The Problem is because of the Array:
XP_DEFAULT_ITERATION_WORKING_PACE

In Config.inc.php it is initialised with true and false
values. true seems to be '1' in PHP and false is
nothing, at least at my php installation.
A workaround was to einter a 0 instead of false.

Maybe this in IncludeConfig.inc.php is wrong:

$XP_DEFAULT_ITERATION_WORKING_PACE = array(^M

// Monday^M

"Mon" => XP_MONDAY_WORK,^M

// Tuesday^M

"Tue" => XP_TUESDAY_WORK,^M

// Wednesday^M

"Wed" => XP_WEDNESDAY_WORK,^M

// Thursday^M

"Thu" => XP_THURSDAY_WORK,^M

// Friday^M

"Fri" => XP_FRIDAY_WORK,^M

// Saturday^M

"Sat" => XP_SATURDAY_WORK,^M

// Sunday^M

"Sun" => XP_SUNDAY_WORK ^M

);^M

My XPWeb version is: 3.2.1

PHP version: PHP/4.4.0-3