Page MenuHomePhabricator

After moving a wiki, properties do not update, even with a newly created page
Closed, InvalidPublic

Description

Author: peter.h.m.brooks

Description:
I have the same data loaded on the new machine, and I've compared the behaviour on both.

On the old, pre-move, machine properties are created normally. On the new one, they are not.

Here are the date from the two tests, including all revision numbers:

The problem is that properties are not created and don't have their
count increased when a page is saved.

They are recognised as properties on the page.

Categories are saved.

I've put the versions at the bottom - but PHP and MySQL are at
different versions - the wikis are both running the same SMW (also
listed at the bottom)

This is the test I've run. The first wiki is the original wiki. The
second is the copy of it running on another machine.

Test of two wiki's:

First wiki:

http://kchclinics.com/wiki/index.php?title=Sandpit:Property_test

Property Test

NOEDITSECTION

[[Has type::Text]]
[[Has colour::Orange]]
[[Location::Ouagadougou]]
[[Population::1,475,223]]
[[Capital of::Burkina Faso]]
[[Category:City]]
[[Category:African]]

Create Page:

Left hand column shows 'Browse properties'
Items show up as:

Blue - Text
Red - Orange 1,475,223 Burkina Faso - City African
Black - Ouagadougou

Browse property page shows:

Sandpit:Property test
Capital of Burkina Faso
Has colour Orange
Location Ouagadougou
Population 1,475,223
Categories City , African
Modification date 22 August 2014 07:34:45
Has type Text


Categories page shows African & City

Properties Page:

Shows:

Capital of - 1 use
Has Type - 4 uses
Has colour - 1 use
Location - 75 uses
Population - 9 uses


Second Wiki

Create Page:

Left hand column DOES NOT show 'Browse properties'
Items show up as:

Blue - Text
Red - Orange 1,475,223 Burkina Faso - City African

Black - Ouagadougou

Properties Page:

Does NOT show:

Capital of
Has colour
Population

Does show:

Has Type - but only 1 use
Location - but '0' uses


Categories page shows African & City

The physical set up is:

First Machine

Apache version 2.2.27
PHP version 5.3.28
MySQL version 5.5.34-cll-lve
Architecture x86_64
Operating system linux
Dedicated IP Address 69.28.199.12
Path to sendmail /usr/sbin/sendmail
Path to Perl /usr/bin/perl
Perl version 5.10.1
Kernel version 2.6.32-531.17.1.lve1.2.60.e

Second Machine

Apache version 2.4.7
PHP version 5.5.9
MySQL version 5.5.38
Architecture x86_64
Operating system linux
Kernel version Ubuntu 14.04.1

SMW versions Machine One:

Semantic Compound Queries (Version 0.3.4) A parser function that
displays multiple semantic queries at the same time Yaron Koren
Semantic Drilldown (Version 1.4) A drilldown interface for navigating
through semantic data Yaron Koren and others
Semantic Extra Special Properties (Version 1.2.1) Adds some extra
special properties to all pages Leo Wallentin, James Hong Kong and
others
Semantic Forms (Version 2.7) Forms for adding and editing semantic
data Yaron Koren, Stephan Gambke and others
Semantic Forms Inputs (Version 0.7) Additional input types for
Semantic Forms Stephan Gambke and others
Semantic Image Input (Version 0.3.0 alpha) Adds an image input that
pulls images from Wikipedia to Semantic Forms Jeroen De Dauw
Semantic Internal Objects (Version 0.7.6) Setting of internal objects
in Semantic MediaWiki Yaron Koren
Semantic Maps (Version 3.0.4) Provides the ability to view and edit
coordinate data stored with the Semantic MediaWiki extension Jeroen De
Dauw
Semantic MediaWiki (Version 1.9.2) Making your wiki more accessible -
for machines and humans (online documentation) Markus Krötzsch, Jeroen
De Dauw, James Hong Kong and others
Semantic Result Formats (Version 1.9.1) Additional result formats for
Semantic MediaWiki queries James Hong Kong, Stephan Gambke, Jeroen De
Dauw, Yaron Koren and others
Semantic Watchlist (Version 0.2.2) Lets users be notified of specific
changes to Semantic MediaWiki data Jeroen De Dauw for WikiWorks
SemanticFormsSelect (Version 1.1) Generate a select field in Semantic
Form which values are from query Jasonzhang
Special pages
Access Log (Version 2.0) Logs user access to MediaWiki Aleksandar
Bojinovic, Peter Kin-Fong Fong
CheckUser (Version 2.3) Grants users with the appropriate permission
the ability to check user's IP addresses and other information Tim
Starling and Aaron Schulz
EmailPage (Version 2.3.0, 2013-11-30) Send rendered HTML page to an
e-mail address or list of addresses using phpmailer User:Nad
MaintenanceShell (Version 0.4.0)

SMW versions machine Two

Semantic Compound Queries (Version 0.3.4) A parser function that
displays multiple semantic queries at the same time Yaron Koren
Semantic Drilldown (Version 1.4) A drilldown interface for navigating
through semantic data Yaron Koren and others
Semantic Extra Special Properties (Version 1.2.1) Adds some extra
special properties to all pages Leo Wallentin, James Hong Kong and
others
Semantic Forms (Version 2.7) Forms for adding and editing semantic
data Yaron Koren, Stephan Gambke and others
Semantic Forms Inputs (Version 0.7) Additional input types for
Semantic Forms Stephan Gambke and others
Semantic Image Input (Version 0.3.0 alpha) Adds an image input that
pulls images from Wikipedia to Semantic Forms Jeroen De Dauw
Semantic Internal Objects (Version 0.7.6) Setting of internal objects
in Semantic MediaWiki Yaron Koren
Semantic Maps (Version 3.0.4) Provides the ability to view and edit
coordinate data stored with the Semantic MediaWiki extension Jeroen De
Dauw
Semantic MediaWiki (Version 1.9.2) Making your wiki more accessible -
for machines and humans (online documentation) Markus Krötzsch, Jeroen
De Dauw, James Hong Kong and others
Semantic Result Formats (Version 1.9.1) Additional result formats for
Semantic MediaWiki queries James Hong Kong, Stephan Gambke, Jeroen De
Dauw, Yaron Koren and others
Semantic Watchlist (Version 0.2.2) Lets users be notified of specific
changes to Semantic MediaWiki data Jeroen De Dauw for WikiWorks
SemanticFormsSelect (Version 1.1) Generate a select field in Semantic
Form which values are from query Jasonzhang
Special pages
Access Log (Version 2.0) Logs user access to MediaWiki Aleksandar
Bojinovic, Peter Kin-Fong Fong
CheckUser (Version 2.3) Grants users with the appropriate permission
the ability to check user's IP addresses and other information Tim
Starling and Aaron Schulz
EmailPage (Version 2.3.0, 2013-11-30) Send rendered HTML page to an
e-mail address or list of addresses using phpmailer User:Nad
MaintenanceShell (Version 0.4.0) Wiki interface for maintenance
scripts Andrew Fitzgerald and Timo Tijhof
Parser hooks
and http://www.shadowritter.net Chklist (Version 0.1.1) Add checkbox
on your wiki page Shadowritter
DynamicPageList (Version 2.01) A highly flexible report generator for
MediaWikis Gero Scholz
GetUserName (Version 1.0) Get current user's name. Ejcaputo
Maps (Version 3.0.1) Enables embedding of dynamic maps into wiki
pages, geocoding of addresses and other geographical operations.
Jeroen De Dauw
MsUpload (Version 9.5.1) Enables easy uploads (when available also via
drag&drop) for one or multiple files simultaneously info@ratin.de |
Ratin
ParserFunctions (Version 1.5.1) Enhance parser with logical functions
Tim Starling, Robert Rohde, Ross McClure and Juraj Simlovic
Strtotime (Version 1.0) Represents time as a string containing a US
English date format Xavier Atero
SubPageList (Version 1.1) Allows to list and count subpages Jeroen De Dauw
Variables
UserInfo (Version 1.0)


Version: unspecified
Severity: major
OS: Linux
Platform: Other

Details

Reference
bz69894

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:35 AM
bzimport set Reference to bz69894.
bzimport added a subscriber: Unknown Object (MLST).

peter.h.m.brooks wrote:

Am I right in thinking that this may be somewhere near here:

SMWSQLStore3Writers::preparePropertyTableInserts

It seems to me that the properties are recognised on the page, and properties that are already there still exist, it's this preparing of the property table (or the write that comes after this) that could be the problem.

If so, is there a debug flag that I should be turning on to get data when it does this?

Aklapper triaged this task as Lowest priority.Mar 22 2015, 5:08 PM
Aklapper subscribed.

In T64114, the SMW maintainers decided to track MediaWiki-extensions-SemanticBundle issues in GitHub at https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues (and not anymore in Wikimedia Bugzilla/Phabricator). If the problem that you reported in this task still happens with a recent and supported version of SemanticBundle, we kindly ask you to transfer the task to GitHub. Thanks for your understanding!