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:Deadendpages<http://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 <[email protected]> > Send MediaWiki-l mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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" <[email protected]> > Subject: [Mediawiki-l] Encyclopedia Britannica open contribution site > To: [email protected] > Message-ID: > <[email protected]> > 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 <[email protected]> > Subject: Re: [Mediawiki-l] Login page not showing > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, PM Poon, > > > 2009/7/10 Ekompute .info <[email protected]>: > > 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" <[email protected]> > Subject: Re: [Mediawiki-l] Login page not showing > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > 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>, > 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 < > [email protected]> wrote: > > > Hi, PM Poon, > > > > > > 2009/7/10 Ekompute .info <[email protected]>: > > > 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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > ------------------------------ > > Message: 4 > Date: Sun, 12 Jul 2009 22:59:59 +0200 > From: Jean-Marc van Leerdam <[email protected]> > Subject: Re: [Mediawiki-l] Login page not showing > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > > 2009/7/12 Ekompute .info <[email protected]>: > > 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>, > > 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" <[email protected]> > Subject: Re: [Mediawiki-l] Login page not showing > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > 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 < > [email protected]> wrote: > > > Hi, > > > > 2009/7/12 Ekompute .info <[email protected]>: > > > 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>, > > > 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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > ------------------------------ > > Message: 6 > Date: Mon, 13 Jul 2009 09:50:28 +0300 > From: mihai <[email protected]> > Subject: [Mediawiki-l] Errors > To: [email protected] > Message-ID: > <[email protected]> > 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" <[email protected]> > Subject: Re: [Mediawiki-l] Errors > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > 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 <[email protected]> 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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > ------------------------------ > > Message: 8 > Date: Mon, 13 Jul 2009 17:13:07 +0900 > From: Henny Savenije <[email protected]> > Subject: Re: [Mediawiki-l] Errors > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > 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 <[email protected]> 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 > > > [email protected] > > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > >_______________________________________________ > >MediaWiki-l mailing list > >[email protected] > >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" <[email protected]> > Subject: Re: [Mediawiki-l] Errors > To: MediaWiki announcements and site admin list > <[email protected]> > Message-ID: > <[email protected]> > 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 < > [email protected]> 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 <[email protected]> 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 > > > > [email protected] > > > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > > >_______________________________________________ > > >MediaWiki-l mailing list > > >[email protected] > > >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 > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > ------------------------------ > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > End of MediaWiki-l Digest, Vol 70, Issue 20 > ******************************************* > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
