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