Hi, I've been working on running MediaWIki on SQL Server 2000. It's mostly working and it feels close to all working, but I still have a few major wrinkles to iron out. 1. Almost nothing that involves a "pager" is working yet, with just a couple of exceptions. 2. Interlanguage links are showing up at the end of the pages instead of in a sidebar as on Wikipedia. 3. Template documentation that's referenced from a template as {{/doc}} doesn't get transcluded. 4. Some tags generated by templates that are obviously meant to be interpreted as HTML are instead getting interpreted as text (for example, if I use the text & templates of the page [[Arnold Schwarzenegger]] from Wikipedia, I will see <small/> under Arnold's picture within the infobox at the top of the page). 5. Not convinced that absolutely all the tables are working yet -- for example, I have yet to see a record created in the redirect table.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
DJ Bauch wrote:
Hi, I've been working on running MediaWIki on SQL Server 2000. It's mostly working and it feels close to all working, but I still have a few major wrinkles to iron out.
- Almost nothing that involves a "pager" is working yet, with just a couple
of exceptions.
For that, make sure the LIMIT and OFFSET clauses (or equivalent) are set up right.
These below are probably unrelated to the database:
- Interlanguage links are showing up at the end of the pages instead of in
a sidebar as on Wikipedia.
You need to set up the interwiki table to include the links you want to use.
- Template documentation that's referenced from a template as {{/doc}}
doesn't get transcluded.
This depends on the subpage settings; that the namespace of the pages you're working in is set in $wgNamespacesWithSubpages.
- Some tags generated by templates that are obviously meant to be
interpreted as HTML are instead getting interpreted as text (for example, if I use the text & templates of the page [[Arnold Schwarzenegger]] from Wikipedia, I will see <small/> under Arnold's picture within the infobox at the top of the page).
Various templates on Wikipedia rely on some currently undefined behavior which differs between the default state and the state when $wgUseTidy is enabled (to use the external 'tidy' program to do HTML scrubbing).
You may need to enable it to match Wikipedia's rendering of such templates.
- -- brion vibber (brion @ pobox.com / brion @ wikimedia.org)
Thanks Brion, two of the issues were a snap to fix after your help -- and I suspect that the 'tidy' issue will be easy also.
The problem with the "pagers" is actually related to some issues in the PHP database library I'm using, which is the 3rd party ADOdb. Without getting into a long story, MSSQL, ODBC, and PDO all had problems that I couldn't get around until I found ADOdb -- primarily relating to the TEXT columns. ADOdb has minimal support for scrolling cursors -- even though they should work, since the recordsets are retrieved with client-side static cursors. That's why I'm convinced I'll get them working -- even though I'll be in PHP up to my elbows.
On 3/15/07, Brion Vibber brion@pobox.com wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
DJ Bauch wrote:
Hi, I've been working on running MediaWIki on SQL Server 2000. It's mostly working and it feels close to all working, but I still have a few major wrinkles to iron out.
- Almost nothing that involves a "pager" is working yet, with just a
couple
of exceptions.
For that, make sure the LIMIT and OFFSET clauses (or equivalent) are set up right.
These below are probably unrelated to the database:
- Interlanguage links are showing up at the end of the pages instead of
in
a sidebar as on Wikipedia.
You need to set up the interwiki table to include the links you want to use.
- Template documentation that's referenced from a template as {{/doc}}
doesn't get transcluded.
This depends on the subpage settings; that the namespace of the pages you're working in is set in $wgNamespacesWithSubpages.
- Some tags generated by templates that are obviously meant to be
interpreted as HTML are instead getting interpreted as text (for
example, if
I use the text & templates of the page [[Arnold Schwarzenegger]] from Wikipedia, I will see <small/> under Arnold's picture within the infobox
at
the top of the page).
Various templates on Wikipedia rely on some currently undefined behavior which differs between the default state and the state when $wgUseTidy is enabled (to use the external 'tidy' program to do HTML scrubbing).
You may need to enable it to match Wikipedia's rendering of such templates.
- -- brion vibber (brion @ pobox.com / brion @ wikimedia.org)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFF+ZyhwRnhpk1wk44RAhb8AJ4qvDVB3TKZf93f0gBcmdH7lXajKwCffg6Z KMsU6PdBNsmI4nuC+mOaBCA= =7huu -----END PGP SIGNATURE-----
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l
I am using the ADOdb Database Abstraction Libary for PHP and Python available from SourceForge at http://adodb.sourceforge.net I tried using both the ODBC and MS-SQL APIs from the PHP distribution and was not satisfied with either one. Although they both worked partially, neither one worked completely -- especially when it came to TEXT columns. I have had to comment out one line of code in the ADOdb distribution in order to get it working correctly for me. That line had something to do with supporting some obscure Oracle feature, but was wreaking havoc for non-Oracle. I'll have details about that on my blog http://mediawikiworker.blogspot.com, when I get around to updating my blog. Later, I had to make one other change to the ADOdb distribution in order to enable scrolling cursors -- but since I don't have the scrolling cursors working in all cases yet, I'm not ready to comment on what other changes must be made to make the cursors work. This really only has much significance on some of the Special: namespace pages.
On 3/15/07, River Tarnell river@attenuate.org wrote:
DJ Bauch:
I've been working on running MediaWIki on SQL Server 2000.
are you using ODBC or the MS SQL-specific API?
- river.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l
wikitech-l@lists.wikimedia.org