Help talk:Installation

Note: As the Semantic MediaWiki page says, If you have questions, please write an email to our user mailinglist. You're more likely to get a reply there than here.

The INSTALL document in SMW 0.7 has a "Testing your Installation" section, follow the steps in that when you have problems and report exactly what goes wrong.

[edit] links not rendering

I just did all the Steps to install the SemanticMediaWiki extension in our wiki, but although everything went well the relations and property links are not rendered the way they should. Any hints what could have gone wrong ? Maybe it's the fact that we run version 1.9.0 of MediaWiki ? Greetings --Moolsan 13:08, 25 January 2007 (CET)

[edit] cannot initialise tables

When I press the button initialise tables I get the following message (partly in dutch): MySQL gaf the foutmelding "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-_wiki7b.`smw_relations` ( subject_id INT(8) UNSIGNED NOT NULL, ' at line 1 (127.0.0.1)". What does this mean? Is it possible the updatescript cannot handle underscores in the DB name? Is is possible to run the script directly in phpmyadmin? 84.26.155.40 11:20, 20 February 2007 (CET)

I'm having this exact same problem, and I'm going to take a stab at it, it seems to be an error related to the version of MYSQL being used. Error 1064 tends to happen when you use a reserved word in a SQL Query that is specific to a certain version of MYSQL. So I'm going to go on a limb and guess that whoever created the SQL statements didn't make them compatiable with older versions of MYSQL.

Currently my host is running MYSQL 4.0.27, and this site is running MYSQL 5 . This error is happening when it tries to build the relations table in SMW_SQLStore.php. So does anyone with more MYSQL experience have any idea why this query is failing?

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 "SMW::setupDatabase". MySQL returned error "1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to :use near '-1.`wiki_smw_relations` ( subject_id INT(8) UNSIGN (localhost)".

Ransim - 170.97.67.142 23:04, 6 September 2007 (CEST)

[edit] Special:Import_ontology

I have seen reference to the Import Ontology page as Help:Import_ontology, Special:Import_ontology, and Special:Ontology_import. None of these seem to work however. I have the rdfapi-php installed, and I am trying to access the page as admin.

[edit] Adding extra namespaces after using SMW

In the installation help it says you can add extra namespaces, you just have to add them so they don't conflict with SMW.

Before I installed SMW I had the following 2 namespaces added:

$wgExtraNamespaces = array(100 => "Policy", 101 => "Policy Discussion");

I installed SMW and added the following before the config line to enable SMW

$smwgNamespaceIndex = 102;

I added some relations/attributes, defined datatypes etc.. and everything worked fine.

Now I need to add a couple more namespaces, but no matter what I try, as soon as they are added, all attribute definitions turns into dead links. (red) with 'Ops no datatype defined.. I tried refreshing and initialising tables via the SMW special page.

This is what I added (After already having used SMW):

$wgExtraNamespaces = array(100 => "Policy", 101 => "Policy Discussion" 102 => "Glossary" 103 => "Glossary Discussion" );

$smwgNamespaceIndex = 104;

I tried using higher namespace numbers, but nothing seems to work, as soon as I add even one extra namespace everything breaks.

Hope someone can help.

ILTK 03:11, 12 June 2007 (CEST)

You should have left $smwgNamespaceIndex as it was and bumped up all the numbers in that array (for example

   ## Leave space for SMW tables
   $wgExtraNamespaces =
   array(120 => "Policy",
         121 => "Policy Discussion"
         ...

-- Skierpage 00:55, 22 June 2007 (CEST)

Thanks, I ended up doing that and leaving $smwgNamespaceIndex as it were, and everything seems to work fine now.

$wgExtraNamespaces =

array(100 => "Policy",

101 => "Policy Discussion",

#Leave gap for existing smw namespaces here.

130 => "Forum",

131 => "Forum Discussion",

132 => "Project",

133 => "Project Discussion",

134 => "Portal",

135 => "Portal Discussion",

136 => "Glossary",

137 => "Glossary Discussion"

);

ILTK 01:18, 22 June 2007 (CEST)

[edit] Migrating SMW to laptop, inline queries don't work

I'm migrating an SMW from a server to a laptop by doing an Export on the server and an Import on the laptop. My problem is that a lot of the SMW functionality, particularly the inline queries, does not work. An inline query will not pick up a particular page until that page has been edited and resaved.

1. Is there another way to import, so that SMW does what it needs to do during the import?

2. Is there a way to programmatically edit and resave every page in the wiki?

Thanks in advance.

Danneau 12 June 2007

There is a script that will update all semantic objects in the database. See the maintenance directory: http://svn.wikimedia.org/svnroot/mediawiki/trunk/extensions/SemanticMediaWiki/maintenance/ --MichielV 13:27, 20 June 2007 (CEST)

[edit] maximum execution time

I am setting up a wiki on a stick, which does not run very fast. Whenever I try to save a page with more than one <ask>s, I get an error message:


Fatal error: Maximum execution time of 30 seconds exceeded in K:\www\mediawiki-1.11.0\includes\Database.php on line 797

I experienced a similar problem during the initial special:SMWAdmin setup; but then I got around by pressing the button five or six times in a row.

Question

How can I increase the time limit? The file mediawiki-1.11.0/includes/Database.php does not contain the string "30". Hillgentleman 04:21, 5 December 2007 (CET)

this is not a wiki parameter but a php parameter. check your php.ini file and search for "max_execution_time". increase the value to 60 or something. - Freddy 12:25, 5 December 2007 (CET)

Works. Thanks. Hillgentleman 18:20, 5 December 2007 (CET)

And I guess that this talk page is not semantic. Hillgentleman 18:21, 5 December 2007 (CET)

Watch out, semantics are everywhere ;-) - Freddy 20:00, 5 December 2007 (CET)