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

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]
simonearly
 
Posts: 5
Joined: 13. March 2006 10:23

Postby potain » 17. April 2006 12:54

Hi

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
potain
 
Posts: 9
Joined: 14. April 2006 04:50
Location: Brisbane Australia

Postby potain » 17. April 2006 13:11

Hi

Just found this link for XAMPP Windows 1.4.7:

http://www.apache-mysql-php.com/?artclno=77

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
potain
 
Posts: 9
Joined: 14. April 2006 04:50
Location: Brisbane Australia

Postby simonearly » 18. April 2006 11:43

yes,
go to the Apache friends forum. There, they will tell you how to do it.
basically, you download MySQL 1.4.x from the MySQL.com 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!
s/.
simonearly
 
Posts: 5
Joined: 13. March 2006 10:23


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 47 guests