Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. Re: DBD::mysql::st execute failed: Field 'data' doesn't have
a default value [for Statement "INSERT INTO datacache (tstamp,
name) (Carlos Vicente)
2. Re: DBD::mysql::st execute failed: Field 'data' doesn't have
a default value [for Statement "INSERT INTO datacache (tstamp,
name) (Stafford Rau)
----------------------------------------------------------------------
Message: 1
Date: Fri, 26 Jul 2013 16:13:32 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] DBD::mysql::st execute failed: Field
'data' doesn't have a default value [for Statement "INSERT INTO
datacache (tstamp, name)
To: Stafford Rau <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
I have not seen this before.
The error suggests that the insert query does not include a value for
the mandatory field 'data'.
The data should be coming from Net::Patricia. Do you have that
installed? If so, which version?
cv
On 7/26/13 12:15 PM, Stafford Rau wrote:
> I just installed netdot 1.0.4 on CentOS 6.4. After doing a discovery
> from the first device, I got a ton of the following errors & warnings
> when I added it: I had the "Add new subnets" and "new subnets inherit
> device owner/user" check boxes selected.
>
> WARN - cr01-dsbdc-county.clackamas.us
> <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not insert IP
> 10.32.50.1 <http://10.32.50.1>: Error while inserting DataCache:
> Can't insert new DataCache: DBD::mysql::st execute failed: Field
> 'data' doesn't have a default value [for Statement "INSERT INTO
> datacache (tstamp, name) ERROR - cr01-dsbdc-county.clackamas.us
> <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not insert
> Subnet 10.32.50.0/24 <http://10.32.50.0/24>: Error while inserting
> DataCache: Can't insert new DataCache: DBD::mysql::st execute failed:
> Field 'data' doesn't have a default value [for Statement "INSERT INTO
> datacache (tstamp, name)
>
> Is this normal, or a known issue? Thanks, --Stafford A. Rau
>
>
>
> _______________________________________________ Netdot-users mailing
> list [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
Message: 2
Date: Fri, 26 Jul 2013 13:40:50 -0700
From: Stafford Rau <[email protected]>
Subject: Re: [Netdot-users] DBD::mysql::st execute failed: Field
'data' doesn't have a default value [for Statement "INSERT INTO
datacache (tstamp, name)
To: [email protected]
Message-ID:
<caaqua9e5sswckxvor4npehkq9xczfhjndhso4guwxdf7nxr...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
It looks like Net::Patricia is version 1.20:
cpan[1]> install Net::Patricia
<snip>
Net::Patricia is up to date (1.20).
cpan[2]>
This seems to be happening anytime I initially try to add any new object.
However, when I try the second time to add the same object, it succeeds.
Adding an ip space container object:
*ip.html* produced the following error:
Error while inserting DataCache: Can't insert new DataCache:
DBD::mysql::st execute failed: Field 'data' doesn't have a default
value [for Statement "INSERT INTO datacache (tstamp, name)
VALUES (?, ?)
" with ParamValues: 0=0, 1='iptree4'] at
/usr/share/perl5/DBIx/ContextualFetch.pm line 52.
Then I added the exact same data a second time, and it worked without
error. Odd.
Address:10.38.0.0/16Status:*Container*Description:Network ManagementFirst
Created2013-07-26 13:33:31Last Modified2013-07-26 13:33:31Owner:NetEng
<http://mgt2.clackamas.us/netdot/management/view.html?table=Entity&id=25>
[edit] <http://mgt2.clackamas.us/netdot/management/ip.html#>Used
by:NetEng
<http://mgt2.clackamas.us/netdot/management/view.html?table=Entity&id=25>
[edit] <http://mgt2.clackamas.us/netdot/management/ip.html#>Netmask:
255.255.0.0Broadcast:10.38.255.255Usable Addresses:65536 (10.38.0.1 -
10.38.255.254)Address Utilization:
Used: 104 of 65536 Available: 65432 (>99%)
Space Allocated:
Available: 95%
On Fri, Jul 26, 2013 at 1:13 PM, Carlos Vicente <[email protected]>wrote:
> I have not seen this before.
>
> The error suggests that the insert query does not include a value for
> the mandatory field 'data'.
>
> The data should be coming from Net::Patricia. Do you have that
> installed? If so, which version?
>
> cv
>
> On 7/26/13 12:15 PM, Stafford Rau wrote:
> > I just installed netdot 1.0.4 on CentOS 6.4. After doing a discovery
> > from the first device, I got a ton of the following errors & warnings
> > when I added it: I had the "Add new subnets" and "new subnets inherit
> > device owner/user" check boxes selected.
> >
> > WARN - cr01-dsbdc-county.clackamas.us
> > <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not insert IP
> > 10.32.50.1 <http://10.32.50.1>: Error while inserting DataCache:
> > Can't insert new DataCache: DBD::mysql::st execute failed: Field
> > 'data' doesn't have a default value [for Statement "INSERT INTO
> > datacache (tstamp, name) ERROR - cr01-dsbdc-county.clackamas.us
> > <http://cr01-dsbdc-county.clackamas.us> [Vlan2]: Could not insert
> > Subnet 10.32.50.0/24 <http://10.32.50.0/24>: Error while inserting
> > DataCache: Can't insert new DataCache: DBD::mysql::st execute failed:
> > Field 'data' doesn't have a default value [for Statement "INSERT INTO
> > datacache (tstamp, name)
> >
> > Is this normal, or a known issue? Thanks, --Stafford A. Rau
> >
> >
> >
> > _______________________________________________ Netdot-users mailing
> > list [email protected]
> > https://osl.uoregon.edu/mailman/listinfo/netdot-users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20130726/45963ec2/attachment-0001.html
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 56, Issue 13
********************************************
