Why do I have to restore a database backup?
I repeat my previous issue, this message appears in 2 special pages ( http://enciclopediaromaniei.ro/wiki/Special:Lonelypagesand, http://enciclopediaromaniei.ro/wiki/Special:Deadendpageshttp://enciclopediaromaniei.ro/wiki/Special:Deadendpages. ):
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@lists.wikimedia.org
Send MediaWiki-l mailing list submissions to mediawiki-l@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@lists.wikimedia.org
You can reach the person managing the list at mediawiki-l-owner@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:
- Encyclopedia Britannica open contribution site (Farkas, Illes)
- Re: Login page not showing (Jean-Marc van Leerdam)
- Re: Login page not showing (Ekompute .info)
- Re: Login page not showing (Jean-Marc van Leerdam)
- Re: Login page not showing (Ekompute .info)
- Errors (mihai)
- Re: Errors (Ekompute .info)
- Re: Errors (Henny Savenije)
- Re: Errors (Ekompute .info)
Message: 1 Date: Sun, 12 Jul 2009 15:37:51 +0200 From: "Farkas, Illes" fij@elte.hu Subject: [Mediawiki-l] Encyclopedia Britannica open contribution site To: mediawiki-l@lists.wikimedia.org Message-ID: ddfa64ce0907120637i6a32733fk892c4acf6b872243@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@gmail.com Subject: Re: [Mediawiki-l] Login page not showing To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: 4e4d410b0907120808v6e7220f5pe0a063a4b4dcd61e@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1
Hi, PM Poon,
2009/7/10 Ekompute .info ekompute@gmail.com:
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@gmail.com Subject: Re: [Mediawiki-l] Login page not showing To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: 1c13c3ab0907120924i70472bb3l9db2fb25f4ed8d98@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 pagehttp://dummipedia.org/Special:UserLogin, 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@gmail.com> wrote:
Hi, PM Poon,
2009/7/10 Ekompute .info ekompute@gmail.com:
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@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@gmail.com Subject: Re: [Mediawiki-l] Login page not showing To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: 4e4d410b0907121359q7f1638a3n86f5d6e8510b308@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1
Hi,
2009/7/12 Ekompute .info ekompute@gmail.com:
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 pagehttp://dummipedia.org/Special:UserLogin, 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@gmail.com Subject: Re: [Mediawiki-l] Login page not showing To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: 1c13c3ab0907121440y66b6225bn656a383915762caf@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@gmail.com> wrote:
Hi,
2009/7/12 Ekompute .info ekompute@gmail.com:
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 pagehttp://dummipedia.org/Special:UserLogin, 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@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@gmail.com Subject: [Mediawiki-l] Errors To: mediawiki-l@lists.wikimedia.org Message-ID: 825b2d240907122350h1b33fe17u95f2b852d44aca7e@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@gmail.com Subject: Re: [Mediawiki-l] Errors To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: 1c13c3ab0907130052i5d51cc4bm726138e066ce93c9@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@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@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@henny-savenije.pe.kr Subject: Re: [Mediawiki-l] Errors To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: mailman.26120.1247476798.5117.mediawiki-l@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@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@gmail.com Subject: Re: [Mediawiki-l] Errors To: MediaWiki announcements and site admin list mediawiki-l@lists.wikimedia.org Message-ID: 1c13c3ab0907130219x43da2235s80af8979ad04dd6a@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@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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
End of MediaWiki-l Digest, Vol 70, Issue 20
mediawiki-l@lists.wikimedia.org