WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-153678-659.MAI' (Errcode: 28 "No space left on device")]
SELECT p.*, o.option_value, GROUP_CONCAT(DISTINCT CONCAT(m.meta_key, "::", m.meta_value) separator "::::") as seo_meta, t.slug, tr.language_code as language FROM wp_posts p JOIN wp_postmeta m ON p.ID = m.post_id JOIN wp_options o ON o.option_name = "siteurl" JOIN wp_term_relationships r ON r.object_id = p.ID JOIN wp_term_taxonomy x ON x.term_taxonomy_id = r.term_taxonomy_id JOIN wp_terms t ON t.term_id = x.term_id JOIN wp_icl_translations tr ON p.ID = tr.element_id WHERE post_type = "page" AND post_status = "publish" AND tr.language_code = 'en' AND t.slug IN ('jquery') AND x.taxonomy = "page_cat" AND tr.element_type = "post_page" AND meta_key IN ("_yoast_wpseo_title", "_yoast_wpseo_metadesc") GROUP BY p.ID

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-153678-65a.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

Setting teh style for error returns and success returns

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-153678-65b.MAI' (Errcode: 28 "No space left on device")]
SELECT p.* FROM wp_mdb_forum_posts AS p LEFT JOIN wp_mdb_forum_posts AS q ON( q.Id = p.ParentId AND p.Id = q.AcceptedAnswerId ) WHERE p.PostTypeId = 2 AND p.ParentId = 58681 GROUP BY p.Id ORDER BY CASE WHEN q.Id IS NOT NULL THEN 1 ELSE 0 END DESC, p.UpvoteCount DESC, p.CreationDate ASC


Topic: Setting teh style for error returns and success returns

tommyhutcheson asked 7 years ago

https://mdbootstrap.com/components/bootstrap-contact-form/ Hello what is the best way to set different styles for successful php returns and error returns.   <a class="btn btn-primary" onclick="validateForm()">Send</a> <div class="alert hide" role="alert hide"> <div class="status" id="status"></div> </div> .errorCSS { background-color: red; } .successCSS { color: #004085; background-color: #cce5ff; border-color: #b8daff; }     function validateForm() { $.ajax({ url : "register.php", type: "POST", data :$('#registration-form').serialize(), success: function(data, textStatus, jqXHR) { $('#status').text(data.message).addClass('successCSS'); if (data.code) //If mail was sent successfully, reset the form. $('#registration-form').closest('form').find("input[type=text], textarea").val(""); }, error: function (jqXHR, textStatus, errorThrown) { $('#status').text(jqXHR).addClass('errorCSS'); } }); }   <?php $firstname = $_POST['firstname']; $surname = $_POST['surname']; $email = $_POST['email']; header('Content-Type: application/json'); if ($firstname === ''){ print json_encode(array('message' => 'firstname cannot be empty', 'code' => 0)); exit(); } if ($surname === ''){ print json_encode(array('message' => 'Surname cannot be empty', 'code' => 0)); exit(); } if ($email === ''){ print json_encode(array('message' => 'Email cannot be empty', 'code' => 0)); exit(); } else { if (!filter_var($email, FILTER_VALIDATE_EMAIL)){ print json_encode(array('message' => 'Email format invalid.', 'code' => 0)); exit(); } } $content="Email: $email nMessage: $message"; $recipient = "@gmail.com"; $mailheader = "From: $email rn"; mail($recipient, $subject, $content, $mailheader) or die("Error!"); print json_encode(array('message' => 'Registration successful !', 'code' => 1)); exit(); ?>  

Bartłomiej Malanowski staff pro premium commented 7 years ago

You can prepare two versions of the output message and use suitable version basing on the response code

Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.

Status

Open

Specification of the issue
  • User: Free
  • Premium support: No
  • Technology: MDB jQuery
  • MDB Version: -
  • Device: -
  • Browser: -
  • OS: -
  • Provided sample code: No
  • Provided link: No