gmane.comp.web.wiki.semediawiki.devel

Re: missing distinct in hierarchy query

Luka Frelih — 2010-03-09T21:08:40

hello!


actually, instead of the ignore clause of mysql smw creates a rule of
similar effect on postgres just after creating each temporary table -
this sql code comes from the function getCreateTempIDTableSQL a few
screens down from executeHierarchyQuery.

but it seems this is not enough when selecting multiple identical ids
for insert in one query. not sure about why the rule does not apply in
this case. so we had to put that distinct into that specific query to
avoid getting internal errors about duplicate ids. 

while i don't know whether there might be other queries in need of
distinct on postgres, this one definitely does. and after adding it we
see no more errors or wrong results from queries, so i don't see why
this could not be implemented right away.


cool... denny, if you're interested in meeting, please contact me
off-list!

best,
LF





------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourse

missing distinct in hierarchy query

Luka Frelih — 2010-03-09T04:33:07

hello!

ran into db errors when running queries recently (we're on svn and
postgresql...)

A database error has occurred
Query: INSERT INTO smw_new (id) SELECT s_id::integer FROM smw_subs2,
smw_res WHERE o_id=id
Function: SMW::executeHierarchyQuery
Error: 1 NAPAKA: duplicate key value violates unique constraint
"smw_new_pkey"

Backtrace:

#0 /wiki/includes/db/Database.php(538):
DatabasePostgres->reportQueryError('NAPAKA: duplic...', 1, 'INSERT INTO
smw...', 'SMW::executeHie...', false)
#1 /wiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2_Queries.php(835): DatabaseBase->query('INSERT INTO smw...', 'SMW::executeHie...')
#2 /wiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2_Queries.php(767): SMWSQLStore2QueryEngine->executeHierarchyQuery(Object(SMWSQLStore2Query))


adding distinct to this query helped:


Index: includes/storage/SMW_SQLStore2_Queries.php
===================================================================
--- includes/storage/SMW_SQLStore2_Queries.php(revision 634

Re: missing distinct in hierarchy query

Markus Krötzsch — 2010-03-09T07:46:36

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Semantic forms suggestion (FAO Yaron Koren)

Neill Mitchell — 2010-03-08T22:16:43

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Semantic forms suggestion (FAO Yaron Koren)

Yaron Koren — 2010-03-08T18:11:11

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Semantic forms suggestion (FAO Yaron Koren)

Robert Michel — 2010-03-08T17:13:23

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Semantic forms suggestion (FAO Yaron Koren)

Yaron Koren — 2010-03-08T14:31:17

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Semantic forms suggestion (FAO Yaron Koren)

Connell, Nick (CIOK — 2010-03-08T11:11:47

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Changes for using multi-valued properties

Markus Krötzsch — 2010-03-06T18:27:52

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

SRF going into testing mode

Denny Vrandecic — 2010-03-05T18:22:38

Just to let you know -- since I am aiming to release SRF 1.5 soon after SMW 1.5 has been released, I am starting some testing and consolidating the next few days.

I know I have gotten a lot of emails regarding updates, bugs, patches, etc. for SRF. I am afraid I will miss a number of them. If you want to ensure that I see your path, bug report, feature wish, etc. please enter it into the Bugzilla system, and set the component to SemanticResultFormats.

This page is your friend:

<https://bugzilla.wikimedia.org/enter_bug.cgi?product=MediaWiki%20extensions>

This would be super helpful.

Cheers,
denny


------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

Re: Date objects & #about

Yaron Koren — 2010-03-05T16:28:49

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Date objects & #about

John McClure — 2010-03-05T15:44:34

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: MediaWiki Developer Meet-Up, April 14-16, Berlin

Yaron Koren — 2010-03-05T14:21:40

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Recurring Events: "Every first saturday of a month"

Yaron Koren — 2010-03-05T00:58:58

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Recurring Events: "Every first saturday of a month"

John McClure — 2010-03-04T22:32:21

Normalization would show the day of a week is an attribute of a date. So:
* An #ask should be able to say ?Date.Weekday
* IOW, a "Date" is a first class object as much as, say, a "Place" is
* IOW, I'd like to see SMW standardize "category:Dates" and its properties
* And I'd like to see the ability to set those properties from a 'container'
object's template
* IMHO, {{#set: page-or-sio-name|propname=value}} would resolve alot of n-ary
issues
* I'm not sure yet how this plays with the (proposed?) Record datatype
   (e.g., is the Record datatype a reimplementation of SIO? Can Records be
named?)

Best regards,
John McClure



------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

Re: Recurring Events: "Every first saturday of a month"

David Raison — 2010-03-04T18:38:18

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


You're right.. this is probably the most complicated part of it ;)

Isn't this what Al suggested in the beginning?
If the original "month" were renamed "monthdate" and this one was called "monthday" or
"monthdayofweek"? (which isn't really better than "dayofweekinmonth", granted)

Does anyone else have a suggestion? :)

cheers,
D.

- --
HaxoGreen 2010 - the Hackers' Summercamp in Luxembourg
July 22nd till July 25th 2010, in Dudelange, Luxembourg
Register Now: http://events.hackerspace.lu/camp/2010/
- ----
mailto:david-LgkhI75pW+Wy8gQith0XOQ< at >public.gmane.org
xmpp:kwisatz-x1yyFRiaB/xrfHSGQ2Ha8aaybsWFMcnm< at >public.gmane.org
mobile: +43 650 73 63 834 | +352 691 44 23 24
++++++++++++++++++++++++++++++++++++++++++++
Wear your geek: http://syn2cat.spreadshirt.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkuP/hoACgkQYTtdUdP5zDdwBACdEc1MePnJUlIdJ2lAYNcUTbt2
pwEAnj9FbLNPdHWn

Re: Recurring Events: "Every first saturday of a month"

Yaron Koren — 2010-03-04T18:15:09

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f< at >public.gmane.org
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Re: Multi-day events

David Raison — 2010-03-04T17:23:48

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Well, this is rather more of a parser/templating issue than it is an SMW issue.
Also, I forgot to mention that I use

{{#arraymap: {{#dates: | StartDate={{{from}}} | EndDate={{{till}}} }}|,|x|[[Has date::x| ]]|  }}

to add the dates generated by DateDiff as SMW properties.

D.



- --
HaxoGreen 2010 - the Hackers' Summercamp in Luxembourg
July 22nd till July 25th 2010, in Dudelange, Luxembourg
Register Now: http://events.hackerspace.lu/camp/2010/
- ----
mailto:david-LgkhI75pW+Wy8gQith0XOQ< at >public.gmane.org
xmpp:kwisatz-x1yyFRiaB/xrfHSGQ2Ha8aaybsWFMcnm< at >public.gmane.org
mobile: +43 650 73 63 834 | +352 691 44 23 24
++++++++++++++++++++++++++++++++++++++++++++
Wear your geek: http://syn2cat.spreadshirt.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkuP7KQACgkQYTtdUdP5zDcVfQCfWA0TPWJim+er+MA3wcrril8S
bOoAnAsfEqNTGw5b7yHmwn6wPiTTChF7
=/3k5
-----END PGP SIGNATURE-----

Multi-day events

David Raison — 2010-03-04T17:19:14

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi again,

besides the "xofmonth" hack, I created another extension a while ago that modifies how multi-day
events are handled.

Usually (and without any better knowledge) if you have an event that starts on April 8th and ends on
April 10th, you only have two [[Has date::]] properties, i.e. the starting and ending dates.

The Timeline Result Format displays these events as continuous, but the Calendar does not.

Is there already a way to have the Calendar display the event on all days?

If not, this is what I did:  (Again, a very quick and dirty hack and not even using any SMW classes.
Example: https://www.hackerspace.lu/wiki/Hackito_Ergo_Sum! -->
https://www.hackerspace.lu/w/index.php?title=Calendar&month=4&year=2010 (8-10 April))

function efDateDiff(){
    global $wgParser;
    $wgParser->setFunctionHook('dates', 'calcdates');
}

/**
 * Adds the magic words for the parser functions
 */
function efDatesFunctionMagic( &$magicWords, $langCode ) {
        $magicW

SMWWriter API open for testing

Denny Vrandecic — 2010-03-04T13:25:13

Dear all,

I just have added a new extension to MediaWiki's SVN that we have been talking about for a while now: SMWWriter, an API for editing facts in SMW easily.

You will find a rather extensive Documentation here:

<http://semantic-mediawiki.org/wiki/Help:SMWWriter>

Since this is my first API extension, I hope I didn't do it too wrong. I know that a few of you had been waiting for this.

Please, test it. And let me know how it goes. And feel free to join in the development :) Or at least tell me about errors.

I think a proper release will follow after the release of SMW 1.5, and after I got and incorporated some initial feedback.

Cheers,
denny
------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev

Re: [News] SMW 1.5.0 is near

2010-03-04T09:48:15

Hi,

well the number of possible fields in n-ary properties is a make or break
criteria for me to be able to use MW/SMW, so it's a point I don't dare to lose
out of sight.

Right now the largest properties I added to the wiki have 15 to 20 fields (but
there are potential data with 60+).
'Unlimited' sounds too good to ask for ;) but a number below 20 would certainly
not allow me to update.

Cheers,
Gu

Quoting Markus Krötzsch <markus-8FRlne0xlEC1mCK3qmO25g7BcMlR18ew< at >public.gmane.org>:






------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev