怀疑问的发现：
Seems able to join another entity(table) by using reference below:
- SELECT P.C.attribute FROM Parent AS P;
- SELECT PCattribute FROM Parent AS P;
2020-12-29
2020-12-28
5.1 Bluetooth 1800 DPI Bluetooth Wireless Mute Slim Mouse For Ipad Android Tablet Laptop Smart Phones
5.1 Bluetooth 1800 DPI Bluetooth Wireless Mute Slim Mouse For Ipad Android Tablet Laptop Smart Phones
On: 20210115_pm023246
Suspect Windows updates causing mouse become weird.
Mouse pointer shaking itself.
Then Bluetooth disconnected.
Switching light red and blue, reconnected by unplug and replug battery, but mouse pointer still moving itself.
After a while/few seconds, Switching light red and blue again.
Replace battery then seems to be ok for now.
__________________________________________________
Ori image size: 8.33"
If you guys are looking for a bluetooth mouse, you can try to buy this.
https://shopee.com.my/product/55631460/5713472008
Less than RM 21 (included shipping as on 20201225_pm070207)
Quiet buttons, with quiet scroll.
Swift and even mouse bottom surface (compare with prolink mouse).
Required ONLY ONE AA battery, ONLY 1.
With an external battery, means no worry after the device's built-in battery dies.
Thin mouse build up, less tired if using thik mouse.
5.1 Bluetooth 1800 DPI Bluetooth Wireless Mute Slim Mouse For Ipad Android Tablet Laptop Smart Phones
2020-12-23
Review: i7S-TWS Stereo
https://billson.blogspot.com/2020/12/review-i7s-tws-stereo.html
Fully charged before try:
Linked with Laptop, listen to YouTube: JAZZ MUSIC - LOUNGE MUSIC - CAFE MUSIC FOR RELAX, STUDY, WORK - YouTube
Left - 90 mins auto off
Right 100 mins auto off
Right 100 mins auto off
2020-12-16
SVN maven project without .setting folder
SVN
Check out Maven Projects from SCM
eclipse
Ctrl + N
Project from SVN
- provide SVN url, Finish.
Check Out As
- Check out as project configured using the New Project Wizard, Finish.
Check out Maven Projects from SCM
Target Location
- provide SVN url, Finish.
2020-12-15
2020-12-14
Maven artifact scope at runtime
Source URL: https://stackoverflow.com/a/12273576
runtime is useful for dependencies required for unit tests and at runtime, but not at compile time. This may typically be dynamically loaded code, such as JDBC drivers, which are not directly referenced in the program code.
Setting dependency to runtime ensure that there isn't an accidental dependency on the code, and also keeps the dependency from being transitive. So that, for example, if module A has a runtime dependency on library X, and module B depends on module A, it does not inherit the dependency on library X. Using "provided" or "compile" would cause B to depend on X.
2020-12-11
ToBeContinue: Eclipse Git - Create as bare repository
Differents:
Bare Repository won't be available in the list of Repository during Share Project below:
Public: Eclipse Git - Create as bare repository
Create as bare repository
Created Folder structure:
2020-11-20
[Archived] RMCO区才可以无限制乘车人数
吉打州的学校不知道有复课么？
如果没有新的宣布就继续关到本年度学年结束
车上还是一样坐3个人吗？还是几个都可以呢？
解除了恢复到RMCO就没有限制乘车人数
提早结束的意思是说一切都能如常了，补习也能开店了？
甲吉柔登结束CMCO后 #继续RMCO！补习的部分等地方政府宣布
结束了幼儿园和安亲班可以开了是吗？
等地方政府宣布
那么还有限制一辆车只能三人坐吗？还是也解除了呢？
一车三人只有CMCO才实行，RMCO就没有此限制了
傍晚好 巴辖 有吗
峇株也是解除cmco，回到rmco
Johor 是不是明天起就结束了，还是说是RMCO呢？
是的，回到RMCO的SOP！
麻坡可以去马六甲了的意思吗
是的，可以，回到RMCO的SOP！
请问补习班和安亲班可以开回了吗？
等地方政府宣布
请问柔佛洲解封了，餐馆油站之类的营业时间就变回之前了吗？可以营业至12am?
明天开始
那这样是开学了吗？
如果没有新的宣布就继续关到本年度学年结束
可以开学了吗
如果没有新的宣布就继续关到本年度学年结束
一桌可以坐几个人了？？？
根据RMCO的SOP就没有几个人，但必须保持距离即可
——————————
那么是说22号开始车就可以坐四个人了咯？
RMCO区才可以无限制乘车人数
2020-11-06
Finding: will npm install get back node_modules I deleted
Googled: Angular clear node_modules
my local Angular projects, can I just remove node_modules folder, and will get back just run npm install right?
Double checked, yes, will get back the folder.
But node_modules folder different size compare with:
the node_modules folder before delete (generated by ng new)
the node_modules folder generated after npm install
local untracked file is gone after git pull
Git version:
PortableGit-2.28.0-64-bit.7z
Case:
Did a Git Stash in Visual Studio Code, before commit i did git pull, then my changes and new files all gone.
Read article saying that git stash won't "add" new files(untracked)
https://www.cnblogs.com/zndxall/archive/2018/09/04/9586088.html
But luckily still able get back all files(changes + new/untracked files) by git stash pop.
2020-10-29
[Solved] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
Googled: "spring.datasource.url" "Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure" "Caused by: java.net.ConnectException: Connection refused: connect"
But has no solutions.
Situation was: SpringBoot Microservice failed to launch due to error above.
MySql version was 8.0.22
Found that my repository was develop on MySql version 8.0.15
After revert back to MySql version 8.0.15, no more Communications link failure error.
But hit another issue
mysql 8.0.15 "java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed"
Need to revise spring.datasource.url by append database connection string
&allowPublicKeyRetrieval=true
Then service is up.
2020-09-25
2020-09-20
[Gave up] Oppo S1 Mini
[Gave up]: I gave up to patch this issue for this customized device, but hope these info I found could lead u somewhere.
Main issue:
- Unfortunately, the process com.google.process.gapps has stopped.
- Unfortunately, Google Play Store has stopped.
Model number: S1 mini
Android version: 7.0
Baseband version: 2019.3.1
Kernel version 3.4.67 | Builder@C1 #51 | sat Jul 4 21:58:27 CST 2020
Build number: q9_m432_b15_wx_r3_V0.9_20200704
Custom build version: 1593871116
Factory version:
Google Play services: 5.0.89 (1307510-034)
Google Play Store: 14.1.48-all [0] [PR] 239702733
Google Services Framework: 3.3.3-1288895
Google Services Framework: 3.3.3-1288895
Google Play services: 5.0.89 (1307510-034)
Google Play Store: 14.1.48-all [0] [PR] 239702733
Saw 6GB RAM installed in device info/setting, but using Device Info HW 4.28.1 showing different thing.
Install Sequence from previous Mi 9 experience:
Framework
Play Service
Play Store
https://play.google.com/store/apps/details?id=com.google.android.gms
All apk won't be able to install, except Google Play services, installed but not working
Android version: 4.4.2 (Build: KOT49H) (32-bit)
Android WebView version: 30.0 (32-bit) (Engine: Blink)
Browser Build Number / Identifier: 2003-01-07
User Agent: i Mozilla/5.0 (Linux; Android 4.4.2; S1 mini Build/KOT49H) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/30.0.0.0 Mobile Safari/537.36
Unknown Android device
Operating system: Android 4.4.2
Architecture: armv7l
Language: en-US
All links below getting for x86 Architecture armv7l
Google Services Framework: version 4.4.2-1289630
Google Play services: version 20.36.14 (000700-331796208)
armeabi-v7a
Although change to architecture of v7, still the same, able to installed, but loop stopping.
Installed, but loop stopping.
Revert back to factory version, 5.0.89 (1307510-034)
Found info to get version GOOGLE PLAY SERVICES 12.2.21 from URL:
https://www.apksquare.com/google-play-services-apk-for-android-4-4-2-kitkat-download-new-version/
Google Play services: version 12.2.21 (070-188803320)
Installed, but loop stopping.
Revert back to factory version, 5.0.89 (1307510-034)
Google Play services: version 20.33.15
Found info of Google Play services: version 20.33.15 (120400-330018294) from URL: https://google-play-services.apk.gold/android-4.4.2
Installed, but loop stopping.
Revert back to factory version, 5.0.89 (1307510-034)
armeabi-v7a
Installed, but loop stopping.
Revert back to factory version, 5.0.89 (1307510-034)
240dpi
Google Play services: version 4.4.48
Factory version with sequence from YouTube printscreen:
Google Services Framework:
3.3.3-1288895
Google Account Manager:
4.4.4-1227136
not sure
Google Play services:
5.0.89 (1307510-034)
Google Calendar Sync:
Google Contacts Sync:
Finally
Google Play Store:
14.1.48-all [0] [PR] 239702733
not sure
Google Services Framework 4.4.2-1289630 (Android 4.4+)
Google Account Manager 4.4.2-940549 (Android 2.2+)
Google Play services 10.0.84 (034-137749526) (034)
Google Calendar Sync 4.4-927798 (Android 4.0.3+)
Google Calendar Sync 5.2.3-99827563-release (Android 4.0.3+)
Google Contacts Sync 4.4.2-1289630 (Android 4.4+)
Google Contacts Sync 4.4.4-1227136 (Android 4.4+)
>adb.exe shell logcat *:E
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/cutils-trace( 3069): Error opening trace file: No such file or directory (2)
E/dalvikvm( 3055): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes2.zip'
E/dalvikvm( 3055): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes3.zip'
E/AndroidRuntime( 3055): FATAL EXCEPTION: main
E/AndroidRuntime( 3055): Process: com.android.vending, PID: 3055
E/AndroidRuntime( 3055): java.lang.NoClassDefFoundError: ieq
E/AndroidRuntime( 3055): at dso.<init>(SourceFile)
E/AndroidRuntime( 3055): at dgb.bj(SourceFile:3)
E/AndroidRuntime( 3055): at dgb.aQ(SourceFile:9)
E/AndroidRuntime( 3055): at djd.onCreate(SourceFile)
E/AndroidRuntime( 3055): at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1007)
E/AndroidRuntime( 3055): at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4541)
E/AndroidRuntime( 3055): at android.app.ActivityThread.access$1500(ActivityThread.java:151)
E/AndroidRuntime( 3055): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1381)
E/AndroidRuntime( 3055): at android.os.Handler.dispatchMessage(Handler.java:110)
E/AndroidRuntime( 3055): at android.os.Looper.loop(Looper.java:193)
E/AndroidRuntime( 3055): at android.app.ActivityThread.main(ActivityThread.java:5299)
E/AndroidRuntime( 3055): at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 3055): at java.lang.reflect.Method.invoke(Method.java:515)
E/AndroidRuntime( 3055): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
E/AndroidRuntime( 3055): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
E/AndroidRuntime( 3055): at dalvik.system.NativeStart.main(Native Method)
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/WindowManager( 677): Starting window AppWindowToken{426cea30 token=Token{420ed1b8 ActivityRecord{4241c4e8 u0 com.android.vending/.AssetBrowserActivity t17}}} timed out
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/cutils-trace( 3096): Error opening trace file: No such file or directory (2)
E/dalvikvm( 3082): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes2.zip'
E/dalvikvm( 3082): Unable to extract+optimize DEX from '/data/data/com.android.vending/code_cache/secondary-dexes/Phonesky.apk.classes3.zip'
E/AndroidRuntime( 3082): FATAL EXCEPTION: main
E/AndroidRuntime( 3082): Process: com.android.vending, PID: 3082
E/AndroidRuntime( 3082): java.lang.NoClassDefFoundError: ieq
E/AndroidRuntime( 3082): at dso.<init>(SourceFile)
E/AndroidRuntime( 3082): at dgb.bj(SourceFile:3)
E/AndroidRuntime( 3082): at dgb.aQ(SourceFile:9)
E/AndroidRuntime( 3082): at djd.onCreate(SourceFile)
E/AndroidRuntime( 3082): at android.app.Instrumentation.callApplicationOnCreate(Instrumentation.java:1007)
E/AndroidRuntime( 3082): at android.app.ActivityThread.handleBindApplication(ActivityThread.java:4541)
E/AndroidRuntime( 3082): at android.app.ActivityThread.access$1500(ActivityThread.java:151)
E/AndroidRuntime( 3082): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1381)
E/AndroidRuntime( 3082): at android.os.Handler.dispatchMessage(Handler.java:110)
E/AndroidRuntime( 3082): at android.os.Looper.loop(Looper.java:193)
E/AndroidRuntime( 3082): at android.app.ActivityThread.main(ActivityThread.java:5299)
E/AndroidRuntime( 3082): at java.lang.reflect.Method.invokeNative(Native Method)
E/AndroidRuntime( 3082): at java.lang.reflect.Method.invoke(Method.java:515)
E/AndroidRuntime( 3082): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:825)
E/AndroidRuntime( 3082): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
E/AndroidRuntime( 3082): at dalvik.system.NativeStart.main(Native Method)
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
E/ ( 677): Could not open '/data/data/hotplug/cmd'
E/ ( 677): error : 2, No such file or directory
WhatsApp Messenger 2.20.198.15 (arm-v7a) (Android 4.1+)
2020-09-18
Visual Studio Code cannot detect installed git
Open Visual Studio Code
File > Preference > Settings
or
Ctrl + ,
in Search Settings: git.path
Click edit in settings.json, and edit as below, end with git.exe
2020-08-28
Fixed: Microsoft Office 2013 Pro Plus 15. microsoft office can't find your license for this application. a repair attempt was unsuccessful
Refer to:
- https://superuser.com/questions/42788/is-it-possible-to-execute-a-file-after-extraction-from-a-7-zip-self-extracting-a
- http://ntsblog.homedev.com.au/index.php/2015/05/14/self-extracting-archive-runs-setup-exe-7zip-sfx-switch/
The Office 2013 Deployment Tool allows the administrator to customize and manage Office 2013 Click-to-Run deployments. This tool will help adminstrators to manage installations sources, product/language combinations, and deployment configuration options for Office Click-to-Run.
Download above and save as: officedeploymenttool_x86_5031-1000.exe
Double click run it, then extract:
- setup.exe
- configuration.xml
Edit configuration.xml to become below.
download template configuration.xml from heidoc.net.
modified to
<Configuration>
<Add OfficeClientEdition="64">
<Product ID="ProPlusRetail">
<Language ID="en-us"/>
</Product>
</Add>
<Updates Enabled="TRUE"/>
<Display Level="Full" AcceptEULA="TRUE"/>
</Configuration>
Run
setup /download configuration.xml
will download as below:
select files below, right click and add to 7zip archive.
;!@Install@!UTF-8!
Title="ProPlusRetail x64"
BeginPrompt="Do you want to install ProPlusRetail x64?"
RunProgram="setup.exe /configure configuration.xml"
;!@InstallEnd@!
Title="ProPlusRetail x64"
BeginPrompt="Do you want to install ProPlusRetail x64?"
RunProgram="setup.exe /configure configuration.xml"
;!@InstallEnd@!
copy /b 7zSD.sfx + config.txt + ProPlusRetail_x64.7z ProPlusRetail_x64.exe
copy /b 7zSD.sfx + config.txt + ProPlusRetail_x64.7z ProPlusRetail_x64.exe7zSD.sfxconfig.txtProPlusRetail_x64.7z1 file(s) copied.
Successful build exe, but never try to install
End up fix the main issue by install from ProfessionalRetail.img, download from url below:
Open url below in new window(verified still able to download@20211204_pm093826):
Microsoft Office 2013 (15.0.4433.1508)
32bit & 64 bit:
http://officeredir.microsoft.com/r/rlidO15C2RMediaDownload?p1=db&p2=en-US&p3=ProfessionalRetail
default setup for 32 bit in ProfessionalRetail.img
For 64 bit, in ProfessionalRetail.img/office/setup64
What are x86 and x64 editions?
Running the x64 (64 bit) edition also requires an x64 Windows edition. The advantage of Office x64 is a bit better performance. Disadvantage is that it doesn't support most third party plugins and add-ons. Microsoft actually discourages the use of the x64 editions. So unless you're absolutely sure you need an x64 edition, you should choose x86 (32 bit).
Download Office 2013 Backup Images from Microsoft
The following links point to the official download server officecdn.microsoft.com. Instead of ISO they come as IMG images. These files are pure backup media, and can't be installed without a retail product key.
The IMG images are not the same as the "Single Image" downloads that used to be available from Digital River, but offline versions of the streaming "Click-to-Run" version, with all disadvantages associated with that. If your required download is not included here (such as Office 2013 Professional Plus) please proceed to the download instructions here.
...
details at: https://www.heidoc.net/joomla/technology-science/microsoft/73-office-2013-direct-download-links