how to install MySQL 4.x with XAMPPlite 1.5.1 -CREloaded err
Posted: 14. April 2006 19:12
Hi,
I am trying to install CRELoaded 6.2 pro on XAMPP lite 1.5.1 (with the MySQL version 5.1.18).
I go through the wizard setup and on stage 4 I get the following error:
____________________________________________________________________________________________________
Welcome to CRE Loaded 6.2 Pro Installation Wizard! Select Langauge: EnglishDeutschFrenchEspañol
New Installation
Database Import
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;
_____________________________________________________________________________________________________
now of course, I can alter the script to remove the requirement of "default", but if I do this and the rest of the install goes well, when I open up the client side (ie the catalogue) I get the following (under articles) ...
I think it might be due to CRELoaded 6.2 not working under MySQL 5.x, if so, are there any work-arounds? or how can i download and install an earlier version of MySQL with XAMPPlite 1.5.1 ?
s./
Categories
--------------------------------------------------------------------------------
View All Products ->
--------------------------------------------------------------------------------
All Products sorted by Categories ->
--------------------------------------------------------------------------------
All Products sorted by Manufacturers ->
Reviews
There are currently no product reviews
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
Affiliate Program
Affiliate Information
Affiliate Log In
Who's Online
There currently is 1 guest online.
Links
2nd Category
CRE Loaded
Upcoming Events
Sorry, you browser does not support iframes.
Articles
1054 - Unknown column 'a.authors_id' in 'on clause'
select a.articles_id from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)
[TEP STOP]
I am trying to install CRELoaded 6.2 pro on XAMPP lite 1.5.1 (with the MySQL version 5.1.18).
I go through the wizard setup and on stage 4 I get the following error:
____________________________________________________________________________________________________
Welcome to CRE Loaded 6.2 Pro Installation Wizard! Select Langauge: EnglishDeutschFrenchEspañol
New Installation
Database Import
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;
_____________________________________________________________________________________________________
now of course, I can alter the script to remove the requirement of "default", but if I do this and the rest of the install goes well, when I open up the client side (ie the catalogue) I get the following (under articles) ...
I think it might be due to CRELoaded 6.2 not working under MySQL 5.x, if so, are there any work-arounds? or how can i download and install an earlier version of MySQL with XAMPPlite 1.5.1 ?
s./
Categories
--------------------------------------------------------------------------------
View All Products ->
--------------------------------------------------------------------------------
All Products sorted by Categories ->
--------------------------------------------------------------------------------
All Products sorted by Manufacturers ->
Reviews
There are currently no product reviews
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
Affiliate Program
Affiliate Information
Affiliate Log In
Who's Online
There currently is 1 guest online.
Links
2nd Category
CRE Loaded
Upcoming Events
Sorry, you browser does not support iframes.
Articles
1054 - Unknown column 'a.authors_id' in 'on clause'
select a.articles_id from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1' and a.articles_date_added > SUBDATE(now( ), INTERVAL '30' DAY)
[TEP STOP]