Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[wiki] TextBook down (database error)
and, in the middle of the class I was teaching yesterday evening, I said: “… and another really good thing of all this stuff is that documentation is just a TextBook away…”, I noticed this:
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 “ MediaWikiBagOStuff::_doquery “.
MySQL returned error “ 1016: Can't open file: 'objectcache.MYI' (errno: 145) (localhost) “
this happened yesterday about 11pm UTC and I’m still seing it… is there something wrong with mediawiki?… the wiki database?
Last edited by baby (2007-03-28 12:55:10)
Mariano Absatz – El Baby
I don’t suffer from insanity. I enjoy every minute of it.
Offline
Re: [wiki] TextBook down (database error)
ugh, nothing has changed in the mediawiki install so I’m not sure what suddenly caused this.
Last edited by hakjoon (2007-03-28 14:26:48)
Shoving is the answer – pusher robot
Offline
Re: [wiki] TextBook down (database error)
hakjoon, I noticed it last night on the TxPlanet feeds, but I thought it was a temporary thing, since it’s happened in the past and it’s recovered fine.
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
Re: [wiki] TextBook down (database error)
I repaired the objectcache table and it seems to be back in working order again. Googling for the error just brought up a bunch of Mediawiki installs with the same issue, which I found kind of humorous.
I’m going to try to bump it up to 1.9 this weekend.
Last edited by hakjoon (2007-03-28 14:53:25)
Shoving is the answer – pusher robot
Offline
Re: [wiki] TextBook down (database error)
Strange, whatever it is, it’s happening around the web…this MediaWikiBagOStuff.
Lot of people complaining of lost mediawiki databases in the process….gulp.
I’m pretty sure we keep a folder of db dumps, right?
Offline
Re: [wiki] TextBook down (database error)
That’s why I like a wiki that uses a flat file system, less chance of losing all your work.
What’s the best way to save off some of the wiki pages for offline use? The txp:tag pages are indispensable when working with a site.
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
#7 2007-04-14 23:01:09
- marios
- Archived Plugin Author
- Registered: 2005-03-12
- Posts: 1,253
Re: [wiki] TextBook down (database error)
As hcgtv suggests, some sort of offline manual would be good at some point, like you have with php.net for instance.
All these wiki weirdness is looking more and more monstrous to me.
regards, marios
Last edited by marios (2007-04-14 23:02:36)
⌃ ⇧ < ⎋ ⌃ ⇧ >
Offline
#8 2007-04-15 01:51:47
- Logoleptic
- Plugin Author
- From: Kansas, USA
- Registered: 2004-02-29
- Posts: 482
Re: [wiki] TextBook down (database error)
hcgtv wrote:
What’s the best way to save off some of the wiki pages for offline use? The txp:tag pages are indispensable when working with a site.
When I want an offline perma-copy of something I’m reading on the Web, I make a PDF of it. PDFCreator was what I used for this before I switched to Adobe’s own Distiller. If you use MacOS X, you should have a native PDF printing capability. Some Linux distros also have this built-in.
Unfortunately, the tag reference no longer lives entirely on one page. I have a PDF tag reference that some generous soul made last year, but it’s not up-to-date with 4.0.4.
Anyone else have a suggestion for creating an offline copy of these resources? I’ve used a certain “website copier” for doing such things to my own sites in the past, but I hesitate to suggest it for Textbook. The program I used would be easy for a novice to mis-configure, resulting in runaway bandwidth consumption.
Offline
Re: [wiki] TextBook down (database error)
Guys, guys…I wouldn’t be so quick to be harsh on MW, there’s probably solutions to these issues; the problem is there’s not enough people looking into them, or enough time for the one guy who is (hakjoon).
On the other hand, MW is a beast to work with. If we had a very extensive documentation set with an active authoring pool, it would be essential, but the truth of the matter is our community is 98% users asking for documentation and 2% providing it, that’s why TextBook never really gets anywhere. Part of the problem too, IMHO, is all the off-shoot doc projects people take up now and then at their own sites. Weblog articles are one thing, but projects that aim to serve as document resources (and I can think of at least three, but won’t point them out), well…despite the good intentions, they only serve to confuse users and pull away from the centralized effort that should be TextBook. But I digress…
My position, which certainly is not a factor anymore, has always been to use MW because of it’s support for internationalization. There is not another wiki on the market that supports internationalization, so flat file, skinny file, round file, blue file…it makes no difference if we don’t want to just unhook the caboose on the languages currently supported. The asian languages and Italian language, for example, are extremely active in TextBook so you can’t look for an English-only solution. Whatever ideas you come up with, keep your international friends involved.
With the recent work of net-carver on the MLP, perhaps it’s time to really consider Txp again for the documentation platform, and migrate existing wiki documents over. The question that remains then is the collaboration, but I think history shows there isn’t much doc collaboration to speak of, so you recruit one or two people for each supported language and give them authoring status in the Internationalized Txp docs site and call it good. Everyone else watches from the sidelines with envy (or relief).
Offline
Re: [wiki] TextBook down (database error)
Destry wrote:
My position, which certainly is not a factor anymore, has always been to use MW because of it’s support for internationalization.
Could you expound on this, I was under the impression that it was different databases anyway, almost a hack of sorts to support different languages.
We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
Re: [wiki] TextBook down (database error)
Well, if the wiki had been up, I would simply point you to the long-existing Language Support page that describes exactly the process, but…
…same wiki, same database, different prefix (of sorts) for each languages pages. It’s achieved by adding a given language record to the “interwiki” table that defines the type of URL each language gets, e.g., fr/, de/, es/ etc.
MediaWiki suggests this is not appropriate use of this method but they do not outright say it should not be done, rather it should be used for…as you presumed…multiple databases (in which case the URL added to the interwiki table is of a different structure), but I think they say that with the assumption that someone’s given wiki project is going to be monstrous if it’s going to be multilanguages to begin with. In any case, it works as we have employed it (thanks to Inspired’s insight on the matter).
Last edited by Destry (2007-04-15 16:51:32)
Offline