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: Unable to delete records (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Mon, 15 Jul 2013 13:13:11 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] Unable to delete records
To: "YUUNI, OSAY OSMAN" <[email protected]>
Cc: "[email protected]" <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Hi Yuuni,
There was a bug in 1.0.4. It happened to some people and not others
(depending on their version of SQL::Translator).
You can create the table manually by pasting the following into your
mysql client:
CREATE TABLE `rrloc` (
`altitude` bigint NOT NULL,
`horiz_pre` varchar(32) NULL,
`id` bigint NOT NULL auto_increment,
`latitude` bigint NOT NULL,
`longitude` bigint NOT NULL,
`rr` bigint NOT NULL,
`size` varchar(32) NULL,
`ttl` varchar(32) NULL,
`vert_pre` varchar(32) NULL,
UNIQUE INDEX `rrloc1` (`rr`),
PRIMARY KEY (`id`),
CONSTRAINT `fk_rr_4` FOREIGN KEY (`rr`) REFERENCES `rr` (`id`)
) ENGINE=InnoDB;
cv
On 7/15/13 11:01 AM, YUUNI, OSAY OSMAN wrote:
>
> Hi everyone,
>
> When I try to delete a record I get the following error. I?m not sure
> what the issue is. I?ve checked the netdot database and it does not
> contain any table called rrloc. Can anyone help?
>
> ==
>
> Transaction aborted: Netdot::Model::RRLOC can't SELECT id, longitude,
> latitude, rr, altitude
>
> FROM rrloc
>
> WHERE rr = ?
>
> : DBD::mysql::st execute failed: Table 'netdot.rrloc' doesn't exist
> [for Statement "SELECT id, longitude, latitude, rr, altitude
>
> FROM rrloc
>
> WHERE rr = ?
>
> " with ParamValues: 0='385'] at
> /usr/local/share/perl5/DBIx/ContextualFetch.pm line 52, line 4.
>
> Stack:
>
> [/usr/local/share/perl5/DBIx/ContextualFetch.pm:52]
>
> [/usr/local/share/perl5/DBIx/ContextualFetch.pm:32]
>
> [/usr/local/share/perl5/Class/DBI.pm:1139]
>
> [/usr/local/share/perl5/Class/DBI/Search/Basic.pm:169]
>
> [/usr/local/share/perl5/Class/DBI.pm:1094]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/None.pm:68]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/Delete.pm:21]
>
> [/usr/local/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
>
> [/usr/local/share/perl5/Class/Trigger.pm:74]
>
> [/usr/local/share/perl5/Class/DBI.pm:735]
>
> [/usr/local/netdot/lib/Netdot/Model.pm:876]
>
> [/usr/local/netdot/lib/Netdot/Model/RR.pm:373]
>
> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2379]
>
> [/usr/local/netdot/htdocs/generic/delete.html:161]
>
> [/usr/local/netdot/htdocs/generic/delete.html:163]
>
> [/usr/local/netdot/htdocs/autohandler:110]
>
> [/usr/local/netdot/htdocs/management/dhandler:1]
>
> [/usr/local/netdot/htdocs/management/autohandler:81]
>
> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/991088776/management/autohandler.obj:21]
>
> [/usr/local/netdot/htdocs/autohandler:76]
>
> at /usr/local/share/perl5/Class/DBI/Search/Basic.pm line 169.
>
> Stack:
>
> [/usr/local/share/perl5/Carp.pm:100]
>
> [/usr/local/share/perl5/Class/DBI.pm:169]
>
> [/usr/local/share/perl5/Class/DBI.pm:1143]
>
> [/usr/local/share/perl5/Class/DBI/Search/Basic.pm:169]
>
> [/usr/local/share/perl5/Class/DBI.pm:1094]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/None.pm:68]
>
> [/usr/local/share/perl5/Class/DBI/Cascade/Delete.pm:21]
>
> [/usr/local/share/perl5/Class/DBI/Relationship/HasMany.pm:75]
>
> [/usr/local/share/perl5/Class/Trigger.pm:74]
>
> [/usr/local/share/perl5/Class/DBI.pm:735]
>
> [/usr/local/netdot/lib/Netdot/Model.pm:876]
>
> [/usr/local/netdot/lib/Netdot/Model/RR.pm:373]
>
> [/usr/local/netdot/lib/Netdot/Model/Device.pm:2379]
>
> [/usr/local/netdot/htdocs/generic/delete.html:161]
>
> [/usr/local/netdot/htdocs/generic/delete.html:163]
>
> [/usr/local/netdot/htdocs/autohandler:110]
>
> [/usr/local/netdot/htdocs/management/dhandler:1]
>
> [/usr/local/netdot/htdocs/management/autohandler:81]
>
> [/usr/local/share/perl5/HTML/Mason/Request.pm:951]
>
> [/usr/local/netdot/htdocs/masondata/obj/991088776/management/autohandler.obj:21]
>
> [/usr/local/netdot/htdocs/autohandler:76]
>
> <http://www.afdb.org/>Osay Osman YUUNI**| Lead IT Infrastructure
> Specialist/Regional ICT Coordinator
>
> *African Development Bank Group | Southern Africa Resource Center
> *Office: +27 12 003 6900 | Ext:8402|+216 7110 2111| E-Mail:
> [email protected] <mailto:[email protected]>_
>
> Mobile: +27 78 090 5501 | Web: http://www.afdb.org <http://www.afdb.org/>
>
> Please consider the environment before printing this email...
>
>
>
> _______________________________________________
> Netdot-users mailing list
> [email protected]
> https://osl.uoregon.edu/mailman/listinfo/netdot-users
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 56, Issue 10
********************************************
