Sponsored

  • Google Play warning: Your app contains a SQL Injection issue
    by Djura Brunet on 25. June 2018. at 07:49

    If you get Google Play warning on your Google Play Developer Console, than maybe there is simple solution. In your AndroidManifest.xml file just set :<provider        android:exported="false"/>and than recompile project, rebuild APK, and reupload new version to Google Play Developer Console. […]

  • FreshRSS: Delete duplicate entries by title
    by Djura Brunet on 18. June 2018. at 16:25

    If you have duplicate entries in your FreshRSS database, here is method for delete duplicate entries by title via phpMyAdmin:Next SQL statement SELECT ALL duplicate entries by title:SELECT * FROM `freshrss_slpadmin_entry` AS a INNER JOIN (   SELECT title     FROM `freshrss_slpadmin_entry`     GROUP BY title   HAVING COUNT( * ) > 1 ) AS b ON b.title = a.titleORDER BY a.titleNext SQL statement SELECT duplicate entries by title with higher id:SELECT * FROM `freshrss_slpadmin_entry` AS a INNER JOIN (   SELECT title, MIN(id) AS min_id     FROM `freshrss_slpadmin_entry`     GROUP BY title   HAVING COUNT( * ) > 1 ) AS b ON b.title = a.titleAND b.min_id <> a.idORDER BY a.titleNext SQL statement DELETE duplicate entries by title with DIFFERENT id:DELETE a.* FROM `freshrss_slpadmin_entry` AS a INNER JOIN (   SELECT title, MIN(id) AS min_id     FROM `freshrss_slpadmin_entry`     GROUP BY title   HAVING COUNT( * ) > 1 ) AS b ON b.title = a.titleAND b.min_id <> a.id&nbs […]

  • Wordpress SQL cleanup database for duplicate and old data
    by Djura Brunet on 14. June 2018. at 13:11

    If you want to cleanup your Wordpress database for some duplicate and old data there is SQL commands to do it via phpMyAdmin :This SQL command will DELETE data for month condition :DELETE FROM `wp_posts` WHERE `post_type` = "attachment" AND post_modified LIKE '2018-04-%'DELETE FROM `wp_posts` WHERE `post_type` = "post" AND post_modified LIKE '2018-04-%'This SQL command will SELECT data with duplicate title :SELECT a.ID, a.post_title, a.post_type, a.post_statusFROM wp_posts AS a INNER JOIN (   SELECT post_title, MIN( id ) AS min_id   FROM wp_posts   WHERE post_type = 'post'   AND post_status = 'publish'   GROUP BY post_title   HAVING COUNT( * ) > 1 ) AS b ON b.post_title = a.post_titleAND b.min_id <> a.idAND a.post_type = 'post'AND a.post_status = 'publish'This SQL command will DELETE data with duplicate title :DELETE a.*FROM wp_posts AS a   INNER JOIN (      SELECT post_title, MIN( id ) AS min_id      FROM wp_posts      WHERE post_type = 'post'      AND post_status = 'publish'      GROUP BY post_title      HAVING COUNT( * ) > 1   ) AS b ON b.post_title = a.post_titleAND b.min_id <> a.idAND a.post_type = 'post'AND a.post_status = 'publish'This SQL command will DELETE Trash data:DELETE wp_posts,wp_term_relationships,wp_postmeta,wp_term_taxonomy FROM wp_posts LEFT JOIN wp_term_relationships ON ( wp_posts.ID = wp_term_relationships.object_id ) LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_term_taxonomy ON ( wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id ) WHERE wp_posts.post_status='trash'This SQL command will DELETE orphaned postmeta data:DELETE pmFROM wp_postmeta pmLEFT JOIN wp_posts wp ON wp.ID = pm.post_idWHERE wp.ID IS NULLThis SQL command will DELETE orphaned relation data:DELETE wp_term_relationships FROM wp_term_relationshipsLEFT JOIN wp_posts ON wp_term_relationships.object_id = wp_posts.IDWHERE wp_posts.ID is NULL;After that do Optimize of all table throw phpmyadmin.Off course, backup your data, before this commands. […]

  • How to unbrick HTC Desire 526G - SP Flash Tool method (fastboot mode)
    by Djura Brunet on 11. April 2018. at 16:41

    Follow the next steps:1. Get SP flash tools (Latest version)2. Download your phone's firmware (from manufacturer site or needrom.com etc) and extract it.3. install Mediatek Preloader drivers as per your OS version (win x7 , 8 10 etc) and architecture (32/64bit).4. Run Flash tools with admin as administrator5. select the scatter file from the firmware folder you downloaded and wait for it to load. (Do not connect your phone yet and leave the battery inserted)6. Select Download Only7. Hit the download button8. Now plug in the micro/type C usb end of your cable to your phone but dont plug to PC. yet9. While hold down both volume buttons i.e up and down buttons, (Do not press the power button), Insert the Usb cable end to your PCs usb port (Please choose a port thats very reliable).10. After a while, P Flash tool will begin to upgrade your phone, dont release the buttons yet, let it lapse about 2mins then release them, the firmware upgrade will still continue and it will display a tick pop-up when done (this may take between 5-10mins).Now unplug your phone, remove and re-insert the battery and power-up your phone. You phone is now unbricked.Note that the first boot will longer than a regular boot.Source: XDA Forum […]

  • Error on installing Windows 10 Update 1709
    by Djura Brunet on 23. January 2018. at 06:51

    If you get error message from Windows Update : ”We couldn’t update system reserved partition” in a new window then:* Search for cmd. Press-and-hold or right-click on Command Prompt in the results, and select Run as administrator.* At the command prompt, type mountvol y: /s and then hit Enter. This will add the Y: drive letter to access the System Partition.* Switch to the Y drive by typing Y: and press Enter.* Then, navigate to the Fonts folder by typing cd EFI\Microsoft\Boot\Fonts.* Once there, type del *.* to delete font files. The system may ask you if you are sure to continue, press Y and then Enter to continue.Now, restart update procedure and it will be OK. […]

Copyright © 1998.-2018. Software Laboratory Professional