Why do I have to restore a database backup?
I repeat my previous issue, this message appears in 2 special pages (
):
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 "". MySQL returned error "1104:
The
SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use
SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
(localhost)".
Except for those 2 special pages, the entire mediawiki site works well.
Thanks,
Mihai
2009/7/13 <mediawiki-l-request(a)lists.wikimedia.org>
Send MediaWiki-l mailing list submissions to
mediawiki-l(a)lists.wikimedia.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
or, via email, send a message with subject or body 'help' to
mediawiki-l-request(a)lists.wikimedia.org
You can reach the person managing the list at
mediawiki-l-owner(a)lists.wikimedia.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MediaWiki-l digest..."
Today's Topics:
1. Encyclopedia Britannica open contribution site (Farkas, Illes)
2. Re: Login page not showing (Jean-Marc van Leerdam)
3. Re: Login page not showing (Ekompute .info)
4. Re: Login page not showing (Jean-Marc van Leerdam)
5. Re: Login page not showing (Ekompute .info)
6. Errors (mihai)
7. Re: Errors (Ekompute .info)
8. Re: Errors (Henny Savenije)
9. Re: Errors (Ekompute .info)
----------------------------------------------------------------------
Message: 1
Date: Sun, 12 Jul 2009 15:37:51 +0200
From: "Farkas, Illes" <fij(a)elte.hu>
Subject: [Mediawiki-l] Encyclopedia Britannica open contribution site
To: mediawiki-l(a)lists.wikimedia.org
Message-ID:
<ddfa64ce0907120637i6a32733fk892c4acf6b872243(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hello,
Do you happen to know the present URL of the site
http://www.britannica.com/bps/home mentioned in the article "Encyclopaedia
Britannica To Follow Modified Wikipedia Model" (
http://www.wired.com/epicenter/2008/06/ency/) ?
Shall I post question to a different list?
Thanks in advance for any suggestion
------------------------------
Message: 2
Date: Sun, 12 Jul 2009 17:08:41 +0200
From: Jean-Marc van Leerdam <j.m.van.leerdam(a)gmail.com>
Subject: Re: [Mediawiki-l] Login page not showing
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<4e4d410b0907120808v6e7220f5pe0a063a4b4dcd61e(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi, PM Poon,
2009/7/10 Ekompute .info <ekompute(a)gmail.com>om>:
Thank you Jim, for taking the trouble to show me
the relevant page. Even
my
Firefox has problems. The pages in the main
namespace looks okay but not
in
the other name spaces like Mediawiki and
Template, for example. I guess
my
skin really do need a complete overhaul, although
I have done three
different versions.
Did you base your skin on Monobook? In that case, perhaps the
explanation I give on [1] can help you find out where the problem
lies. The page also has references to wikimedia and other
theme/skinning related sites.
There is some weird sizing happening on your site when using IE
(widening the screen will only increase the width of the page even
more, adding a scrollbar and stretching the content apart...). The top
menu also doesn't show in IE (it is projected on top of the main
navigation portlet.
[1]
http://about42.nl/wiki/Monobook_CSS_Explained
--
Regards,
Jean-Marc
--
. ___
. @@ // \\ "De Chelonian Mobile"
. (_,\/ \_/ \ TortoiseSVN
. \ \_/_\_/> The coolest Interface to (Sub)Version Control
. /_/ \_\
http://tortoisesvn.net
------------------------------
Message: 3
Date: Mon, 13 Jul 2009 00:24:04 +0800
From: "Ekompute .info" <ekompute(a)gmail.com>
Subject: Re: [Mediawiki-l] Login page not showing
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<1c13c3ab0907120924i70472bb3l9db2fb25f4ed8d98(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi Jean-Marc, thank you for your response. I did follow your advice and
managed to learn a thing or two. However, I still have some problems as
sometimes when I changed certain things, other things move "without"
apparent reason. Anyway, I tried many configurations and managed to
"solve"
the login page problem, as you can see at this
page<http://dummipedia.org/Special:UserLogin>in>,
using IE6. I still don't understand why this particular version works, LOL.
However, the red links are not showing in the p-cactions bar (2nd bar below
logo, right at the top) although it works for the personal toolbar:
a.new, #p-personal a.new, #p-cactions a.new {
color: #ba0000;
}
Both bars are defined by the above statements, so it is rather surprising
that one works and not the other. I would be glad if you or anyone can
assist me as there is no way at the moment for me, or anyone for that
matter, to know whether the pages are empty.
PM Poon
On Sun, Jul 12, 2009 at 11:08 PM, Jean-Marc van Leerdam <
j.m.van.leerdam(a)gmail.com> wrote:
Hi, PM Poon,
2009/7/10 Ekompute .info <ekompute(a)gmail.com>om>:
> Thank you Jim, for taking the trouble to show me the relevant page.
Even
my
> Firefox has problems. The pages in the main namespace looks okay but
not
> in
>
the other name spaces like Mediawiki and
Template, for example. I guess
> my
> > skin really do need a complete overhaul, although I have done three
> > different versions.
> >
>
> Did you base your skin on Monobook? In that case, perhaps the
> explanation I give on [1] can help you find out where the problem
> lies. The page also has references to wikimedia and other
> theme/skinning related sites.
>
> There is some weird sizing happening on your site when using IE
> (widening the screen will only increase the width of the page even
> more, adding a scrollbar and stretching the content apart...). The top
> menu also doesn't show in IE (it is projected on top of the main
> navigation portlet.
>
> [1]
http://about42.nl/wiki/Monobook_CSS_Explained
>
> --
> Regards,
>
> Jean-Marc
> --
> . ___
> . @@ // \\ "De Chelonian Mobile"
> . (_,\/ \_/ \ TortoiseSVN
> . \ \_/_\_/> The coolest Interface to (Sub)Version Control
> . /_/ \_\
http://tortoisesvn.net
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
------------------------------
Message: 4
Date: Sun, 12 Jul 2009 22:59:59 +0200
From: Jean-Marc van Leerdam <j.m.van.leerdam(a)gmail.com>
Subject: Re: [Mediawiki-l] Login page not showing
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<4e4d410b0907121359q7f1638a3n86f5d6e8510b308(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi,
2009/7/12 Ekompute .info <ekompute(a)gmail.com>om>:
Hi Jean-Marc, thank you for your response. I did
follow your advice and
managed to learn a thing or two. However, I still have some problems as
sometimes when I changed certain things, other things move "without"
apparent reason. Anyway, I tried many configurations and ?managed to
"solve"
the login page problem, as you can see at this
page<http://dummipedia.org/Special:UserLogin>in>,
using IE6. I still don't understand why this particular version works,
LOL.
However, the red links are not showing in the
p-cactions bar (2nd bar
below
logo, right at the top) although it works for the
personal toolbar:
a.new, #p-personal a.new, #p-cactions a.new {
? ?color: #ba0000;
}
Both bars are defined by the above statements, so it is rather surprising
that one works and not the other. I would be glad if you or anyone can
assist me as there is no way at the moment for me, or anyone for that
matter, to know whether the pages are empty.
Using FF WebDeveloper plugin shows that the .new is applied to the
<li>, not to the <a>, therefor the css selection is not done. For
example, hovering on the Video tab on the main page gives
html > body .mediawiki ltr ns-0 ns-subject
page-Free_Simplified_Online_Encyclopedia skin-nuskin > div
#globalWrapper > div #column-one > div #p-cactions .portlet > div
.pBody > ul > li #ca-video .new > a
--
Regards,
Jean-Marc
--
. ___
. @@ // \\ "De Chelonian Mobile"
. (_,\/ \_/ \ TortoiseSVN
. \ \_/_\_/> The coolest Interface to (Sub)Version Control
. /_/ \_\
http://tortoisesvn.net
------------------------------
Message: 5
Date: Mon, 13 Jul 2009 05:40:02 +0800
From: "Ekompute .info" <ekompute(a)gmail.com>
Subject: Re: [Mediawiki-l] Login page not showing
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<1c13c3ab0907121440y66b6225bn656a383915762caf(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi Jean-Marc, thank you once again for your response and for taking the
trouble to help me out. I have checked my main.css but could not find the
problem that you mentioned. I have posted the contents of the main.css at
Dummipedia.com <http://dummipedia.com/MediaWiki:Main.css> and will be glad
if you can help me pinpoint the problem.
PM Poon
On Mon, Jul 13, 2009 at 4:59 AM, Jean-Marc van Leerdam <
j.m.van.leerdam(a)gmail.com> wrote:
> Hi,
>
> 2009/7/12 Ekompute .info <ekompute(a)gmail.com>om>:
> > Hi Jean-Marc, thank you for your response. I did follow your advice and
> > managed to learn a thing or two. However, I still have some problems as
> > sometimes when I changed certain things, other things move "without"
> > apparent reason. Anyway, I tried many configurations and managed to
> "solve"
> > the login page problem, as you can see at this
> >
page<http://dummipedia.org/Special:UserLogin>in>,
> > using IE6. I still don't understand why this particular version works,
> LOL.
>
However, the red links are not showing in
the p-cactions bar (2nd bar
> below
> > logo, right at the top) although it works for the personal toolbar:
> >
> > a.new, #p-personal a.new, #p-cactions a.new {
> > color: #ba0000;
> > }
> >
> > Both bars are defined by the above statements, so it is rather
surprising
that one
works and not the other. I would be glad if you or anyone can
assist me as there is no way at the moment for me, or anyone for that
matter, to know whether the pages are empty.
Using FF WebDeveloper plugin shows that the .new is applied to the
<li>, not to the <a>, therefor the css selection is not done. For
example, hovering on the Video tab on the main page gives
html > body .mediawiki ltr ns-0 ns-subject
page-Free_Simplified_Online_Encyclopedia skin-nuskin > div
#globalWrapper > div #column-one > div #p-cactions .portlet > div
.pBody > ul > li #ca-video .new > a
--
Regards,
Jean-Marc
--
. ___
. @@ // \\ "De Chelonian Mobile"
. (_,\/ \_/ \ TortoiseSVN
. \ \_/_\_/> The coolest Interface to (Sub)Version Control
. /_/ \_\
http://tortoisesvn.net
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
------------------------------
Message: 6
Date: Mon, 13 Jul 2009 09:50:28 +0300
From: mihai <er.mihai(a)gmail.com>
Subject: [Mediawiki-l] Errors
To: mediawiki-l(a)lists.wikimedia.org
Message-ID:
<825b2d240907122350h1b33fe17u95f2b852d44aca7e(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi,
I have an error on my own wiki
http://enciclopediaromaniei.ro. The error
appears in 2 cases
http://enciclopediaromaniei.ro/wiki/Special:Lonelypagesand
http://enciclopediaromaniei.ro/wiki/Special:Deadendpages. You can see the
version of the soft used
http://enciclopediaromaniei.ro/wiki/Special:Version
.
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 "". MySQL returned error "1104: The SELECT would
examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET
SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
(localhost)".
My wiki is hosted and I don't know what to say to host in order to
eliminate
the error.
Thanks,
Mihai
http://enciclopediaromaniei.ro
------------------------------
Message: 7
Date: Mon, 13 Jul 2009 15:52:06 +0800
From: "Ekompute .info" <ekompute(a)gmail.com>
Subject: Re: [Mediawiki-l] Errors
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<1c13c3ab0907130052i5d51cc4bm726138e066ce93c9(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Oh dear... guess you need to restore a copy of your database backup. The
webhost is not responsible, so there is practically nothing much you can
say
to them. If you don't have a copy, check with them as fast as possible as
they may have a temporary backup which is replaced daily. If you wait too
long, they may have replaced their backup with the latest corrupted copy.
PM Poon
On Mon, Jul 13, 2009 at 2:50 PM, mihai <er.mihai(a)gmail.com> wrote:
the
version of the soft used
http://enciclopediaromaniei.ro/wiki/Special:Version
.
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 "". MySQL returned error "1104: The SELECT would
examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET
SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
(localhost)".
My wiki is hosted and I don't know what to say to host in order to
eliminate
the error.
Thanks,
Mihai
http://enciclopediaromaniei.ro
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
------------------------------
Message: 8
Date: Mon, 13 Jul 2009 17:13:07 +0900
From: Henny Savenije <webmaster(a)henny-savenije.pe.kr>
Subject: Re: [Mediawiki-l] Errors
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<mailman.26120.1247476798.5117.mediawiki-l(a)lists.wikimedia.org>
Content-Type: text/plain; charset="us-ascii"; format=flowed
On most cPanel servers the server makes a daily, weekly and monthly
backup. If you're on a cpanel server ask them to replace first the
daily copy and if that doesn't work the weekly and so on.
At 04:52 PM 7/13/2009, you wrote:
Oh dear... guess you need to restore a copy of
your database backup. The
webhost is not responsible, so there is practically nothing much you can
say
to them. If you don't have a copy, check with
them as fast as possible as
they may have a temporary backup which is replaced daily. If you wait too
long, they may have replaced their backup with the latest corrupted copy.
PM Poon
On Mon, Jul 13, 2009 at 2:50 PM, mihai <er.mihai(a)gmail.com> wrote:
> Hi,
> I have an error on my own wiki
http://enciclopediaromaniei.ro. The
error
the
> version of the soft used
>
http://enciclopediaromaniei.ro/wiki/Special:Version
> .
>
> 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 "". MySQL returned error "1104: The SELECT would
examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET
SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
(localhost)".
My wiki is hosted and I don't know what to say to host in order to
eliminate
the error.
Thanks,
Mihai
http://enciclopediaromaniei.ro
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_ _
(o) (o)
oOOO----(_)----OOOo---
Henny (Lee Hae Kang)
-----------------------------
http://www.henny-savenije.pe.kr Portal to all my sites
http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free
to discover Korea with Hendrick Hamel (1653-1666)
http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean
http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch
http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen
and Eibokken and his first Korean-Dutch dictionary
http://www.cartography.henny-savenije.pe.kr (in English) Korea
through Western Cartographic eyes
http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon
http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures
http://www.british.henny-savenije.pe.kr A British encounter in Pusan
(1797)
http://www.genealogy.henny-savenije.pe.kr/ Genealogy
http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies
------------------------------
Message: 9
Date: Mon, 13 Jul 2009 17:19:53 +0800
From: "Ekompute .info" <ekompute(a)gmail.com>
Subject: Re: [Mediawiki-l] Errors
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<1c13c3ab0907130219x43da2235s80af8979ad04dd6a(a)mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi Henny Savenije, I think the practice differs from webhost to webhost. I
was once asked to pay US$28.75 to restore a backup (without guarantee) by
my
previous webhost, Siteground. Apparently, they kept 2 daily backups at any
one time. The two backups turned out to be corrupted and yet, they said I
still have to pay.
PM Poon
On Mon, Jul 13, 2009 at 4:13 PM, Henny Savenije <
webmaster(a)henny-savenije.pe.kr> wrote:
On most cPanel servers the server makes a daily,
weekly and monthly
backup. If you're on a cpanel server ask them to replace first the
daily copy and if that doesn't work the weekly and so on.
At 04:52 PM 7/13/2009, you wrote:
Oh dear... guess you need to restore a copy of
your database backup. The
webhost is not responsible, so there is practically nothing much you can
say
>to them. If you don't have a copy, check with them as fast as possible
as
>they may have a temporary backup which is
replaced daily. If you wait
too
>long, they may have replaced their backup
with the latest corrupted
copy.
PM Poon
On Mon, Jul 13, 2009 at 2:50 PM, mihai <er.mihai(a)gmail.com> wrote:
> Hi,
> I have an error on my own wiki
http://enciclopediaromaniei.ro. The
error
> > appears in 2 cases
> >
http://enciclopediaromaniei.ro/wiki/Special:Lonelypagesand
> >
http://enciclopediaromaniei.ro/wiki/Special:Deadendpages. You can
see
the
> > version of the soft used
> >
http://enciclopediaromaniei.ro/wiki/Special:Version
> > .
> >
> > 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 "". MySQL returned error "1104: The SELECT would
examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET
SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
(localhost)".
My wiki is hosted and I don't know what to say to host in order to
eliminate
the error.
Thanks,
Mihai
http://enciclopediaromaniei.ro
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_ _
(o) (o)
oOOO----(_)----OOOo---
Henny (Lee Hae Kang)
-----------------------------
http://www.henny-savenije.pe.kr Portal to all my sites
http://www.hendrick-hamel.henny-savenije.pe.kr (in English) Feel free
to discover Korea with Hendrick Hamel (1653-1666)
http://www.hendrick-hamel.henny-savenije.pe.kr/indexk2.htm In Korean
http://www.hendrick-hamel.henny-savenije.pe.kr/Dutch In Dutch
http://www.vos.henny-savenije.pe.kr Frits Vos Article about Witsen
and Eibokken and his first Korean-Dutch dictionary
http://www.cartography.henny-savenije.pe.kr (in English) Korea
through Western Cartographic eyes
http://www.hwasong.henny-savenije.pe.kr Hwasong the fortress in Suwon
http://www.oldKorea.henny-savenije.pe.kr Old Korea in pictures
http://www.british.henny-savenije.pe.kr A British encounter in Pusan
(1797)
http://www.genealogy.henny-savenije.pe.kr/ Genealogy
http://www.henny-savenije.pe.kr/phorum Bulletin board for Korean studies
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
------------------------------
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
End of MediaWiki-l Digest, Vol 70, Issue 20
*******************************************