SoftLabPro

Google Calendar Event Flair Solution

2018-10-27T11:42:00.000+02:00

With the new update of the google calendar, event flairs gadget that were a side gadget have been deprecated. ☹

A quick solution I discovered is that my MS Windows 10 has a virtual keyboard with emoji built in.

I pull up this keyboard and just ad the emoji in Event Title box, that fits my need.

For now, this works perfectly.

Hope this helps others!

How to clean flash (update) Liquid Remix ROM on Xiaomi Mi A1

2018-10-20T17:48:00.000+02:00

Clean Flash (1st setup):

1. Download the ROM and GApps
2. Move your ROM.zip + GApps + TWRP-Installer.zip to your internal storage
3. Advanced Wipe
4. Boot into TWRP linked above
5. Wipe System,Data & Cache
6. Flash the ROM zip and the TWRP-Installer.zip
7. Reboot to Recovery via TWRP (Reboot -> Recovery) ,
8. Flash GApps and Magisk
9. Reboot to System
10. Enjoy Liquid!

Dirty Flash (Update) :

1. Download the ROM and GApps
2. Move your ROM.zip + GApps + TWRP-Installer.zip to your internal storage
3. Advanced Wipe
4. Boot into TWRP linked above
5. Wipe Cache
6. Flash the ROM zip and the TWRP-Installer.zip
7. Reboot to Recovery via TWRP (Reboot -> Recovery) ,
8. Flash GApps and Magisk
9. Reboot to System
10. Enjoy Liquid!

LiquidRemix Pie rom on Xiaomi Mi A1 with Stock GApps and Google Camera

2018-10-17T14:37:00.002+02:00

If you want to successfully flash your Xiaomi Mi A1 with LiquidRemix Pie rom, with GApps ARM64 9.0 Stock edition and Google Camera, then follow this procedure:

- After flashing XDA flash procedure and first bootup, disable and root uninstall preinstalled Google Camera.
- Then with Magisk Manager install Google_Cam_Fix_for_LineageOS_v1.0 module and restart phone
- Now you could install GoogleCamera-Pixel2Mod-Arnova8G2-V8.2.apk successfully.
- And finally, you could install Pixel 3 Wallpapers (com.breel.wallpapers18_9.apk).
- After that, everything is like Pixel Expirience with most customisation from this great rom, like Double Tap to Sleep, Double Tap to Wake, Google Assistent e.t.c. ;)

P.S. from XDA: You can use GApps Aroma edition. It allows you to modify the package before flash, so you don't have to uninstall gcam from gapps package and also uncheck any other gapps pre-installed you didn't want to shrink system size.

How to flash Pixel Expirience 9.0 on Xiaomi Mi A1

2018-10-16T14:06:00.000+02:00

Pixel Experience is an AOSP based ROM, with Google apps included and all Pixel goodies (launcher, wallpapers, icons, fonts, bootanimation).

To flash this rom follow these steps:

1. Be sure to remove any PIN, Password, Fingerprint protection

2. Install ADB Tools and Drivers on your PC.

2. Unlock Bootloader if not already done.

- Power Off the phone by using the Power key at first.
- Press and hold the Volume Down + Power button for a couple of seconds to enter Fastboot mode
- You can release held keys when the Fastboot Mode appears on the phone's screen.
- In ADB folder Terminal type : fastboot oem unlock

3. Reflash stock 8.1, if you are not already on it, with Mi Flash Tool.

4. Boot in to TWRP with Terminal command : fastboot boot recovery.img

- Then choose Format data and reboot bootloader with same command:
- fastboot boot recovery.img

5. After boot TWRP again choose to Wipe System, Data and Dalvik Cache.

6. Put rom, twrp and magisk on your phone internal storage with thise commands:

- adb push PixelExperience_tissot-9.0-20181012-0716-UNOFFICIAL.zip /sdcard
- adb push twrp-installer-tissot--3.2.3-0.zip /sdcard
- adb push Magisk-v17.1.zip /sdcard
- adb push MagiskManager-v6.0.0.apk /sdcard

7. Than flash the ROM, and after that flash TWRP installer.

8. Now Reboot to Recovery.

9. Flash Magisk (Optional)

10. Reboot system. Than you go with first boot and automatic restart.

11. After first boot and setup, install Magisk Manager if it does not appear.
(Only if you installed Magisk)

12. Profit!

How to restore GRUB loader after Windows 10 Update

2018-10-03T20:29:00.000+02:00

If you just updated your Windows 10 in a multiboot configuration, and Grub no longer appeared, than just had to run in Windows Command Prompt as administrator, next command:

bcdedit /set {bootmgr} path \EFI\ubuntu\grubx64.efi

and your Grub boot menu should appear in next reboot.

Automatic Install nVidia drivers in Ubuntu

2018-09-20T08:08:00.000+02:00

The first method is the easiest to perform and in most cases it is the recommended approach. First, detect the model of your nvidia graphic card and the recommended driver. To do so execute:

$ ubuntu-drivers devices
== /sys/devices/pci0000:00/0000:00:01.0/0000:01:00.0 ==
modalias : pci:v000010DEd00001180sv00001458sd0000353Cbc03sc00i00
vendor   : NVIDIA Corporation
model    : GK104 [GeForce GTX 680]
driver   : nvidia-304 - distro non-free
driver   : nvidia-340 - distro non-free
driver   : nvidia-384 - distro non-free recommended
driver   : xserver-xorg-video-nouveau - distro free builtin

== cpu-microcode.py ==
driver   : intel-microcode - distro free

If you agree with the recommendation feel free to use ubuntu-drivers command again to install all recommended drivers:

$ sudo ubuntu-drivers autoinstall

Once the installation is concluded, reboot your system and you are done.

Start Android Studio in Ubuntu with root privileges

2018-09-19T14:42:00.001+02:00

If you have to start Android Studio in Ubuntu with root privileges for regular updates, you should make these commands in terminal:

sudo ln -s /opt/android-studio/bin/studio.sh /usr/local/bin/studio
sudo chmod 777 /usr/local/bin/studio

If you have problem with sudo in Ubuntu you can setup root password with command:

sudo passwd root

Now you can start android studio from anywhere by entering command : studio

Wordpress: Update default page layout for all posts

2018-09-11T10:38:00.000+02:00

To update default page layout for all posts, we need to do it in database table wp_postmeta for all post_id's, with next command:

INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID, "mom_page_layout", "right-sidebar" FROM wp_posts WHERE post_type = "post" AND post_status = "publish"

After that, all published posts will have desired page layout.

This is also available for event pages, with command :

INSERT INTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID, "mom_page_layout", "right-sidebar" FROM wp_posts WHERE post_type = "event" AND post_status = "publish"

Relocate Android Studio SDK and Emulator files

2018-09-06T20:03:00.001+02:00

If you want to relocate your Android Studio SDK and Emulator files to different folder or disc, than you have to setup these environment variables :

ANDROID_SDK_HOME - D:\Android
ANDROID_EMULATOR_HOME - D:\Android\.android\
ANDROID_AVD_HOME - D:\Android\.android\avd\

After these setup variables, your Android Studio will use these folders.

Android SQL Injection Vulnerability with exported=false

2018-09-04T15:31:00.002+02:00

So here's the problem: when I add the widget to the homescreen, a SecurityException is immediately thrown inside the onDataSetChanged() method when I try to query the provider. This appears to be because the homescreen does not hold the permission to read my content provider.

Because of Google Play Developer Console witch refuse App Submission because of SQL Injection Vulnerability with exported=false in AndroidManifest.xml, we need to leave that option to false.

While the context is actually correct, it is bound to the wrong process.

So we need to enclose our query in clearing Identiry Token in WidgetService.java:

// Revert back to our process' identity so we can work with our
// content provider
final long identityToken = Binder.clearCallingIdentity();

mCursor = cr.query(EntryColumns.ALL_ENTRIES_CONTENT_URI, new String[]{EntryColumns.TITLE, EntryColumns._ID, FeedData.FeedColumns.ICON}, selection.toString(), null, EntryColumns.DATE + Constants.DB_DESC);

// Restore the identity - not sure if it's needed since we're going
// to return right here, but it just *seems* cleaner
Binder.restoreCallingIdentity(identityToken);

This solves the problem, even without setting read/write permissions on the contentprovider, just using it with exported set to "false".

Google Play warning: Your app contains a SQL Injection issue

2018-06-25T09:49:00.001+02:00

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

2018-06-18T18:25:00.002+02:00

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.title
ORDER BY a.title

Next 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.title
AND b.min_id <> a.id
ORDER BY a.title

Next 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.title
AND b.min_id <> a.id

Wordpress SQL cleanup database for duplicate and old data

2018-06-14T15:11:00.002+02:00

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_status
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_title
AND b.min_id <> a.id
AND 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_title

AND b.min_id <> a.id

AND 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 pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL

This SQL command will DELETE orphaned relation data:

DELETE wp_term_relationships FROM wp_term_relationships
LEFT JOIN wp_posts ON wp_term_relationships.object_id = wp_posts.ID
WHERE 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)

2018-04-11T18:41:00.001+02:00

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 administrator
5. 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 Only
7. Hit the download button
8. Now plug in the micro/type C usb end of your cable to your phone but dont plug to PC. yet
9. 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

2018-01-23T07:51:00.001+01:00

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.

MS Windows 10 cannot see Network Computers after Update 1709

2018-01-17T10:36:00.001+01:00

If you have problem with your Network Computers browsing with Windows Explorer after Windows 10 Update 1709 or similar, than this Update is probably removed SMB 1.0/CIFS File Sharing Support Windows feature, which removed Computer Browser Windows Service.

So, just Add complete SMB 1.0/CIFS File Sharing Support throw Add/Remove Windows Feature,
than your PC will be restared and Computer Browser service will be on list started again.

Now you will see all your Network Computers again.
Source: Microsoft Community Forum

Android Emulator does not Launch in Ubuntu 17.10

2017-12-01T22:05:00.000+01:00

I tried to run the Android Studio 3 emulator on fresh installed Ubuntu 17.10 to test an app I'm working on. And I got this error in Android Studio Event Log:

libGL error: unable to load driver: i965_dri.so
AVD Emulator: Process finished with exit code -1

Solution:
Type in Terminal:

$ cd ~/Android/Sdk/emulator/lib64/libstdc++
$ mv libstdc++.so.6 libstdc++.so.6.bak
$ ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 libstdc++.so.6

That's it!

Now my Android Studio 3 emulator is working again!

HP 850 G3 Grub Multiboot Ubuntu and Windows 10 on UEFI

2017-12-01T21:52:00.001+01:00

After I installed Microsoft Windows 10, and then alongside Ubuntu, with UEFI bootabled USB disks,
last setup (Ubuntu) created Grub configuration, which is listed in HP UEFI BIOS sequence, but after power on, system get Grub Bush command prompt, without listed operating systems, like Ubuntu, Windows e.t.c., unabled to boot.

Solution: In HP BIOS setup put in a 5 (or more) seconds delay in the "Boot Options" menu. Then, when you switch on your notebook, you'll have 5 (or more) seconds to choose "ubuntu" among the possible boot options (it should be the first one).

I think that those 5 seconds delay give HP enough time to recall all UEFI and other partitions and successfully recall Grub menu.

How to solve FreshRSS cron job - actualize_script.php file not found - error 404

2017-11-06T13:32:00.000+01:00

If you get - file not found - error 404 - after update FreshRSS,
- just change the actualize_script.php file permission to '0644' from your cPanel File Manager and script will be accessible from cron-job.org.
- and put .htaccess in same folder with these lines:

order deny,allow
Allow from all
Satisfy all

The Empire Strikes Back

2017-09-13T09:40:00.000+02:00

Apple Special Event 2017 was Live streamed only with Apple Safari and Microsoft Edge browsers.

Does that mean that all Google with Chrome and Linux with Mozilla Firefox population is dismissed ?

Android SDK emulator - GPU driver issues

2017-09-06T21:33:00.003+02:00

If you have an Intel HD Graphics running the Android SDK emulator in slow software mode, it's intended that a compatibility OpenGL renderer is not used.

I'm sorry about it, but we need to be able to switch to better-supported Intel GPU drivers especially when running high API levels (25+) of system images. Intel iGPUs of that generation (and older) have many issues with OpenGL compatibility.

You could try in terminal:

emulator -list-avds
emulator -avd <AVD_NAME> -gpu host

Source : Stackoverflow forum

but that is not permanent fix.

Real resolution to this problem is fine tune the Android emulator with next procedure:

If you'd still like to use the native OpenGL renderer on a Intel HD GPU (at your own risk), go to :

Settings (in Android emulator)
section: General

option: OpenGL ES renderer (requires restart)
select: ANGLE (D3D9)

option: OpenGL ES API level (requires restart)
select: Compatibility (OpenGL ES 1.1/2.0)

and restart your Android emulator in HAX fast virtual mode with hardware rendering...

Source: Google Issue Tracker - Discussion : GPU driver issue

Wordpress Newspaper 8.1 theme - Activation method

2017-09-01T12:11:00.003+02:00

First of all go this path /includes/wp_booster/td_cake.php.
Open td_cake.php file in any PHP editor.
Find

function td_cake_manual($s_id, $e_id, $t_id)
and change below code

if (md5($s_id . $e_id) == $t_id) {
return true;
} else {
return false;
}

with

if (md5($s_id . $e_id) == $t_id) {
return true;
} else {
return true;
}

Then open includes/wp_booster/td_ajax.php
on line 891 replace: return false; with return true;

Then go to theme panel go to Activate theme, click Activate the theme manually (at the bottom (footer)) use any code and key without any error.

LG G2 D802 - How to increase volume level in Lineage OS

2017-08-31T22:12:00.000+02:00

You can just turn up the volume by changing the standard volume using the standard CM File Manager in root mode or with adb terminal :

Open terminal and send:

adb root
adb pull /system/etc/mixer_paths.xml

edit the file with your favorite editor like this:

<path name="speaker">
...
<ctl name="RX7 Digital Volume" value="69" />
</path>

go back in your terminal and send:

adb remount
adb push mixer_paths.xml /system/etc/mixer_paths.xml

Just change, save, reboot and test.

This worked great for me.

Changed the speaker volume as well as the in-call as well.

LG G2 D802 - How to update LineageOS Nightly

2017-08-29T13:04:00.000+02:00

To update LG G2 D802 mobile phone with Lineage OS Nightly ROM, before complete procedure, you should also download these files:

Restart your phone into TWRP Recovery mode.

Install lineage-14.1-20170814-nightly-d802-signed.zip
Wipe Dalvik Cache
Install open_gapps-arm-7.1-nano-20170818.zip
Install addonsu
Choose : Restart

Wait patiently on this next boot and you are on fresh nightly rom...

Lineage OS Nightly - How to fix Google Play services force close

2017-08-29T08:27:00.002+02:00

This error of Google Play services occurs due to improper Google Webview implementation or if there is not Google web view installed in your device.

So now that we know the problem due to which Google Play services occur, we can fix this error by enabling or reinstalling the Google Web view application.

Mute Force Close window
Install Android System WebView from Google Play
Go to Settings, in About Phone, press Build Number, until it appears that you are a developer.
Back to settings, in Developer Options, go to WebView Implementation and select “Google WebView.”

Restart your phone and that error should be fixed.