Yaron,

I have had very little success in trying to fix my wiki :(
I seem to be going around in circles!
I have gone back to the orginal MW 1.13.2 DB which I kept a backup of. I have made a copy of the DB and installed MW 1.14.0 onto it. Now when I view my events (original namespace 206), all the pages are called 'Form:...' which is exactly what you said. (As you mentioned you should update http://www.mediawiki.org/wiki/Namespace_reservation with the new namespace).
Running the query;
UPDATE page SET
page_title = REPLACE(page_title, 'Event:', ''),
page_namespace = 256
WHERE page_title LIKE 'Event:%' AND page_namespace=206
affects zero rows. Looking at the records in the 'page' table there are no pages named 'Event:...'
I have also noticed that the namespace is stored in several other tables and the above query won't update all of those records (unless there is a cascade??).
I have also tried altering the query to;
UPDATE page SET
page_namespace = 256
WHERE page_namespace=206
Which does change the namespace in the 'page' table, but still doesn't display the pages correctly in the web site (assuming because the namespace column in the other tables hasn't bee altered?).

What am I doing wrong?
What do I have to do to resolve it?

Your assistance is greatly appreciated.

Craig

2009/4/18 Yaron Koren <yaron57@gmail.com>
Yes, exactly; although your SQL queries should end with something like "WHERE page_namespace = 206".



On Fri, Apr 17, 2009 at 6:26 AM, Craig Feuerherdt <craigfeuerherdt@gmail.com> wrote:
Yaron,

Thanks for that bit of info.
I am assuming it is as simple as following the instructions on http://www.mediawiki.org/wiki/Manual:Using_custom_namespaces#Use_a_database_query? Will that update the namespace references in all tables?

I will have to change several namespaces as I started at 200.......not too difficult if it is as stated above.


Craig

2009/4/16 Yaron Koren <yaron57@gmail.com>
Well, that would explain it - SMW itself sets the "Form" namespace number (I really should change the SF documentation to reflect that), and it's also getting set to 206. Unfortunately, changing namespaces is somewhat tricky - whichever namespaces you change (I'd recommend "Event" and "Event_talk", since it's just two of them), you'll probably have to go into the 'page' table in the database in order to salvage them, by changing their namespace IDs en masse. Which isn't all that hard, if you know SQL. Just make sure to pick numbers that aren't between, say, 200 and 210.

-Yaron



On Wed, Apr 15, 2009 at 10:34 PM, Craig Feuerherdt <craigfeuerherdt@gmail.com> wrote:
Event namespace is 206.
I have "$smwgNamespaceIndex = 200;" before the semantic mediawiki include as per http://semantic-mediawiki.org/wiki/Help:Configuration.
Have included "$sfgNamespaceIndex = 150;" after the semantic forms include, but it hasn't made any difference.

Craig

2009/4/16 Yaron Koren <yaron57@gmail.com>

It looks like your namespace number/code for "Event" and for "Form" are the same on your wiki. What are they being set to on LocalSettings.php?

-Yaron

On Wed, Apr 15, 2009 at 7:33 AM, Craig Feuerherdt <craigfeuerherdt@gmail.com> wrote:
A little more searching around and I have found out that when I select 'add page with form' from the semantic forms section on special pages, all of the pages in one of my namespaces/categories (Event) is shown as a form...wtf?

Web site can be found at http://www.bendigo-orienteers.com.au/

Craig

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Semediawiki-user mailing list
Semediawiki-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-user