Re: [SMW-devel] Status SMW, release plans for 1.5.0
On Mittwoch, 10. Februar 2010, zehet...@molgen.mpg.de wrote:
Hi,
I'm not sure if I see this correctly but it looks to me that SMW 1.5 does
some modifications to the MySQL database (like creating new tables) which
are necessary for its 'internal part changes'.
What exactly does trigger those modifications?
The install/update button on Special:SMWAdmin. It is also possible to trigger
the update from the command line (like when upgrading MediaWiki). See INSTALL
for details on how to upgrade SMW.
I hope that this fixes your problem.
-- Markus
When I simply replace the SMW 1.4 extension folder with a new SMW 1.5
folder and try to go to a page (even a non-existing one) I get an
MediaWiki internal error because in function SMW:getSemanticData a SQL
query is executed which uses a table smw_subp2 which doesn't exist (yet).
Original exception: exception 'DBQueryError' with message 'A database error
has occurred
Query: SELECT DISTINCT o_id AS id0,o0.smw_title AS v0,o0.smw_namespace AS
v1,o0.smw_iw AS v2,o0.smw_sortkey AS v3 FROM `cmw_smw_subp2` INNER JOIN
`cmw_smw_ids` AS o0 ON o_id=o0.smw_id WHERE s_id='542'
Function: SMW::getSemanticData
Error: 1146 Table 'cancerdb.cmw_smw_subp2' doesn't exist
(localhost:mysql5.sock)
I guess that's one of the newly created tables but how do I force that
update/modification to create it?
The stack trace suggests that the SMW query, even on a non-existing page,
is triggered by SemanticForms
SFFormEditTab::displayTab(Object(SkinMonoBook),Array)
SFLinkUtils::getFormsThatPagePointsTo('Non-Kinase', 14, '_SF_DF',
'_SF_DF_BACKUP', 1)
SMWSQLStore2-getPropertyValues(Object(Title), Object(SMWPropertyValue))
If I disable the inclusion of SF_Settings.php (btw. the latest SVN version)
the error disappears.
Thanks,
Gu
Quoting Markus Krötzsch mar...@semantic-mediawiki.org:
And another copy for devel list. My first email went to the list owners
only:
email address autocompletion is a dangerous thing. -- Markus
On Montag, 8. Februar 2010, Markus Krötzsch wrote:
Dear SMW users,
this is just to let you know that the main changes to the SVN version
of SMW have been completed, and that the release of SMW 1.5.0 is
planned for February now. Since there have been major changes in some
internal parts, it would be good to get some testing going. Especially,
extension developers should check that there are no compatibility
problems with the new version -- little has changed in the officially
documented
interfaces,
but you never know.
The main changes in SMW 1.5.0 are internal, cleaning up the rather
complex piece of code use for database access in SMW, and should not be
visible to the user unless something went wrong. On the user level, a
different declaration of n-ary (multi-valued) properties, and an
extended UI for Special:Ask are the most noticeable changes.
We have heard that some users have reported problems/bugs with the SVN
version on IRC recently, but we do not know what exactly the problems
were. There are no logs of the IRC (and in any case single messages
are easy to overlook). So please, if you find any problems in SMW, be
sure to report them on bugzilla.mediawiki.org, or at least send some
email to one of the lists where it is on archive. Otherwise, your
problem reports have a high chance of going unnoticed.
Cheers,
Markus
--
Markus Krötzsch mar...@semantic-mediawiki.org
* Personal page: http://korrekt.org
* Semantic MediaWiki: http://semantic-mediawiki.org
* Semantic Web textbook: http://semantic-web-book.org
--
signature.asc
Description: This is a digitally signed message part.
--
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev___
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
Re: [SMW-devel] [Semediawiki-devel] Status SMW, release plans for 1.5.0
On Montag, 8. Februar 2010, Harwarth, Stefan (Bundeswehr) wrote: Hi, thank you very much Markus for all the improvements in SMW, I couldn't wait to try the new features but.. :( ..it doesn't work properly on my wiki. Whenever I put an #ask-query on a page that queries for all pages in a category, then all I get is an empty page (not even the output around the query is printed any more). This is usually seen when some memory issue occurs, e.g. due to more source code being loaded now. You can try to increase the PHP memory limit in LocalSettings.php (where requirements above 50M are unusual even if you use normal-sized queries; I found it needed on some wikis that create very long/broad result tables but basic operation should usually work with 20M). With the debug output format I don't get any errors and I can also past the SQL query into MySQL and get the desired rows, so up to the database query it runs fine. Unfortunately there is no debug output or exceptions printed even with full MediaWiki debugging features enabled :( Another oddity is that when using Spezial:Semantische Suche (is that Special:Ask? I never used it before...) it always prepends the Query part with broadtable20 after clicking the Finde Ergebnisse Button - and this is even independent of asking for a Category or a single page. This is strange and could hint at a URL encoding problem. Can you reproduce the problem on sandbox.semantic-mediawiki.org? The code for Special_Ask was recently extended by Yaron, so maybe he has an idea if this could be related. @Markus: On Bugzilla Philipp filed the bug 21232 in October, asking for chained property value printing which is a pretty important feature for my use case. Is it possible to add this feature to 1.5.0, or is it inherently impossible to implement, or are you just lacking the time :) I am aware of the bug, and I think it is not impossible to address (especially we do have a better query result architecture now that can do smarter things at printout time). But implementing it will be some work as it requires an extension not only in the result retrieval, but also in the parsing of query parameters and in the data structures that represent print requests for queries. Regards, Markus Nice evening, Stefan -Original Message- From: Markus Krötzsch [mailto:mar...@semantic-mediawiki.org] Sent: Monday, February 08, 2010 10:05 AM To: Semantic MediaWiki Cc: semediawiki-devel-ow...@lists.sourceforge.net Subject: [Semediawiki-user] Status SMW, release plans for 1.5.0 Dear SMW users, this is just to let you know that the main changes to the SVN version of SMW have been completed, and that the release of SMW 1.5.0 is planned for February now. Since there have been major changes in some internal parts, it would be good to get some testing going. Especially, extension developers should check that there are no compatibility problems with the new version -- little has changed in the officially documented interfaces, but you never know. The main changes in SMW 1.5.0 are internal, cleaning up the rather complex piece of code use for database access in SMW, and should not be visible to the user unless something went wrong. On the user level, a different declaration of n-ary (multi-valued) properties, and an extended UI for Special:Ask are the most noticeable changes. We have heard that some users have reported problems/bugs with the SVN version on IRC recently, but we do not know what exactly the problems were. There are no logs of the IRC (and in any case single messages are easy to overlook). So please, if you find any problems in SMW, be sure to report them on bugzilla.mediawiki.org, or at least send some email to one of the lists where it is on archive. Otherwise, your problem reports have a high chance of going unnoticed. Cheers, Markus -- Markus Krötzsch mar...@semantic-mediawiki.org * Personal page: http://korrekt.org * Semantic MediaWiki: http://semantic-mediawiki.org * Semantic Web textbook: http://semantic-web-book.org -- --- --- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com ___ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel -- Markus Krötzsch mar...@semantic-mediawiki.org * Personal page: http://korrekt.org * Semantic MediaWiki: http://semantic-mediawiki.org * Semantic Web textbook: http://semantic-web-book.org -- signature.asc Description: This is a digitally
Re: [SMW-devel] Status SMW, release plans for 1.5.0
Upps silly me, somehow I must have misread that installations with SMWSQLStore2
do the update automatically.
Sorry,
Gu
Quoting Markus Krötzsch mar...@semantic-mediawiki.org:
On Mittwoch, 10. Februar 2010, zehet...@molgen.mpg.de wrote:
Hi,
I'm not sure if I see this correctly but it looks to me that SMW 1.5 does
some modifications to the MySQL database (like creating new tables) which
are necessary for its 'internal part changes'.
What exactly does trigger those modifications?
The install/update button on Special:SMWAdmin. It is also possible to trigger
the update from the command line (like when upgrading MediaWiki). See INSTALL
for details on how to upgrade SMW.
I hope that this fixes your problem.
-- Markus
When I simply replace the SMW 1.4 extension folder with a new SMW 1.5
folder and try to go to a page (even a non-existing one) I get an
MediaWiki internal error because in function SMW:getSemanticData a SQL
query is executed which uses a table smw_subp2 which doesn't exist (yet).
Original exception: exception 'DBQueryError' with message 'A database
error
has occurred
Query: SELECT DISTINCT o_id AS id0,o0.smw_title AS v0,o0.smw_namespace AS
v1,o0.smw_iw AS v2,o0.smw_sortkey AS v3 FROM `cmw_smw_subp2` INNER JOIN
`cmw_smw_ids` AS o0 ON o_id=o0.smw_id WHERE s_id='542'
Function: SMW::getSemanticData
Error: 1146 Table 'cancerdb.cmw_smw_subp2' doesn't exist
(localhost:mysql5.sock)
I guess that's one of the newly created tables but how do I force that
update/modification to create it?
The stack trace suggests that the SMW query, even on a non-existing page,
is triggered by SemanticForms
SFFormEditTab::displayTab(Object(SkinMonoBook),Array)
SFLinkUtils::getFormsThatPagePointsTo('Non-Kinase', 14, '_SF_DF',
'_SF_DF_BACKUP', 1)
SMWSQLStore2-getPropertyValues(Object(Title), Object(SMWPropertyValue))
If I disable the inclusion of SF_Settings.php (btw. the latest SVN
version)
the error disappears.
Thanks,
Gu
Quoting Markus Krötzsch mar...@semantic-mediawiki.org:
And another copy for devel list. My first email went to the list owners
only:
email address autocompletion is a dangerous thing. -- Markus
On Montag, 8. Februar 2010, Markus Krötzsch wrote:
Dear SMW users,
this is just to let you know that the main changes to the SVN version
of SMW have been completed, and that the release of SMW 1.5.0 is
planned for February now. Since there have been major changes in some
internal parts, it would be good to get some testing going.
Especially,
extension developers should check that there are no compatibility
problems with the new version -- little has changed in the officially
documented
interfaces,
but you never know.
The main changes in SMW 1.5.0 are internal, cleaning up the rather
complex piece of code use for database access in SMW, and should not
be
visible to the user unless something went wrong. On the user level, a
different declaration of n-ary (multi-valued) properties, and an
extended UI for Special:Ask are the most noticeable changes.
We have heard that some users have reported problems/bugs with the SVN
version on IRC recently, but we do not know what exactly the problems
were. There are no logs of the IRC (and in any case single messages
are easy to overlook). So please, if you find any problems in SMW, be
sure to report them on bugzilla.mediawiki.org, or at least send some
email to one of the lists where it is on archive. Otherwise, your
problem reports have a high chance of going unnoticed.
Cheers,
Markus
--
Markus Krötzsch mar...@semantic-mediawiki.org
* Personal page: http://korrekt.org
* Semantic MediaWiki: http://semantic-mediawiki.org
* Semantic Web textbook: http://semantic-web-book.org
--
--
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
___
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
