I accidently stepped on a block which triggered infinite slowness 5 and I cant get rid of it. Milk doesn't work,   /effect @p 2 0 or /effect @p clear    doesn't work either.  How can I get rid of this? I tried shutting down Minecraft but it was still no good. It's really bugging me since I'm trying to create an adventure map. Any help? Also if you can help but need to know how this happened, here's the command:  /execute @a ~ ~ ~ detect ~ ~-1 ~ minecraft:wool 15 effect @a slowness 1000000 5   [Edit] I've found that if I keep activating a command block with the command:     /effect player(BruhTemmieLlama2) 2 0   The potion effect would disappear for a second.  [Edit2] I found a temporary solution.  If I spammed a lever attached to a command block with the command a few lines up, the effect would go away. So I turned the command block purple by turning on options "Repeat" and  "Always Active" and the effect would disappear. But if i removed the command from the command block, the effect would come back. I'd still like to know a way to permantly be rid of these effects. Thx pals!
I've placed a command block making it day all the time. I want to turn it off, but I've lost it. What's the quickest way to find it?
mysqldump, preserve update_time and modify_time attributes as listed by show table status from Does mysqldump preserve the create_time and update_time attributes that are output by show table status from?  If not, is there an option that does this?   it looks like mysqldump preserves this data if you export to XML. EDIT: Well the data is included in the export. Whether it's read in at the other end I'm not sure.  Is there a way to do this with a normal .sql dump? Why is "bicycle" pronounced differently from other obviously related words? In non-relativistic QM, the $\Delta E$ in the time-energy uncertainty principle is the limiting standard deviation of the set of energy measurements of $n$ identically prepared systems as $n$ goes to infinity. What does the $\Delta t$ mean, since $t$ is not even an observable? Creating additional Virtual Host Ubuntu Server When clicking between "Week", "Month", "Quarter", "Year" and "All" on the users page, the name I have typed in to filter on disappears. I feel like it should stay there, so that I can type in my name, and see how I've done in a week/month/etc. I get double question marks when referring to labels inside figures I have some charts embedded in figures, and I want to be able to refer to them easily using the "Figure x" notation. I'm doing it like this (in this order):  \documentclass[12pt,letterpaper]{article}  ...  \section*{Results} ...we performed a linear regression to obtain a standard curve  (Figure~\ref{0:stdcurve})....  \pagebreak \section*{Results (Graphs)} \subsection*{Construction of Standard Graph for PNP} \begin{figure}[h]   % Figure 1     \centering     \includegraphics[scale=1]{kinematics-res/graph0-1}     \caption{The standard curve for PNP.}     \label{0:stdcurve} \end{figure}   However, instead of getting the output "...to obtain a standard curve (Figure 1)...", I just get "...to obtain a standard curve (Figure ??)..."  I also noticed that the PDFLaTeX compiler is generating warnings saying that it couldn't find the reference of the name 0:stdcurve. Why am I getting these warnings? What order should Asimov's Foundation series be read in? See these three pages:          All three of them say:     Earned at least X total score for at least 20 answers in the  tag.   This same text also appears on the tooltip for the tag badge:   Also note the double colon after 'gold badge'  As well as on these pages:          But the  clearly states:        Bronze Badge:  You must have a total score of 100 in at least 20 non-community wiki answers to achieve this badge.   Silver Badge: You must have a total score of 400 in at least 80 non-community wiki answers to achieve this badge.   Gold Badge: You must have a total score of 1000 in at least 200 non-community wiki answers to achieve this badge.        Edit:  It has been noted in the comments that other users see different numbers in these pages, but in all cases it appears they see the same number of answers are required for all tag badge description, regardless of the badge's type. Contribute to bounty? How does extra damage work for critical hits? rand() returns same values when called within a single function Prove by mathematical induction that $2n ≤ 2^n$, for all integer $n≥1$? I need to prove  $2n \leq 2^n$, for all integer $n≥1$ by mathematical induction?  This is how I prove this:  Prove:$2n ≤ 2^n$, for all integer $n≥1$  Proof: $2+4+6+...+2n=2^n$  $i.)$ Let $P(n)=1         P(1): 2(1)=2^1\implies 2=2$.        Hence, $P(1)$ is true.  $ii.)$  Assume that $P(n)$ is true for $n=k$, i.e, $2+4+6+...+2k=2^k$, and prove that $P(n)$ is also true for $n=k+1$, i.e, $2+4+6...+2(k+1)=2^{(k+1)}$  from the assumption add $2(k+1)$ on both sides so we have   $2+4+6...2k+2(k+1)=2^k+2(k+1)$  I'm confused with $2^k+2(k+1)$, I don't know how to make $2^k$ be equivalent to $2^{k+1}$.  I feel i'm doing something wrong.   Any help would be appreciated! I have some section where user can upload CV and profile images,  I'm using the native attachment functions,  $attachment_cv_id = media_handle_upload( 'candidate_cv', 0 ); if ( ! is_wp_error( $attachment_cv_id ) ) {     // We link this file to the post      // add_post_meta( $result , 'wpcf-cv-file', wp_get_attachment_url($attachment_cv_id)); } else {     $submit_candidate_errors[] = lang("Hubo error subiendo la CV"); }   Is there any way I can hide this files from the media section in the wp-admin? ( perhaps changing its folder )  Thanks  -EDIT-  i'm trying like Dave suggested, adding a meta: 'rrhh-file'  $attachment_id = media_handle_upload( 'apply_file', 0 );  if ( ! is_wp_error( $attachment_id ) ) {     // The image was uploaded successfully!     add_post_meta($attachment_id, 'rrhh-file', true); }   And even that it has the attribute:  var_dump(get_post_meta(1200)); // last id I uploaded die();   Prints out:  array(4) {   ["_wp_attached_file"]=&gt;   array(1) {     [0]=&gt;     string(20) "2017/06/image001.jpg"   }   ["_wp_attachment_metadata"]=&gt;   array(1) {     [0]=&gt;     string(666) "a:5:{s:5:"width";i:523;s:6:"height";i:122;s:4:"file";s:20:"2017/06/image001.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:4:{s:4:"file";s:20:"image001-150x122.jpg";s:5:"width";i:150;s:6:"height";i:122;s:9:"mime-type";s:10:"image/jpeg";}s:6:"medium";a:4:{s:4:"file";s:19:"image001-300x70.jpg";s:5:"width";i:300;s:6:"height";i:70;s:9:"mime-type";s:10:"image/jpeg";}}s:10:"image_meta";a:12:{s:8:"aperture";s:1:"0";s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";s:1:"0";s:9:"copyright";s:0:"";s:12:"focal_length";s:1:"0";s:3:"iso";s:1:"0";s:13:"shutter_speed";s:1:"0";s:5:"title";s:0:"";s:11:"orientation";s:1:"1";s:8:"keywords";a:0:{}}}"   }   ["rrhh-file"]=&gt; // &lt;-- here   array(1) {     [0]=&gt;     string(1) "1"   }   ["_edit_lock"]=&gt;   array(1) {     [0]=&gt;     string(12) "1498731595:1"   } }   With this action this attachment still shows up in the media library  add_action( 'pre_get_posts', 'wpse_hide_cv_media_list_view' ); function wpse_hide_cv_media_list_view( $query ) {     // Bail if this is not the admin area.     if ( ! is_admin() ) {         return;     }      // Bail if this is not the main query.     if ( ! $query-&gt;is_main_query() ) {         return;     }      // Only proceed if this the attachment upload screen.     $screen = get_current_screen();     if ( ! $screen || 'upload' !== $screen-&gt;id || 'attachment' !== $screen-&gt;post_type ) {         return;     }      // Modify the query.     $query-&gt;set( 'meta_query', [         [             'key'     =&gt; 'rrhh-file',             'compare' =&gt; 'NOT EXISTS',         ]     ]);      return; }   Any idea what i'm missing? Render looks darker than Look Dev mode In Windows Vista, I have tried to set the setting 'the following number of lines at a time' to zero. I assumed my scroll wheel would not scroll anymore. But it still works.  I'm trying to disable the wheel because my RSI complaints worsen when using the scroll wheel often.  Does anyone have an idea on how to achieve this? I will be arriving in Mumbai Terminal T2 on a Turkish Airlines international flight. I have a separately-purchased IndiGo ticket 5 hours later from Terminal 1B (Domestic). In the past I heard of a free bus to transfer.    Is that still the case and if not how do I get to Terminal 1B from Terminal 2? Can I install Microsoft Office? If so, how? I want to know how to install Microsoft Office (specifically, Microsoft Office 2010) in Ubuntu?   I am a die hard fan of MS Office and I want to know if there is a way I can use it in Ubuntu. Why should I use a private variable in a property accessor? Books on Number Theory for anyone who loves Mathematics?(Beginner to Advanced &amp; just for someone who has a basic grasp of math) For a continuous function $f$ show $\exists c\in (0,1)$ s.t $f(c)=3c^2$ Let $f: [0,1] \to \mathbb{R}$ be a continuous function such that $$\int_0^1 f (t) dt =1 .$$ Show that there exists a point $c \in (0,1)$ such that $ f(c)=3c^2$.  I tried using mean value theorem of integrals on $f (x)$, so $$\int_0^1 f (t) dt = f (c) =1,$$ but it should be $3 c^2$. What is going wrong?