[Mediawiki-l] MediaWiki-l Digest, Vol 38, Issue 13
Michael D. Peters
michael.peters at lazarusalliance.com
Wed Nov 8 17:08:27 UTC 2006
horsewiki.archive and horsewiki_archive are two separate tables.
> Looks like the dump is failing on your first table, according to your
> 'show tables' command. Can you dump a another single table? Can you
> select from the archive table?
I'm far from a DBA. How do I do this?
> I think this is more of a MySQL issue than MediaWiki...and it appears
> there are other entries for it online.
>
> http://lists.mysql.com/mysql/202700
This is my post about this very issue without success.
> http://www.google.com/search?hs=gc&hl=en&lr=&client=firefox-
> a&rls=org.mozilla%3Aen-US%3Aofficial&q=mysqldump+error+1146&btnG=Search
I am not certain if this is my problem.
> Send MediaWiki-l mailing list submissions to
> mediawiki-l at Wikimedia.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> or, via email, send a message with subject or body 'help' to
> mediawiki-l-request at Wikimedia.org
>
> You can reach the person managing the list at
> mediawiki-l-owner at 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. R?p. : Re: include only a part of a page in another.
> (Serveur-Faucon Surveillance)
> 2. Re: mediawiki busts out of frames? (Brion Vibber)
> 3. Re: mediawiki busts out of frames? (Arjen Verweij)
> 4. Re: Problems with MediaWiki on Windows with Apache :-(
> (Fernando Correia)
> 5. Re: Deleting a page (Sindhu.Subramaniam at iflexsolutions.com)
> 6. When using LOCK TABLES?? (Michael D. Peters)
> 7. Re: When using LOCK TABLES?? (Rotem Liss)
> 8. Re: When using LOCK TABLES?? (Diona Kidd)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 07 Nov 2006 14:07:16 -0500
> From: "Serveur-Faucon Surveillance" <SrvFaucon at cslaval.qc.ca>
> Subject: [Mediawiki-l] R?p. : Re: include only a part of a page in
> another.
> To: <mediawiki-l at Wikimedia.org>
> Message-ID: <s550931c.005 at bp.cslaval.qc.ca>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Actually, these are already found ;)
>
> What I am searching is a way to have a function like this :
>
> {{if (this page is included) | then put <onlyinclude tag> | else
> <putnothing>}}
>
> That way, only the text that I want would be included, and at the same
> time would show when seeing the page directly.
>
> Putting <noinclude> all over a lot of pages is not really what I am
> looking for.
>
>
> <
> <<I believe you are looking for the <noinclude> and <includeonly> tags.
> <<See http://en.wikipedia.org/wiki/Help:Template#Noinclude_and_includeonly
> <
> <
>>>> JMorgan at d2hawkeye.com 2006-11-07 13:43:48 >>>
>>Hi all,
>>
>>So I am experimenting with page inclusion, but can't find the perfect
>>solution.
>>
>>I know I can include a full page with this {{:Page tests no 99}}.
>>
>>I know I can include part of a page by putting in the "Page tests no
> 99" >page some "<include></include>" so that only the not included part
> will be >visible insite the first page.
>>
>>But what I would prefer, is more something like putting some <from
> here><to >here>, but that would be visible even when the included page
> is visited. >That's not what the <onlyinclude></onlyinclude> tags do.
>>
>>So what I was thinking about doing is to put some kind of condition.
>>
>>{{if (this page is included) | then put <onlyinclude> | else <put
>>nothing>}}
>>{{if (this page is included) | then put </onlyinclude> | else <put
>>nothing>}}
>>
>>
>>But I can't find the correct syntax for that. Can someone help me?
> Thanks.
>
>
>
> I believe you are looking for the <noinclude> and <includeonly> tags.
> See http://en.wikipedia.org/wiki/Help:Template#Noinclude_and_includeonly
> -Justin
>
>
> PRIVACY NOTICE
>
> This email and any attachments may be confidential and/or privileged. Use
> of the information contained in this email by anyone other than the
> intended recipient is strictly prohibited. If you have received this email
> in error, please notify the sender by replying to this message and delete
> this email.
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
> ---------------------------------------------------
> Alexandre Racine - Gardien Virtuel - S?curit? Informatique
> www.gardienvirtuel.com
> Montr?al, Qu?bec, Canada
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 07 Nov 2006 20:13:46 +0100
> From: Brion Vibber <brion at pobox.com>
> Subject: Re: [Mediawiki-l] mediawiki busts out of frames?
> To: MediaWiki announcements and site admin list
> <mediawiki-l at Wikimedia.org>
> Message-ID: <4550DAEA.7080905 at pobox.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Arjen Verweij wrote:
>> Hello,
>>
>> I'm trying to embed a wiki page inside an existing site that uses
>> frames.
>> Using target="_self" I was hoping to have the wiki page load inside the
>> frame. Unfortunately, mediawiki seems to bust out of the frame, as if
>> target="_top".
>>
>> Does anyone know if this behaviour is due to mediawiki? If it isn't, I'm
>> sorry for bothering you, but I have next to no control over the parent
>> page
>> (environment). The alternative is to make the wiki look exactly like the
>> existing page (integrate existing header and sidebar) but I'm looking to
>> avoid this.
>
> http://meta.wikimedia.org/wiki/MediaWiki_FAQ#I_want_my_wiki_to_appear_in_a_frame_as_part_of_my_site.2C_but_it_keeps_popping_out_of_the_frame
>
> -- brion vibber (brion @ pobox.com)
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 7 Nov 2006 20:16:11 +0100
> From: "Arjen Verweij" <arjen.verweij at gmail.com>
> Subject: Re: [Mediawiki-l] mediawiki busts out of frames?
> To: "MediaWiki announcements and site admin list"
> <mediawiki-l at wikimedia.org>
> Message-ID:
> <201207d70611071116gc1e7707p263224eb2d1ad5e6 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Thanks, I found you in the past as well in:
> http://mail.wikipedia.org/pipermail/mediawiki-l/2004-July/000845.html
>
> Now mediawiki opens in a frame, but in the wrong one with target="_self".
> I
> guess this is progress though. Thank you for responding I will read your
> link.
>
> Arjen
>
> 2006/11/7, Brion Vibber <brion at pobox.com>:
>>
>> Arjen Verweij wrote:
>> > Hello,
>> >
>> > I'm trying to embed a wiki page inside an existing site that uses
>> frames.
>> > Using target="_self" I was hoping to have the wiki page load inside
>> the
>> > frame. Unfortunately, mediawiki seems to bust out of the frame, as if
>> > target="_top".
>> >
>> > Does anyone know if this behaviour is due to mediawiki? If it isn't,
>> I'm
>> > sorry for bothering you, but I have next to no control over the parent
>> page
>> > (environment). The alternative is to make the wiki look exactly like
>> the
>> > existing page (integrate existing header and sidebar) but I'm looking
>> to
>> > avoid this.
>>
>>
>> http://meta.wikimedia.org/wiki/MediaWiki_FAQ#I_want_my_wiki_to_appear_in_a_frame_as_part_of_my_site.2C_but_it_keeps_popping_out_of_the_frame
>>
>> -- brion vibber (brion @ pobox.com)
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-l at Wikimedia.org
>> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 7 Nov 2006 17:26:22 -0300
> From: "Fernando Correia" <fernandoacorreia at gmail.com>
> Subject: Re: [Mediawiki-l] Problems with MediaWiki on Windows with
> Apache :-(
> To: "MediaWiki announcements and site admin list"
> <mediawiki-l at wikimedia.org>
> Message-ID:
> <8140eff40611071226m79c3fbcdh6627aeba1f635c10 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I also had very similar problems with e-mail and change notifications on
> Windows, but I was able to sort them out.
>
> I use the PEAR method to send e-mails.
>
> I have some configurations like these:
>
> $wgEnableEmail = true;
> $wgEnableUserEmail = true;
> $wgEmergencyContact = "xxx <xxx at host>";
> $wgPasswordSender = $wgEmergencyContact;
> $wgSMTP = array(
> 'host' => "xxx.com.br",
> 'IDHost' => "xxx.com.br",
> 'port' => 25,
> 'auth' => false,
> );
>
> This line, 'auth' => false, was important. Although our mail server
> requires SMTP authentication, it was configure to not use it for the
> server
> IP. If the parameter was true, even with a valid username and password,
> I'd
> get email errors.
>
> I think other important parameters are:
>
> $wgEnotifUserTalk = true; # UPO
> $wgEnotifWatchlist = true; # UPO
>
>
> I'm new to MediaWiki so I think I can't help you very much. All I can say
> is
> that it works for me...
>
>
> ------------------------------
>
> Message: 5
> Date: Wed, 8 Nov 2006 09:18:31 +0530
> From: <Sindhu.Subramaniam at iflexsolutions.com>
> Subject: Re: [Mediawiki-l] Deleting a page
> To: <mediawiki-l at Wikimedia.org>
> Message-ID:
> <AF8C412A3B3396418292A43D613B83DD51E74A at MUM-MSG-01.i-flex.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Thanks a lot Alexis, the 'ALTER TABLE' commands worked. I can delete
> pages now.
>
> Best regards,
> Sindhu Subramaniam
>
> -----Original Message-----
> From: mediawiki-l-bounces at Wikimedia.org
> [mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of Alexis Moinet
> Sent: Tuesday, November 07, 2006 6:40 PM
> To: MediaWiki announcements and site admin list
> Subject: Re: [Mediawiki-l] Deleting a page
>
> http://meta.wikimedia.org/wiki/How_to_move_a_MediaWiki_Database#Troubles
> hooting
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
> ------------------------------
>
> Message: 6
> Date: Wed, 8 Nov 2006 11:00:34 -0500 (EST)
> From: "Michael D. Peters" <michael.peters at lazarusalliance.com>
> Subject: [Mediawiki-l] When using LOCK TABLES??
> To: mediawiki-l at Wikimedia.org
> Message-ID:
> <2181.71.224.6.35.1163001634.squirrel at Exchanger.lazarusalliance.com>
> Content-Type: text/plain;charset=iso-8859-1
>
> I would like to relocate my current wiki to another system. I am not
> having luck moving the database.
>
> I run this command:
>
> # mysqldump --user root --password=password horsewiki > horsewiki.sql
> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when
> using LOCK TABLES
> #
>
> #mysql -h localhost -u root -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 6760 to server version: 5.0.20a-max-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use horsewiki
> Database changed
> mysql> show tables;
> +-----------------------+
> | Tables_in_horsewiki |
> +-----------------------+
> | archive |
> | categorylinks |
> | externallinks |
> | hitcounter |
> | horse_archive |
> | horse_categorylinks |
> | horse_externallinks |
> | horse_filearchive |
> | horse_hitcounter |
> | horse_image |
> | horse_imagelinks |
> | horse_interwiki |
> | horse_ipblocks |
> | horse_ipblocks_old |
> | horse_job |
> | horse_langlinks |
> | horse_logging |
> | horse_math |
> | horse_objectcache |
> | horse_oldimage |
> | horse_page |
> | horse_pagelinks |
> | horse_querycache |
> | horse_querycache_info |
> | horse_recentchanges |
> | horse_revision |
> | horse_searchindex |
> | horse_site_stats |
> | horse_templatelinks |
> | horse_text |
> | horse_trackbacks |
> | horse_transcache |
> | horse_user |
> | horse_user_groups |
> | horse_user_newtalk |
> | horse_validate |
> | horse_watchlist |
> | image |
> | imagelinks |
> | interwiki |
> | ipblocks |
> | job |
> | logging |
> | math |
> | objectcache |
> | oldimage |
> | page |
> | pagelinks |
> | querycache |
> | recentchanges |
> | revision |
> | searchindex |
> | site_stats |
> | templatelinks |
> | text |
> | trackbacks |
> | transcache |
> | user |
> | user_groups |
> | user_newtalk |
> | validate |
> | watchlist |
> +-----------------------+
> 62 rows in set (0.00 sec)
>
> mysql>
>
> I don't really know if "horsewiki.archive" is the same thing as
> "horsewiki_archive"?
>
> Anyone have an idea? Maybe another way to move a database?
> --
> Best regards,
>
> Michael
>
>
> -----------------------------------------
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain CONFIDENTIAL material. If you
> receive this material/information in error, please contact the sender and
> delete or destroy the material/information.
>
> Lazarus Alliance archives all electronic messages for a period of three
> years.
>
> http://lazarusalliance.com/policy/
>
>
>
> ------------------------------
>
> Message: 7
> Date: Wed, 08 Nov 2006 18:11:09 +0200
> From: Rotem Liss <rotemliss_net at fastmail.fm>
> Subject: Re: [Mediawiki-l] When using LOCK TABLES??
> To: MediaWiki announcements and site admin list
> <mediawiki-l at Wikimedia.org>
> Message-ID: <4552019D.1030300 at fastmail.fm>
> Content-Type: text/plain; charset=ISO-8859-1
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Michael D. Peters wrote:
>> I don't really know if "horsewiki.archive" is the same thing as
>> "horsewiki_archive"?
>>
>
> I think that horsewiki.archive means "the table archive in the database
> horsewiki", while horsewiki_archive means "the table horsewiki_archive in
> the
> current database". I don't know how to use mysqldump, but you may have to
> specify a DB tables prefix instead of a database name.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFFUgGdqahN/0dU8mcRAmvxAJ4hu5XlVAc2neSDvG0jOUt6j5v8PgCeONjX
> LuRJtb8k4eKQ2iTTdaPLFck=
> =j363
> -----END PGP SIGNATURE-----
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 8 Nov 2006 11:38:05 -0500
> From: Diona Kidd <diona at knowmad.com>
> Subject: Re: [Mediawiki-l] When using LOCK TABLES??
> To: MediaWiki announcements and site admin list
> <mediawiki-l at Wikimedia.org>
> Message-ID: <FC009637-3802-49AD-AB6A-5167B628C49D at knowmad.com>
> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
>
> horsewiki.archive and horsewiki_archive are two separate tables.
> Looks like the dump is failing on your first table, according to your
> 'show tables' command. Can you dump a another single table? Can you
> select from the archive table?
>
> I think this is more of a MySQL issue than MediaWiki...and it appears
> there are other entries for it online.
>
> http://lists.mysql.com/mysql/202700
> http://www.google.com/search?hs=gc&hl=en&lr=&client=firefox-
> a&rls=org.mozilla%3Aen-US%3Aofficial&q=mysqldump+error+1146&btnG=Search
>
> Diona
> ---------------
> Knowmad Technologies
> http://www.knowmad.com
>
>
>
> On Nov 8, 2006, at 11:00 AM, Michael D. Peters wrote:
>
>> I would like to relocate my current wiki to another system. I am not
>> having luck moving the database.
>>
>> I run this command:
>>
>> # mysqldump --user root --password=password horsewiki > horsewiki.sql
>> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist
>> when
>> using LOCK TABLES
>> #
>>
>> #mysql -h localhost -u root -p
>> Enter password:
>> Welcome to the MySQL monitor. Commands end with ; or \g.
>> Your MySQL connection id is 6760 to server version: 5.0.20a-max-log
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>
>> mysql> use horsewiki
>> Database changed
>> mysql> show tables;
>> +-----------------------+
>> | Tables_in_horsewiki |
>> +-----------------------+
>> | archive |
>> | categorylinks |
>> | externallinks |
>> | hitcounter |
>> | horse_archive |
>> | horse_categorylinks |
>> | horse_externallinks |
>> | horse_filearchive |
>> | horse_hitcounter |
>> | horse_image |
>> | horse_imagelinks |
>> | horse_interwiki |
>> | horse_ipblocks |
>> | horse_ipblocks_old |
>> | horse_job |
>> | horse_langlinks |
>> | horse_logging |
>> | horse_math |
>> | horse_objectcache |
>> | horse_oldimage |
>> | horse_page |
>> | horse_pagelinks |
>> | horse_querycache |
>> | horse_querycache_info |
>> | horse_recentchanges |
>> | horse_revision |
>> | horse_searchindex |
>> | horse_site_stats |
>> | horse_templatelinks |
>> | horse_text |
>> | horse_trackbacks |
>> | horse_transcache |
>> | horse_user |
>> | horse_user_groups |
>> | horse_user_newtalk |
>> | horse_validate |
>> | horse_watchlist |
>> | image |
>> | imagelinks |
>> | interwiki |
>> | ipblocks |
>> | job |
>> | logging |
>> | math |
>> | objectcache |
>> | oldimage |
>> | page |
>> | pagelinks |
>> | querycache |
>> | recentchanges |
>> | revision |
>> | searchindex |
>> | site_stats |
>> | templatelinks |
>> | text |
>> | trackbacks |
>> | transcache |
>> | user |
>> | user_groups |
>> | user_newtalk |
>> | validate |
>> | watchlist |
>> +-----------------------+
>> 62 rows in set (0.00 sec)
>>
>> mysql>
>>
>> I don't really know if "horsewiki.archive" is the same thing as
>> "horsewiki_archive"?
>>
>> Anyone have an idea? Maybe another way to move a database?
>> --
>> Best regards,
>>
>> Michael
>>
>>
>> -----------------------------------------
>> The information transmitted is intended only for the person or
>> entity to which it is addressed and may contain CONFIDENTIAL
>> material. If you receive this material/information in error, please
>> contact the sender and delete or destroy the material/information.
>>
>> Lazarus Alliance archives all electronic messages for a period of
>> three years.
>>
>> http://lazarusalliance.com/policy/
>>
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-l at Wikimedia.org
>> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
>
> ------------------------------
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
> End of MediaWiki-l Digest, Vol 38, Issue 13
> *******************************************
>
-----------------------------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
Lazarus Alliance archives all electronic messages for a period of three years.
http://lazarusalliance.com/policy/
More information about the MediaWiki-l
mailing list