Apache Friends Support Forum

Hi, is there a way I can download an older version of XAMPP as CreLoaded osCommerce version 2 is refusing to install.
Apparently this may have something to do with XAMPP's MYSQL version being to new.

Unless anybody knows what the answer to this creloaded installer error code is ??
1067 - Invalid default value for 'dt'

CREATE TABLE visual_verify_code ( oscsid varchar(32) NOT NULL, code varchar(6) NOT NULL, dt TIMESTAMP(12) NOT NULL DEFAULT 'CURDATE()', PRIMARY KEY (oscsid) ) TYPE=MyISAM;

Phil.

You cannot set the default for a TIMESTAMP column to be the value of a function, like "'CURDATE()'". The DEFAULT value must be a constant like "CURRENT_TIMESTAMP".

Wiedmann wrote:You cannot set the default for a TIMESTAMP column to be the value of a function, like "'CURDATE()'". The DEFAULT value must be a constant like "CURRENT_TIMESTAMP".

Are you saying substitute CURDATE() for CURRENT_TIMESTAMP ?

No thats not what he is saying constants are varables that dont change i.e. a constant value. you are trying, rather the script you are installing is trying to assign it a value via a function which is not possible for a default value in MYSQL. i would try removing that default value, and trying out the script to see if there are any ill effects. FYI as far back as MYSQL 4.1.9 or further this will not work, so a downgrade might not fix it. Later.

Thanks for the techie tips but I have now sorted the problem by installing an earlier version of XAMPP from here:
http://sourceforge.net/project/showfile ... e_id=89552

osCommerce isn't so much the problem as creloaded is - I presume some of the contributions may have been written to cater for an earlier version of mysql.

All sorted now.
Thanks.