Re: [Semediawiki-user] No unique constraint: Is this wise?

[Brian O. <bos...@ve...>]

Yaron,

Two records in the smw_ids table, with the same smw_namespace and same  
smw_title, but with different smw_id's.

I was using Gu's SQFT extension, #sask, but got this error:

Database error
A database query syntax error has occurred. This may indicate a bug in  
the software. The last attempted database query was:
(SQL query hidden)
from within function "SQFTSMW::getSelectResult". MySQL returned error  
"1242: Subquery returns more than 1 row (localhost)".

The workaround was to delete one of the 2 properties with the same name.

Brian O.


On Nov 6, 2008, at 3:59 PM, Yaron Koren wrote:

> By two "properties", do you two different property pages, or two  
> different triples with the same subject, property and object? Or  
> something else?
>
> -Yaron
>
>
> On Thu, Nov 6, 2008 at 12:10 PM, Brian Osborne  
> <bos...@ve...> wrote:
> SMW users,
>
> I accidentally created 2 properties with the same name, then ran into
> error messages trying to use that property. I could fix the problem by
> deleting the extra or unused property from within the database, but
> I'm a bit surprised that I was allowed to create these 2 properties in
> the first place. The CREATE TABLE statement shows that I could create
> all kinds of things with the same name in one namespace. Since I can't
> actually use these duplicates or triplicates or ... whatever .... why
> am I allowed to create them? This seems unwise to me, shouldn't there
> should be a unique constraint there?
>
> Brian O.
>
>
>
> CREATE TABLE `smw_ids` (
>   `smw_id` int(8) unsigned NOT NULL auto_increment,
>   `smw_namespace` int(11) NOT NULL,
>   `smw_title` varchar(255) character set latin1 collate latin1_bin
> NOT NULL,
>   `smw_iw` char(32) default NULL,
>   `smw_sortkey` varchar(255) character set latin1 collate latin1_bin
> NOT NULL,
>   PRIMARY KEY  (`smw_id`),
>   KEY `smw_title` (`smw_title`,`smw_namespace`,`smw_iw`),
>   KEY `smw_sortkey` (`smw_sortkey`)
> ) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=latin1 |
>
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Semediawiki-user mailing list
> Sem...@li...
> https://lists.sourceforge.net/lists/listinfo/semediawiki-user
>