import cacti.sql to mysql error

andy2002 · Post by **andy2002** » Mon Jun 26, 2006 9:50 am

Sir
When I import cacti.sql into mysql,it shows"ERROR 1264 (22003) at line 1857: Out of range value adjusted for column 'availability' at row 1",can you help me?

thanks

BSOD2600 · Post by **BSOD2600** » Mon Jun 26, 2006 10:47 am

Read http://forums.cacti.net/viewtopic.php?t=11747

After following all those instructions, you still have the same problem?

andy2002 · Post by **andy2002** » Mon Jun 26, 2006 11:53 am

Sir
Thank your help,but I don't understand how to install "mysqli extension"?

Thanks

BSOD2600 · Post by **BSOD2600** » Mon Jun 26, 2006 12:40 pm

Honestly, that's really not needed to fix the error you've got.

1) make sure mysql isnt in sql-strict mode.
2) delete the old cacti database folder
3) patch cacti
4) THEN import cacti.sql

lassep · Post by **lassep** » Fri Jul 21, 2006 3:46 pm

BSOD2600 wrote:Honestly, that's really not needed to fix the error you've got.

1) make sure mysql isnt in sql-strict mode.
2) delete the old cacti database folder
3) patch cacti
4) THEN import cacti.sql

I changed the language setting on SQL to utf8 and then the cacti DB could be created without error

/Lasse

Post by **TheWitness** » Tue Jul 25, 2006 9:07 pm

There is also a patched cacti.sql at http://www.cacti.net/patches

TheWitness

Cacti

import cacti.sql to mysql error

import cacti.sql to mysql error

Who is online