Hi,
Sorry for the "urgent" nature of my question but I have a problem on a production wiki.
I need to erase all exisiting user options and replace them with the following ones:
"quickbar=1 underline=0 cols=4 rows=4 searchlimit=20 contextlines=5 contextchars=50 skin= math=1 rcdays=1 rclimit=50 wllimit=250 highlightbroken=0 stubthreshold=0 previewontop=0 editsection=0 editsectiononrightclick=0 showtoc=0 showtoolbar=0 date=default imagesize=0 thumbsize=0 rememberpassword=0 enotifwatchlistpages=0 enotifusertalkpages=1 enotifminoredits=0 enotifrevealaddr=0 shownumberswatching=0 fancysig=0 externaleditor=0 externaldiff=0 showjumplinks=0 numberheadings=0 uselivepreview=0 watchlistdays=3 variant= language=fr searchNs0=0 nickname=Admin timecorrection=02:00 searchNs1=0 searchNs2=0 searchNs3=0 searchNs4=0 searchNs5=0 searchNs6=0 searchNs7=0 searchNs8=0 searchNs9=0 searchNs10=0 searchNs11=0 searchNs12=0 searchNs13=0 searchNs14=0 searchNs15=0 disablemail=1 justify=0 hideminor=0 extendwatchlist=0 usenewrc=0 editondblclick=0 editwidth=0 watchcreations=0 watchdefault=0 watchmoves=0 watchdeletion=0 minordefault=0 previewonfirst=0 nocache=0 forceeditsummary=0 watchlisthideown=0 watchlisthidebots=0 watchlisthideminor=0 ccmeonemails=0 diffonly=0 riched_disable=0 riched_disable_ns_main=0 riched_disable_ns_talk=0 riched_disable_ns_user=0 riched_disable_ns_user_talk=0 riched_disable_ns_project=0 riched_disable_ns_project_talk=0 riched_disable_ns_image=0 riched_disable_ns_image_talk=0 riched_disable_ns_mediawiki=0 riched_disable_ns_mediawiki_talk=0 riched_disable_ns_template=0 riched_disable_ns_template_talk=0 riched_disable_ns_help=0 riched_disable_ns_help_talk=0 riched_disable_ns_category=0 riched_disable_ns_category_talk=0 ajaxsearch= searchNs90=0 searchNs91=0 searchNs92=0 searchNs93=0 lqt_sort_order=3 disablesuggest= showhiddencats=0"
The user-options field is a blob and I'm not sure what the correct sql command would be (I'm not a SQL guru). May I try something like:
UPDATE user SET user_options = "quickbar=1 underline=0 cols=4 rows=4 searchlimit=20 contextlines=5 contextchars=50 skin= math=1 rcdays=1 rclimit=50 wllimit=250 highlightbroken=0 stubthreshold=0 previewontop=0 editsection=0 editsectiononrightclick=0 showtoc=0 showtoolbar=0 date=default imagesize=0 thumbsize=0 rememberpassword=0 enotifwatchlistpages=0 enotifusertalkpages=1 enotifminoredits=0 enotifrevealaddr=0 shownumberswatching=0 fancysig=0 externaleditor=0 externaldiff=0 showjumplinks=0 numberheadings=0 uselivepreview=0 watchlistdays=3 variant= language=fr searchNs0=0 nickname=Admin timecorrection=02:00 searchNs1=0 searchNs2=0 searchNs3=0 searchNs4=0 searchNs5=0 searchNs6=0 searchNs7=0 searchNs8=0 searchNs9=0 searchNs10=0 searchNs11=0 searchNs12=0 searchNs13=0 searchNs14=0 searchNs15=0 disablemail=1 justify=0 hideminor=0 extendwatchlist=0 usenewrc=0 editondblclick=0 editwidth=0 watchcreations=0 watchdefault=0 watchmoves=0 watchdeletion=0 minordefault=0 previewonfirst=0 nocache=0 forceeditsummary=0 watchlisthideown=0 watchlisthidebots=0 watchlisthideminor=0 ccmeonemails=0 diffonly=0 riched_disable=0 riched_disable_ns_main=0 riched_disable_ns_talk=0 riched_disable_ns_user=0 riched_disable_ns_user_talk=0 riched_disable_ns_project=0 riched_disable_ns_project_talk=0 riched_disable_ns_image=0 riched_disable_ns_image_talk=0 riched_disable_ns_mediawiki=0 riched_disable_ns_mediawiki_talk=0 riched_disable_ns_template=0 riched_disable_ns_template_talk=0 riched_disable_ns_help=0 riched_disable_ns_help_talk=0 riched_disable_ns_category=0 riched_disable_ns_category_talk=0 ajaxsearch= searchNs90=0 searchNs91=0 searchNs92=0 searchNs93=0 lqt_sort_order=3 disablesuggest= showhiddencats=0"
?
Thank you very much for any advice.
Laurent
Hi Laurent, My prehistoric method with blob (if phpMyAdmin accessible on your server):
Export the table ('user') with SQL mode , but don't use hexadecimal for blob field (**) You get a file that is a text format .sql with all the informations ( structure, KEY, INSERT, IF NOT EXIST, etc) At this time the blob field is "translated" to text format (if you get no readable text, modify the case/choice for hexadecimal, like **)
So you can open that sql/txt file with true text processor like pspPad or NotePad+ Replace what you want in it , paying attention to format and semicolumn Reimporting/replace with SQL in the original table @+ de jfb "0.02$"
(normalement mon franglais doit être compréhensible par un autre franglais ;O)
----- Original Message ----- From: webmaster@wikimini.org To: mediawiki-l@lists.wikimedia.org Sent: Thursday, October 02, 2008 4:08 AM Subject: [Mediawiki-l] Urgent: Erase all user options preferences
Hi,
Sorry for the "urgent" nature of my question but I have a problem on a production wiki.
I need to erase all exisiting user options and replace them with the following ones:
"quickbar=1 underline=0 cols=4 rows=4 searchlimit=20 contextlines=5 contextchars=50 skin= math=1 rcdays=1 rclimit=50 wllimit=250 highlightbroken=0 stubthreshold=0 previewontop=0 editsection=0 editsectiononrightclick=0 showtoc=0 showtoolbar=0 date=default imagesize=0 thumbsize=0 rememberpassword=0 enotifwatchlistpages=0 enotifusertalkpages=1 enotifminoredits=0 enotifrevealaddr=0 shownumberswatching=0 fancysig=0 externaleditor=0 externaldiff=0 showjumplinks=0 numberheadings=0 uselivepreview=0 watchlistdays=3 variant= language=fr searchNs0=0 nickname=Admin timecorrection=02:00 searchNs1=0 searchNs2=0 searchNs3=0 searchNs4=0 searchNs5=0 searchNs6=0 searchNs7=0 searchNs8=0 searchNs9=0 searchNs10=0 searchNs11=0 searchNs12=0 searchNs13=0 searchNs14=0 searchNs15=0 disablemail=1 justify=0 hideminor=0 extendwatchlist=0 usenewrc=0 editondblclick=0 editwidth=0 watchcreations=0 watchdefault=0 watchmoves=0 watchdeletion=0 minordefault=0 previewonfirst=0 nocache=0 forceeditsummary=0 watchlisthideown=0 watchlisthidebots=0 watchlisthideminor=0 ccmeonemails=0 diffonly=0 riched_disable=0 riched_disable_ns_main=0 riched_disable_ns_talk=0 riched_disable_ns_user=0 riched_disable_ns_user_talk=0 riched_disable_ns_project=0 riched_disable_ns_project_talk=0 riched_disable_ns_image=0 riched_disable_ns_image_talk=0 riched_disable_ns_mediawiki=0 riched_disable_ns_mediawiki_talk=0 riched_disable_ns_template=0 riched_disable_ns_template_talk=0 riched_disable_ns_help=0 riched_disable_ns_help_talk=0 riched_disable_ns_category=0 riched_disable_ns_category_talk=0 ajaxsearch= searchNs90=0 searchNs91=0 searchNs92=0 searchNs93=0 lqt_sort_order=3 disablesuggest= showhiddencats=0"
The user-options field is a blob and I'm not sure what the correct sql command would be (I'm not a SQL guru). May I try something like:
UPDATE user SET user_options = "quickbar=1 underline=0 cols=4 rows=4 searchlimit=20 contextlines=5 contextchars=50 skin= math=1 rcdays=1 rclimit=50 wllimit=250 highlightbroken=0 stubthreshold=0 previewontop=0 editsection=0 editsectiononrightclick=0 showtoc=0 showtoolbar=0 date=default imagesize=0 thumbsize=0 rememberpassword=0 enotifwatchlistpages=0 enotifusertalkpages=1 enotifminoredits=0 enotifrevealaddr=0 shownumberswatching=0 fancysig=0 externaleditor=0 externaldiff=0 showjumplinks=0 numberheadings=0 uselivepreview=0 watchlistdays=3 variant= language=fr searchNs0=0 nickname=Admin timecorrection=02:00 searchNs1=0 searchNs2=0 searchNs3=0 searchNs4=0 searchNs5=0 searchNs6=0 searchNs7=0 searchNs8=0 searchNs9=0 searchNs10=0 searchNs11=0 searchNs12=0 searchNs13=0 searchNs14=0 searchNs15=0 disablemail=1 justify=0 hideminor=0 extendwatchlist=0 usenewrc=0 editondblclick=0 editwidth=0 watchcreations=0 watchdefault=0 watchmoves=0 watchdeletion=0 minordefault=0 previewonfirst=0 nocache=0 forceeditsummary=0 watchlisthideown=0 watchlisthidebots=0 watchlisthideminor=0 ccmeonemails=0 diffonly=0 riched_disable=0 riched_disable_ns_main=0 riched_disable_ns_talk=0 riched_disable_ns_user=0 riched_disable_ns_user_talk=0 riched_disable_ns_project=0 riched_disable_ns_project_talk=0 riched_disable_ns_image=0 riched_disable_ns_image_talk=0 riched_disable_ns_mediawiki=0 riched_disable_ns_mediawiki_talk=0 riched_disable_ns_template=0 riched_disable_ns_template_talk=0 riched_disable_ns_help=0 riched_disable_ns_help_talk=0 riched_disable_ns_category=0 riched_disable_ns_category_talk=0 ajaxsearch= searchNs90=0 searchNs91=0 searchNs92=0 searchNs93=0 lqt_sort_order=3 disablesuggest= showhiddencats=0"
?
Thank you very much for any advice.
Laurent
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Orange vous informe que cet e-mail a ete controle par l'anti-virus mail. Aucun virus connu a ce jour par nos services n'a ete detecte.
-- No virus found in this incoming message. Checked by AVG. Version: 7.5.526 / Virus Database: 270.7.5/1701 - Release Date: 30/09/2008 19:08
On Wed, Oct 1, 2008 at 10:08 PM, webmaster@wikimini.org wrote:
Hi,
Sorry for the "urgent" nature of my question but I have a problem on a production wiki.
I need to erase all exisiting user options and replace them with the following ones:
You can just run the userOptions.php maintenance script. Of course, you would have to run it quite a few times!
mediawiki-l@lists.wikimedia.org