how to install MySQL 4.x with XAMPPlite 1.5.1 -CREloaded err

Problems with the Windows version of XAMPP, questions, comments, and anything related.

how to install MySQL 4.x with XAMPPlite 1.5.1 -CREloaded err

Postby simonearly » 14. April 2006 19:12


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 ?



View All Products ->

All Products sorted by Categories ->

All Products sorted by Manufacturers ->


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.


2nd Category
CRE Loaded

Upcoming Events

Sorry, you browser does not support iframes.

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)

Posts: 5
Joined: 13. March 2006 10:23

Postby potain » 17. April 2006 12:54


I too think that my problems with Vtiger may be becuase of MySQL 5.

Would you please advise if there is a an earlier version of XAMPP with MySQL 4.0 or instructions on how to install it on the latest version of XAMPP .

Thank you

Jean Perombelon
Posts: 9
Joined: 14. April 2006 04:50
Location: Brisbane Australia

Postby potain » 17. April 2006 13:11


Just found this link for XAMPP Windows 1.4.7:

and I am downloading it now. The question do I need to uninstall v 1.51 or can I istall on top of it.

Thank you
Posts: 9
Joined: 14. April 2006 04:50
Location: Brisbane Australia

Postby simonearly » 18. April 2006 11:43

go to the Apache friends forum. There, they will tell you how to do it.
basically, you download MySQL 1.4.x from the site, install it as a windows service, then using the XAMPPlite control panel, disable the MySQL 5.x service and stop it auto-running.

you then need to reinstall CREloaded6.2 plus all the patches as if it was a clean install.

then, stop and start everything and you will be using MySQL 4.x and everything will work fine!

worked for me!
Posts: 5
Joined: 13. March 2006 10:23

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 104 guests