importing mysql database

Post general support questions here that do not specifically fall into the Linux or Windows categories.

Moderators: Developers, Moderators

Post Reply
doqb
Posts: 8
Joined: Sun Oct 22, 2006 6:19 pm

importing mysql database

Post by doqb »

I have installed mysql 5.0.26 for windows and created the cacti database, when trying to import the cacti.sql database structure I get the following error:

ERROR 1101 (42000) at line 1890: BLOB/TEXT column 'oid' can't have a default value

I found the error being in the host_snmp_cache table under:

oid TEXT NOT NULL default '',

I have changed that line to

oid TEXT NOT NULL,

and the import is succesfull, but I dont know if that will affect cacti operation.....
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 »

It should not affect operations..

Interesting error....
[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
doqb
Posts: 8
Joined: Sun Oct 22, 2006 6:19 pm

Post by doqb »

thanks for the info....
Top
JasonGarrett
Posts: 2
Joined: Thu Sep 16, 2004 11:28 pm

Post by JasonGarrett »

I can confirm that this error also occurs in 5.0.41-community-nt-log MySQL Community Edition (GPL)
Top
Post Reply

Return to “Help: General”

Who is online

Users browsing this forum: No registered users and 0 guests