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: small SQL error on 0.9.10 -> 1.0.1 upgrade (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Fri, 12 Oct 2012 11:03:21 -0400
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] small SQL error on 0.9.10 -> 1.0.1 upgrade
To: Alexander Bochmann <[email protected]>
Cc: netdot-users <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi Alexander,
On 10/11/12 12:19 PM, Alexander Bochmann wrote:
> Hi,
>
> my upgrade from 0.9.10 -> 1.0.1 -> 1.0.2 went basically
> quite smooth (besides the web interface was partly broken
> because I forgot to copy over the new apache config file) -
> but I got one error during make upgrade for 1.0.1:
>
> DBD::mysql::db do failed: Duplicate entry '' for key 'Site5' at
> ../lib/DBUTIL.pm line 392.
> ERROR while executing ALTER TABLE site ADD UNIQUE KEY Site5 (number):
> DBD::mysql::db do failed: Duplicate entry '' for key 'Site5' at
> ../lib/DBUTIL.pm line 392.
>
> Doesn't seem to have any negative impact though, as far
> as I can see, netdot runs fine now.
>
You probably have two or more sites with the same number. You can
probably find them with a SQL query:
mysql> select a.id, a.number, b.id, b.number from site a, site b where
a.number=b.number;
After correcting that, go ahead and add the unique index again:
mysql> ALTER TABLE site ADD UNIQUE KEY Site5 (number);
Cheers,
--
cv
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 47, Issue 6
*******************************************
