Sorry Valerio, I'm not really an expert. However, I thought the output
(below) would help someone on the list give you some better advice.
2009/3/20 Valerio M. Pelliccioni <v...@silkwood.it>:
> Oh yes, Dan.
> I did it, more and more without any success.
> What I did in the meanwhile was to dig into the code and I've found that in
> the in the SWM_SQLStore.php file there is no sign of smw_attribute but
> instead I've seen this:
> -----------------------------------------------------
> SMWSQLHelpers::setupTable($smw_atts2, // most standard properties
> ("attributes")
> array('s_id' => $dbt_id . ' NOT NULL',
> 'p_id' => $dbt_id . ' NOT NULL',
> 'value_unit' =>
> ($wgDBtype=='postgres'?'TEXT':'VARCHAR(63) binary'),
> 'value_xsd' => $dbt_title . ' NOT NULL',
> 'value_num' =>
> ($wgDBtype=='postgres'?'DOUBLE PRECISION':'DOUBLE')), $db, $reportTo);
> SMWSQLHelpers::setupIndex($smw_atts2,
> array('s_id','p_id','value_num','value_xsd'), $db);
> ---------------------------------------------------------
>
> Does this mean that the smw_attributes has been renamed as smw_att_2 ???
>
> The same goes for the smw_relations table (maybe renamed as smw_rels2 ???)
>
> In a drop statment of the same file ther is this table array:
> --------------------------------------------------
>
> function drop($verbose = true) {
> global $wgDBtype;
> $this->reportProgress("Deleting all database content and
> tables generated by SMW ...nn",$verbose);
> $db =& wfGetDB( DB_MASTER );
> $tables = array('smw_rels2', 'smw_atts2', 'smw_text2',
> 'smw_spec2',
> 'smw_subs2', 'smw_redi2', 'smw_ids',
> 'smw_inst2',
> 'smw_conc2');
> ---------------------------------------------------------
>
> which matches exactly the output you requested, see below:
>
>
> Setting up standard database configuration for SMW ...
>
> Selected storage engine is "SMWSQLStore2" (or an extension thereof)
>
> Setting up table `wikismw_ids` ...
> ... table exists already, checking structure ...
> ... column smw_id is fine
> ... column smw_namespace is fine
> ... column smw_title is fine
> ... column smw_iw is fine
> ... column smw_sortkey is fine
> ... table `wikismw_ids` set up successfully.
> Setting up table `wikismw_redi2` ...
> ... table exists already, checking structure ...
> ... column s_title is fine
> ... column s_namespace is fine
> ... column o_id is fine
> ... table `wikismw_redi2` set up successfully.
> Setting up table `wikismw_rels2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column p_id is fine
> ... column o_id is fine
> ... table `wikismw_rels2` set up successfully.
> Setting up table `wikismw_atts2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column p_id is fine
> ... column value_unit is fine
> ... column value_xsd is fine
> ... column value_num is fine
> ... table `wikismw_atts2` set up successfully.
> Setting up table `wikismw_text2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column p_id is fine
> ... column value_blob is fine
> ... table `wikismw_text2` set up successfully.
> Setting up table `wikismw_spec2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column p_id is fine
> ... column value_string is fine
> ... table `wikismw_spec2` set up successfully.
> Setting up table `wikismw_subs2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column o_id is fine
> ... table `wikismw_subs2` set up successfully.
> Setting up table `wikismw_inst2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column o_id is fine
> ... table `wikismw_inst2` set up successfully.
> Setting up table `wikismw_conc2` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column concept_txt is fine
> ... column concept_docu is fine
> ... column concept_features is fine
> ... column concept_size is fine
> ... column concept_depth is fine
> ... column cache_date is fine
> ... column cache_count is fine
> ... table `wikismw_conc2` set up successfully.
> Setting up table `wikismw_conccache` ...
> ... table exists already, checking structure ...
> ... column s_id is fine
> ... column o_id is fine
> ... table `wikismw_conccache` set up successfully.
> Database initialised successfully.
>
> Setting up internal property indices ...
> ... space for internal properties already allocated.
> ... writing entries for internal properties.
> Internal properties initialised successfully.
>
> The storage engine was set up successfully.
>
>
> Hope this helps (both you and me)!!
>
> Valerio
>
>
>
>
>>----- Original Message -----
>>From: dan.bol...@gmail.com
>>To: v...@silkwood.it
> Cc: semediawiki-devel@lists.sourceforge.net
>>Data: Fri, 20 Mar 2009 12:15:12 +0000
>>Subject: Re: [SMW-devel] Missed smw_attributes and smw_relations (and other?)
>> tables
>
>>2009/3/19 Valerio M. Pelliccioni <v...@silkwood.it>:
>>> Hi everybody,
>>> after some tries with the DrillDown installation, and some filters
>>> configuration I discovered that my SMW lacks two (or more) tables
>>> because of an error message from DD Special:BrowseData page:
>>> smw_attributes and smw_relations.
>>> So, I made a brand new installation (immediately after a fresh 1.14
>>> Mediawiki installation).
>>> This (seems) doesn't solve the problem.
>>> I can't see the above tables in my (W)AMP stack.
>>> Am I missed something, or am I completely astray?
>>> Please help,
>>> Thank' so much.
>>
>>Did you hit "Database installation and upgrade" on [[Special:SMWAdmin]] ?
>>
>>Please try that and let us know if your problem persists (and any
>>output that it may generate).
>>
>>
>>Good luck!
>>
>>Dan.
>>
>>
>>> This is my Special:Version partial output:
>>>
>>> MediaWiki 1.14.0
>>> PHP 5.2.8 (apache2handler)
>>> MySQL <http://www.mysql.com/> 5.1.30-community
>>> /Semantic MediaWiki <http://semantic-mediawiki.org> (Version 1.4.2)
>>> /Making your wiki more accessible – for machines /and/ humans. View
>>> online documentation. Klaus Lassleben,
>>> <http://semantic-mediawiki.org/wiki/Help:User_manual>Markus Krötzsch
>>> <http://korrekt.org>, Denny Vrandecic <http://simia.net>, S Page, and
>>> others. Maintained by AIFB Karlsruhe
>>> <http://www.aifb.uni-karlsruhe.de/Forschungsgruppen/WBS/english>
>>> Extension functions smwfSetupExtension
>>> Parser extension tags <ask> and <pre>
>>> Parser function hooks anchorencode, ask, concept, declare, defaultsort,
>>> displaytitle, filepath, formatnum, fullurl, fullurle, grammar, info,
>>> int, language, lc, lcfirst, localurl, localurle, ns, numberingroup,
>>> numberofadmins, numberofarticles, numberofedits, numberoffiles,
>>> numberofpages, numberofusers, numberofviews, padleft, padright,
>>> pagesincategory, pagesize, plural, set, show, special, tag, uc, ucfirst
>>> and urlencod
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
>>> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
>>> easily build your RIAs with Flex Builder, the Eclipse(TM)based development
>>> software that enables intelligent coding and step-through debugging.
>>> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
>>> _______________________________________________
>>> Semediawiki-devel mailing list
>>> Semediawiki-devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
>>>
>>
>>
>
>
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
