Error importing cacti.sql

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
zlynt
Posts: 9
Joined: Tue Nov 08, 2005 4:33 pm

Error importing cacti.sql

Post by zlynt »

The import hangs at line 1856 with the following error:

C:\downloads\cacti-0.8.6g\cacti-0.8.6g>mysql --user=root --password cacti <cacti.sql
Enter password: *********
ERROR 1264 (22003) at line 1856: Out of range value adjusted for column 'availability' at row 1

Could be a bug in mysql, gonna check, but I thought I'd post here too.

running msql 5.0.15 btw
Top
User avatar
rony
Developer/Forum Admin
Posts: 6022
Joined: Mon Nov 17, 2003 6:35 pm
Location: Michigan, USA
Contact:
Contact rony

Post by rony »

FYI, we don't support mysql 5.0 yet...

But, please submit a bug in bugs.cacti.net, this will have to be resolved before 0.8.6h is released.
[size=117][i][b]Tony Roman[/b][/i][/size]
[size=84][i]Experience is what causes a person to make new mistakes instead of old ones.[/i][/size]
[size=84][i]There are only 3 way to complete a project: Good, Fast or Cheap, pick two.[/i][/size]
[size=84][i]With age comes wisdom, what you choose to do with it determines whether or not you are wise.[/i][/size]
Top
zlynt
Posts: 9
Joined: Tue Nov 08, 2005 4:33 pm

Post by zlynt »

well i guess that's likely the problem then huh... i'll switch to 4x and see what happens.

Thanks for the prompt feedback.
Top
ibae
Posts: 2
Joined: Thu Nov 10, 2005 10:59 pm

Post by ibae »

1. open cacti.sql using notepad
2. From Edit -> Goto 1856
3. Change last number 100.00000 in line 1856 to 99.99999
Then try to import it again. :wink:
Top
Post Reply

Return to “Help: Windows Specific”

Who is online

Users browsing this forum: No registered users and 0 guests