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(a)wikimini.org>
To: <mediawiki-l(a)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(a)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