Hi,
My wiki is located at: http://www.researchpipeline.com/mediawiki/index.php?title=Main_Page
I just upgraded to mediawiki 1.15.0 from the previous version. When I try to create a new page or click on "recent changes" I get the following error:
Database error
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 "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1146: Table 'lyndi1_wikidb.mw_tag_summary' doesn't exist (localhost)".
I'm a relative newbie. What does this mean?
Thanks,
Lyndie
Lyndie Chiou wrote:
Hi,
My wiki is located at: http://www.researchpipeline.com/mediawiki/index.php?title=Main_Page
I just upgraded to mediawiki 1.15.0 from the previous version. When I try to create a new page or click on "recent changes" I get the following error:
Database error
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 "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1146: Table 'lyndi1_wikidb.mw_tag_summary' doesn't exist (localhost)".
I'm a relative newbie. What does this mean?
Thanks,
Lyndie
You need to run the upgrade scripts
For details see the page at http://www.mediawiki.org/wiki/Manual:Upgrading
Thanks, but that's what I did - I upgraded to v. 1.15 by re-running the installer. I got a message at the end that the upgrade had completed successfully.
Or am I missing something?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Q Sent: Thursday, July 02, 2009 8:48 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Database error msg?
Lyndie Chiou wrote:
Hi,
My wiki is located at: http://www.researchpipeline.com/mediawiki/index.php?title=Main_Page
I just upgraded to mediawiki 1.15.0 from the previous version. When I try
to
create a new page or click on "recent changes" I get the following error:
Database error
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 "IndexPager::reallyDoQuery (LogPager)". MySQL
returned
error "1146: Table 'lyndi1_wikidb.mw_tag_summary' doesn't exist (localhost)".
I'm a relative newbie. What does this mean?
Thanks,
Lyndie
You need to run the upgrade scripts
For details see the page at http://www.mediawiki.org/wiki/Manual:Upgrading
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
You can't just re-run the installer anymore. As it says in the UPGRADE file:
From the command line, browse to the "maintenance" directory and run the update.php script to check and update the schema. This will insert missing tables, update existing tables, and move data around as needed. In most cases, this is successful and nothing further needs to be done.
Michelle
On Jul 2, 2009, at 9:27 PM, Lyndie Chiou wrote:
Thanks, but that's what I did - I upgraded to v. 1.15 by re-running the installer. I got a message at the end that the upgrade had completed successfully.
Or am I missing something?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Q Sent: Thursday, July 02, 2009 8:48 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Database error msg?
Lyndie Chiou wrote:
Hi,
My wiki is located at: http://www.researchpipeline.com/mediawiki/index.php?title=Main_Page
I just upgraded to mediawiki 1.15.0 from the previous version. When I try
to
create a new page or click on "recent changes" I get the following error:
Database error
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 "IndexPager::reallyDoQuery (LogPager)". MySQL
returned
error "1146: Table 'lyndi1_wikidb.mw_tag_summary' doesn't exist (localhost)".
I'm a relative newbie. What does this mean?
Thanks,
Lyndie
You need to run the upgrade scripts
For details see the page at http://www.mediawiki.org/wiki/Manual:Upgrading
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
On Fri, Jul 3, 2009 at 1:23 AM, Michelle michelle.sg1@gmail.com wrote:
You can't just re-run the installer anymore. As it says in the UPGRADE file:
From the command line, browse to the "maintenance" directory and run the update.php script to check and update the schema. This will insert missing tables, update existing tables, and move data around as needed. In most cases, this is successful and nothing further needs to be done.
I believe you are mistaken. The selection you're quoting has been in the UPGRADE file since 1.6. Also in there: "You can use the web-based installer wizard if you first remove the LocalSettings.php (and AdminSettings.php, if any) files;[...]" On Fri, Jul 3, 2009 at 12:27 AM, Lyndie Chiou lyndie@researchpipeline.comwrote:
Thanks, but that's what I did - I upgraded to v. 1.15 by re-running the installer. I got a message at the end that the upgrade had completed successfully.
Or am I missing something?
Do you happen to have the output from when you re-ran the installer?
After much finagling I ran the update script (I don't have command-line access so I had to set up a cron job). My wiki works again! Thanks for the tip - I guess I have to run the update script from now on instead of re-installing.
Lyndie
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Benjamin Lees Sent: Friday, July 03, 2009 12:07 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Database error msg?
On Fri, Jul 3, 2009 at 1:23 AM, Michelle michelle.sg1@gmail.com wrote:
You can't just re-run the installer anymore. As it says in the UPGRADE file:
From the command line, browse to the "maintenance" directory and run the update.php script to check and update the schema. This will insert missing tables, update existing tables, and move data around as needed. In most cases, this is successful and nothing further needs to be done.
I believe you are mistaken. The selection you're quoting has been in the UPGRADE file since 1.6. Also in there: "You can use the web-based installer wizard if you first remove the LocalSettings.php (and AdminSettings.php, if any) files;[...]" On Fri, Jul 3, 2009 at 12:27 AM, Lyndie Chiou lyndie@researchpipeline.comwrote:
Thanks, but that's what I did - I upgraded to v. 1.15 by re-running the installer. I got a message at the end that the upgrade had completed successfully.
Or am I missing something?
Do you happen to have the output from when you re-ran the installer? _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On Sat, Jul 4, 2009 at 2:39 PM, Lyndie Chioulyndie@researchpipeline.com wrote:
After much finagling I ran the update script (I don't have command-line access so I had to set up a cron job). My wiki works again! Thanks for the tip - I guess I have to run the update script from now on instead of re-installing.
Lyndie
You need to do both, the installer updates the files and the update script corrects the database schema. -Peachey
Ok, thanks!
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of K. Peachey Sent: Friday, July 03, 2009 10:32 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Database error msg?
On Sat, Jul 4, 2009 at 2:39 PM, Lyndie Chioulyndie@researchpipeline.com wrote:
After much finagling I ran the update script (I don't have command-line access so I had to set up a cron job). My wiki works again! Thanks for the tip - I guess I have to run the update script from now on instead of re-installing.
Lyndie
You need to do both, the installer updates the files and the update script corrects the database schema. -Peachey
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi,
(sorry for my poor english... I speak french...;-) )
I have actually a wiki where the users are members of different groups. Some groups are able to read, some others to read/write, etc...
My wiki is divided in categories. One of them is a kind of mini-portal for a specific group. This category is accessed usually by a specific user (a generic user) that all the group uses.
I have receive today a request : is it possible for this generic user to view ONLY the pages in ONLY one category ?
Example : if I have Category A, Category B and Category C, is it possible for this generic user to access only Category C, and never Category A and Category B ? If in a page of Category C there is a link to a page in Category A, he should receive an error, or an access denied message, something like that...
Is it possible ? Some ideas ?
Thanks in advance !
Pierre Labrecque
"PL" == Pierre Labrecque pierre.labrecque@live.ca writes:
PL> I have receive today a request : is it possible for this generic user to PL> view ONLY the pages in ONLY one category ?
Well, in https://bugzilla.wikimedia.org/show_bug.cgi?id=7897 you can see how I stopped users from _edit_ing categories. So you would probably make three different usergroups etc...
Pierre Labrecque a écrit:
Hi,
(sorry for my poor english... I speak french...;-) )
I have actually a wiki where the users are members of different groups. Some groups are able to read, some others to read/write, etc...
My wiki is divided in categories. One of them is a kind of mini-portal for a specific group. This category is accessed usually by a specific user (a generic user) that all the group uses.
I have receive today a request : is it possible for this generic user to view ONLY the pages in ONLY one category ?
Example : if I have Category A, Category B and Category C, is it possible for this generic user to access only Category C, and never Category A and Category B ? If in a page of Category C there is a link to a page in Category A, he should receive an error, or an access denied message, something like that...
Is it possible ? Some ideas ?
Thanks in advance !
Pierre Labrecque
No. MediaWiki is not a CMS. There're some extensions to add user rights to mediawiki http://www.mediawiki.org/wiki/Category:Page_specific_user_rights_extensions but many of them are incomplete.
Wich would be interesting would be to make like in Knol: possibility of having signed pages : ie with the title : "Page Tilte (Name of the owner)".
We are using it at Design Platform because this is a way to encourage participation and for the user, to filter wich pages are synthesis content and wich are personal stories from autors (well, we host stories also, that's the point), all the deal is with the search engine : user sould have the possibility to exclude thoose pages. If not the results in the search engine would be... well, like in Knoll : it is impossible to find anything. We have not looked at technics about pages protection, for the moment this is based on admins control, so it is not a question, more a remark on how an encyclopedia can benefit from some CMS abilities. 2009/7/7 Platonides Platonides@gmail.com
Pierre Labrecque a écrit:
Hi,
(sorry for my poor english... I speak french...;-) )
I have actually a wiki where the users are members of different groups.
Some
groups are able to read, some others to read/write, etc...
My wiki is divided in categories. One of them is a kind of mini-portal
for a
specific group. This category is accessed usually by a specific user (a generic user) that all the group uses.
I have receive today a request : is it possible for this generic user to view ONLY the pages in ONLY one category ?
Example : if I have Category A, Category B and Category C, is it possible for this generic user to access only Category C, and never Category A and Category B ? If in a page of Category C there is a link to a page in Category A, he should receive an error, or an access denied message, something like that...
Is it possible ? Some ideas ?
Thanks in advance !
Pierre Labrecque
No. MediaWiki is not a CMS. There're some extensions to add user rights to mediawiki http://www.mediawiki.org/wiki/Category:Page_specific_user_rights_extensions but many of them are incomplete.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Thibaut DEVERAUX escribió:
Wich would be interesting would be to make like in Knol: possibility of having signed pages : ie with the title : "Page Tilte (Name of the owner)".
We are using it at Design Platform because this is a way to encourage participation and for the user, to filter wich pages are synthesis content and wich are personal stories from autors (well, we host stories also, that's the point), all the deal is with the search engine : user sould have the possibility to exclude thoose pages. If not the results in the search engine would be... well, like in Knoll : it is impossible to find anything. We have not looked at technics about pages protection, for the moment this is based on admins control, so it is not a question, more a remark on how an encyclopedia can benefit from some CMS abilities.
They could make them on the user namespace. Eg. [[User:Foo/Page title]] (or create a specific namespace 'Personal') Search can then filter to exclude that namespace.
Yes, I tought about this too, does it provides possibility to restrict thoose pages editions specificly to user that own this namespace ?
2009/7/9 Platonides Platonides@gmail.com
Thibaut DEVERAUX escribió:
Wich would be interesting would be to make like in Knol: possibility of having signed pages : ie with the title : "Page Tilte (Name of the
owner)".
We are using it at Design Platform because this is a way to encourage participation and for the user, to filter wich pages are synthesis
content
and wich are personal stories from autors (well, we host stories also, that's the point), all the deal is with the search engine : user sould
have
the possibility to exclude thoose pages. If not the results in the search engine would be... well, like in Knoll : it is impossible to find
anything.
We have not looked at technics about pages protection, for the moment
this
is based on admins control, so it is not a question, more a remark on how
an
encyclopedia can benefit from some CMS abilities.
They could make them on the user namespace. Eg. [[User:Foo/Page title]] (or create a specific namespace 'Personal') Search can then filter to exclude that namespace.
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Well, finally, I have use this extension: http://www.mediawiki.org/wiki/Extension:Restrict_access_by_category_and_grou p
Work fine for me...
Thanks for all your comments!
Pierre
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Thibaut DEVERAUX Sent: Friday, July 10, 2009 6:10 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Restrict access to a specific category
Yes, I tought about this too, does it provides possibility to restrict thoose pages editions specificly to user that own this namespace ?
2009/7/9 Platonides Platonides@gmail.com
Thibaut DEVERAUX escribió:
Wich would be interesting would be to make like in Knol: possibility of having signed pages : ie with the title : "Page Tilte (Name of the
owner)".
We are using it at Design Platform because this is a way to encourage participation and for the user, to filter wich pages are synthesis
content
and wich are personal stories from autors (well, we host stories also, that's the point), all the deal is with the search engine : user sould
have
the possibility to exclude thoose pages. If not the results in the
search
engine would be... well, like in Knoll : it is impossible to find
anything.
We have not looked at technics about pages protection, for the moment
this
is based on admins control, so it is not a question, more a remark on
how
an
encyclopedia can benefit from some CMS abilities.
They could make them on the user namespace. Eg. [[User:Foo/Page title]] (or create a specific namespace 'Personal') Search can then filter to exclude that namespace.
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
Lyndie Chiou wrote:
After much finagling I ran the update script (I don't have command-line access so I had to set up a cron job). My wiki works again! Thanks for the tip - I guess I have to run the update script from now on instead of re-installing.
Lyndie
Updating is done by replacing the old files with the new ones (don't remove uploaded files or extensions in the process) and running update.php
Rerunning the installer can usually substitute running update.php though. Something failed in your case.
mediawiki-l@lists.wikimedia.org