cacti.sql importation problem

[xphildar]

Hello, i'm new to cacti and french so excuse me for stupid question and my bad english

I installed cacti one time on a Windows XP with apache and mysql and got no problem but or some reason i had to re install my OS i went for Windows 2000 server SP4 with IIS 5 and other stuff for cacti...

i succesfully create my cacti base but when i try to import the cacti.sql into this base with the command :

msql --user=cactiuser --password cacti < c:\inetpub\wwwroot\cacti\cacti.sql

I got this error message

ERROR 1264 (22003) at line 1856: Out of range value adjusted for column 'availability' at row 1

i dont want to modify this files cause i sure it works

If someone have answer for me it will sure make me happy

i'm running cacti-0.8.6g
(maybe trying to run is better -_- )

thank you

[TheWitness]

Please use mysql control center or phpMyAdmin to change the size of the host tables definitions for the following fields:

cur_time
avg_time
min_time
max_time

Change them to DECIMAL(10,5) and the problem will go away. Please do not use MySQL 5.x as it does not work with Cacti. The client may however work in Cactid.

TheWitness

[xphildar]

thank you , i got it work with your advice,

i got an another problem, graph display but no value inside...

anyway i will look around in the forum there some thread talking about this problem ^^