Mysql base

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

Moderators: Developers, Moderators

Post Reply
CORNUEZ
Posts: 1
Joined: Tue Jan 02, 2007 4:50 am

Mysql base

Post by CORNUEZ »

Hello,
I have an error in the creation of the table host_snmp_cache
Mysql return ERROR 1101 (42000): BLOB/TEXT column 'oid' can't have a default value
Version of Mysql 5.0.27

Thanks
cigamit
Developer
Posts: 3369
Joined: Thu Apr 07, 2005 3:29 pm
Location: B/CS Texas
Contact:

Post by cigamit »

Hum... I've ran into this error with a few of my plugins that do basically the same thing. Problem is MySQL 5 errors out saying they can't have a default value, but if you remove it MySQL 3 errors out saying it has to have a default value.

Short of making a different SQL file for each version, I have no clue how to make both versions work with it.
User avatar
BSOD2600
Cacti Moderator
Posts: 12171
Joined: Sat May 08, 2004 12:44 pm
Location: USA

Post by BSOD2600 »

Personally, I'd say who cares about MySQL 3 :-P.
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests