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