Warning: mysql_query(): Unable to save result set in /usr/local/apache/common-local/php-1.4/includes/Database.php on line 312
Database error
From Wikipedia, the free encyclopedia.
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE cur_id=l_to AND l_from=1387711 FOR UPDATE from within function "LinkCache::preFill". MySQL returned error "1213: Deadlock found when trying to get lock; Try restarting transaction (10.0.0.1)".
Article Discussion Edit this page History Move
Please don't start your line of thought from the subject line, repeat the subject in the body.
Subject: I get many errors at wikipedia.org, like this one
NSK wrote:
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE cur_id=l_to AND l_from=1387711 FOR UPDATE from within function "LinkCache::preFill". MySQL returned error "1213: Deadlock found when trying to get lock; Try restarting transaction (10.0.0.1)".
Here's my answer that I gave at the Village Pump:
"In most browsers you can just hit refresh, your browser will point out that you're posting data and ask you if you are sure you want to repeat the operation, say yes. Deadlocks can be dealt with in software, but it's hard to know in advance what parts of the software will cause them."
The way we deal with them in software is just to repeat the transaction, so by hitting refresh you're doing the same thing manually.
-- Tim Starling
I want to start a wiki where users have the option to use a different language front-end - but all the data is held in one central database. So if I search from the German start page - I might get results that were originally added in Spanish or French.
Is there an elegant way of achieving this?
Paul Youlten
----- Original Message ----- From: "NSK" nsk2@wikinerds.org To: "Wikimedia developers" wikitech-l@wikimedia.org Sent: Wednesday, January 12, 2005 12:52 AM Subject: [Wikitech-l] I get many errors at wikipedia.org, like this one
Warning: mysql_query(): Unable to save result set in /usr/local/apache/common-local/php-1.4/includes/Database.php on line 312
Database error
From Wikipedia, the free encyclopedia.
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT cur_id,cur_namespace,cur_title FROM `cur`,`links` WHERE cur_id=l_to AND l_from=1387711 FOR UPDATE from within function "LinkCache::preFill". MySQL returned error "1213: Deadlock found when trying to get lock; Try restarting transaction (10.0.0.1)".
Article Discussion Edit this page History Move
Paul Youlten wrote:
I want to start a wiki where users have the option to use a different language front-end - but all the data is held in one central database. So if I search from the German start page - I might get results that were originally added in Spanish or French.
Is there an elegant way of achieving this?
Paul Youlten
I believe this should be a new message, but to answer your question, no, there's not really any easy way to do this, unless you're able to write a really good translator (which is relatively difficult).
On Wed, 12 Jan 2005 09:27:15 +0100, Paul Youlten paul.youlten@gmail.com wrote:
I want to start a wiki where users have the option to use a different language front-end - but all the data is held in one central database. So if I search from the German start page - I might get results that were originally added in Spanish or French.
Is there an elegant way of achieving this?
Well, as of version 1.4 (currently in beta) MediaWiki allows each user to select the language used by the *interface*. Thus you could have a site that was multilingual (as http://meta.wikimedia.org is, at least theoretically) and people could search whatever was there, translating for each other's convenience as necessary. [For obvious reasons, automatic translation is not a good idea.]
Alternatively, you could have multiple instances of MediaWiki with appropriate interlanguage linking (as currently used by Wikipedia), and come up with some kind of "meta search" that could find content in any of them - some work has gone into abstracted search systems, I believe, specifically in relation to "Lucene" (?); but no-one, as far as I know, has developed a multi-MediaWiki search engine (apart from Google with an appropriate "site:..." term, of course!)
v1.4 sounds perfect.
Anyone want to guess how long it will take to stabilize?
Paul ----- Original Message ----- From: "Rowan Collins" rowan.collins@gmail.com To: "Wikimedia developers" wikitech-l@wikimedia.org Sent: Wednesday, January 12, 2005 9:33 PM Subject: Re: [Wikitech-l] Iinformation Architectures
On Wed, 12 Jan 2005 09:27:15 +0100, Paul Youlten paul.youlten@gmail.com wrote:
I want to start a wiki where users have the option to use a different language front-end - but all the data is held in one central database. So if I search from the German start page - I might get results that were originally added in Spanish or French.
Is there an elegant way of achieving this?
Well, as of version 1.4 (currently in beta) MediaWiki allows each user to select the language used by the *interface*. Thus you could have a site that was multilingual (as http://meta.wikimedia.org is, at least theoretically) and people could search whatever was there, translating for each other's convenience as necessary. [For obvious reasons, automatic translation is not a good idea.]
Alternatively, you could have multiple instances of MediaWiki with appropriate interlanguage linking (as currently used by Wikipedia), and come up with some kind of "meta search" that could find content in any of them - some work has gone into abstracted search systems, I believe, specifically in relation to "Lucene" (?); but no-one, as far as I know, has developed a multi-MediaWiki search engine (apart from Google with an appropriate "site:..." term, of course!)
-- Rowan Collins BSc [IMSoP] _______________________________________________ Wikitech-l mailing list Wikitech-l@wikimedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l
On Thu, 13 Jan 2005 01:07:58 +0100, Paul Youlten paul.youlten@gmail.com wrote:
v1.4 sounds perfect.
Anyone want to guess how long it will take to stabilize?
Well, it's considered stable enough to run all of Wikimedia's high-profile wikis, so while there are still bugs around, anything major is pretty high priority right now - and even once we "reach" 1.4.0, there's bound to be plenty still to fix. The tracking bug at http://bugzilla.wikimedia.org/show_bug.cgi?id=202 shows 8 dependencies still unfixed in our bugzilla database.
Basically, I don't know the "official" answer to when 1.4 final will hit, but I do know that it will be very soon - I'd say a few weeks at most - and there's a pretty solid guarantee that the 1.4betas are "safe for production use".
wikitech-l@lists.wikimedia.org