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

mdb-file upload - How to remove existing images on server - Material Design for Bootstrap

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-614e93-10.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-614e93-11.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

mdb-file upload - How to remove existing images on server

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-614e93-12.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 = 103817 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: mdb-file upload - How to remove existing images on server

Maurizio Maimeri asked 6 years ago

Hello, i'm using MDB-file upload plugin in edit mode, i.e. I want to give the possibility to the user to change or remove the existing images stored on the server.

I use the "data-default-file" to show the existing image but I want that, once I press the "delete" button, a special value, for example "deleted image", would be inserted in the relevant input value in order to execute a deleting procedure server-side when I submit the form (I make use of php as server-side language and I read the values of $_FILE[] variable)

Has anyone suggestions for this issue?

thanks a lot!


Arkadiusz Cacko commented 6 years ago

Hi @Maurizio Maimeri Please try this short example (first answer)https://stackoverflow.com/questions/15005899/delete-image-from-folder-php. I hope this helps, but please let me know if you need anything else. Regards Arek


Maurizio Maimeri commented 6 years ago

Dear [@Arkadiusz Cacko thank you very much for your kind reply. I found it useful and also in other existing groups I found out something similar. I think that using the "hidden" input is the best solution to adopt!

Regards Maurizio


Please insert min. 20 characters.

FREE CONSULTATION

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

Status

Resolved

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

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

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